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 PO_TBL_NUMBER

Line 14: p_po_line_id_tbl IN PO_TBL_NUMBER,

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: );
18:

Line 15: p_shipment_num_tbl IN PO_TBL_NUMBER,

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: );
18:
19: PROCEDURE derive_ship_to_org_id

Line 16: x_line_loc_id_tbl IN OUT NOCOPY PO_TBL_NUMBER

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: );
18:
19: PROCEDURE derive_ship_to_org_id
20: (

Line 24: x_ship_to_org_id_tbl IN OUT NOCOPY PO_TBL_NUMBER

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:
27: PROCEDURE derive_receiving_routing_id
28: (

Line 32: x_receiving_routing_id_tbl IN OUT NOCOPY PO_TBL_NUMBER

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:
35: PROCEDURE derive_tax_name
36: (

Line 39: p_tax_code_id_tbl IN PO_TBL_NUMBER,

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:
43: PROCEDURE default_locs_for_spo

Line 68: p_item_id_tbl IN PO_TBL_NUMBER,

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:
72: PROCEDURE default_ship_to_org_id

Line 76: p_ship_to_loc_id_tbl IN PO_TBL_NUMBER,

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:
80: PROCEDURE default_close_tolerances

Line 77: x_ship_to_org_id_tbl IN OUT NOCOPY PO_TBL_NUMBER

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:
80: PROCEDURE default_close_tolerances
81: (

Line 84: p_item_id_tbl IN PO_TBL_NUMBER,

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,
88: x_receive_close_tolerance_tbl IN OUT NOCOPY PO_TBL_NUMBER

Line 85: p_ship_to_org_id_tbl IN PO_TBL_NUMBER,

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,
88: x_receive_close_tolerance_tbl IN OUT NOCOPY PO_TBL_NUMBER
89: );

Line 86: p_line_type_id_tbl IN PO_TBL_NUMBER,

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,
88: x_receive_close_tolerance_tbl IN OUT NOCOPY PO_TBL_NUMBER
89: );
90:

Line 87: x_invoice_close_tolerance_tbl IN OUT NOCOPY PO_TBL_NUMBER,

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,
88: x_receive_close_tolerance_tbl IN OUT NOCOPY PO_TBL_NUMBER
89: );
90:
91: PROCEDURE default_invoice_match_options

Line 88: x_receive_close_tolerance_tbl IN OUT NOCOPY PO_TBL_NUMBER

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,
88: x_receive_close_tolerance_tbl IN OUT NOCOPY PO_TBL_NUMBER
89: );
90:
91: PROCEDURE default_invoice_match_options
92: (

Line 95: p_vendor_id_tbl IN PO_TBL_NUMBER,

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: );
99:

Line 96: p_vendor_site_id_tbl IN PO_TBL_NUMBER,

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: );
99:
100: PROCEDURE default_accrue_on_receipt_flag

Line 104: p_item_id_tbl IN PO_TBL_NUMBER,

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
108: );

Line 105: p_ship_to_org_id_tbl IN PO_TBL_NUMBER,

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
108: );
109:

Line 112: p_item_id_tbl IN PO_TBL_NUMBER,

108: );
109:
110: PROCEDURE default_outsourced_assembly
111: (
112: p_item_id_tbl IN PO_TBL_NUMBER,
113: p_ship_to_organization_id_tbl IN PO_TBL_NUMBER,
114: x_outsourced_assembly_tbl IN OUT NOCOPY PO_TBL_NUMBER
115: );
116:

Line 113: p_ship_to_organization_id_tbl IN PO_TBL_NUMBER,

109:
110: PROCEDURE default_outsourced_assembly
111: (
112: p_item_id_tbl IN PO_TBL_NUMBER,
113: p_ship_to_organization_id_tbl IN PO_TBL_NUMBER,
114: x_outsourced_assembly_tbl IN OUT NOCOPY PO_TBL_NUMBER
115: );
116:
117: PROCEDURE default_secondary_unit_of_meas

Line 114: x_outsourced_assembly_tbl IN OUT NOCOPY PO_TBL_NUMBER

110: PROCEDURE default_outsourced_assembly
111: (
112: p_item_id_tbl IN PO_TBL_NUMBER,
113: p_ship_to_organization_id_tbl IN PO_TBL_NUMBER,
114: x_outsourced_assembly_tbl IN OUT NOCOPY PO_TBL_NUMBER
115: );
116:
117: PROCEDURE default_secondary_unit_of_meas
118: (

Line 121: p_item_id_tbl IN PO_TBL_NUMBER,

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: );
125:

Line 122: p_ship_to_org_id_tbl IN PO_TBL_NUMBER,

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: );
125:
126: PROCEDURE populate_error_flag

Line 1055: p_intf_line_loc_id_tbl IN PO_TBL_NUMBER,

1051: --End of Comments
1052: ------------------------------------------------------------------------
1053: PROCEDURE update_line_loc_interface
1054: (
1055: p_intf_line_loc_id_tbl IN PO_TBL_NUMBER,
1056: p_line_loc_id_tbl IN PO_TBL_NUMBER,
1057: p_error_flag_tbl IN PO_TBL_VARCHAR1
1058: ) IS
1059:

Line 1056: p_line_loc_id_tbl IN PO_TBL_NUMBER,

1052: ------------------------------------------------------------------------
1053: PROCEDURE update_line_loc_interface
1054: (
1055: p_intf_line_loc_id_tbl IN PO_TBL_NUMBER,
1056: p_line_loc_id_tbl IN PO_TBL_NUMBER,
1057: p_error_flag_tbl IN PO_TBL_VARCHAR1
1058: ) IS
1059:
1060: d_api_name CONSTANT VARCHAR2(30) := 'update_line_loc_interface';

Line 1185: l_line_loc_id_tbl PO_TBL_NUMBER;

1181: -- key value used to identify rows in po_session_gt table
1182: l_key po_session_gt.key%TYPE;
1183:
1184: -- variables to hold results from po_session_gt table
1185: l_line_loc_id_tbl PO_TBL_NUMBER;
1186: l_draft_id_tbl PO_TBL_NUMBER;
1187:
1188: l_delete_flag_tbl PO_TBL_VARCHAR1 := PO_TBL_VARCHAR1();
1189: l_record_already_exist_tbl PO_TBL_VARCHAR1 := PO_TBL_VARCHAR1();

Line 1186: l_draft_id_tbl PO_TBL_NUMBER;

1182: l_key po_session_gt.key%TYPE;
1183:
1184: -- variables to hold results from po_session_gt table
1185: l_line_loc_id_tbl PO_TBL_NUMBER;
1186: l_draft_id_tbl PO_TBL_NUMBER;
1187:
1188: l_delete_flag_tbl PO_TBL_VARCHAR1 := PO_TBL_VARCHAR1();
1189: l_record_already_exist_tbl PO_TBL_VARCHAR1 := PO_TBL_VARCHAR1();
1190: BEGIN

Line 1273: p_po_line_id_tbl IN PO_TBL_NUMBER,

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

Line 1274: p_shipment_num_tbl IN PO_TBL_NUMBER,

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
1277:
1278: d_api_name CONSTANT VARCHAR2(30) := 'derive_line_loc_id';

Line 1275: x_line_loc_id_tbl IN OUT NOCOPY PO_TBL_NUMBER

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
1277:
1278: d_api_name CONSTANT VARCHAR2(30) := 'derive_line_loc_id';
1279: d_module CONSTANT VARCHAR2(255) := d_pkg_name || d_api_name || '.';

Line 1283: l_index_tbl PO_TBL_NUMBER;

1279: d_module CONSTANT VARCHAR2(255) := d_pkg_name || d_api_name || '.';
1280: d_position NUMBER;
1281:
1282: -- tables to store the derived result
1283: l_index_tbl PO_TBL_NUMBER;
1284: l_result_tbl PO_TBL_NUMBER;
1285: BEGIN
1286: d_position := 0;
1287:

Line 1284: l_result_tbl PO_TBL_NUMBER;

1280: d_position NUMBER;
1281:
1282: -- tables to store the derived result
1283: l_index_tbl PO_TBL_NUMBER;
1284: l_result_tbl PO_TBL_NUMBER;
1285: BEGIN
1286: d_position := 0;
1287:
1288: IF (PO_LOG.d_proc) THEN

Line 1367: x_ship_to_org_id_tbl IN OUT NOCOPY PO_TBL_NUMBER

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

Line 1375: l_index_tbl PO_TBL_NUMBER;

1371: d_module CONSTANT VARCHAR2(255) := d_pkg_name || d_api_name || '.';
1372: d_position NUMBER;
1373:
1374: -- tables to store the derived result
1375: l_index_tbl PO_TBL_NUMBER;
1376: l_result_tbl PO_TBL_NUMBER;
1377: BEGIN
1378: d_position := 0;
1379:

Line 1376: l_result_tbl PO_TBL_NUMBER;

1372: d_position NUMBER;
1373:
1374: -- tables to store the derived result
1375: l_index_tbl PO_TBL_NUMBER;
1376: l_result_tbl PO_TBL_NUMBER;
1377: BEGIN
1378: d_position := 0;
1379:
1380: IF (PO_LOG.d_proc) THEN

Line 1458: x_receiving_routing_id_tbl IN OUT NOCOPY PO_TBL_NUMBER

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

Line 1466: l_index_tbl PO_TBL_NUMBER;

1462: d_module CONSTANT VARCHAR2(255) := d_pkg_name || d_api_name || '.';
1463: d_position NUMBER;
1464:
1465: -- tables to store the derived result
1466: l_index_tbl PO_TBL_NUMBER;
1467: l_result_tbl PO_TBL_NUMBER;
1468: BEGIN
1469: d_position := 0;
1470:

Line 1467: l_result_tbl PO_TBL_NUMBER;

1463: d_position NUMBER;
1464:
1465: -- tables to store the derived result
1466: l_index_tbl PO_TBL_NUMBER;
1467: l_result_tbl PO_TBL_NUMBER;
1468: BEGIN
1469: d_position := 0;
1470:
1471: IF (PO_LOG.d_proc) THEN

Line 1548: p_tax_code_id_tbl IN PO_TBL_NUMBER,

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:
1552: d_api_name CONSTANT VARCHAR2(30) := 'derive_tax_name';

Line 1557: l_index_tbl PO_TBL_NUMBER;

1553: d_module CONSTANT VARCHAR2(255) := d_pkg_name || d_api_name || '.';
1554: d_position NUMBER;
1555:
1556: -- tables to store the derived result
1557: l_index_tbl PO_TBL_NUMBER;
1558: l_result_tbl PO_TBL_VARCHAR30;
1559: BEGIN
1560: d_position := 0;
1561:

Line 1636: p_item_id_tbl IN PO_TBL_NUMBER,

1632: --End of Comments
1633: ------------------------------------------------------------------------
1634: PROCEDURE default_outsourced_assembly
1635: (
1636: p_item_id_tbl IN PO_TBL_NUMBER,
1637: p_ship_to_organization_id_tbl IN PO_TBL_NUMBER,
1638: x_outsourced_assembly_tbl IN OUT NOCOPY PO_TBL_NUMBER
1639: ) IS
1640:

Line 1637: p_ship_to_organization_id_tbl IN PO_TBL_NUMBER,

1633: ------------------------------------------------------------------------
1634: PROCEDURE default_outsourced_assembly
1635: (
1636: p_item_id_tbl IN PO_TBL_NUMBER,
1637: p_ship_to_organization_id_tbl IN PO_TBL_NUMBER,
1638: x_outsourced_assembly_tbl IN OUT NOCOPY PO_TBL_NUMBER
1639: ) IS
1640:
1641: d_api_name CONSTANT VARCHAR2(30) := 'default_outsourced_assembly';

Line 1638: x_outsourced_assembly_tbl IN OUT NOCOPY PO_TBL_NUMBER

1634: PROCEDURE default_outsourced_assembly
1635: (
1636: p_item_id_tbl IN PO_TBL_NUMBER,
1637: p_ship_to_organization_id_tbl IN PO_TBL_NUMBER,
1638: x_outsourced_assembly_tbl IN OUT NOCOPY PO_TBL_NUMBER
1639: ) IS
1640:
1641: d_api_name CONSTANT VARCHAR2(30) := 'default_outsourced_assembly';
1642: d_module CONSTANT VARCHAR2(255) := d_pkg_name || d_api_name || '.';

Line 1646: l_index_tbl PO_TBL_NUMBER;

1642: d_module CONSTANT VARCHAR2(255) := d_pkg_name || d_api_name || '.';
1643: d_position NUMBER;
1644:
1645: -- tables to store the derived result
1646: l_index_tbl PO_TBL_NUMBER;
1647: l_result_tbl PO_TBL_NUMBER;
1648: BEGIN
1649: d_position := 0;
1650:

Line 1647: l_result_tbl PO_TBL_NUMBER;

1643: d_position NUMBER;
1644:
1645: -- tables to store the derived result
1646: l_index_tbl PO_TBL_NUMBER;
1647: l_result_tbl PO_TBL_NUMBER;
1648: BEGIN
1649: d_position := 0;
1650:
1651: IF (PO_LOG.d_proc) THEN

Line 2331: p_item_id_tbl IN PO_TBL_NUMBER,

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:
2335: d_api_name CONSTANT VARCHAR2(30) := 'default_inspect_required_flag';

Line 2340: l_index_tbl PO_TBL_NUMBER;

2336: d_module CONSTANT VARCHAR2(255) := d_pkg_name || d_api_name || '.';
2337: d_position NUMBER;
2338:
2339: -- variable to hold the default query result
2340: l_index_tbl PO_TBL_NUMBER;
2341: l_result_tbl PO_TBL_VARCHAR1;
2342: BEGIN
2343: d_position := 0;
2344:

Line 2421: p_ship_to_loc_id_tbl IN PO_TBL_NUMBER,

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:
2425: d_api_name CONSTANT VARCHAR2(30) := 'default_ship_to_org_id';

Line 2422: x_ship_to_org_id_tbl IN OUT NOCOPY PO_TBL_NUMBER

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

Line 2430: l_index_tbl PO_TBL_NUMBER;

2426: d_module CONSTANT VARCHAR2(255) := d_pkg_name || d_api_name || '.';
2427: d_position NUMBER;
2428:
2429: -- variable to hold the default query result
2430: l_index_tbl PO_TBL_NUMBER;
2431: l_result_tbl PO_TBL_NUMBER;
2432: BEGIN
2433: d_position := 0;
2434:

Line 2431: l_result_tbl PO_TBL_NUMBER;

2427: d_position NUMBER;
2428:
2429: -- variable to hold the default query result
2430: l_index_tbl PO_TBL_NUMBER;
2431: l_result_tbl PO_TBL_NUMBER;
2432: BEGIN
2433: d_position := 0;
2434:
2435: IF (PO_LOG.d_proc) THEN

Line 2523: p_item_id_tbl IN PO_TBL_NUMBER,

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,
2527: x_receive_close_tolerance_tbl IN OUT NOCOPY PO_TBL_NUMBER

Line 2524: p_ship_to_org_id_tbl IN PO_TBL_NUMBER,

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,
2527: x_receive_close_tolerance_tbl IN OUT NOCOPY PO_TBL_NUMBER
2528: ) IS

Line 2525: p_line_type_id_tbl IN PO_TBL_NUMBER,

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,
2527: x_receive_close_tolerance_tbl IN OUT NOCOPY PO_TBL_NUMBER
2528: ) IS
2529:

Line 2526: x_invoice_close_tolerance_tbl IN OUT NOCOPY PO_TBL_NUMBER,

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,
2527: x_receive_close_tolerance_tbl IN OUT NOCOPY PO_TBL_NUMBER
2528: ) IS
2529:
2530: d_api_name CONSTANT VARCHAR2(30) := 'default_close_tolerances';

Line 2527: x_receive_close_tolerance_tbl IN OUT NOCOPY PO_TBL_NUMBER

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,
2527: x_receive_close_tolerance_tbl IN OUT NOCOPY PO_TBL_NUMBER
2528: ) IS
2529:
2530: d_api_name CONSTANT VARCHAR2(30) := 'default_close_tolerances';
2531: d_module CONSTANT VARCHAR2(255) := d_pkg_name || d_api_name || '.';

Line 2535: l_index_tbl PO_TBL_NUMBER;

2531: d_module CONSTANT VARCHAR2(255) := d_pkg_name || d_api_name || '.';
2532: d_position NUMBER;
2533:
2534: -- variable to hold the default query result
2535: l_index_tbl PO_TBL_NUMBER;
2536: l_invoice_tolerance_tbl PO_TBL_NUMBER;
2537: l_receive_tolerance_tbl PO_TBL_NUMBER;
2538:
2539: -- temp index value

Line 2536: l_invoice_tolerance_tbl PO_TBL_NUMBER;

2532: d_position NUMBER;
2533:
2534: -- variable to hold the default query result
2535: l_index_tbl PO_TBL_NUMBER;
2536: l_invoice_tolerance_tbl PO_TBL_NUMBER;
2537: l_receive_tolerance_tbl PO_TBL_NUMBER;
2538:
2539: -- temp index value
2540: l_index NUMBER;

Line 2537: l_receive_tolerance_tbl PO_TBL_NUMBER;

2533:
2534: -- variable to hold the default query result
2535: l_index_tbl PO_TBL_NUMBER;
2536: l_invoice_tolerance_tbl PO_TBL_NUMBER;
2537: l_receive_tolerance_tbl PO_TBL_NUMBER;
2538:
2539: -- temp index value
2540: l_index NUMBER;
2541: BEGIN

Line 2734: p_vendor_id_tbl IN PO_TBL_NUMBER,

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

Line 2735: p_vendor_site_id_tbl IN PO_TBL_NUMBER,

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
2738:
2739: d_api_name CONSTANT VARCHAR2(30) := 'default_invoice_match_options';

Line 2744: l_index_tbl PO_TBL_NUMBER;

2740: d_module CONSTANT VARCHAR2(255) := d_pkg_name || d_api_name || '.';
2741: d_position NUMBER;
2742:
2743: -- variable to hold the default query result
2744: l_index_tbl PO_TBL_NUMBER;
2745: l_result_tbl PO_TBL_VARCHAR30;
2746: BEGIN
2747: d_position := 0;
2748:

Line 2865: p_item_id_tbl IN PO_TBL_NUMBER,

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
2869: ) IS

Line 2866: p_ship_to_org_id_tbl IN PO_TBL_NUMBER,

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
2869: ) IS
2870:

Line 2876: l_index_tbl PO_TBL_NUMBER;

2872: d_module CONSTANT VARCHAR2(255) := d_pkg_name || d_api_name || '.';
2873: d_position NUMBER;
2874:
2875: -- variable to hold the default query result
2876: l_index_tbl PO_TBL_NUMBER;
2877: l_outside_op_flag_tbl PO_TBL_VARCHAR1;
2878: l_stock_enabled_flag_tbl PO_TBL_VARCHAR1;
2879:
2880: l_item_status VARCHAR2(1);

Line 3004: p_item_id_tbl IN PO_TBL_NUMBER,

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

Line 3005: p_ship_to_org_id_tbl IN PO_TBL_NUMBER,

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
3008:
3009: d_api_name CONSTANT VARCHAR2(30) := 'default_secondary_unit_of_meas';

Line 3014: l_index_tbl PO_TBL_NUMBER;

3010: d_module CONSTANT VARCHAR2(255) := d_pkg_name || d_api_name || '.';
3011: d_position NUMBER;
3012:
3013: -- variable to hold the default query result
3014: l_index_tbl PO_TBL_NUMBER;
3015: l_result_tbl PO_TBL_VARCHAR30;
3016: BEGIN
3017: d_position := 0;
3018:

Line 3106: l_remove_err_line_loc_tbl PO_TBL_NUMBER := PO_TBL_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();
3108: BEGIN
3109: d_position := 0;
3110:

Line 3107: l_remove_err_line_tbl PO_TBL_NUMBER := PO_TBL_NUMBER();

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();
3108: BEGIN
3109: d_position := 0;
3110:
3111: IF (PO_LOG.d_proc) THEN