更新工艺路线资源



DECLARE

    -- API input variables

  l_operation_tbl    bom_rtg_pub.operation_tbl_type := bom_rtg_pub.g_miss_operation_tbl;

  l_rtg_header_rec   bom_rtg_pub.rtg_header_rec_type := bom_rtg_pub.g_miss_rtg_header_rec;

  l_rtg_revision_tbl bom_rtg_pub.rtg_revision_tbl_type := bom_rtg_pub.g_miss_rtg_revision_tbl;

  l_op_resource_tbl  bom_rtg_pub.op_resource_tbl_type := bom_rtg_pub.g_miss_op_resource_tbl;

  l_sub_resource_tbl bom_rtg_pub.sub_resource_tbl_type := bom_rtg_pub.g_miss_sub_resource_tbl;

  l_op_network_tbl   bom_rtg_pub.op_network_tbl_type := bom_rtg_pub.g_miss_op_network_tbl;

    -- API output variables

  x_rtg_header_rec   bom_rtg_pub.rtg_header_rec_type;   -- routing header record

  x_rtg_revision_tbl bom_rtg_pub.rtg_revision_tbl_type;   -- routing revisions

  x_operation_tbl    bom_rtg_pub.operation_tbl_type;   -- routing operations

  x_op_resource_tbl  bom_rtg_pub.op_resource_tbl_type;   -- oepration resources

  x_sub_resource_tbl bom_rtg_pub.sub_resource_tbl_type;   -- sub operation resources

  x_op_network_tbl   bom_rtg_pub.op_network_tbl_type;   -- operation networks

  x_message_list     error_handler.error_tbl_type;

    -- Other API variables

  l_return_status   VARCHAR2 ( 1   ) :=   NULL ;

  l_msg_count       NUMBER   :=   0   ;

  l_cnt             NUMBER   :=   1   ;

    -- WHO columns

  l_user_id          NUMBER   := - 1   ;

  l_resp_id          NUMBER   := - 1   ;

  l_application_id   NUMBER   := - 1   ;

  l_row_cnt