eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.PO_PDOI_ITEM_PROCESS_PVT dependencies on DBMS_SQL

Line 24: x_unprocessed_row_tbl IN OUT NOCOPY DBMS_SQL.NUMBER_TABLE,

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,

Line 25: x_proc_row_in_round_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

Line 26: x_create_in_inv_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: );

Line 27: x_create_in_master_index_tbl OUT NOCOPY DBMS_SQL.NUMBER_TABLE,

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:

Line 28: x_create_in_ship_to_index_tbl OUT NOCOPY DBMS_SQL.NUMBER_TABLE,

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

Line 29: x_update_index_tbl 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
33: (

Line 35: p_index_tbl IN DBMS_SQL.NUMBER_TABLE,

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

Line 41: p_index_tbl IN DBMS_SQL.NUMBER_TABLE,

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 ---------------------------------

Line 73: l_create_in_inv_index_tbl DBMS_SQL.NUMBER_TABLE;

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:

Line 74: l_create_in_master_index_tbl DBMS_SQL.NUMBER_TABLE;

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

Line 75: l_create_in_ship_to_index_tbl DBMS_SQL.NUMBER_TABLE;

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;

Line 76: l_update_index_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;

Line 79: l_unprocessed_row_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;
81:
82: -- rows processed in current loop round
83: l_proc_row_in_round_tbl DBMS_SQL.NUMBER_TABLE;

Line 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

Line 341: l_index_tbl DBMS_SQL.NUMBER_TABLE;

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:

Line 725: x_unprocessed_row_tbl IN OUT NOCOPY DBMS_SQL.NUMBER_TABLE,

721: ------------------------------------------------------------------------
722: PROCEDURE identify_actions
723: (
724: x_items IN OUT NOCOPY PO_PDOI_TYPES.line_locs_rec_type,
725: x_unprocessed_row_tbl IN OUT NOCOPY DBMS_SQL.NUMBER_TABLE,
726: x_proc_row_in_round_tbl OUT NOCOPY DBMS_SQL.NUMBER_TABLE,
727: x_create_in_inv_index_tbl OUT NOCOPY DBMS_SQL.NUMBER_TABLE,
728: x_create_in_master_index_tbl OUT NOCOPY DBMS_SQL.NUMBER_TABLE,
729: x_create_in_ship_to_index_tbl OUT NOCOPY DBMS_SQL.NUMBER_TABLE,

Line 726: x_proc_row_in_round_tbl OUT NOCOPY DBMS_SQL.NUMBER_TABLE,

722: PROCEDURE identify_actions
723: (
724: x_items IN OUT NOCOPY PO_PDOI_TYPES.line_locs_rec_type,
725: x_unprocessed_row_tbl IN OUT NOCOPY DBMS_SQL.NUMBER_TABLE,
726: x_proc_row_in_round_tbl OUT NOCOPY DBMS_SQL.NUMBER_TABLE,
727: x_create_in_inv_index_tbl OUT NOCOPY DBMS_SQL.NUMBER_TABLE,
728: x_create_in_master_index_tbl OUT NOCOPY DBMS_SQL.NUMBER_TABLE,
729: x_create_in_ship_to_index_tbl OUT NOCOPY DBMS_SQL.NUMBER_TABLE,
730: x_update_index_tbl OUT NOCOPY DBMS_SQL.NUMBER_TABLE

Line 727: x_create_in_inv_index_tbl OUT NOCOPY DBMS_SQL.NUMBER_TABLE,

723: (
724: x_items IN OUT NOCOPY PO_PDOI_TYPES.line_locs_rec_type,
725: x_unprocessed_row_tbl IN OUT NOCOPY DBMS_SQL.NUMBER_TABLE,
726: x_proc_row_in_round_tbl OUT NOCOPY DBMS_SQL.NUMBER_TABLE,
727: x_create_in_inv_index_tbl OUT NOCOPY DBMS_SQL.NUMBER_TABLE,
728: x_create_in_master_index_tbl OUT NOCOPY DBMS_SQL.NUMBER_TABLE,
729: x_create_in_ship_to_index_tbl OUT NOCOPY DBMS_SQL.NUMBER_TABLE,
730: x_update_index_tbl OUT NOCOPY DBMS_SQL.NUMBER_TABLE
731: ) IS

Line 728: x_create_in_master_index_tbl OUT NOCOPY DBMS_SQL.NUMBER_TABLE,

724: x_items IN OUT NOCOPY PO_PDOI_TYPES.line_locs_rec_type,
725: x_unprocessed_row_tbl IN OUT NOCOPY DBMS_SQL.NUMBER_TABLE,
726: x_proc_row_in_round_tbl OUT NOCOPY DBMS_SQL.NUMBER_TABLE,
727: x_create_in_inv_index_tbl OUT NOCOPY DBMS_SQL.NUMBER_TABLE,
728: x_create_in_master_index_tbl OUT NOCOPY DBMS_SQL.NUMBER_TABLE,
729: x_create_in_ship_to_index_tbl OUT NOCOPY DBMS_SQL.NUMBER_TABLE,
730: x_update_index_tbl OUT NOCOPY DBMS_SQL.NUMBER_TABLE
731: ) IS
732:

Line 729: x_create_in_ship_to_index_tbl OUT NOCOPY DBMS_SQL.NUMBER_TABLE,

725: x_unprocessed_row_tbl IN OUT NOCOPY DBMS_SQL.NUMBER_TABLE,
726: x_proc_row_in_round_tbl OUT NOCOPY DBMS_SQL.NUMBER_TABLE,
727: x_create_in_inv_index_tbl OUT NOCOPY DBMS_SQL.NUMBER_TABLE,
728: x_create_in_master_index_tbl OUT NOCOPY DBMS_SQL.NUMBER_TABLE,
729: x_create_in_ship_to_index_tbl OUT NOCOPY DBMS_SQL.NUMBER_TABLE,
730: x_update_index_tbl OUT NOCOPY DBMS_SQL.NUMBER_TABLE
731: ) IS
732:
733: d_api_name CONSTANT VARCHAR2(30) := 'identify_actions';

Line 730: x_update_index_tbl OUT NOCOPY DBMS_SQL.NUMBER_TABLE

726: x_proc_row_in_round_tbl OUT NOCOPY DBMS_SQL.NUMBER_TABLE,
727: x_create_in_inv_index_tbl OUT NOCOPY DBMS_SQL.NUMBER_TABLE,
728: x_create_in_master_index_tbl OUT NOCOPY DBMS_SQL.NUMBER_TABLE,
729: x_create_in_ship_to_index_tbl OUT NOCOPY DBMS_SQL.NUMBER_TABLE,
730: x_update_index_tbl OUT NOCOPY DBMS_SQL.NUMBER_TABLE
731: ) IS
732:
733: d_api_name CONSTANT VARCHAR2(30) := 'identify_actions';
734: d_module CONSTANT VARCHAR2(255) := d_pkg_name || d_api_name || '.';

Line 956: p_index_tbl IN DBMS_SQL.NUMBER_TABLE,

952: ------------------------------------------------------------------------
953: PROCEDURE insert_master_item
954: (
955: p_org_type IN VARCHAR2,
956: p_index_tbl IN DBMS_SQL.NUMBER_TABLE,
957: x_items IN OUT NOCOPY PO_PDOI_TYPES.line_locs_rec_type
958: ) IS
959:
960: d_api_name CONSTANT VARCHAR2(30) := 'insert_master_item';

Line 982: l_category_id_tbl DBMS_SQL.NUMBER_TABLE;

978: l_transaction_id_tbl PO_TBL_NUMBER;
979: l_item_id_tbl PO_TBL_NUMBER;
980: l_org_id_tbl PO_TBL_NUMBER;
981: l_revision_tbl PO_TBL_VARCHAR5;
982: l_category_id_tbl DBMS_SQL.NUMBER_TABLE;
983:
984: -- rows that return errors when creating items
985: l_error_index_tbl DBMS_SQL.NUMBER_TABLE;
986: l_table_name_tbl PO_TBL_VARCHAR30;

Line 985: l_error_index_tbl DBMS_SQL.NUMBER_TABLE;

981: l_revision_tbl PO_TBL_VARCHAR5;
982: l_category_id_tbl DBMS_SQL.NUMBER_TABLE;
983:
984: -- rows that return errors when creating items
985: l_error_index_tbl DBMS_SQL.NUMBER_TABLE;
986: l_table_name_tbl PO_TBL_VARCHAR30;
987: l_message_name_tbl PO_TBL_VARCHAR30;
988: l_column_name_tbl PO_TBL_VARCHAR100;
989: BEGIN

Line 1396: p_index_tbl IN DBMS_SQL.NUMBER_TABLE,

1392: --End of Comments
1393: ------------------------------------------------------------------------
1394: PROCEDURE update_master_item
1395: (
1396: p_index_tbl IN DBMS_SQL.NUMBER_TABLE,
1397: x_items IN OUT NOCOPY PO_PDOI_TYPES.line_locs_rec_type
1398: ) IS
1399:
1400: d_api_name CONSTANT VARCHAR2(30) := 'update_master_item';

Line 1412: l_update_index_tbl DBMS_SQL.NUMBER_TABLE;

1408: l_index_tbl PO_TBL_NUMBER;
1409: l_orig_desc_tbl PO_TBL_VARCHAR2000;
1410: l_orig_list_price_tbl PO_TBL_NUMBER;
1411:
1412: l_update_index_tbl DBMS_SQL.NUMBER_TABLE;
1413:
1414: -- variables to hold results from INV's API call
1415: l_inventory_item_id NUMBER;
1416: l_organization_id NUMBER;