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_HEADER_PROCESS_PVT dependencies on DBMS_SQL

Line 14: p_index_tbl IN DBMS_SQL.NUMBER_TABLE,

10: --------------------------------------------------------------------------
11: PROCEDURE derive_rate_type_code
12: (
13: p_key IN po_session_gt.key%TYPE,
14: p_index_tbl IN DBMS_SQL.NUMBER_TABLE,
15: p_rate_type_tbl IN PO_TBL_VARCHAR30,
16: x_rate_type_code_tbl IN OUT NOCOPY PO_TBL_VARCHAR30
17: );
18:

Line 22: p_index_tbl IN DBMS_SQL.NUMBER_TABLE,

18:
19: PROCEDURE derive_agent_id
20: (
21: p_key IN po_session_gt.key%TYPE,
22: p_index_tbl IN DBMS_SQL.NUMBER_TABLE,
23: p_agent_name_tbl IN PO_TBL_VARCHAR2000,
24: x_agent_id_tbl IN OUT NOCOPY PO_TBL_NUMBER
25: );
26:

Line 30: p_index_tbl IN DBMS_SQL.NUMBER_TABLE,

26:
27: PROCEDURE derive_vendor_site_id
28: (
29: p_key IN po_session_gt.key%TYPE,
30: p_index_tbl IN DBMS_SQL.NUMBER_TABLE,
31: p_vendor_id_tbl IN PO_TBL_NUMBER,
32: p_vendor_site_code_tbl IN PO_TBL_VARCHAR30,
33: x_vendor_site_id_tbl IN OUT NOCOPY PO_TBL_NUMBER
34: );

Line 39: p_index_tbl IN DBMS_SQL.NUMBER_TABLE,

35:
36: PROCEDURE derive_vendor_contact_id
37: (
38: p_key IN po_session_gt.key%TYPE,
39: p_index_tbl IN DBMS_SQL.NUMBER_TABLE,
40: p_vendor_site_id_tbl IN PO_TBL_NUMBER,
41: p_vendor_contact_tbl IN PO_TBL_VARCHAR2000,
42: x_vendor_contact_id_tbl IN OUT NOCOPY PO_TBL_NUMBER
43: );

Line 48: p_index_tbl IN DBMS_SQL.NUMBER_TABLE,

44:
45: PROCEDURE derive_from_header_id
46: (
47: p_key IN po_session_gt.key%TYPE,
48: p_index_tbl IN DBMS_SQL.NUMBER_TABLE,
49: p_from_rfq_num_tbl IN PO_TBL_VARCHAR30,
50: x_from_header_id_tbl IN OUT NOCOPY PO_TBL_NUMBER
51: );
52:

Line 56: p_index_tbl IN DBMS_SQL.NUMBER_TABLE,

52:
53: PROCEDURE derive_style_id
54: (
55: p_key IN po_session_gt.key%TYPE,
56: p_index_tbl IN DBMS_SQL.NUMBER_TABLE,
57: p_style_display_name_tbl IN PO_TBL_VARCHAR2000,
58: x_style_id_tbl IN OUT NOCOPY PO_TBL_NUMBER
59: );
60:

Line 64: p_index_tbl IN DBMS_SQL.NUMBER_TABLE,

60:
61: PROCEDURE default_info_from_vendor
62: (
63: p_key IN po_session_gt.key%TYPE,
64: p_index_tbl IN DBMS_SQL.NUMBER_TABLE,
65: p_vendor_id_tbl IN PO_TBL_NUMBER,
66: x_invoice_currency_code_tbl OUT NOCOPY PO_TBL_VARCHAR30,
67: x_terms_id_tbl OUT NOCOPY PO_TBL_NUMBER
68: );

Line 73: p_index_tbl IN DBMS_SQL.NUMBER_TABLE,

69:
70: PROCEDURE default_info_from_vendor_site
71: (
72: p_key IN po_session_gt.key%TYPE,
73: p_index_tbl IN DBMS_SQL.NUMBER_TABLE,
74: p_vendor_id_tbl IN PO_TBL_NUMBER,
75: x_vendor_site_id_tbl IN OUT NOCOPY PO_TBL_NUMBER,
76: x_fob_tbl OUT NOCOPY PO_TBL_VARCHAR30,
77: x_freight_carrier_tbl OUT NOCOPY PO_TBL_VARCHAR30,

Line 90: p_index_tbl IN DBMS_SQL.NUMBER_TABLE,

86:
87: PROCEDURE default_vendor_contact
88: (
89: p_key IN po_session_gt.key%TYPE,
90: p_index_tbl IN DBMS_SQL.NUMBER_TABLE,
91: p_vendor_site_id_tbl IN PO_TBL_NUMBER,
92: x_vendor_contact_id_tbl IN OUT NOCOPY PO_TBL_NUMBER
93: );
94:

Line 513: l_index_tbl DBMS_SQL.NUMBER_TABLE;

509: -- key used when operating on temp table
510: l_key po_session_gt.key%TYPE;
511:
512: -- table used to save the index of the each row
513: l_index_tbl DBMS_SQL.NUMBER_TABLE;
514:
515: -- temp variable used in derivation error handling
516: l_column_name VARCHAR2(11);
517: BEGIN

Line 974: l_index_tbl DBMS_SQL.NUMBER_TABLE;

970: -- key used when operating on temp table
971: l_key po_session_gt.key%TYPE;
972:
973: -- table used to save the index of the each row
974: l_index_tbl DBMS_SQL.NUMBER_TABLE;
975:
976: -- information defaulted from vendor
977:
978: --

Line 1705: p_index_tbl IN DBMS_SQL.NUMBER_TABLE,

1701: ------------------------------------------------------------------------
1702: PROCEDURE derive_location_id
1703: (
1704: p_key IN po_session_gt.key%TYPE,
1705: p_index_tbl IN DBMS_SQL.NUMBER_TABLE,
1706: p_location_type IN VARCHAR2,
1707: p_location_tbl IN PO_TBL_VARCHAR100,
1708: x_location_id_tbl IN OUT NOCOPY PO_TBL_NUMBER
1709: ) IS

Line 1812: p_index_tbl IN DBMS_SQL.NUMBER_TABLE,

1808: ------------------------------------------------------------------------
1809: PROCEDURE derive_terms_id
1810: (
1811: p_key IN po_session_gt.key%TYPE,
1812: p_index_tbl IN DBMS_SQL.NUMBER_TABLE,
1813: p_payment_terms_tbl IN PO_TBL_VARCHAR100,
1814: x_terms_id_tbl IN OUT NOCOPY PO_TBL_NUMBER
1815: ) IS
1816:

Line 1909: p_index_tbl IN DBMS_SQL.NUMBER_TABLE,

1905: ------------------------------------------------------------------------
1906: PROCEDURE derive_vendor_id
1907: (
1908: p_key IN po_session_gt.key%TYPE,
1909: p_index_tbl IN DBMS_SQL.NUMBER_TABLE,
1910: p_vendor_name_tbl IN PO_TBL_VARCHAR2000,
1911: p_vendor_num_tbl IN PO_TBL_VARCHAR30,
1912: x_vendor_id_tbl IN OUT NOCOPY PO_TBL_NUMBER
1913: ) IS

Line 2021: p_index_tbl IN DBMS_SQL.NUMBER_TABLE,

2017: ------------------------------------------------------------------------
2018: PROCEDURE derive_rate_type_code
2019: (
2020: p_key IN po_session_gt.key%TYPE,
2021: p_index_tbl IN DBMS_SQL.NUMBER_TABLE,
2022: p_rate_type_tbl IN PO_TBL_VARCHAR30,
2023: x_rate_type_code_tbl IN OUT NOCOPY PO_TBL_VARCHAR30
2024: ) IS
2025:

Line 2112: p_index_tbl IN DBMS_SQL.NUMBER_TABLE,

2108: ------------------------------------------------------------------------
2109: PROCEDURE derive_agent_id
2110: (
2111: p_key IN po_session_gt.key%TYPE,
2112: p_index_tbl IN DBMS_SQL.NUMBER_TABLE,
2113: p_agent_name_tbl IN PO_TBL_VARCHAR2000,
2114: x_agent_id_tbl IN OUT NOCOPY PO_TBL_NUMBER
2115: ) IS
2116:

Line 2205: p_index_tbl IN DBMS_SQL.NUMBER_TABLE,

2201: ------------------------------------------------------------------------
2202: PROCEDURE derive_vendor_site_id
2203: (
2204: p_key IN po_session_gt.key%TYPE,
2205: p_index_tbl IN DBMS_SQL.NUMBER_TABLE,
2206: p_vendor_id_tbl IN PO_TBL_NUMBER,
2207: p_vendor_site_code_tbl IN PO_TBL_VARCHAR30,
2208: x_vendor_site_id_tbl IN OUT NOCOPY PO_TBL_NUMBER
2209: ) IS

Line 2303: p_index_tbl IN DBMS_SQL.NUMBER_TABLE,

2299: ------------------------------------------------------------------------
2300: PROCEDURE derive_vendor_contact_id
2301: (
2302: p_key IN po_session_gt.key%TYPE,
2303: p_index_tbl IN DBMS_SQL.NUMBER_TABLE,
2304: p_vendor_site_id_tbl IN PO_TBL_NUMBER,
2305: p_vendor_contact_tbl IN PO_TBL_VARCHAR2000,
2306: x_vendor_contact_id_tbl IN OUT NOCOPY PO_TBL_NUMBER
2307: ) IS

Line 2402: p_index_tbl IN DBMS_SQL.NUMBER_TABLE,

2398: ------------------------------------------------------------------------
2399: PROCEDURE derive_style_id
2400: (
2401: p_key IN po_session_gt.key%TYPE,
2402: p_index_tbl IN DBMS_SQL.NUMBER_TABLE,
2403: p_style_display_name_tbl IN PO_TBL_VARCHAR2000,
2404: x_style_id_tbl IN OUT NOCOPY PO_TBL_NUMBER
2405: ) IS
2406:

Line 2494: p_index_tbl IN DBMS_SQL.NUMBER_TABLE,

2490: ------------------------------------------------------------------------
2491: PROCEDURE derive_from_header_id
2492: (
2493: p_key IN po_session_gt.key%TYPE,
2494: p_index_tbl IN DBMS_SQL.NUMBER_TABLE,
2495: p_from_rfq_num_tbl IN PO_TBL_VARCHAR30,
2496: x_from_header_id_tbl IN OUT NOCOPY PO_TBL_NUMBER
2497: ) IS
2498:

Line 2589: p_index_tbl IN DBMS_SQL.NUMBER_TABLE,

2585: ------------------------------------------------------------------------
2586: PROCEDURE default_info_from_vendor
2587: (
2588: p_key IN po_session_gt.key%TYPE,
2589: p_index_tbl IN DBMS_SQL.NUMBER_TABLE,
2590: p_vendor_id_tbl IN PO_TBL_NUMBER,
2591: x_invoice_currency_code_tbl OUT NOCOPY PO_TBL_VARCHAR30,
2592: x_terms_id_tbl OUT NOCOPY PO_TBL_NUMBER
2593: ) IS

Line 2736: p_index_tbl IN DBMS_SQL.NUMBER_TABLE,

2732: ------------------------------------------------------------------------
2733: PROCEDURE default_info_from_vendor_site
2734: (
2735: p_key IN po_session_gt.key%TYPE,
2736: p_index_tbl IN DBMS_SQL.NUMBER_TABLE,
2737: p_vendor_id_tbl IN PO_TBL_NUMBER,
2738: x_vendor_site_id_tbl IN OUT NOCOPY PO_TBL_NUMBER,
2739: x_fob_tbl OUT NOCOPY PO_TBL_VARCHAR30,
2740: x_freight_carrier_tbl OUT NOCOPY PO_TBL_VARCHAR30,

Line 2949: p_index_tbl IN DBMS_SQL.NUMBER_TABLE,

2945: ------------------------------------------------------------------------
2946: PROCEDURE default_vendor_contact
2947: (
2948: p_key IN po_session_gt.key%TYPE,
2949: p_index_tbl IN DBMS_SQL.NUMBER_TABLE,
2950: p_vendor_site_id_tbl IN PO_TBL_NUMBER,
2951: x_vendor_contact_id_tbl IN OUT NOCOPY PO_TBL_NUMBER
2952: ) IS
2953:

Line 3179: l_index_tbl DBMS_SQL.number_table;

3175: d_api_name CONSTANT VARCHAR2(30) := 'populate_error_flag';
3176: d_module CONSTANT VARCHAR2(255) := d_pkg_name || d_api_name || '.';
3177: d_position NUMBER;
3178:
3179: l_index_tbl DBMS_SQL.number_table;
3180:
3181: BEGIN
3182: d_position := 0;
3183: