APPS.PO_PDOI_LINE_LOC_PROCESS_PVT dependencies on PO_TBL_VARCHAR30

Line 31: p_receiving_routing_tbl IN PO_TBL_VARCHAR30,

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

Line 40: x_tax_name_tbl IN OUT NOCOPY PO_TBL_VARCHAR30

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
44: (

Line 97: x_match_option_tbl IN OUT NOCOPY PO_TBL_VARCHAR30

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
101: (

Line 123: x_secondary_unit_of_meas_tbl IN OUT NOCOPY PO_TBL_VARCHAR30

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
127: (

Line 1566: p_receiving_routing_tbl IN PO_TBL_VARCHAR30,

1562: PROCEDURE derive_receiving_routing_id
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';

Line 1658: x_tax_name_tbl IN OUT NOCOPY PO_TBL_VARCHAR30

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

Line 1667: l_result_tbl PO_TBL_VARCHAR30;

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:
1671: IF (PO_LOG.d_proc) THEN

Line 2927: x_match_option_tbl IN OUT NOCOPY PO_TBL_VARCHAR30

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

Line 2936: l_result_tbl PO_TBL_VARCHAR30;

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:
2940: IF (PO_LOG.d_proc) THEN

Line 3224: x_secondary_unit_of_meas_tbl IN OUT NOCOPY PO_TBL_VARCHAR30

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

Line 3233: l_result_tbl PO_TBL_VARCHAR30;

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:
3237: IF (PO_LOG.d_proc) THEN