DBA Data[Home] [Help]

APPS.PO_PDOI_MOVE_TO_DRAFT_TABS_PVT dependencies on PO_PDOI_TYPES

Line 12: p_headers IN PO_PDOI_TYPES.headers_rec_type

8: ---------------------- PRIVATE PROCEDURES PROTOTYPE ----------------------
9: --------------------------------------------------------------------------
10: PROCEDURE insert_po_headers_draft_all
11: (
12: p_headers IN PO_PDOI_TYPES.headers_rec_type
13: );
14:
15: PROCEDURE insert_po_ga_org_assign_draft
16: (

Line 17: p_headers IN PO_PDOI_TYPES.headers_rec_type

13: );
14:
15: PROCEDURE insert_po_ga_org_assign_draft
16: (
17: p_headers IN PO_PDOI_TYPES.headers_rec_type
18: );
19:
20: PROCEDURE insert_blk_dists_draft_all
21: (

Line 22: p_headers IN PO_PDOI_TYPES.headers_rec_type

18: );
19:
20: PROCEDURE insert_blk_dists_draft_all
21: (
22: p_headers IN PO_PDOI_TYPES.headers_rec_type
23: );
24:
25: PROCEDURE insert_po_lines_draft_all
26: (

Line 27: p_lines IN PO_PDOI_TYPES.lines_rec_type

23: );
24:
25: PROCEDURE insert_po_lines_draft_all
26: (
27: p_lines IN PO_PDOI_TYPES.lines_rec_type
28: );
29:
30: PROCEDURE insert_po_line_locs_draft_all
31: (

Line 32: p_line_locs IN PO_PDOI_TYPES.line_locs_rec_type

28: );
29:
30: PROCEDURE insert_po_line_locs_draft_all
31: (
32: p_line_locs IN PO_PDOI_TYPES.line_locs_rec_type
33: );
34:
35: PROCEDURE insert_po_dists_draft_all
36: (

Line 37: p_dists IN PO_PDOI_TYPES.distributions_rec_type

33: );
34:
35: PROCEDURE insert_po_dists_draft_all
36: (
37: p_dists IN PO_PDOI_TYPES.distributions_rec_type
38: );
39:
40: PROCEDURE insert_po_price_diff_draft
41: (

Line 42: p_price_diffs IN PO_PDOI_TYPES.price_diffs_rec_type

38: );
39:
40: PROCEDURE insert_po_price_diff_draft
41: (
42: p_price_diffs IN PO_PDOI_TYPES.price_diffs_rec_type
43: );
44:
45: PROCEDURE merge_po_attr_values_draft
46: (

Line 48: p_attr_values IN PO_PDOI_TYPES.attr_values_rec_type

44:
45: PROCEDURE merge_po_attr_values_draft
46: (
47: p_key IN po_session_gt.key%TYPE,
48: p_attr_values IN PO_PDOI_TYPES.attr_values_rec_type
49: );
50:
51: PROCEDURE merge_po_attr_values_tlp_draft
52: (

Line 54: p_attr_values_tlp IN PO_PDOI_TYPES.attr_values_tlp_rec_type

50:
51: PROCEDURE merge_po_attr_values_tlp_draft
52: (
53: p_key IN po_session_gt.key%TYPE,
54: p_attr_values_tlp IN PO_PDOI_TYPES.attr_values_tlp_rec_type
55: );
56:
57: PROCEDURE reset_cat_attributes
58: (

Line 85: p_headers IN PO_PDOI_TYPES.headers_rec_type

81: --End of Comments
82: ------------------------------------------------------------------------
83: PROCEDURE insert_headers
84: (
85: p_headers IN PO_PDOI_TYPES.headers_rec_type
86: ) IS
87:
88: d_api_name CONSTANT VARCHAR2(30) := 'insert_headers';
89: d_module CONSTANT VARCHAR2(255) := d_pkg_name || d_api_name || '.';

Line 158: x_lines IN OUT NOCOPY PO_PDOI_TYPES.lines_rec_type

154: --End of Comments
155: ------------------------------------------------------------------------
156: PROCEDURE insert_lines
157: (
158: x_lines IN OUT NOCOPY PO_PDOI_TYPES.lines_rec_type
159: ) IS
160:
161: d_api_name CONSTANT VARCHAR2(30) := 'insert_lines';
162: d_module CONSTANT VARCHAR2(255) := d_pkg_name || d_api_name || '.';

Line 282: x_lines IN OUT NOCOPY PO_PDOI_TYPES.lines_rec_type

278: --End of Comments
279: ------------------------------------------------------------------------
280: PROCEDURE update_lines
281: (
282: x_lines IN OUT NOCOPY PO_PDOI_TYPES.lines_rec_type
283: ) IS
284:
285: d_api_name CONSTANT VARCHAR2(30) := 'update_lines';
286: d_module CONSTANT VARCHAR2(255) := d_pkg_name || d_api_name || '.';

Line 340: l_precision_tbl PO_PDOI_TYPES.varchar_index_tbl_type;

336: l_num_tbl DBMS_SQL.NUMBER_TABLE;
337:
338: -- variables used in UOM processing
339: l_precision FND_CURRENCIES.precision%TYPE;
340: l_precision_tbl PO_PDOI_TYPES.varchar_index_tbl_type;
341: l_uom_rate NUMBER;
342:
343: -- location lines that need to be updated
344: l_update_loc_queue DBMS_SQL.NUMBER_TABLE;

Line 1303: p_line_locs IN PO_PDOI_TYPES.line_locs_rec_type

1299: --End of Comments
1300: ------------------------------------------------------------------------
1301: PROCEDURE insert_line_locs
1302: (
1303: p_line_locs IN PO_PDOI_TYPES.line_locs_rec_type
1304: ) IS
1305:
1306: d_api_name CONSTANT VARCHAR2(30) := 'insert_line_locs';
1307: d_module CONSTANT VARCHAR2(255) := d_pkg_name || d_api_name || '.';

Line 1404: p_dists IN PO_PDOI_TYPES.distributions_rec_type

1400: --End of Comments
1401: ------------------------------------------------------------------------
1402: PROCEDURE insert_dists
1403: (
1404: p_dists IN PO_PDOI_TYPES.distributions_rec_type
1405: ) IS
1406:
1407: d_api_name CONSTANT VARCHAR2(30) := 'insert_dists';
1408: d_module CONSTANT VARCHAR2(255) := d_pkg_name || d_api_name || '.';

Line 1460: p_price_diffs IN PO_PDOI_TYPES.price_diffs_rec_type

1456: --End of Comments
1457: ------------------------------------------------------------------------
1458: PROCEDURE insert_price_diffs
1459: (
1460: p_price_diffs IN PO_PDOI_TYPES.price_diffs_rec_type
1461: ) IS
1462:
1463: d_api_name CONSTANT VARCHAR2(30) := 'insert_price_diffs';
1464: d_module CONSTANT VARCHAR2(255) := d_pkg_name || d_api_name || '.';

Line 1527: p_attr_values IN PO_PDOI_TYPES.attr_values_rec_type

1523: (
1524: p_processing_row_tbl IN DBMS_SQL.NUMBER_TABLE,
1525: p_sync_attr_id_tbl IN PO_TBL_NUMBER,
1526: p_sync_draft_id_tbl IN PO_TBL_NUMBER,
1527: p_attr_values IN PO_PDOI_TYPES.attr_values_rec_type
1528: ) IS
1529:
1530: d_api_name CONSTANT VARCHAR2(30) := 'merge_attr_values';
1531: d_module CONSTANT VARCHAR2(255) := d_pkg_name || d_api_name || '.';

Line 1645: p_attr_values_tlp IN PO_PDOI_TYPES.attr_values_tlp_rec_type

1641: (
1642: p_processing_row_tbl IN DBMS_SQL.NUMBER_TABLE,
1643: p_sync_attr_tlp_id_tbl IN PO_TBL_NUMBER,
1644: p_sync_draft_id_tbl IN PO_TBL_NUMBER,
1645: p_attr_values_tlp IN PO_PDOI_TYPES.attr_values_tlp_rec_type
1646: ) IS
1647:
1648: d_api_name CONSTANT VARCHAR2(30) := 'merge_attr_values_tlp';
1649: d_module CONSTANT VARCHAR2(255) := d_pkg_name || d_api_name || '.';

Line 1758: p_headers IN PO_PDOI_TYPES.headers_rec_type

1754: --End of Comments
1755: ------------------------------------------------------------------------
1756: PROCEDURE insert_po_headers_draft_all
1757: (
1758: p_headers IN PO_PDOI_TYPES.headers_rec_type
1759: )IS
1760:
1761: d_api_name CONSTANT VARCHAR2(30) := 'insert_po_headers_draft_all';
1762: d_module CONSTANT VARCHAR2(255) := d_pkg_name || d_api_name || '.';

Line 2043: p_headers IN PO_PDOI_TYPES.headers_rec_type

2039: --End of Comments
2040: ------------------------------------------------------------------------
2041: PROCEDURE insert_po_ga_org_assign_draft
2042: (
2043: p_headers IN PO_PDOI_TYPES.headers_rec_type
2044: ) IS
2045:
2046: d_api_name CONSTANT VARCHAR2(30) := 'insert_po_ga_org_assign_draft';
2047: d_module CONSTANT VARCHAR2(255) := d_pkg_name || d_api_name || '.';

Line 2140: p_headers IN PO_PDOI_TYPES.headers_rec_type

2136: --End of Comments
2137: ------------------------------------------------------------------------
2138: PROCEDURE insert_blk_dists_draft_all
2139: (
2140: p_headers IN PO_PDOI_TYPES.headers_rec_type
2141: ) IS
2142:
2143: d_api_name CONSTANT VARCHAR2(30) := 'insert_blk_dists_draft_all';
2144: d_module CONSTANT VARCHAR2(255) := d_pkg_name || d_api_name || '.';

Line 2262: p_dists IN PO_PDOI_TYPES.distributions_rec_type

2258: --End of Comments
2259: ------------------------------------------------------------------------
2260: PROCEDURE insert_po_dists_draft_all
2261: (
2262: p_dists IN PO_PDOI_TYPES.distributions_rec_type
2263: ) IS
2264:
2265: d_api_name CONSTANT VARCHAR2(30) := 'insert_po_dists_draft_all';
2266: d_module CONSTANT VARCHAR2(255) := d_pkg_name || d_api_name || '.';

Line 2516: p_lines IN PO_PDOI_TYPES.lines_rec_type

2512: --End of Comments
2513: ------------------------------------------------------------------------
2514: PROCEDURE insert_po_lines_draft_all
2515: (
2516: p_lines IN PO_PDOI_TYPES.lines_rec_type
2517: ) IS
2518:
2519: d_api_name CONSTANT VARCHAR2(30) := 'insert_po_lines_draft_all';
2520: d_module CONSTANT VARCHAR2(255) := d_pkg_name || d_api_name || '.';

Line 2795: p_line_locs IN PO_PDOI_TYPES.line_locs_rec_type

2791: --End of Comments
2792: ------------------------------------------------------------------------
2793: PROCEDURE insert_po_line_locs_draft_all
2794: (
2795: p_line_locs IN PO_PDOI_TYPES.line_locs_rec_type
2796: ) IS
2797:
2798: d_api_name CONSTANT VARCHAR2(30) := 'insert_po_line_locs_draft_all';
2799: d_module CONSTANT VARCHAR2(255) := d_pkg_name || d_api_name || '.';

Line 3076: p_price_diffs IN PO_PDOI_TYPES.price_diffs_rec_type

3072: --End of Comments
3073: ------------------------------------------------------------------------
3074: PROCEDURE insert_po_price_diff_draft
3075: (
3076: p_price_diffs IN PO_PDOI_TYPES.price_diffs_rec_type
3077: ) IS
3078:
3079: d_api_name CONSTANT VARCHAR2(30) := 'insert_po_price_diff_draft';
3080: d_module CONSTANT VARCHAR2(255) := d_pkg_name || d_api_name || '.';

Line 3187: p_attr_values IN PO_PDOI_TYPES.attr_values_rec_type

3183: ------------------------------------------------------------------------
3184: PROCEDURE merge_po_attr_values_draft
3185: (
3186: p_key IN po_session_gt.key%TYPE,
3187: p_attr_values IN PO_PDOI_TYPES.attr_values_rec_type
3188: ) IS
3189:
3190: d_api_name CONSTANT VARCHAR2(30) := 'merge_po_attr_values_draft';
3191: d_module CONSTANT VARCHAR2(255) := d_pkg_name || d_api_name || '.';

Line 4560: p_attr_values_tlp IN PO_PDOI_TYPES.attr_values_tlp_rec_type

4556: ------------------------------------------------------------------------
4557: PROCEDURE merge_po_attr_values_tlp_draft
4558: (
4559: p_key IN po_session_gt.key%TYPE,
4560: p_attr_values_tlp IN PO_PDOI_TYPES.attr_values_tlp_rec_type
4561: ) IS
4562:
4563: d_api_name CONSTANT VARCHAR2(30) := 'merge_po_attr_values_tlp_draft';
4564: d_module CONSTANT VARCHAR2(255) := d_pkg_name || d_api_name || '.';