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 1158: p_intf_line_loc_id_tbl IN PO_TBL_NUMBER,

1154: --End of Comments
1155: ------------------------------------------------------------------------
1156: PROCEDURE update_line_loc_interface
1157: (
1158: p_intf_line_loc_id_tbl IN PO_TBL_NUMBER,
1159: p_line_loc_id_tbl IN PO_TBL_NUMBER,
1160: p_error_flag_tbl IN PO_TBL_VARCHAR1
1161: ) IS
1162:

Line 1159: p_line_loc_id_tbl IN PO_TBL_NUMBER,

1155: ------------------------------------------------------------------------
1156: PROCEDURE update_line_loc_interface
1157: (
1158: p_intf_line_loc_id_tbl IN PO_TBL_NUMBER,
1159: p_line_loc_id_tbl IN PO_TBL_NUMBER,
1160: p_error_flag_tbl IN PO_TBL_VARCHAR1
1161: ) IS
1162:
1163: d_api_name CONSTANT VARCHAR2(30) := 'update_line_loc_interface';

Line 1294: l_line_loc_id_tbl PO_TBL_NUMBER;

1290: -- key value used to identify rows in po_session_gt table
1291: l_key po_session_gt.key%TYPE;
1292:
1293: -- variables to hold results from po_session_gt table
1294: l_line_loc_id_tbl PO_TBL_NUMBER;
1295: l_draft_id_tbl PO_TBL_NUMBER;
1296:
1297: l_delete_flag_tbl PO_TBL_VARCHAR1 := PO_TBL_VARCHAR1();
1298: l_record_already_exist_tbl PO_TBL_VARCHAR1 := PO_TBL_VARCHAR1();

Line 1295: l_draft_id_tbl PO_TBL_NUMBER;

1291: l_key po_session_gt.key%TYPE;
1292:
1293: -- variables to hold results from po_session_gt table
1294: l_line_loc_id_tbl PO_TBL_NUMBER;
1295: l_draft_id_tbl PO_TBL_NUMBER;
1296:
1297: l_delete_flag_tbl PO_TBL_VARCHAR1 := PO_TBL_VARCHAR1();
1298: l_record_already_exist_tbl PO_TBL_VARCHAR1 := PO_TBL_VARCHAR1();
1299: BEGIN

Line 1382: p_po_line_id_tbl IN PO_TBL_NUMBER,

1378: PROCEDURE derive_line_loc_id
1379: (
1380: p_key IN po_session_gt.key%TYPE,
1381: p_index_tbl IN DBMS_SQL.NUMBER_TABLE,
1382: p_po_line_id_tbl IN PO_TBL_NUMBER,
1383: p_shipment_num_tbl IN PO_TBL_NUMBER,
1384: x_line_loc_id_tbl IN OUT NOCOPY PO_TBL_NUMBER
1385: ) IS
1386:

Line 1383: p_shipment_num_tbl IN PO_TBL_NUMBER,

1379: (
1380: p_key IN po_session_gt.key%TYPE,
1381: p_index_tbl IN DBMS_SQL.NUMBER_TABLE,
1382: p_po_line_id_tbl IN PO_TBL_NUMBER,
1383: p_shipment_num_tbl IN PO_TBL_NUMBER,
1384: x_line_loc_id_tbl IN OUT NOCOPY PO_TBL_NUMBER
1385: ) IS
1386:
1387: d_api_name CONSTANT VARCHAR2(30) := 'derive_line_loc_id';

Line 1384: x_line_loc_id_tbl IN OUT NOCOPY PO_TBL_NUMBER

1380: p_key IN po_session_gt.key%TYPE,
1381: p_index_tbl IN DBMS_SQL.NUMBER_TABLE,
1382: p_po_line_id_tbl IN PO_TBL_NUMBER,
1383: p_shipment_num_tbl IN PO_TBL_NUMBER,
1384: x_line_loc_id_tbl IN OUT NOCOPY PO_TBL_NUMBER
1385: ) IS
1386:
1387: d_api_name CONSTANT VARCHAR2(30) := 'derive_line_loc_id';
1388: d_module CONSTANT VARCHAR2(255) := d_pkg_name || d_api_name || '.';

Line 1392: l_index_tbl PO_TBL_NUMBER;

1388: d_module CONSTANT VARCHAR2(255) := d_pkg_name || d_api_name || '.';
1389: d_position NUMBER;
1390:
1391: -- tables to store the derived result
1392: l_index_tbl PO_TBL_NUMBER;
1393: l_result_tbl PO_TBL_NUMBER;
1394: BEGIN
1395: d_position := 0;
1396:

Line 1393: l_result_tbl PO_TBL_NUMBER;

1389: d_position NUMBER;
1390:
1391: -- tables to store the derived result
1392: l_index_tbl PO_TBL_NUMBER;
1393: l_result_tbl PO_TBL_NUMBER;
1394: BEGIN
1395: d_position := 0;
1396:
1397: IF (PO_LOG.d_proc) THEN

Line 1476: x_ship_to_org_id_tbl IN OUT NOCOPY PO_TBL_NUMBER

1472: (
1473: p_key IN po_session_gt.key%TYPE,
1474: p_index_tbl IN DBMS_SQL.NUMBER_TABLE,
1475: p_ship_to_org_code_tbl IN PO_TBL_VARCHAR5,
1476: x_ship_to_org_id_tbl IN OUT NOCOPY PO_TBL_NUMBER
1477: ) IS
1478:
1479: d_api_name CONSTANT VARCHAR2(30) := 'derive_ship_to_org_id';
1480: d_module CONSTANT VARCHAR2(255) := d_pkg_name || d_api_name || '.';

Line 1484: l_index_tbl PO_TBL_NUMBER;

1480: d_module CONSTANT VARCHAR2(255) := d_pkg_name || d_api_name || '.';
1481: d_position NUMBER;
1482:
1483: -- tables to store the derived result
1484: l_index_tbl PO_TBL_NUMBER;
1485: l_result_tbl PO_TBL_NUMBER;
1486: BEGIN
1487: d_position := 0;
1488:

Line 1485: l_result_tbl PO_TBL_NUMBER;

1481: d_position NUMBER;
1482:
1483: -- tables to store the derived result
1484: l_index_tbl PO_TBL_NUMBER;
1485: l_result_tbl PO_TBL_NUMBER;
1486: BEGIN
1487: d_position := 0;
1488:
1489: IF (PO_LOG.d_proc) THEN

Line 1567: x_receiving_routing_id_tbl IN OUT NOCOPY PO_TBL_NUMBER

1563: (
1564: p_key IN po_session_gt.key%TYPE,
1565: p_index_tbl IN DBMS_SQL.NUMBER_TABLE,
1566: p_receiving_routing_tbl IN PO_TBL_VARCHAR30,
1567: x_receiving_routing_id_tbl IN OUT NOCOPY PO_TBL_NUMBER
1568: ) IS
1569:
1570: d_api_name CONSTANT VARCHAR2(30) := 'derive_receiving_routing_id';
1571: d_module CONSTANT VARCHAR2(255) := d_pkg_name || d_api_name || '.';

Line 1575: l_index_tbl PO_TBL_NUMBER;

1571: d_module CONSTANT VARCHAR2(255) := d_pkg_name || d_api_name || '.';
1572: d_position NUMBER;
1573:
1574: -- tables to store the derived result
1575: l_index_tbl PO_TBL_NUMBER;
1576: l_result_tbl PO_TBL_NUMBER;
1577: BEGIN
1578: d_position := 0;
1579:

Line 1576: l_result_tbl PO_TBL_NUMBER;

1572: d_position NUMBER;
1573:
1574: -- tables to store the derived result
1575: l_index_tbl PO_TBL_NUMBER;
1576: l_result_tbl PO_TBL_NUMBER;
1577: BEGIN
1578: d_position := 0;
1579:
1580: IF (PO_LOG.d_proc) THEN

Line 1657: p_tax_code_id_tbl IN PO_TBL_NUMBER,

1653: PROCEDURE derive_tax_name
1654: (
1655: p_key IN po_session_gt.key%TYPE,
1656: p_index_tbl IN DBMS_SQL.NUMBER_TABLE,
1657: p_tax_code_id_tbl IN PO_TBL_NUMBER,
1658: x_tax_name_tbl IN OUT NOCOPY PO_TBL_VARCHAR30
1659: ) IS
1660:
1661: d_api_name CONSTANT VARCHAR2(30) := 'derive_tax_name';

Line 1666: l_index_tbl PO_TBL_NUMBER;

1662: d_module CONSTANT VARCHAR2(255) := d_pkg_name || d_api_name || '.';
1663: d_position NUMBER;
1664:
1665: -- tables to store the derived result
1666: l_index_tbl PO_TBL_NUMBER;
1667: l_result_tbl PO_TBL_VARCHAR30;
1668: BEGIN
1669: d_position := 0;
1670:

Line 1745: p_item_id_tbl IN PO_TBL_NUMBER,

1741: --End of Comments
1742: ------------------------------------------------------------------------
1743: PROCEDURE default_outsourced_assembly
1744: (
1745: p_item_id_tbl IN PO_TBL_NUMBER,
1746: p_ship_to_organization_id_tbl IN PO_TBL_NUMBER,
1747: x_outsourced_assembly_tbl IN OUT NOCOPY PO_TBL_NUMBER
1748: ) IS
1749:

Line 1746: p_ship_to_organization_id_tbl IN PO_TBL_NUMBER,

1742: ------------------------------------------------------------------------
1743: PROCEDURE default_outsourced_assembly
1744: (
1745: p_item_id_tbl IN PO_TBL_NUMBER,
1746: p_ship_to_organization_id_tbl IN PO_TBL_NUMBER,
1747: x_outsourced_assembly_tbl IN OUT NOCOPY PO_TBL_NUMBER
1748: ) IS
1749:
1750: d_api_name CONSTANT VARCHAR2(30) := 'default_outsourced_assembly';

Line 1747: x_outsourced_assembly_tbl IN OUT NOCOPY PO_TBL_NUMBER

1743: PROCEDURE default_outsourced_assembly
1744: (
1745: p_item_id_tbl IN PO_TBL_NUMBER,
1746: p_ship_to_organization_id_tbl IN PO_TBL_NUMBER,
1747: x_outsourced_assembly_tbl IN OUT NOCOPY PO_TBL_NUMBER
1748: ) IS
1749:
1750: d_api_name CONSTANT VARCHAR2(30) := 'default_outsourced_assembly';
1751: d_module CONSTANT VARCHAR2(255) := d_pkg_name || d_api_name || '.';

Line 1755: l_index_tbl PO_TBL_NUMBER;

1751: d_module CONSTANT VARCHAR2(255) := d_pkg_name || d_api_name || '.';
1752: d_position NUMBER;
1753:
1754: -- tables to store the derived result
1755: l_index_tbl PO_TBL_NUMBER;
1756: l_result_tbl PO_TBL_NUMBER;
1757: BEGIN
1758: d_position := 0;
1759:

Line 1756: l_result_tbl PO_TBL_NUMBER;

1752: d_position NUMBER;
1753:
1754: -- tables to store the derived result
1755: l_index_tbl PO_TBL_NUMBER;
1756: l_result_tbl PO_TBL_NUMBER;
1757: BEGIN
1758: d_position := 0;
1759:
1760: IF (PO_LOG.d_proc) THEN

Line 2522: p_item_id_tbl IN PO_TBL_NUMBER,

2518: PROCEDURE default_inspect_required_flag
2519: (
2520: p_key IN po_session_gt.key%TYPE,
2521: p_index_tbl IN DBMS_SQL.NUMBER_TABLE,
2522: p_item_id_tbl IN PO_TBL_NUMBER,
2523: x_inspection_required_flag_tbl IN OUT NOCOPY PO_TBL_VARCHAR1
2524: ) IS
2525:
2526: d_api_name CONSTANT VARCHAR2(30) := 'default_inspect_required_flag';

Line 2531: l_index_tbl PO_TBL_NUMBER;

2527: d_module CONSTANT VARCHAR2(255) := d_pkg_name || d_api_name || '.';
2528: d_position NUMBER;
2529:
2530: -- variable to hold the default query result
2531: l_index_tbl PO_TBL_NUMBER;
2532: l_result_tbl PO_TBL_VARCHAR1;
2533: BEGIN
2534: d_position := 0;
2535:

Line 2612: p_ship_to_loc_id_tbl IN PO_TBL_NUMBER,

2608: PROCEDURE default_ship_to_org_id
2609: (
2610: p_key IN po_session_gt.key%TYPE,
2611: p_index_tbl IN DBMS_SQL.NUMBER_TABLE,
2612: p_ship_to_loc_id_tbl IN PO_TBL_NUMBER,
2613: x_ship_to_org_id_tbl IN OUT NOCOPY PO_TBL_NUMBER
2614: ) IS
2615:
2616: d_api_name CONSTANT VARCHAR2(30) := 'default_ship_to_org_id';

Line 2613: x_ship_to_org_id_tbl IN OUT NOCOPY PO_TBL_NUMBER

2609: (
2610: p_key IN po_session_gt.key%TYPE,
2611: p_index_tbl IN DBMS_SQL.NUMBER_TABLE,
2612: p_ship_to_loc_id_tbl IN PO_TBL_NUMBER,
2613: x_ship_to_org_id_tbl IN OUT NOCOPY PO_TBL_NUMBER
2614: ) IS
2615:
2616: d_api_name CONSTANT VARCHAR2(30) := 'default_ship_to_org_id';
2617: d_module CONSTANT VARCHAR2(255) := d_pkg_name || d_api_name || '.';

Line 2621: l_index_tbl PO_TBL_NUMBER;

2617: d_module CONSTANT VARCHAR2(255) := d_pkg_name || d_api_name || '.';
2618: d_position NUMBER;
2619:
2620: -- variable to hold the default query result
2621: l_index_tbl PO_TBL_NUMBER;
2622: l_result_tbl PO_TBL_NUMBER;
2623: BEGIN
2624: d_position := 0;
2625:

Line 2622: l_result_tbl PO_TBL_NUMBER;

2618: d_position NUMBER;
2619:
2620: -- variable to hold the default query result
2621: l_index_tbl PO_TBL_NUMBER;
2622: l_result_tbl PO_TBL_NUMBER;
2623: BEGIN
2624: d_position := 0;
2625:
2626: IF (PO_LOG.d_proc) THEN

Line 2714: p_item_id_tbl IN PO_TBL_NUMBER,

2710: PROCEDURE default_close_tolerances
2711: (
2712: p_key IN po_session_gt.key%TYPE,
2713: p_index_tbl IN DBMS_SQL.NUMBER_TABLE,
2714: p_item_id_tbl IN PO_TBL_NUMBER,
2715: p_ship_to_org_id_tbl IN PO_TBL_NUMBER,
2716: p_line_type_id_tbl IN PO_TBL_NUMBER,
2717: x_invoice_close_tolerance_tbl IN OUT NOCOPY PO_TBL_NUMBER,
2718: x_receive_close_tolerance_tbl IN OUT NOCOPY PO_TBL_NUMBER

Line 2715: p_ship_to_org_id_tbl IN PO_TBL_NUMBER,

2711: (
2712: p_key IN po_session_gt.key%TYPE,
2713: p_index_tbl IN DBMS_SQL.NUMBER_TABLE,
2714: p_item_id_tbl IN PO_TBL_NUMBER,
2715: p_ship_to_org_id_tbl IN PO_TBL_NUMBER,
2716: p_line_type_id_tbl IN PO_TBL_NUMBER,
2717: x_invoice_close_tolerance_tbl IN OUT NOCOPY PO_TBL_NUMBER,
2718: x_receive_close_tolerance_tbl IN OUT NOCOPY PO_TBL_NUMBER
2719: ) IS

Line 2716: p_line_type_id_tbl IN PO_TBL_NUMBER,

2712: p_key IN po_session_gt.key%TYPE,
2713: p_index_tbl IN DBMS_SQL.NUMBER_TABLE,
2714: p_item_id_tbl IN PO_TBL_NUMBER,
2715: p_ship_to_org_id_tbl IN PO_TBL_NUMBER,
2716: p_line_type_id_tbl IN PO_TBL_NUMBER,
2717: x_invoice_close_tolerance_tbl IN OUT NOCOPY PO_TBL_NUMBER,
2718: x_receive_close_tolerance_tbl IN OUT NOCOPY PO_TBL_NUMBER
2719: ) IS
2720:

Line 2717: x_invoice_close_tolerance_tbl IN OUT NOCOPY PO_TBL_NUMBER,

2713: p_index_tbl IN DBMS_SQL.NUMBER_TABLE,
2714: p_item_id_tbl IN PO_TBL_NUMBER,
2715: p_ship_to_org_id_tbl IN PO_TBL_NUMBER,
2716: p_line_type_id_tbl IN PO_TBL_NUMBER,
2717: x_invoice_close_tolerance_tbl IN OUT NOCOPY PO_TBL_NUMBER,
2718: x_receive_close_tolerance_tbl IN OUT NOCOPY PO_TBL_NUMBER
2719: ) IS
2720:
2721: d_api_name CONSTANT VARCHAR2(30) := 'default_close_tolerances';

Line 2718: x_receive_close_tolerance_tbl IN OUT NOCOPY PO_TBL_NUMBER

2714: p_item_id_tbl IN PO_TBL_NUMBER,
2715: p_ship_to_org_id_tbl IN PO_TBL_NUMBER,
2716: p_line_type_id_tbl IN PO_TBL_NUMBER,
2717: x_invoice_close_tolerance_tbl IN OUT NOCOPY PO_TBL_NUMBER,
2718: x_receive_close_tolerance_tbl IN OUT NOCOPY PO_TBL_NUMBER
2719: ) IS
2720:
2721: d_api_name CONSTANT VARCHAR2(30) := 'default_close_tolerances';
2722: d_module CONSTANT VARCHAR2(255) := d_pkg_name || d_api_name || '.';

Line 2726: l_index_tbl PO_TBL_NUMBER;

2722: d_module CONSTANT VARCHAR2(255) := d_pkg_name || d_api_name || '.';
2723: d_position NUMBER;
2724:
2725: -- variable to hold the default query result
2726: l_index_tbl PO_TBL_NUMBER;
2727: l_invoice_tolerance_tbl PO_TBL_NUMBER;
2728: l_receive_tolerance_tbl PO_TBL_NUMBER;
2729:
2730: -- temp index value

Line 2727: l_invoice_tolerance_tbl PO_TBL_NUMBER;

2723: d_position NUMBER;
2724:
2725: -- variable to hold the default query result
2726: l_index_tbl PO_TBL_NUMBER;
2727: l_invoice_tolerance_tbl PO_TBL_NUMBER;
2728: l_receive_tolerance_tbl PO_TBL_NUMBER;
2729:
2730: -- temp index value
2731: l_index NUMBER;

Line 2728: l_receive_tolerance_tbl PO_TBL_NUMBER;

2724:
2725: -- variable to hold the default query result
2726: l_index_tbl PO_TBL_NUMBER;
2727: l_invoice_tolerance_tbl PO_TBL_NUMBER;
2728: l_receive_tolerance_tbl PO_TBL_NUMBER;
2729:
2730: -- temp index value
2731: l_index NUMBER;
2732: BEGIN

Line 2925: p_vendor_id_tbl IN PO_TBL_NUMBER,

2921: PROCEDURE default_invoice_match_options
2922: (
2923: p_key IN po_session_gt.key%TYPE,
2924: p_index_tbl IN DBMS_SQL.NUMBER_TABLE,
2925: p_vendor_id_tbl IN PO_TBL_NUMBER,
2926: p_vendor_site_id_tbl IN PO_TBL_NUMBER,
2927: x_match_option_tbl IN OUT NOCOPY PO_TBL_VARCHAR30
2928: ) IS
2929:

Line 2926: p_vendor_site_id_tbl IN PO_TBL_NUMBER,

2922: (
2923: p_key IN po_session_gt.key%TYPE,
2924: p_index_tbl IN DBMS_SQL.NUMBER_TABLE,
2925: p_vendor_id_tbl IN PO_TBL_NUMBER,
2926: p_vendor_site_id_tbl IN PO_TBL_NUMBER,
2927: x_match_option_tbl IN OUT NOCOPY PO_TBL_VARCHAR30
2928: ) IS
2929:
2930: d_api_name CONSTANT VARCHAR2(30) := 'default_invoice_match_options';

Line 2935: l_index_tbl PO_TBL_NUMBER;

2931: d_module CONSTANT VARCHAR2(255) := d_pkg_name || d_api_name || '.';
2932: d_position NUMBER;
2933:
2934: -- variable to hold the default query result
2935: l_index_tbl PO_TBL_NUMBER;
2936: l_result_tbl PO_TBL_VARCHAR30;
2937: BEGIN
2938: d_position := 0;
2939:

Line 3056: p_item_id_tbl IN PO_TBL_NUMBER,

3052: PROCEDURE default_accrue_on_receipt_flag
3053: (
3054: p_key IN po_session_gt.key%TYPE,
3055: p_index_tbl IN DBMS_SQL.NUMBER_TABLE,
3056: p_item_id_tbl IN PO_TBL_NUMBER,
3057: p_ship_to_org_id_tbl IN PO_TBL_NUMBER,
3058: p_receipt_required_flag_tbl IN PO_TBL_VARCHAR1,
3059: x_accrue_on_receipt_flag_tbl IN OUT NOCOPY PO_TBL_VARCHAR1
3060: ) IS

Line 3057: p_ship_to_org_id_tbl IN PO_TBL_NUMBER,

3053: (
3054: p_key IN po_session_gt.key%TYPE,
3055: p_index_tbl IN DBMS_SQL.NUMBER_TABLE,
3056: p_item_id_tbl IN PO_TBL_NUMBER,
3057: p_ship_to_org_id_tbl IN PO_TBL_NUMBER,
3058: p_receipt_required_flag_tbl IN PO_TBL_VARCHAR1,
3059: x_accrue_on_receipt_flag_tbl IN OUT NOCOPY PO_TBL_VARCHAR1
3060: ) IS
3061:

Line 3067: l_index_tbl PO_TBL_NUMBER;

3063: d_module CONSTANT VARCHAR2(255) := d_pkg_name || d_api_name || '.';
3064: d_position NUMBER;
3065:
3066: -- variable to hold the default query result
3067: l_index_tbl PO_TBL_NUMBER;
3068: l_outside_op_flag_tbl PO_TBL_VARCHAR1;
3069: l_stock_enabled_flag_tbl PO_TBL_VARCHAR1;
3070:
3071: l_item_status VARCHAR2(1);

Line 3222: p_item_id_tbl IN PO_TBL_NUMBER,

3218: PROCEDURE default_secondary_unit_of_meas
3219: (
3220: p_key IN po_session_gt.key%TYPE,
3221: p_index_tbl IN DBMS_SQL.NUMBER_TABLE,
3222: p_item_id_tbl IN PO_TBL_NUMBER,
3223: p_ship_to_org_id_tbl IN PO_TBL_NUMBER,
3224: x_secondary_unit_of_meas_tbl IN OUT NOCOPY PO_TBL_VARCHAR30
3225: ) IS
3226:

Line 3223: p_ship_to_org_id_tbl IN PO_TBL_NUMBER,

3219: (
3220: p_key IN po_session_gt.key%TYPE,
3221: p_index_tbl IN DBMS_SQL.NUMBER_TABLE,
3222: p_item_id_tbl IN PO_TBL_NUMBER,
3223: p_ship_to_org_id_tbl IN PO_TBL_NUMBER,
3224: x_secondary_unit_of_meas_tbl IN OUT NOCOPY PO_TBL_VARCHAR30
3225: ) IS
3226:
3227: d_api_name CONSTANT VARCHAR2(30) := 'default_secondary_unit_of_meas';

Line 3232: l_index_tbl PO_TBL_NUMBER;

3228: d_module CONSTANT VARCHAR2(255) := d_pkg_name || d_api_name || '.';
3229: d_position NUMBER;
3230:
3231: -- variable to hold the default query result
3232: l_index_tbl PO_TBL_NUMBER;
3233: l_result_tbl PO_TBL_VARCHAR30;
3234: BEGIN
3235: d_position := 0;
3236:

Line 3324: l_remove_err_line_loc_tbl PO_TBL_NUMBER := PO_TBL_NUMBER();

3320:
3321: l_index_tbl DBMS_SQL.number_table;
3322: l_index NUMBER;
3323: l_intf_header_id NUMBER;
3324: l_remove_err_line_loc_tbl PO_TBL_NUMBER := PO_TBL_NUMBER();
3325: l_remove_err_line_tbl PO_TBL_NUMBER := PO_TBL_NUMBER();
3326: BEGIN
3327: d_position := 0;
3328:

Line 3325: l_remove_err_line_tbl PO_TBL_NUMBER := PO_TBL_NUMBER();

3321: l_index_tbl DBMS_SQL.number_table;
3322: l_index NUMBER;
3323: l_intf_header_id NUMBER;
3324: l_remove_err_line_loc_tbl PO_TBL_NUMBER := PO_TBL_NUMBER();
3325: l_remove_err_line_tbl PO_TBL_NUMBER := PO_TBL_NUMBER();
3326: BEGIN
3327: d_position := 0;
3328:
3329: IF (PO_LOG.d_proc) THEN