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 110: p_index_tbl IN DBMS_SQL.NUMBER_TABLE,

106: --PDOI CLM Integration Starts
107: PROCEDURE default_clm_standard_format
108: (
109: p_key IN po_session_gt.key%TYPE,
110: p_index_tbl IN DBMS_SQL.NUMBER_TABLE,
111: p_style_id_tbl IN PO_TBL_NUMBER,
112: p_clm_award_type IN PO_TBL_VARCHAR30,
113: x_clm_standard_form_tbl IN OUT NOCOPY PO_TBL_VARCHAR2000,
114: x_clm_document_format_tbl IN OUT NOCOPY PO_TBL_VARCHAR2000

Line 120: p_index_tbl IN DBMS_SQL.NUMBER_TABLE,

116:
117: PROCEDURE derive_clm_award_type
118: (
119: p_key IN po_session_gt.key%TYPE,
120: p_index_tbl IN DBMS_SQL.NUMBER_TABLE,
121: p_clm_award_type_disp_tbl IN PO_TBL_VARCHAR240,
122: x_clm_award_type_tbl IN OUT NOCOPY PO_TBL_VARCHAR30
123: );
124:

Line 128: p_index_tbl IN DBMS_SQL.NUMBER_TABLE,

124:
125: PROCEDURE derive_clm_award_admin
126: (
127: p_key IN po_session_gt.key%TYPE,
128: p_index_tbl IN DBMS_SQL.NUMBER_TABLE,
129: p_clm_award_admin_disp_tbl IN PO_TBL_VARCHAR240,
130: x_clm_award_administrator_tbl IN OUT NOCOPY PO_TBL_VARCHAR2000
131: );
132:

Line 136: p_index_tbl IN DBMS_SQL.NUMBER_TABLE,

132:
133: PROCEDURE derive_clm_contract_officer
134: (
135: p_key IN po_session_gt.key%TYPE,
136: p_index_tbl IN DBMS_SQL.NUMBER_TABLE,
137: p_clm_contract_oficer_disp_tbl IN PO_TBL_VARCHAR240,
138: x_clm_contract_officer_tbl IN OUT NOCOPY PO_TBL_NUMBER
139: );
140:

Line 144: p_index_tbl IN DBMS_SQL.NUMBER_TABLE,

140:
141: PROCEDURE derive_vendor_site_id_from_idv
142: (
143: p_key IN po_session_gt.key%TYPE,
144: p_index_tbl IN DBMS_SQL.NUMBER_TABLE,
145: p_clm_source_document_id_tbl IN PO_TBL_NUMBER,
146: p_doc_type_tbl IN PO_TBL_VARCHAR30,
147: x_vendor_site_id_tbl IN OUT NOCOPY PO_TBL_NUMBER
148: );

Line 827: l_index_tbl DBMS_SQL.NUMBER_TABLE;

823: -- key used when operating on temp table
824: l_key po_session_gt.key%TYPE;
825:
826: -- table used to save the index of the each row
827: l_index_tbl DBMS_SQL.NUMBER_TABLE;
828:
829: -- temp variable used in derivation error handling
830: l_column_name VARCHAR2(11);
831: BEGIN

Line 1443: l_index_tbl DBMS_SQL.NUMBER_TABLE;

1439: -- key used when operating on temp table
1440: l_key po_session_gt.key%TYPE;
1441:
1442: -- table used to save the index of the each row
1443: l_index_tbl DBMS_SQL.NUMBER_TABLE;
1444:
1445: -- information defaulted from vendor
1446:
1447: --

Line 2214: p_index_tbl IN DBMS_SQL.NUMBER_TABLE,

2210: ------------------------------------------------------------------------
2211: PROCEDURE derive_location_id
2212: (
2213: p_key IN po_session_gt.key%TYPE,
2214: p_index_tbl IN DBMS_SQL.NUMBER_TABLE,
2215: p_location_type IN VARCHAR2,
2216: p_location_tbl IN PO_TBL_VARCHAR100,
2217: x_location_id_tbl IN OUT NOCOPY PO_TBL_NUMBER
2218: ) IS

Line 2321: p_index_tbl IN DBMS_SQL.NUMBER_TABLE,

2317: ------------------------------------------------------------------------
2318: PROCEDURE derive_terms_id
2319: (
2320: p_key IN po_session_gt.key%TYPE,
2321: p_index_tbl IN DBMS_SQL.NUMBER_TABLE,
2322: p_payment_terms_tbl IN PO_TBL_VARCHAR100,
2323: x_terms_id_tbl IN OUT NOCOPY PO_TBL_NUMBER
2324: ) IS
2325:

Line 2418: p_index_tbl IN DBMS_SQL.NUMBER_TABLE,

2414: ------------------------------------------------------------------------
2415: PROCEDURE derive_vendor_id
2416: (
2417: p_key IN po_session_gt.key%TYPE,
2418: p_index_tbl IN DBMS_SQL.NUMBER_TABLE,
2419: p_vendor_name_tbl IN PO_TBL_VARCHAR2000,
2420: p_vendor_num_tbl IN PO_TBL_VARCHAR30,
2421: x_vendor_id_tbl IN OUT NOCOPY PO_TBL_NUMBER
2422: ) IS

Line 2530: p_index_tbl IN DBMS_SQL.NUMBER_TABLE,

2526: ------------------------------------------------------------------------
2527: PROCEDURE derive_rate_type_code
2528: (
2529: p_key IN po_session_gt.key%TYPE,
2530: p_index_tbl IN DBMS_SQL.NUMBER_TABLE,
2531: p_rate_type_tbl IN PO_TBL_VARCHAR30,
2532: x_rate_type_code_tbl IN OUT NOCOPY PO_TBL_VARCHAR30
2533: ) IS
2534:

Line 2621: p_index_tbl IN DBMS_SQL.NUMBER_TABLE,

2617: ------------------------------------------------------------------------
2618: PROCEDURE derive_agent_id
2619: (
2620: p_key IN po_session_gt.key%TYPE,
2621: p_index_tbl IN DBMS_SQL.NUMBER_TABLE,
2622: p_agent_name_tbl IN PO_TBL_VARCHAR2000,
2623: x_agent_id_tbl IN OUT NOCOPY PO_TBL_NUMBER
2624: ) IS
2625:

Line 2714: p_index_tbl IN DBMS_SQL.NUMBER_TABLE,

2710: ------------------------------------------------------------------------
2711: PROCEDURE derive_vendor_site_id
2712: (
2713: p_key IN po_session_gt.key%TYPE,
2714: p_index_tbl IN DBMS_SQL.NUMBER_TABLE,
2715: p_vendor_id_tbl IN PO_TBL_NUMBER,
2716: p_vendor_site_code_tbl IN PO_TBL_VARCHAR30,
2717: x_vendor_site_id_tbl IN OUT NOCOPY PO_TBL_NUMBER
2718: ) IS

Line 2812: p_index_tbl IN DBMS_SQL.NUMBER_TABLE,

2808: ------------------------------------------------------------------------
2809: PROCEDURE derive_vendor_contact_id
2810: (
2811: p_key IN po_session_gt.key%TYPE,
2812: p_index_tbl IN DBMS_SQL.NUMBER_TABLE,
2813: p_vendor_site_id_tbl IN PO_TBL_NUMBER,
2814: p_vendor_contact_tbl IN PO_TBL_VARCHAR2000,
2815: x_vendor_contact_id_tbl IN OUT NOCOPY PO_TBL_NUMBER
2816: ) IS

Line 2911: p_index_tbl IN DBMS_SQL.NUMBER_TABLE,

2907: ------------------------------------------------------------------------
2908: PROCEDURE derive_style_id
2909: (
2910: p_key IN po_session_gt.key%TYPE,
2911: p_index_tbl IN DBMS_SQL.NUMBER_TABLE,
2912: p_style_display_name_tbl IN PO_TBL_VARCHAR2000,
2913: x_style_id_tbl IN OUT NOCOPY PO_TBL_NUMBER
2914: ) IS
2915:

Line 3003: p_index_tbl IN DBMS_SQL.NUMBER_TABLE,

2999: ------------------------------------------------------------------------
3000: PROCEDURE derive_from_header_id
3001: (
3002: p_key IN po_session_gt.key%TYPE,
3003: p_index_tbl IN DBMS_SQL.NUMBER_TABLE,
3004: p_from_rfq_num_tbl IN PO_TBL_VARCHAR30,
3005: x_from_header_id_tbl IN OUT NOCOPY PO_TBL_NUMBER
3006: ) IS
3007:

Line 3098: p_index_tbl IN DBMS_SQL.NUMBER_TABLE,

3094: ------------------------------------------------------------------------
3095: PROCEDURE default_info_from_vendor
3096: (
3097: p_key IN po_session_gt.key%TYPE,
3098: p_index_tbl IN DBMS_SQL.NUMBER_TABLE,
3099: p_vendor_id_tbl IN PO_TBL_NUMBER,
3100: x_invoice_currency_code_tbl OUT NOCOPY PO_TBL_VARCHAR30,
3101: x_terms_id_tbl OUT NOCOPY PO_TBL_NUMBER
3102: ) IS

Line 3245: p_index_tbl IN DBMS_SQL.NUMBER_TABLE,

3241: ------------------------------------------------------------------------
3242: PROCEDURE default_info_from_vendor_site
3243: (
3244: p_key IN po_session_gt.key%TYPE,
3245: p_index_tbl IN DBMS_SQL.NUMBER_TABLE,
3246: p_vendor_id_tbl IN PO_TBL_NUMBER,
3247: x_vendor_site_id_tbl IN OUT NOCOPY PO_TBL_NUMBER,
3248: x_fob_tbl OUT NOCOPY PO_TBL_VARCHAR30,
3249: x_freight_carrier_tbl OUT NOCOPY PO_TBL_VARCHAR30,

Line 3461: p_index_tbl IN DBMS_SQL.NUMBER_TABLE,

3457: ------------------------------------------------------------------------
3458: PROCEDURE default_vendor_contact
3459: (
3460: p_key IN po_session_gt.key%TYPE,
3461: p_index_tbl IN DBMS_SQL.NUMBER_TABLE,
3462: p_vendor_site_id_tbl IN PO_TBL_NUMBER,
3463: x_vendor_contact_id_tbl IN OUT NOCOPY PO_TBL_NUMBER
3464: ) IS
3465:

Line 3691: l_index_tbl DBMS_SQL.number_table;

3687: d_api_name CONSTANT VARCHAR2(30) := 'populate_error_flag';
3688: d_module CONSTANT VARCHAR2(255) := d_pkg_name || d_api_name || '.';
3689: d_position NUMBER;
3690:
3691: l_index_tbl DBMS_SQL.number_table;
3692:
3693: BEGIN
3694: d_position := 0;
3695:

Line 3732: p_index_tbl IN DBMS_SQL.NUMBER_TABLE,

3728: --PDOI CLM Integration Starts
3729: PROCEDURE default_clm_standard_format
3730: (
3731: p_key IN po_session_gt.key%TYPE,
3732: p_index_tbl IN DBMS_SQL.NUMBER_TABLE,
3733: p_style_id_tbl IN PO_TBL_NUMBER,
3734: p_clm_award_type IN PO_TBL_VARCHAR30,
3735: x_clm_standard_form_tbl IN OUT NOCOPY PO_TBL_VARCHAR2000,
3736: x_clm_document_format_tbl IN OUT NOCOPY PO_TBL_VARCHAR2000

Line 3876: p_index_tbl IN DBMS_SQL.NUMBER_TABLE,

3872:
3873: PROCEDURE derive_clm_award_type
3874: (
3875: p_key IN po_session_gt.key%TYPE,
3876: p_index_tbl IN DBMS_SQL.NUMBER_TABLE,
3877: p_clm_award_type_disp_tbl IN PO_TBL_VARCHAR240,
3878: x_clm_award_type_tbl IN OUT NOCOPY PO_TBL_VARCHAR30
3879: ) IS
3880:

Line 3947: p_index_tbl IN DBMS_SQL.NUMBER_TABLE,

3943:
3944: PROCEDURE derive_clm_award_admin
3945: (
3946: p_key IN po_session_gt.key%TYPE,
3947: p_index_tbl IN DBMS_SQL.NUMBER_TABLE,
3948: p_clm_award_admin_disp_tbl IN PO_TBL_VARCHAR240,
3949: x_clm_award_administrator_tbl IN OUT NOCOPY PO_TBL_VARCHAR2000
3950: ) IS
3951:

Line 4016: p_index_tbl IN DBMS_SQL.NUMBER_TABLE,

4012:
4013: PROCEDURE derive_clm_contract_officer
4014: (
4015: p_key IN po_session_gt.key%TYPE,
4016: p_index_tbl IN DBMS_SQL.NUMBER_TABLE,
4017: p_clm_contract_oficer_disp_tbl IN PO_TBL_VARCHAR240,
4018: x_clm_contract_officer_tbl IN OUT NOCOPY PO_TBL_NUMBER
4019: ) IS
4020:

Line 4086: p_index_tbl IN DBMS_SQL.NUMBER_TABLE,

4082:
4083: PROCEDURE derive_clm_source_document_id
4084: (
4085: p_key IN po_session_gt.key%TYPE,
4086: p_index_tbl IN DBMS_SQL.NUMBER_TABLE,
4087: p_clm_source_document_disp_tbl IN PO_TBL_VARCHAR240,
4088: x_clm_source_document_id_tbl IN OUT NOCOPY PO_TBL_NUMBER
4089: ) IS
4090:

Line 4153: p_index_tbl IN DBMS_SQL.NUMBER_TABLE,

4149:
4150: PROCEDURE derive_vendor_id_from_idv
4151: (
4152: p_key IN po_session_gt.key%TYPE,
4153: p_index_tbl IN DBMS_SQL.NUMBER_TABLE,
4154: p_clm_source_document_id_tbl IN PO_TBL_NUMBER,
4155: p_doc_type_tbl IN PO_TBL_VARCHAR30,
4156: x_vendor_id_tbl IN OUT NOCOPY PO_TBL_NUMBER
4157: ) IS

Line 4221: p_index_tbl IN DBMS_SQL.NUMBER_TABLE,

4217:
4218: PROCEDURE derive_vendor_site_id_from_idv
4219: (
4220: p_key IN po_session_gt.key%TYPE,
4221: p_index_tbl IN DBMS_SQL.NUMBER_TABLE,
4222: p_clm_source_document_id_tbl IN PO_TBL_NUMBER,
4223: p_doc_type_tbl IN PO_TBL_VARCHAR30,
4224: x_vendor_site_id_tbl IN OUT NOCOPY PO_TBL_NUMBER
4225: ) IS