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_LINE_LOC_PROCESS_PVT dependencies on DBMS_SQL

Line 13: p_index_tbl IN DBMS_SQL.NUMBER_TABLE,

9: --------------------------------------------------------------------------
10: PROCEDURE derive_line_loc_id
11: (
12: p_key IN po_session_gt.key%TYPE,
13: p_index_tbl IN DBMS_SQL.NUMBER_TABLE,
14: p_po_line_id_tbl IN PO_TBL_NUMBER,
15: p_shipment_num_tbl IN PO_TBL_NUMBER,
16: x_line_loc_id_tbl IN OUT NOCOPY PO_TBL_NUMBER
17: );

Line 22: p_index_tbl IN DBMS_SQL.NUMBER_TABLE,

18:
19: PROCEDURE derive_ship_to_org_id
20: (
21: p_key IN po_session_gt.key%TYPE,
22: p_index_tbl IN DBMS_SQL.NUMBER_TABLE,
23: p_ship_to_org_code_tbl IN PO_TBL_VARCHAR5,
24: x_ship_to_org_id_tbl IN OUT NOCOPY PO_TBL_NUMBER
25: );
26:

Line 30: p_index_tbl IN DBMS_SQL.NUMBER_TABLE,

26:
27: PROCEDURE derive_receiving_routing_id
28: (
29: p_key IN po_session_gt.key%TYPE,
30: p_index_tbl IN DBMS_SQL.NUMBER_TABLE,
31: p_receiving_routing_tbl IN PO_TBL_VARCHAR30,
32: x_receiving_routing_id_tbl IN OUT NOCOPY PO_TBL_NUMBER
33: );
34:

Line 38: p_index_tbl IN DBMS_SQL.NUMBER_TABLE,

34:
35: PROCEDURE derive_tax_name
36: (
37: p_key IN po_session_gt.key%TYPE,
38: p_index_tbl IN DBMS_SQL.NUMBER_TABLE,
39: p_tax_code_id_tbl IN PO_TBL_NUMBER,
40: x_tax_name_tbl IN OUT NOCOPY PO_TBL_VARCHAR30
41: );
42:

Line 46: p_index_tbl IN DBMS_SQL.NUMBER_TABLE,

42:
43: PROCEDURE default_locs_for_spo
44: (
45: p_key IN po_session_gt.key%TYPE,
46: p_index_tbl IN DBMS_SQL.NUMBER_TABLE,
47: x_line_locs IN OUT NOCOPY PO_PDOI_TYPES.line_locs_rec_type
48: );
49:
50: PROCEDURE default_locs_for_blanket

Line 53: p_index_tbl IN DBMS_SQL.NUMBER_TABLE,

49:
50: PROCEDURE default_locs_for_blanket
51: (
52: p_key IN po_session_gt.key%TYPE,
53: p_index_tbl IN DBMS_SQL.NUMBER_TABLE,
54: x_line_locs IN OUT NOCOPY PO_PDOI_TYPES.line_locs_rec_type
55: );
56:
57: PROCEDURE default_locs_for_quotation

Line 60: p_index_tbl IN DBMS_SQL.NUMBER_TABLE,

56:
57: PROCEDURE default_locs_for_quotation
58: (
59: p_key IN po_session_gt.key%TYPE,
60: p_index_tbl IN DBMS_SQL.NUMBER_TABLE,
61: x_line_locs IN OUT NOCOPY PO_PDOI_TYPES.line_locs_rec_type
62: );
63:
64: PROCEDURE default_inspect_required_flag

Line 67: p_index_tbl IN DBMS_SQL.NUMBER_TABLE,

63:
64: PROCEDURE default_inspect_required_flag
65: (
66: p_key IN po_session_gt.key%TYPE,
67: p_index_tbl IN DBMS_SQL.NUMBER_TABLE,
68: p_item_id_tbl IN PO_TBL_NUMBER,
69: x_inspection_required_flag_tbl IN OUT NOCOPY PO_TBL_VARCHAR1
70: );
71:

Line 75: p_index_tbl IN DBMS_SQL.NUMBER_TABLE,

71:
72: PROCEDURE default_ship_to_org_id
73: (
74: p_key IN po_session_gt.key%TYPE,
75: p_index_tbl IN DBMS_SQL.NUMBER_TABLE,
76: p_ship_to_loc_id_tbl IN PO_TBL_NUMBER,
77: x_ship_to_org_id_tbl IN OUT NOCOPY PO_TBL_NUMBER
78: );
79:

Line 83: p_index_tbl IN DBMS_SQL.NUMBER_TABLE,

79:
80: PROCEDURE default_close_tolerances
81: (
82: p_key IN po_session_gt.key%TYPE,
83: p_index_tbl IN DBMS_SQL.NUMBER_TABLE,
84: p_item_id_tbl IN PO_TBL_NUMBER,
85: p_ship_to_org_id_tbl IN PO_TBL_NUMBER,
86: p_line_type_id_tbl IN PO_TBL_NUMBER,
87: x_invoice_close_tolerance_tbl IN OUT NOCOPY PO_TBL_NUMBER,

Line 94: p_index_tbl IN DBMS_SQL.NUMBER_TABLE,

90:
91: PROCEDURE default_invoice_match_options
92: (
93: p_key IN po_session_gt.key%TYPE,
94: p_index_tbl IN DBMS_SQL.NUMBER_TABLE,
95: p_vendor_id_tbl IN PO_TBL_NUMBER,
96: p_vendor_site_id_tbl IN PO_TBL_NUMBER,
97: x_match_option_tbl IN OUT NOCOPY PO_TBL_VARCHAR30
98: );

Line 103: p_index_tbl IN DBMS_SQL.NUMBER_TABLE,

99:
100: PROCEDURE default_accrue_on_receipt_flag
101: (
102: p_key IN po_session_gt.key%TYPE,
103: p_index_tbl IN DBMS_SQL.NUMBER_TABLE,
104: p_item_id_tbl IN PO_TBL_NUMBER,
105: p_ship_to_org_id_tbl IN PO_TBL_NUMBER,
106: p_receipt_required_flag_tbl IN PO_TBL_VARCHAR1,
107: x_accrue_on_receipt_flag_tbl IN OUT NOCOPY PO_TBL_VARCHAR1

Line 120: p_index_tbl IN DBMS_SQL.NUMBER_TABLE,

116:
117: PROCEDURE default_secondary_unit_of_meas
118: (
119: p_key IN po_session_gt.key%TYPE,
120: p_index_tbl IN DBMS_SQL.NUMBER_TABLE,
121: p_item_id_tbl IN PO_TBL_NUMBER,
122: p_ship_to_org_id_tbl IN PO_TBL_NUMBER,
123: x_secondary_unit_of_meas_tbl IN OUT NOCOPY PO_TBL_VARCHAR30
124: );

Line 495: l_index_tbl DBMS_SQL.NUMBER_TABLE;

491: -- key of temp table used to identify the derived result
492: l_key po_session_gt.key%TYPE;
493:
494: -- table used to save the index of the each row
495: l_index_tbl DBMS_SQL.NUMBER_TABLE;
496: BEGIN
497: d_position := 0;
498:
499: IF (PO_LOG.d_proc) THEN

Line 777: l_index_tbl DBMS_SQL.NUMBER_TABLE;

773: -- key of temp table used to identify the derived result
774: l_key po_session_gt.key%TYPE;
775:
776: -- table used to save the index of the each row
777: l_index_tbl DBMS_SQL.NUMBER_TABLE;
778: BEGIN
779: d_position := 0;
780:
781: IF (PO_LOG.d_proc) THEN

Line 1115: p_po_line_id_tbl IN DBMS_SQL.NUMBER_TABLE,

1111: --End of Comments
1112: ------------------------------------------------------------------------
1113: PROCEDURE update_amount_quantity_on_line
1114: (
1115: p_po_line_id_tbl IN DBMS_SQL.NUMBER_TABLE,
1116: p_draft_id_tbl IN DBMS_SQL.NUMBER_TABLE
1117: ) IS
1118:
1119: d_api_name CONSTANT VARCHAR2(30) := 'update_amount_quantity_on_line';

Line 1116: p_draft_id_tbl IN DBMS_SQL.NUMBER_TABLE

1112: ------------------------------------------------------------------------
1113: PROCEDURE update_amount_quantity_on_line
1114: (
1115: p_po_line_id_tbl IN DBMS_SQL.NUMBER_TABLE,
1116: p_draft_id_tbl IN DBMS_SQL.NUMBER_TABLE
1117: ) IS
1118:
1119: d_api_name CONSTANT VARCHAR2(30) := 'update_amount_quantity_on_line';
1120: d_module CONSTANT VARCHAR2(255) := d_pkg_name || d_api_name || '.';

Line 1173: p_po_line_id_tbl IN DBMS_SQL.NUMBER_TABLE,

1169: --End of Comments
1170: ------------------------------------------------------------------------
1171: PROCEDURE delete_exist_price_breaks
1172: (
1173: p_po_line_id_tbl IN DBMS_SQL.NUMBER_TABLE,
1174: p_draft_id_tbl IN DBMS_SQL.NUMBER_TABLE
1175: ) IS
1176:
1177: d_api_name CONSTANT VARCHAR2(30) := 'delete_exist_price_breaks';

Line 1174: p_draft_id_tbl IN DBMS_SQL.NUMBER_TABLE

1170: ------------------------------------------------------------------------
1171: PROCEDURE delete_exist_price_breaks
1172: (
1173: p_po_line_id_tbl IN DBMS_SQL.NUMBER_TABLE,
1174: p_draft_id_tbl IN DBMS_SQL.NUMBER_TABLE
1175: ) IS
1176:
1177: d_api_name CONSTANT VARCHAR2(30) := 'delete_exist_price_breaks';
1178: d_module CONSTANT VARCHAR2(255) := d_pkg_name || d_api_name || '.';

Line 1272: p_index_tbl IN DBMS_SQL.NUMBER_TABLE,

1268: ------------------------------------------------------------------------
1269: PROCEDURE derive_line_loc_id
1270: (
1271: p_key IN po_session_gt.key%TYPE,
1272: p_index_tbl IN DBMS_SQL.NUMBER_TABLE,
1273: p_po_line_id_tbl IN PO_TBL_NUMBER,
1274: p_shipment_num_tbl IN PO_TBL_NUMBER,
1275: x_line_loc_id_tbl IN OUT NOCOPY PO_TBL_NUMBER
1276: ) IS

Line 1365: p_index_tbl IN DBMS_SQL.NUMBER_TABLE,

1361: ------------------------------------------------------------------------
1362: PROCEDURE derive_ship_to_org_id
1363: (
1364: p_key IN po_session_gt.key%TYPE,
1365: p_index_tbl IN DBMS_SQL.NUMBER_TABLE,
1366: p_ship_to_org_code_tbl IN PO_TBL_VARCHAR5,
1367: x_ship_to_org_id_tbl IN OUT NOCOPY PO_TBL_NUMBER
1368: ) IS
1369:

Line 1456: p_index_tbl IN DBMS_SQL.NUMBER_TABLE,

1452: ------------------------------------------------------------------------
1453: PROCEDURE derive_receiving_routing_id
1454: (
1455: p_key IN po_session_gt.key%TYPE,
1456: p_index_tbl IN DBMS_SQL.NUMBER_TABLE,
1457: p_receiving_routing_tbl IN PO_TBL_VARCHAR30,
1458: x_receiving_routing_id_tbl IN OUT NOCOPY PO_TBL_NUMBER
1459: ) IS
1460:

Line 1547: p_index_tbl IN DBMS_SQL.NUMBER_TABLE,

1543: ------------------------------------------------------------------------
1544: PROCEDURE derive_tax_name
1545: (
1546: p_key IN po_session_gt.key%TYPE,
1547: p_index_tbl IN DBMS_SQL.NUMBER_TABLE,
1548: p_tax_code_id_tbl IN PO_TBL_NUMBER,
1549: x_tax_name_tbl IN OUT NOCOPY PO_TBL_VARCHAR30
1550: ) IS
1551:

Line 1699: p_index_tbl IN DBMS_SQL.NUMBER_TABLE,

1695: ------------------------------------------------------------------------
1696: PROCEDURE default_locs_for_spo
1697: (
1698: p_key IN po_session_gt.key%TYPE,
1699: p_index_tbl IN DBMS_SQL.NUMBER_TABLE,
1700: x_line_locs IN OUT NOCOPY PO_PDOI_TYPES.line_locs_rec_type
1701: ) IS
1702:
1703: d_api_name CONSTANT VARCHAR2(30) := 'default_locs_for_spo';

Line 2001: p_index_tbl IN DBMS_SQL.NUMBER_TABLE,

1997: ------------------------------------------------------------------------
1998: PROCEDURE default_locs_for_blanket
1999: (
2000: p_key IN po_session_gt.key%TYPE,
2001: p_index_tbl IN DBMS_SQL.NUMBER_TABLE,
2002: x_line_locs IN OUT NOCOPY PO_PDOI_TYPES.line_locs_rec_type
2003: ) IS
2004:
2005: d_api_name CONSTANT VARCHAR2(30) := 'default_locs_for_blanket';

Line 2130: p_index_tbl IN DBMS_SQL.NUMBER_TABLE,

2126: ------------------------------------------------------------------------
2127: PROCEDURE default_locs_for_quotation
2128: (
2129: p_key IN po_session_gt.key%TYPE,
2130: p_index_tbl IN DBMS_SQL.NUMBER_TABLE,
2131: x_line_locs IN OUT NOCOPY PO_PDOI_TYPES.line_locs_rec_type
2132: ) IS
2133:
2134: d_api_name CONSTANT VARCHAR2(30) := 'default_locs_for_quotation';

Line 2330: p_index_tbl IN DBMS_SQL.NUMBER_TABLE,

2326: ------------------------------------------------------------------------
2327: PROCEDURE default_inspect_required_flag
2328: (
2329: p_key IN po_session_gt.key%TYPE,
2330: p_index_tbl IN DBMS_SQL.NUMBER_TABLE,
2331: p_item_id_tbl IN PO_TBL_NUMBER,
2332: x_inspection_required_flag_tbl IN OUT NOCOPY PO_TBL_VARCHAR1
2333: ) IS
2334:

Line 2420: p_index_tbl IN DBMS_SQL.NUMBER_TABLE,

2416: ------------------------------------------------------------------------
2417: PROCEDURE default_ship_to_org_id
2418: (
2419: p_key IN po_session_gt.key%TYPE,
2420: p_index_tbl IN DBMS_SQL.NUMBER_TABLE,
2421: p_ship_to_loc_id_tbl IN PO_TBL_NUMBER,
2422: x_ship_to_org_id_tbl IN OUT NOCOPY PO_TBL_NUMBER
2423: ) IS
2424:

Line 2522: p_index_tbl IN DBMS_SQL.NUMBER_TABLE,

2518: ------------------------------------------------------------------------
2519: PROCEDURE default_close_tolerances
2520: (
2521: p_key IN po_session_gt.key%TYPE,
2522: p_index_tbl IN DBMS_SQL.NUMBER_TABLE,
2523: p_item_id_tbl IN PO_TBL_NUMBER,
2524: p_ship_to_org_id_tbl IN PO_TBL_NUMBER,
2525: p_line_type_id_tbl IN PO_TBL_NUMBER,
2526: x_invoice_close_tolerance_tbl IN OUT NOCOPY PO_TBL_NUMBER,

Line 2733: p_index_tbl IN DBMS_SQL.NUMBER_TABLE,

2729: ------------------------------------------------------------------------
2730: PROCEDURE default_invoice_match_options
2731: (
2732: p_key IN po_session_gt.key%TYPE,
2733: p_index_tbl IN DBMS_SQL.NUMBER_TABLE,
2734: p_vendor_id_tbl IN PO_TBL_NUMBER,
2735: p_vendor_site_id_tbl IN PO_TBL_NUMBER,
2736: x_match_option_tbl IN OUT NOCOPY PO_TBL_VARCHAR30
2737: ) IS

Line 2864: p_index_tbl IN DBMS_SQL.NUMBER_TABLE,

2860: ------------------------------------------------------------------------
2861: PROCEDURE default_accrue_on_receipt_flag
2862: (
2863: p_key IN po_session_gt.key%TYPE,
2864: p_index_tbl IN DBMS_SQL.NUMBER_TABLE,
2865: p_item_id_tbl IN PO_TBL_NUMBER,
2866: p_ship_to_org_id_tbl IN PO_TBL_NUMBER,
2867: p_receipt_required_flag_tbl IN PO_TBL_VARCHAR1,
2868: x_accrue_on_receipt_flag_tbl IN OUT NOCOPY PO_TBL_VARCHAR1

Line 3003: p_index_tbl IN DBMS_SQL.NUMBER_TABLE,

2999: ------------------------------------------------------------------------
3000: PROCEDURE default_secondary_unit_of_meas
3001: (
3002: p_key IN po_session_gt.key%TYPE,
3003: p_index_tbl IN DBMS_SQL.NUMBER_TABLE,
3004: p_item_id_tbl IN PO_TBL_NUMBER,
3005: p_ship_to_org_id_tbl IN PO_TBL_NUMBER,
3006: x_secondary_unit_of_meas_tbl IN OUT NOCOPY PO_TBL_VARCHAR30
3007: ) IS

Line 3103: l_index_tbl DBMS_SQL.number_table;

3099: d_api_name CONSTANT VARCHAR2(30) := 'populate_error_flag';
3100: d_module CONSTANT VARCHAR2(255) := d_pkg_name || d_api_name || '.';
3101: d_position NUMBER;
3102:
3103: l_index_tbl DBMS_SQL.number_table;
3104: l_index NUMBER;
3105: l_intf_header_id NUMBER;
3106: l_remove_err_line_loc_tbl PO_TBL_NUMBER := PO_TBL_NUMBER();
3107: l_remove_err_line_tbl PO_TBL_NUMBER := PO_TBL_NUMBER();