APPS.PO_PDOI_ITEM_PROCESS_PVT dependencies on PO_PDOI_TYPES

Line 12: p_lines IN PO_PDOI_TYPES.lines_rec_type,

8: ---------------------- PRIVATE PROCEDURES PROTOTYPE ----------------------
9: --------------------------------------------------------------------------
10: PROCEDURE construct_item_records
11: (
12: p_lines IN PO_PDOI_TYPES.lines_rec_type,
13: x_items OUT NOCOPY PO_PDOI_TYPES.line_locs_rec_type
14: );
15:
16: PROCEDURE derive_default_loc_attrs

Line 13: x_items OUT NOCOPY PO_PDOI_TYPES.line_locs_rec_type

9: --------------------------------------------------------------------------
10: PROCEDURE construct_item_records
11: (
12: p_lines IN PO_PDOI_TYPES.lines_rec_type,
13: x_items OUT NOCOPY PO_PDOI_TYPES.line_locs_rec_type
14: );
15:
16: PROCEDURE derive_default_loc_attrs
17: (

Line 18: x_items IN OUT NOCOPY PO_PDOI_TYPES.line_locs_rec_type

14: );
15:
16: PROCEDURE derive_default_loc_attrs
17: (
18: x_items IN OUT NOCOPY PO_PDOI_TYPES.line_locs_rec_type
19: );
20:
21: PROCEDURE identify_actions
22: (

Line 23: x_items IN OUT NOCOPY PO_PDOI_TYPES.line_locs_rec_type,

19: );
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,

Line 36: x_items IN OUT NOCOPY PO_PDOI_TYPES.line_locs_rec_type

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
40: (

Line 42: x_items IN OUT NOCOPY PO_PDOI_TYPES.line_locs_rec_type

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

Line 64: x_lines IN OUT NOCOPY PO_PDOI_TYPES.lines_rec_type

60: --End of Comments
61: ------------------------------------------------------------------------
62: PROCEDURE create_items
63: (
64: x_lines IN OUT NOCOPY PO_PDOI_TYPES.lines_rec_type
65: ) IS
66:
67: d_api_name CONSTANT VARCHAR2(30) := 'create_items';
68: d_module CONSTANT VARCHAR2(255) := d_pkg_name || d_api_name || '.';

Line 71: l_items PO_PDOI_TYPES.line_locs_rec_type;

67: d_api_name CONSTANT VARCHAR2(30) := 'create_items';
68: d_module CONSTANT VARCHAR2(255) := d_pkg_name || d_api_name || '.';
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;

Line 332: p_lines IN PO_PDOI_TYPES.lines_rec_type,

328: --End of Comments
329: ------------------------------------------------------------------------
330: PROCEDURE construct_item_records
331: (
332: p_lines IN PO_PDOI_TYPES.lines_rec_type,
333: x_items OUT NOCOPY PO_PDOI_TYPES.line_locs_rec_type
334: ) IS
335:
336: d_api_name CONSTANT VARCHAR2(30) := 'construct_item_records';

Line 333: x_items OUT NOCOPY PO_PDOI_TYPES.line_locs_rec_type

329: ------------------------------------------------------------------------
330: PROCEDURE construct_item_records
331: (
332: p_lines IN PO_PDOI_TYPES.lines_rec_type,
333: x_items OUT NOCOPY PO_PDOI_TYPES.line_locs_rec_type
334: ) IS
335:
336: d_api_name CONSTANT VARCHAR2(30) := 'construct_item_records';
337: d_module CONSTANT VARCHAR2(255) := d_pkg_name || d_api_name || '.';

Line 590: PO_PDOI_TYPES.fill_all_line_locs_attr

586: d_position := 20;
587:
588: -- bug5106386
589: -- Initialize all pl/sql tables that are not part of the query
590: PO_PDOI_TYPES.fill_all_line_locs_attr
591: ( p_num_records => x_items.line_ref_index_tbl.COUNT,
592: x_line_locs => x_items
593: );
594:

Line 653: x_items IN OUT NOCOPY PO_PDOI_TYPES.line_locs_rec_type

649: --End of Comments
650: ------------------------------------------------------------------------
651: PROCEDURE derive_default_loc_attrs
652: (
653: x_items IN OUT NOCOPY PO_PDOI_TYPES.line_locs_rec_type
654: ) IS
655:
656: d_api_name CONSTANT VARCHAR2(30) := 'derive_default_loc_attrs';
657: d_module CONSTANT VARCHAR2(255) := d_pkg_name || d_api_name || '.';

Line 725: x_items IN OUT NOCOPY PO_PDOI_TYPES.line_locs_rec_type,

721: --End of Comments
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,

Line 958: x_items IN OUT NOCOPY PO_PDOI_TYPES.line_locs_rec_type

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';
962: d_module CONSTANT VARCHAR2(255) := d_pkg_name || d_api_name || '.';

Line 1398: x_items IN OUT NOCOPY PO_PDOI_TYPES.line_locs_rec_type

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';
1402: d_module CONSTANT VARCHAR2(255) := d_pkg_name || d_api_name || '.';