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 652: x_items IN OUT NOCOPY PO_PDOI_TYPES.line_locs_rec_type

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

Line 724: x_items IN OUT NOCOPY PO_PDOI_TYPES.line_locs_rec_type,

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

Line 957: x_items IN OUT NOCOPY PO_PDOI_TYPES.line_locs_rec_type

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

Line 1397: x_items IN OUT NOCOPY PO_PDOI_TYPES.line_locs_rec_type

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