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 285: x_lines IN OUT NOCOPY PO_PDOI_TYPES.lines_rec_type

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

Line 348: l_precision_tbl PO_PDOI_TYPES.varchar_index_tbl_type;

344: l_num_tbl DBMS_SQL.NUMBER_TABLE;
345:
346: -- variables used in UOM processing
347: l_precision FND_CURRENCIES.precision%TYPE;
348: l_precision_tbl PO_PDOI_TYPES.varchar_index_tbl_type;
349: l_uom_rate NUMBER;
350:
351: -- location lines that need to be updated
352: l_update_loc_queue DBMS_SQL.NUMBER_TABLE;

Line 1497: p_line_locs IN PO_PDOI_TYPES.line_locs_rec_type

1493: --End of Comments
1494: ------------------------------------------------------------------------
1495: PROCEDURE insert_line_locs
1496: (
1497: p_line_locs IN PO_PDOI_TYPES.line_locs_rec_type
1498: ) IS
1499:
1500: d_api_name CONSTANT VARCHAR2(30) := 'insert_line_locs';
1501: d_module CONSTANT VARCHAR2(255) := d_pkg_name || d_api_name || '.';

Line 1598: p_dists IN PO_PDOI_TYPES.distributions_rec_type

1594: --End of Comments
1595: ------------------------------------------------------------------------
1596: PROCEDURE insert_dists
1597: (
1598: p_dists IN PO_PDOI_TYPES.distributions_rec_type
1599: ) IS
1600:
1601: d_api_name CONSTANT VARCHAR2(30) := 'insert_dists';
1602: d_module CONSTANT VARCHAR2(255) := d_pkg_name || d_api_name || '.';

Line 1654: p_price_diffs IN PO_PDOI_TYPES.price_diffs_rec_type

1650: --End of Comments
1651: ------------------------------------------------------------------------
1652: PROCEDURE insert_price_diffs
1653: (
1654: p_price_diffs IN PO_PDOI_TYPES.price_diffs_rec_type
1655: ) IS
1656:
1657: d_api_name CONSTANT VARCHAR2(30) := 'insert_price_diffs';
1658: d_module CONSTANT VARCHAR2(255) := d_pkg_name || d_api_name || '.';

Line 1721: p_attr_values IN PO_PDOI_TYPES.attr_values_rec_type

1717: (
1718: p_processing_row_tbl IN DBMS_SQL.NUMBER_TABLE,
1719: p_sync_attr_id_tbl IN PO_TBL_NUMBER,
1720: p_sync_draft_id_tbl IN PO_TBL_NUMBER,
1721: p_attr_values IN PO_PDOI_TYPES.attr_values_rec_type
1722: ) IS
1723:
1724: d_api_name CONSTANT VARCHAR2(30) := 'merge_attr_values';
1725: d_module CONSTANT VARCHAR2(255) := d_pkg_name || d_api_name || '.';

Line 1839: p_attr_values_tlp IN PO_PDOI_TYPES.attr_values_tlp_rec_type

1835: (
1836: p_processing_row_tbl IN DBMS_SQL.NUMBER_TABLE,
1837: p_sync_attr_tlp_id_tbl IN PO_TBL_NUMBER,
1838: p_sync_draft_id_tbl IN PO_TBL_NUMBER,
1839: p_attr_values_tlp IN PO_PDOI_TYPES.attr_values_tlp_rec_type
1840: ) IS
1841:
1842: d_api_name CONSTANT VARCHAR2(30) := 'merge_attr_values_tlp';
1843: d_module CONSTANT VARCHAR2(255) := d_pkg_name || d_api_name || '.';

Line 1954: p_headers IN PO_PDOI_TYPES.headers_rec_type

1950: --End of Comments
1951: ------------------------------------------------------------------------
1952: PROCEDURE insert_po_headers_draft_all
1953: (
1954: p_headers IN PO_PDOI_TYPES.headers_rec_type
1955: )IS
1956:
1957: d_api_name CONSTANT VARCHAR2(30) := 'insert_po_headers_draft_all';
1958: d_module CONSTANT VARCHAR2(255) := d_pkg_name || d_api_name || '.';

Line 2279: p_headers IN PO_PDOI_TYPES.headers_rec_type

2275: --End of Comments
2276: ------------------------------------------------------------------------
2277: PROCEDURE insert_po_ga_org_assign_draft
2278: (
2279: p_headers IN PO_PDOI_TYPES.headers_rec_type
2280: ) IS
2281:
2282: d_api_name CONSTANT VARCHAR2(30) := 'insert_po_ga_org_assign_draft';
2283: d_module CONSTANT VARCHAR2(255) := d_pkg_name || d_api_name || '.';

Line 2376: p_headers IN PO_PDOI_TYPES.headers_rec_type

2372: --End of Comments
2373: ------------------------------------------------------------------------
2374: PROCEDURE insert_blk_dists_draft_all
2375: (
2376: p_headers IN PO_PDOI_TYPES.headers_rec_type
2377: ) IS
2378:
2379: d_api_name CONSTANT VARCHAR2(30) := 'insert_blk_dists_draft_all';
2380: d_module CONSTANT VARCHAR2(255) := d_pkg_name || d_api_name || '.';

Line 2498: p_dists IN PO_PDOI_TYPES.distributions_rec_type

2494: --End of Comments
2495: ------------------------------------------------------------------------
2496: PROCEDURE insert_po_dists_draft_all
2497: (
2498: p_dists IN PO_PDOI_TYPES.distributions_rec_type
2499: ) IS
2500:
2501: d_api_name CONSTANT VARCHAR2(30) := 'insert_po_dists_draft_all';
2502: d_module CONSTANT VARCHAR2(255) := d_pkg_name || d_api_name || '.';

Line 2774: p_lines IN PO_PDOI_TYPES.lines_rec_type

2770: --End of Comments
2771: ------------------------------------------------------------------------
2772: PROCEDURE insert_po_lines_draft_all
2773: (
2774: p_lines IN PO_PDOI_TYPES.lines_rec_type
2775: ) IS
2776:
2777: d_api_name CONSTANT VARCHAR2(30) := 'insert_po_lines_draft_all';
2778: d_module CONSTANT VARCHAR2(255) := d_pkg_name || d_api_name || '.';

Line 3122: p_line_locs IN PO_PDOI_TYPES.line_locs_rec_type

3118: --End of Comments
3119: ------------------------------------------------------------------------
3120: PROCEDURE insert_po_line_locs_draft_all
3121: (
3122: p_line_locs IN PO_PDOI_TYPES.line_locs_rec_type
3123: ) IS
3124:
3125: d_api_name CONSTANT VARCHAR2(30) := 'insert_po_line_locs_draft_all';
3126: d_module CONSTANT VARCHAR2(255) := d_pkg_name || d_api_name || '.';

Line 3416: p_price_diffs IN PO_PDOI_TYPES.price_diffs_rec_type

3412: --End of Comments
3413: ------------------------------------------------------------------------
3414: PROCEDURE insert_po_price_diff_draft
3415: (
3416: p_price_diffs IN PO_PDOI_TYPES.price_diffs_rec_type
3417: ) IS
3418:
3419: d_api_name CONSTANT VARCHAR2(30) := 'insert_po_price_diff_draft';
3420: d_module CONSTANT VARCHAR2(255) := d_pkg_name || d_api_name || '.';

Line 3527: p_attr_values IN PO_PDOI_TYPES.attr_values_rec_type

3523: ------------------------------------------------------------------------
3524: PROCEDURE merge_po_attr_values_draft
3525: (
3526: p_key IN po_session_gt.key%TYPE,
3527: p_attr_values IN PO_PDOI_TYPES.attr_values_rec_type
3528: ) IS
3529:
3530: d_api_name CONSTANT VARCHAR2(30) := 'merge_po_attr_values_draft';
3531: d_module CONSTANT VARCHAR2(255) := d_pkg_name || d_api_name || '.';

Line 4900: p_attr_values_tlp IN PO_PDOI_TYPES.attr_values_tlp_rec_type

4896: ------------------------------------------------------------------------
4897: PROCEDURE merge_po_attr_values_tlp_draft
4898: (
4899: p_key IN po_session_gt.key%TYPE,
4900: p_attr_values_tlp IN PO_PDOI_TYPES.attr_values_tlp_rec_type
4901: ) IS
4902:
4903: d_api_name CONSTANT VARCHAR2(30) := 'merge_po_attr_values_tlp_draft';
4904: d_module CONSTANT VARCHAR2(255) := d_pkg_name || d_api_name || '.';