20:
21: PROCEDURE identify_actions
22: (
23: x_items IN OUT NOCOPY PO_PDOI_TYPES.line_locs_rec_type,
24: x_unprocessed_row_tbl IN OUT NOCOPY DBMS_SQL.NUMBER_TABLE,
25: x_proc_row_in_round_tbl OUT NOCOPY DBMS_SQL.NUMBER_TABLE,
26: x_create_in_inv_index_tbl OUT NOCOPY DBMS_SQL.NUMBER_TABLE,
27: x_create_in_master_index_tbl OUT NOCOPY DBMS_SQL.NUMBER_TABLE,
28: x_create_in_ship_to_index_tbl OUT NOCOPY DBMS_SQL.NUMBER_TABLE,
21: PROCEDURE identify_actions
22: (
23: x_items IN OUT NOCOPY PO_PDOI_TYPES.line_locs_rec_type,
24: x_unprocessed_row_tbl IN OUT NOCOPY DBMS_SQL.NUMBER_TABLE,
25: x_proc_row_in_round_tbl OUT NOCOPY DBMS_SQL.NUMBER_TABLE,
26: x_create_in_inv_index_tbl OUT NOCOPY DBMS_SQL.NUMBER_TABLE,
27: x_create_in_master_index_tbl OUT NOCOPY DBMS_SQL.NUMBER_TABLE,
28: x_create_in_ship_to_index_tbl OUT NOCOPY DBMS_SQL.NUMBER_TABLE,
29: x_update_index_tbl OUT NOCOPY DBMS_SQL.NUMBER_TABLE
22: (
23: x_items IN OUT NOCOPY PO_PDOI_TYPES.line_locs_rec_type,
24: x_unprocessed_row_tbl IN OUT NOCOPY DBMS_SQL.NUMBER_TABLE,
25: x_proc_row_in_round_tbl OUT NOCOPY DBMS_SQL.NUMBER_TABLE,
26: x_create_in_inv_index_tbl OUT NOCOPY DBMS_SQL.NUMBER_TABLE,
27: x_create_in_master_index_tbl OUT NOCOPY DBMS_SQL.NUMBER_TABLE,
28: x_create_in_ship_to_index_tbl OUT NOCOPY DBMS_SQL.NUMBER_TABLE,
29: x_update_index_tbl OUT NOCOPY DBMS_SQL.NUMBER_TABLE
30: );
23: x_items IN OUT NOCOPY PO_PDOI_TYPES.line_locs_rec_type,
24: x_unprocessed_row_tbl IN OUT NOCOPY DBMS_SQL.NUMBER_TABLE,
25: x_proc_row_in_round_tbl OUT NOCOPY DBMS_SQL.NUMBER_TABLE,
26: x_create_in_inv_index_tbl OUT NOCOPY DBMS_SQL.NUMBER_TABLE,
27: x_create_in_master_index_tbl OUT NOCOPY DBMS_SQL.NUMBER_TABLE,
28: x_create_in_ship_to_index_tbl OUT NOCOPY DBMS_SQL.NUMBER_TABLE,
29: x_update_index_tbl OUT NOCOPY DBMS_SQL.NUMBER_TABLE
30: );
31:
24: x_unprocessed_row_tbl IN OUT NOCOPY DBMS_SQL.NUMBER_TABLE,
25: x_proc_row_in_round_tbl OUT NOCOPY DBMS_SQL.NUMBER_TABLE,
26: x_create_in_inv_index_tbl OUT NOCOPY DBMS_SQL.NUMBER_TABLE,
27: x_create_in_master_index_tbl OUT NOCOPY DBMS_SQL.NUMBER_TABLE,
28: x_create_in_ship_to_index_tbl OUT NOCOPY DBMS_SQL.NUMBER_TABLE,
29: x_update_index_tbl OUT NOCOPY DBMS_SQL.NUMBER_TABLE
30: );
31:
32: PROCEDURE insert_master_item
25: x_proc_row_in_round_tbl OUT NOCOPY DBMS_SQL.NUMBER_TABLE,
26: x_create_in_inv_index_tbl OUT NOCOPY DBMS_SQL.NUMBER_TABLE,
27: x_create_in_master_index_tbl OUT NOCOPY DBMS_SQL.NUMBER_TABLE,
28: x_create_in_ship_to_index_tbl OUT NOCOPY DBMS_SQL.NUMBER_TABLE,
29: x_update_index_tbl OUT NOCOPY DBMS_SQL.NUMBER_TABLE
30: );
31:
32: PROCEDURE insert_master_item
33: (
31:
32: PROCEDURE insert_master_item
33: (
34: p_org_type IN VARCHAR2,
35: p_index_tbl IN DBMS_SQL.NUMBER_TABLE,
36: x_items IN OUT NOCOPY PO_PDOI_TYPES.line_locs_rec_type
37: );
38:
39: PROCEDURE update_master_item
37: );
38:
39: PROCEDURE update_master_item
40: (
41: p_index_tbl IN DBMS_SQL.NUMBER_TABLE,
42: x_items IN OUT NOCOPY PO_PDOI_TYPES.line_locs_rec_type
43: );
44: --------------------------------------------------------------------------
45: ---------------------- PUBLIC PROCEDURES ---------------------------------
69: d_position NUMBER;
70:
71: l_items PO_PDOI_TYPES.line_locs_rec_type;
72:
73: l_create_in_inv_index_tbl DBMS_SQL.NUMBER_TABLE;
74: l_create_in_master_index_tbl DBMS_SQL.NUMBER_TABLE;
75: l_create_in_ship_to_index_tbl DBMS_SQL.NUMBER_TABLE;
76: l_update_index_tbl DBMS_SQL.NUMBER_TABLE;
77:
70:
71: l_items PO_PDOI_TYPES.line_locs_rec_type;
72:
73: l_create_in_inv_index_tbl DBMS_SQL.NUMBER_TABLE;
74: l_create_in_master_index_tbl DBMS_SQL.NUMBER_TABLE;
75: l_create_in_ship_to_index_tbl DBMS_SQL.NUMBER_TABLE;
76: l_update_index_tbl DBMS_SQL.NUMBER_TABLE;
77:
78: -- identify rows that have not been processed
71: l_items PO_PDOI_TYPES.line_locs_rec_type;
72:
73: l_create_in_inv_index_tbl DBMS_SQL.NUMBER_TABLE;
74: l_create_in_master_index_tbl DBMS_SQL.NUMBER_TABLE;
75: l_create_in_ship_to_index_tbl DBMS_SQL.NUMBER_TABLE;
76: l_update_index_tbl DBMS_SQL.NUMBER_TABLE;
77:
78: -- identify rows that have not been processed
79: l_unprocessed_row_tbl DBMS_SQL.NUMBER_TABLE;
72:
73: l_create_in_inv_index_tbl DBMS_SQL.NUMBER_TABLE;
74: l_create_in_master_index_tbl DBMS_SQL.NUMBER_TABLE;
75: l_create_in_ship_to_index_tbl DBMS_SQL.NUMBER_TABLE;
76: l_update_index_tbl DBMS_SQL.NUMBER_TABLE;
77:
78: -- identify rows that have not been processed
79: l_unprocessed_row_tbl DBMS_SQL.NUMBER_TABLE;
80: l_index NUMBER;
75: l_create_in_ship_to_index_tbl DBMS_SQL.NUMBER_TABLE;
76: l_update_index_tbl DBMS_SQL.NUMBER_TABLE;
77:
78: -- identify rows that have not been processed
79: l_unprocessed_row_tbl DBMS_SQL.NUMBER_TABLE;
80: l_index NUMBER;
81:
82: -- rows processed in current loop round
83: l_proc_row_in_round_tbl DBMS_SQL.NUMBER_TABLE;
79: l_unprocessed_row_tbl DBMS_SQL.NUMBER_TABLE;
80: l_index NUMBER;
81:
82: -- rows processed in current loop round
83: l_proc_row_in_round_tbl DBMS_SQL.NUMBER_TABLE;
84: BEGIN
85: d_position := 0;
86:
87: IF (PO_LOG.d_proc) THEN
337: d_module CONSTANT VARCHAR2(255) := d_pkg_name || d_api_name || '.';
338: d_position NUMBER;
339:
340: l_key PO_SESSION_GT.key%TYPE;
341: l_index_tbl DBMS_SQL.NUMBER_TABLE;
342: l_line_index NUMBER;
343: BEGIN
344: d_position := 0;
345:
722: ------------------------------------------------------------------------
723: PROCEDURE identify_actions
724: (
725: x_items IN OUT NOCOPY PO_PDOI_TYPES.line_locs_rec_type,
726: x_unprocessed_row_tbl IN OUT NOCOPY DBMS_SQL.NUMBER_TABLE,
727: x_proc_row_in_round_tbl OUT NOCOPY DBMS_SQL.NUMBER_TABLE,
728: x_create_in_inv_index_tbl OUT NOCOPY DBMS_SQL.NUMBER_TABLE,
729: x_create_in_master_index_tbl OUT NOCOPY DBMS_SQL.NUMBER_TABLE,
730: x_create_in_ship_to_index_tbl OUT NOCOPY DBMS_SQL.NUMBER_TABLE,
723: PROCEDURE identify_actions
724: (
725: x_items IN OUT NOCOPY PO_PDOI_TYPES.line_locs_rec_type,
726: x_unprocessed_row_tbl IN OUT NOCOPY DBMS_SQL.NUMBER_TABLE,
727: x_proc_row_in_round_tbl OUT NOCOPY DBMS_SQL.NUMBER_TABLE,
728: x_create_in_inv_index_tbl OUT NOCOPY DBMS_SQL.NUMBER_TABLE,
729: x_create_in_master_index_tbl OUT NOCOPY DBMS_SQL.NUMBER_TABLE,
730: x_create_in_ship_to_index_tbl OUT NOCOPY DBMS_SQL.NUMBER_TABLE,
731: x_update_index_tbl OUT NOCOPY DBMS_SQL.NUMBER_TABLE
724: (
725: x_items IN OUT NOCOPY PO_PDOI_TYPES.line_locs_rec_type,
726: x_unprocessed_row_tbl IN OUT NOCOPY DBMS_SQL.NUMBER_TABLE,
727: x_proc_row_in_round_tbl OUT NOCOPY DBMS_SQL.NUMBER_TABLE,
728: x_create_in_inv_index_tbl OUT NOCOPY DBMS_SQL.NUMBER_TABLE,
729: x_create_in_master_index_tbl OUT NOCOPY DBMS_SQL.NUMBER_TABLE,
730: x_create_in_ship_to_index_tbl OUT NOCOPY DBMS_SQL.NUMBER_TABLE,
731: x_update_index_tbl OUT NOCOPY DBMS_SQL.NUMBER_TABLE
732: ) IS
725: x_items IN OUT NOCOPY PO_PDOI_TYPES.line_locs_rec_type,
726: x_unprocessed_row_tbl IN OUT NOCOPY DBMS_SQL.NUMBER_TABLE,
727: x_proc_row_in_round_tbl OUT NOCOPY DBMS_SQL.NUMBER_TABLE,
728: x_create_in_inv_index_tbl OUT NOCOPY DBMS_SQL.NUMBER_TABLE,
729: x_create_in_master_index_tbl OUT NOCOPY DBMS_SQL.NUMBER_TABLE,
730: x_create_in_ship_to_index_tbl OUT NOCOPY DBMS_SQL.NUMBER_TABLE,
731: x_update_index_tbl OUT NOCOPY DBMS_SQL.NUMBER_TABLE
732: ) IS
733:
726: x_unprocessed_row_tbl IN OUT NOCOPY DBMS_SQL.NUMBER_TABLE,
727: x_proc_row_in_round_tbl OUT NOCOPY DBMS_SQL.NUMBER_TABLE,
728: x_create_in_inv_index_tbl OUT NOCOPY DBMS_SQL.NUMBER_TABLE,
729: x_create_in_master_index_tbl OUT NOCOPY DBMS_SQL.NUMBER_TABLE,
730: x_create_in_ship_to_index_tbl OUT NOCOPY DBMS_SQL.NUMBER_TABLE,
731: x_update_index_tbl OUT NOCOPY DBMS_SQL.NUMBER_TABLE
732: ) IS
733:
734: d_api_name CONSTANT VARCHAR2(30) := 'identify_actions';
727: x_proc_row_in_round_tbl OUT NOCOPY DBMS_SQL.NUMBER_TABLE,
728: x_create_in_inv_index_tbl OUT NOCOPY DBMS_SQL.NUMBER_TABLE,
729: x_create_in_master_index_tbl OUT NOCOPY DBMS_SQL.NUMBER_TABLE,
730: x_create_in_ship_to_index_tbl OUT NOCOPY DBMS_SQL.NUMBER_TABLE,
731: x_update_index_tbl OUT NOCOPY DBMS_SQL.NUMBER_TABLE
732: ) IS
733:
734: d_api_name CONSTANT VARCHAR2(30) := 'identify_actions';
735: d_module CONSTANT VARCHAR2(255) := d_pkg_name || d_api_name || '.';
953: ------------------------------------------------------------------------
954: PROCEDURE insert_master_item
955: (
956: p_org_type IN VARCHAR2,
957: p_index_tbl IN DBMS_SQL.NUMBER_TABLE,
958: x_items IN OUT NOCOPY PO_PDOI_TYPES.line_locs_rec_type
959: ) IS
960:
961: d_api_name CONSTANT VARCHAR2(30) := 'insert_master_item';
979: l_transaction_id_tbl PO_TBL_NUMBER;
980: l_item_id_tbl PO_TBL_NUMBER;
981: l_org_id_tbl PO_TBL_NUMBER;
982: l_revision_tbl PO_TBL_VARCHAR5;
983: l_category_id_tbl DBMS_SQL.NUMBER_TABLE;
984:
985: -- rows that return errors when creating items
986: l_error_index_tbl DBMS_SQL.NUMBER_TABLE;
987: l_table_name_tbl PO_TBL_VARCHAR30;
982: l_revision_tbl PO_TBL_VARCHAR5;
983: l_category_id_tbl DBMS_SQL.NUMBER_TABLE;
984:
985: -- rows that return errors when creating items
986: l_error_index_tbl DBMS_SQL.NUMBER_TABLE;
987: l_table_name_tbl PO_TBL_VARCHAR30;
988: l_message_name_tbl PO_TBL_VARCHAR30;
989: l_column_name_tbl PO_TBL_VARCHAR100;
990: BEGIN
1393: --End of Comments
1394: ------------------------------------------------------------------------
1395: PROCEDURE update_master_item
1396: (
1397: p_index_tbl IN DBMS_SQL.NUMBER_TABLE,
1398: x_items IN OUT NOCOPY PO_PDOI_TYPES.line_locs_rec_type
1399: ) IS
1400:
1401: d_api_name CONSTANT VARCHAR2(30) := 'update_master_item';
1409: l_index_tbl PO_TBL_NUMBER;
1410: l_orig_desc_tbl PO_TBL_VARCHAR2000;
1411: l_orig_list_price_tbl PO_TBL_NUMBER;
1412:
1413: l_update_index_tbl DBMS_SQL.NUMBER_TABLE;
1414:
1415: -- variables to hold results from INV's API call
1416: l_inventory_item_id NUMBER;
1417: l_organization_id NUMBER;