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 527: l_index_tbl DBMS_SQL.NUMBER_TABLE;

523: -- key of temp table used to identify the derived result
524: l_key po_session_gt.key%TYPE;
525:
526: -- table used to save the index of the each row
527: l_index_tbl DBMS_SQL.NUMBER_TABLE;
528:
529: --< Shared Proc 14223789 Start >
530: l_is_ship_to_org_valid BOOLEAN;
531: l_in_current_sob BOOLEAN;

Line 875: l_index_tbl DBMS_SQL.NUMBER_TABLE;

871: -- key of temp table used to identify the derived result
872: l_key po_session_gt.key%TYPE;
873:
874: -- table used to save the index of the each row
875: l_index_tbl DBMS_SQL.NUMBER_TABLE;
876: BEGIN
877: d_position := 0;
878:
879: IF (PO_LOG.d_proc) THEN

Line 1218: p_po_line_id_tbl IN DBMS_SQL.NUMBER_TABLE,

1214: --End of Comments
1215: ------------------------------------------------------------------------
1216: PROCEDURE update_amount_quantity_on_line
1217: (
1218: p_po_line_id_tbl IN DBMS_SQL.NUMBER_TABLE,
1219: p_draft_id_tbl IN DBMS_SQL.NUMBER_TABLE
1220: ) IS
1221:
1222: d_api_name CONSTANT VARCHAR2(30) := 'update_amount_quantity_on_line';

Line 1219: p_draft_id_tbl IN DBMS_SQL.NUMBER_TABLE

1215: ------------------------------------------------------------------------
1216: PROCEDURE update_amount_quantity_on_line
1217: (
1218: p_po_line_id_tbl IN DBMS_SQL.NUMBER_TABLE,
1219: p_draft_id_tbl IN DBMS_SQL.NUMBER_TABLE
1220: ) IS
1221:
1222: d_api_name CONSTANT VARCHAR2(30) := 'update_amount_quantity_on_line';
1223: d_module CONSTANT VARCHAR2(255) := d_pkg_name || d_api_name || '.';

Line 1282: p_po_line_id_tbl IN DBMS_SQL.NUMBER_TABLE,

1278: --End of Comments
1279: ------------------------------------------------------------------------
1280: PROCEDURE delete_exist_price_breaks
1281: (
1282: p_po_line_id_tbl IN DBMS_SQL.NUMBER_TABLE,
1283: p_draft_id_tbl IN DBMS_SQL.NUMBER_TABLE
1284: ) IS
1285:
1286: d_api_name CONSTANT VARCHAR2(30) := 'delete_exist_price_breaks';

Line 1283: p_draft_id_tbl IN DBMS_SQL.NUMBER_TABLE

1279: ------------------------------------------------------------------------
1280: PROCEDURE delete_exist_price_breaks
1281: (
1282: p_po_line_id_tbl IN DBMS_SQL.NUMBER_TABLE,
1283: p_draft_id_tbl IN DBMS_SQL.NUMBER_TABLE
1284: ) IS
1285:
1286: d_api_name CONSTANT VARCHAR2(30) := 'delete_exist_price_breaks';
1287: d_module CONSTANT VARCHAR2(255) := d_pkg_name || d_api_name || '.';

Line 1381: p_index_tbl IN DBMS_SQL.NUMBER_TABLE,

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

Line 1474: p_index_tbl IN DBMS_SQL.NUMBER_TABLE,

1470: ------------------------------------------------------------------------
1471: PROCEDURE derive_ship_to_org_id
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:

Line 1565: p_index_tbl IN DBMS_SQL.NUMBER_TABLE,

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

Line 1656: p_index_tbl IN DBMS_SQL.NUMBER_TABLE,

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

Line 1808: p_index_tbl IN DBMS_SQL.NUMBER_TABLE,

1804: ------------------------------------------------------------------------
1805: PROCEDURE default_locs_for_spo
1806: (
1807: p_key IN po_session_gt.key%TYPE,
1808: p_index_tbl IN DBMS_SQL.NUMBER_TABLE,
1809: x_line_locs IN OUT NOCOPY PO_PDOI_TYPES.line_locs_rec_type
1810: ) IS
1811:
1812: d_api_name CONSTANT VARCHAR2(30) := 'default_locs_for_spo';

Line 2145: p_index_tbl IN DBMS_SQL.NUMBER_TABLE,

2141: ------------------------------------------------------------------------
2142: PROCEDURE default_locs_for_blanket
2143: (
2144: p_key IN po_session_gt.key%TYPE,
2145: p_index_tbl IN DBMS_SQL.NUMBER_TABLE,
2146: x_line_locs IN OUT NOCOPY PO_PDOI_TYPES.line_locs_rec_type
2147: ) IS
2148:
2149: d_api_name CONSTANT VARCHAR2(30) := 'default_locs_for_blanket';

Line 2283: p_index_tbl IN DBMS_SQL.NUMBER_TABLE,

2279: ------------------------------------------------------------------------
2280: PROCEDURE default_locs_for_quotation
2281: (
2282: p_key IN po_session_gt.key%TYPE,
2283: p_index_tbl IN DBMS_SQL.NUMBER_TABLE,
2284: x_line_locs IN OUT NOCOPY PO_PDOI_TYPES.line_locs_rec_type
2285: ) IS
2286:
2287: d_api_name CONSTANT VARCHAR2(30) := 'default_locs_for_quotation';

Line 2521: p_index_tbl IN DBMS_SQL.NUMBER_TABLE,

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

Line 2611: p_index_tbl IN DBMS_SQL.NUMBER_TABLE,

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

Line 2713: p_index_tbl IN DBMS_SQL.NUMBER_TABLE,

2709: ------------------------------------------------------------------------
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,

Line 2924: p_index_tbl IN DBMS_SQL.NUMBER_TABLE,

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

Line 3055: p_index_tbl IN DBMS_SQL.NUMBER_TABLE,

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

Line 3221: p_index_tbl IN DBMS_SQL.NUMBER_TABLE,

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

Line 3321: l_index_tbl DBMS_SQL.number_table;

3317: d_api_name CONSTANT VARCHAR2(30) := 'populate_error_flag';
3318: d_module CONSTANT VARCHAR2(255) := d_pkg_name || d_api_name || '.';
3319: d_position 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();