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 1457: p_receiving_routing_tbl IN PO_TBL_VARCHAR30,

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

Line 1549: x_tax_name_tbl IN OUT NOCOPY PO_TBL_VARCHAR30

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

Line 1558: l_result_tbl PO_TBL_VARCHAR30;

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

Line 2736: x_match_option_tbl IN OUT NOCOPY PO_TBL_VARCHAR30

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

Line 2745: l_result_tbl PO_TBL_VARCHAR30;

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

Line 3006: x_secondary_unit_of_meas_tbl IN OUT NOCOPY PO_TBL_VARCHAR30

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

Line 3015: l_result_tbl PO_TBL_VARCHAR30;

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