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

Line 18: p_index_tbl IN DBMS_SQL.NUMBER_TABLE,

14:
15: PROCEDURE derive_item_id
16: (
17: p_key IN po_session_gt.key%TYPE,
18: p_index_tbl IN DBMS_SQL.NUMBER_TABLE,
19: p_vendor_id_tbl IN PO_TBL_NUMBER,
20: p_intf_header_id_tbl IN PO_TBL_NUMBER,
21: p_intf_line_id_tbl IN PO_TBL_NUMBER,
22: p_vendor_product_num_tbl IN PO_TBL_VARCHAR30,

Line 39: p_index_tbl IN DBMS_SQL.NUMBER_TABLE,

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

Line 47: p_index_tbl IN DBMS_SQL.NUMBER_TABLE,

43:
44: PROCEDURE derive_job_id
45: (
46: p_key IN po_session_gt.key%TYPE,
47: p_index_tbl IN DBMS_SQL.NUMBER_TABLE,
48: p_file_line_language_tbl IN PO_TBL_VARCHAR5,
49: p_job_business_group_name_tbl IN PO_TBL_VARCHAR2000,
50: p_job_name_tbl IN PO_TBL_VARCHAR2000,
51: x_job_business_group_id_tbl IN OUT NOCOPY PO_TBL_NUMBER,

Line 65: p_index_tbl IN DBMS_SQL.NUMBER_TABLE,

61:
62: PROCEDURE derive_ip_category_id
63: (
64: p_key IN po_session_gt.key%TYPE,
65: p_index_tbl IN DBMS_SQL.NUMBER_TABLE,
66: p_file_line_language_tbl IN PO_TBL_VARCHAR5,
67: p_ip_category_tbl IN PO_TBL_VARCHAR2000,
68: x_ip_category_id_tbl IN OUT NOCOPY PO_TBL_NUMBER
69: );

Line 74: p_index_tbl IN DBMS_SQL.NUMBER_TABLE,

70:
71: PROCEDURE derive_unit_of_measure
72: (
73: p_key IN po_session_gt.key%TYPE,
74: p_index_tbl IN DBMS_SQL.NUMBER_TABLE,
75: p_uom_code_tbl IN PO_TBL_VARCHAR5,
76: x_unit_of_measure_tbl IN OUT NOCOPY PO_TBL_VARCHAR30
77: );
78:

Line 82: p_index_tbl IN DBMS_SQL.NUMBER_TABLE,

78:
79: PROCEDURE derive_line_type_id
80: (
81: p_key IN po_session_gt.key%TYPE,
82: p_index_tbl IN DBMS_SQL.NUMBER_TABLE,
83: p_file_line_language_tbl IN PO_TBL_VARCHAR5,
84: p_line_type_tbl IN PO_TBL_VARCHAR30,
85: x_line_type_id_tbl IN OUT NOCOPY PO_TBL_NUMBER
86: );

Line 91: p_index_tbl IN DBMS_SQL.NUMBER_TABLE,

87:
88: PROCEDURE derive_un_number_id
89: (
90: p_key IN po_session_gt.key%TYPE,
91: p_index_tbl IN DBMS_SQL.NUMBER_TABLE,
92: p_un_number_tbl IN PO_TBL_VARCHAR30,
93: x_un_number_id_tbl IN OUT NOCOPY PO_TBL_NUMBER
94: );
95:

Line 99: p_index_tbl IN DBMS_SQL.NUMBER_TABLE,

95:
96: PROCEDURE derive_hazard_class_id
97: (
98: p_key IN po_session_gt.key%TYPE,
99: p_index_tbl IN DBMS_SQL.NUMBER_TABLE,
100: p_hazard_class_tbl IN PO_TBL_VARCHAR100,
101: x_hazard_class_id_tbl IN OUT NOCOPY PO_TBL_NUMBER
102: );
103:

Line 107: p_index_tbl IN DBMS_SQL.NUMBER_TABLE,

103:
104: PROCEDURE derive_template_id
105: (
106: p_key IN po_session_gt.key%TYPE,
107: p_index_tbl IN DBMS_SQL.NUMBER_TABLE,
108: p_template_name_tbl IN PO_TBL_VARCHAR30,
109: x_template_id_tbl IN OUT NOCOPY PO_TBL_NUMBER
110: );
111:

Line 115: p_index_tbl IN DBMS_SQL.NUMBER_TABLE,

111:
112: PROCEDURE default_info_from_line_type
113: (
114: p_key IN po_session_gt.key%TYPE,
115: p_index_tbl IN DBMS_SQL.NUMBER_TABLE,
116: p_line_type_id_tbl IN PO_TBL_NUMBER,
117: x_order_type_lookup_code_tbl IN OUT NOCOPY PO_TBL_VARCHAR30,
118: x_purchase_basis_tbl IN OUT NOCOPY PO_TBL_VARCHAR30,
119: x_matching_basis_tbl IN OUT NOCOPY PO_TBL_VARCHAR30,

Line 128: p_index_tbl IN DBMS_SQL.NUMBER_TABLE,

124:
125: PROCEDURE default_info_from_item
126: (
127: p_key IN po_session_gt.key%TYPE,
128: p_index_tbl IN DBMS_SQL.NUMBER_TABLE,
129: p_item_id_tbl IN PO_TBL_NUMBER,
130: x_item_desc_tbl OUT NOCOPY PO_TBL_VARCHAR2000,
131: x_unit_of_measure_tbl OUT NOCOPY PO_TBL_VARCHAR30,
132: x_unit_price_tbl OUT NOCOPY PO_TBL_NUMBER,

Line 143: p_index_tbl IN DBMS_SQL.NUMBER_TABLE,

139:
140: PROCEDURE default_info_from_job
141: (
142: p_key IN po_session_gt.key%TYPE,
143: p_index_tbl IN DBMS_SQL.NUMBER_TABLE,
144: p_job_id_tbl IN PO_TBL_NUMBER,
145: x_item_desc_tbl OUT NOCOPY PO_TBL_VARCHAR2000,
146: x_category_id_tbl OUT NOCOPY PO_TBL_NUMBER
147: );

Line 152: p_index_tbl IN DBMS_SQL.NUMBER_TABLE,

148:
149: PROCEDURE default_po_cat_id_from_ip
150: (
151: p_key IN po_session_gt.key%TYPE,
152: p_index_tbl IN DBMS_SQL.NUMBER_TABLE,
153: p_ip_category_id_tbl IN PO_TBL_NUMBER,
154: x_po_category_id_tbl IN OUT NOCOPY PO_TBL_NUMBER
155: );
156:

Line 160: p_index_tbl IN DBMS_SQL.NUMBER_TABLE,

156:
157: PROCEDURE default_ip_cat_id_from_po
158: (
159: p_key IN po_session_gt.key%TYPE,
160: p_index_tbl IN DBMS_SQL.NUMBER_TABLE,
161: p_po_category_id_tbl IN PO_TBL_NUMBER,
162: x_ip_category_id_tbl IN OUT NOCOPY PO_TBL_NUMBER
163: );
164:

Line 168: p_index_tbl IN DBMS_SQL.NUMBER_TABLE,

164:
165: PROCEDURE default_hc_id_from_un_number
166: (
167: p_key IN po_session_gt.key%TYPE,
168: p_index_tbl IN DBMS_SQL.NUMBER_TABLE,
169: p_un_number_tbl IN PO_TBL_VARCHAR30,
170: x_hazard_class_id_tbl IN OUT NOCOPY PO_TBL_NUMBER
171: );
172:

Line 175: p_index_tbl IN DBMS_SQL.NUMBER_TABLE,

171: );
172:
173: PROCEDURE match_lines_on_line_num
174: (
175: p_index_tbl IN DBMS_SQL.NUMBER_TABLE,
176: x_lines IN OUT NOCOPY PO_PDOI_TYPES.lines_rec_type
177: );
178:
179: PROCEDURE match_lines_on_item_info

Line 187: p_source_index_tbl IN DBMS_SQL.NUMBER_TABLE,

183:
184: PROCEDURE copy_lines
185: (
186: p_source_lines IN PO_PDOI_TYPES.lines_rec_type,
187: p_source_index_tbl IN DBMS_SQL.NUMBER_TABLE,
188: x_target_lines IN OUT NOCOPY PO_PDOI_TYPES.lines_rec_type
189: );
190:
191: PROCEDURE uniqueness_check_on_desc

Line 195: x_processing_row_tbl IN OUT NOCOPY DBMS_SQL.NUMBER_TABLE,

191: PROCEDURE uniqueness_check_on_desc
192: (
193: p_key IN po_session_gt.key%TYPE,
194: p_group_num IN NUMBER,
195: x_processing_row_tbl IN OUT NOCOPY DBMS_SQL.NUMBER_TABLE,
196: x_lines IN OUT NOCOPY PO_PDOI_TYPES.lines_rec_type
197: );
198:
199: PROCEDURE uniqueness_check_on_item

Line 203: x_processing_row_tbl IN OUT NOCOPY DBMS_SQL.NUMBER_TABLE,

199: PROCEDURE uniqueness_check_on_item
200: (
201: p_key IN po_session_gt.key%TYPE,
202: p_group_num IN NUMBER,
203: x_processing_row_tbl IN OUT NOCOPY DBMS_SQL.NUMBER_TABLE,
204: x_lines IN OUT NOCOPY PO_PDOI_TYPES.lines_rec_type
205: );
206:
207: PROCEDURE uniqueness_check_on_vpn

Line 211: x_processing_row_tbl IN OUT NOCOPY DBMS_SQL.NUMBER_TABLE,

207: PROCEDURE uniqueness_check_on_vpn
208: (
209: p_key IN po_session_gt.key%TYPE,
210: p_group_num IN NUMBER,
211: x_processing_row_tbl IN OUT NOCOPY DBMS_SQL.NUMBER_TABLE,
212: x_lines IN OUT NOCOPY PO_PDOI_TYPES.lines_rec_type
213: );
214:
215: PROCEDURE uniqueness_check_on_job

Line 219: x_processing_row_tbl IN OUT NOCOPY DBMS_SQL.NUMBER_TABLE,

215: PROCEDURE uniqueness_check_on_job
216: (
217: p_key IN po_session_gt.key%TYPE,
218: p_group_num IN NUMBER,
219: x_processing_row_tbl IN OUT NOCOPY DBMS_SQL.NUMBER_TABLE,
220: x_lines IN OUT NOCOPY PO_PDOI_TYPES.lines_rec_type
221: );
222:
223: PROCEDURE uniqueness_check_on_line_num

Line 227: x_processing_row_tbl IN OUT NOCOPY DBMS_SQL.NUMBER_TABLE,

223: PROCEDURE uniqueness_check_on_line_num
224: (
225: p_key IN po_session_gt.key%TYPE,
226: p_group_num IN NUMBER,
227: x_processing_row_tbl IN OUT NOCOPY DBMS_SQL.NUMBER_TABLE,
228: x_lines IN OUT NOCOPY PO_PDOI_TYPES.lines_rec_type
229: );
230:
231:

Line 238: x_processing_row_tbl IN OUT NOCOPY DBMS_SQL.NUMBER_TABLE,

234: p_key IN po_session_gt.key%TYPE,
235: p_group_num IN NUMBER,
236: p_target_lines_index_tbl IN PO_TBL_NUMBER,
237: p_check_line_num_assign IN VARCHAR2,
238: x_processing_row_tbl IN OUT NOCOPY DBMS_SQL.NUMBER_TABLE,
239: x_lines IN OUT NOCOPY PO_PDOI_TYPES.lines_rec_type
240: );
241:
242:

Line 263: p_index_tbl IN DBMS_SQL.NUMBER_TABLE,

259: --CLM PDOI Integration Starts
260: PROCEDURE derive_contract_type
261: (
262: p_key IN po_session_gt.key%TYPE,
263: p_index_tbl IN DBMS_SQL.NUMBER_TABLE,
264: p_contract_type_display_tbl IN PO_TBL_VARCHAR240,
265: x_contract_type_tbl IN OUT NOCOPY PO_TBL_VARCHAR240
266: );
267:

Line 271: p_index_tbl IN DBMS_SQL.NUMBER_TABLE,

267:
268: PROCEDURE derive_cost_constraint
269: (
270: p_key IN po_session_gt.key%TYPE,
271: p_index_tbl IN DBMS_SQL.NUMBER_TABLE,
272: p_cost_constraint_display_tbl IN PO_TBL_VARCHAR240,
273: x_cost_constraint_tbl IN OUT NOCOPY PO_TBL_VARCHAR30
274: );
275:

Line 279: p_index_tbl IN DBMS_SQL.NUMBER_TABLE,

275:
276: PROCEDURE derive_clm_idc_type
277: (
278: p_key IN po_session_gt.key%TYPE,
279: p_index_tbl IN DBMS_SQL.NUMBER_TABLE,
280: p_clm_idc_type_display_tbl IN PO_TBL_VARCHAR240,
281: x_clm_idc_type_tbl IN OUT NOCOPY PO_TBL_VARCHAR240
282: );
283:

Line 287: p_index_tbl IN DBMS_SQL.NUMBER_TABLE,

283:
284: PROCEDURE derive_clm_base_line_num
285: (
286: p_key IN po_session_gt.key%TYPE,
287: p_index_tbl IN DBMS_SQL.NUMBER_TABLE,
288: p_clm_base_line_num_disp_tbl IN PO_TBL_VARCHAR240,
289: p_intf_line_id_tbl IN PO_TBL_NUMBER,
290: p_intf_header_id_tbl IN PO_TBL_NUMBER,
291: p_line_num_display_tbl IN PO_TBL_VARCHAR100,

Line 299: p_index_tbl IN DBMS_SQL.NUMBER_TABLE,

295:
296: PROCEDURE derive_from_line_id
297: (
298: p_key IN po_session_gt.key%TYPE,
299: p_index_tbl IN DBMS_SQL.NUMBER_TABLE,
300: p_from_line_disp_tbl IN PO_TBL_VARCHAR240,
301: p_from_header_id_tbl IN PO_TBL_NUMBER,
302: x_from_line_id_tbl IN OUT NOCOPY PO_TBL_NUMBER
303: );

Line 308: p_index_tbl IN DBMS_SQL.NUMBER_TABLE,

304:
305: PROCEDURE derive_from_header_id
306: (
307: p_key IN po_session_gt.key%TYPE,
308: p_index_tbl IN DBMS_SQL.NUMBER_TABLE,
309: p_from_header_disp_tbl IN PO_TBL_VARCHAR240,
310: x_from_header_id_tbl IN OUT NOCOPY PO_TBL_NUMBER
311: );
312:

Line 316: p_index_tbl IN DBMS_SQL.NUMBER_TABLE,

312:
313: PROCEDURE default_clm_option_indicator
314: (
315: p_key IN po_session_gt.key%TYPE,
316: p_index_tbl IN DBMS_SQL.NUMBER_TABLE,
317: p_intf_line_id_tbl IN PO_TBL_NUMBER,
318: p_clm_base_line_num_tbl IN PO_TBL_NUMBER,
319: x_clm_option_indicator_tbl IN OUT NOCOPY PO_TBL_VARCHAR1
320: );

Line 325: p_index_tbl IN DBMS_SQL.NUMBER_TABLE,

321:
322: PROCEDURE default_clm_option_num
323: (
324: p_key IN po_session_gt.key%TYPE,
325: p_index_tbl IN DBMS_SQL.NUMBER_TABLE,
326: p_intf_header_id_tbl IN PO_TBL_NUMBER,
327: p_intf_line_id_tbl IN PO_TBL_NUMBER,
328: p_clm_base_line_num_tbl IN PO_TBL_NUMBER,
329: p_clm_option_indicator_tbl IN PO_TBL_VARCHAR1,

Line 336: p_index_tbl IN DBMS_SQL.NUMBER_TABLE,

332:
333: PROCEDURE default_from_header_id
334: (
335: p_key IN po_session_gt.key%TYPE,
336: p_index_tbl IN DBMS_SQL.NUMBER_TABLE,
337: p_intf_header_id_tbl IN PO_TBL_NUMBER,
338: p_intf_line_id_tbl IN PO_TBL_NUMBER,
339: x_from_header_id_tbl IN OUT NOCOPY PO_TBL_NUMBER
340: );

Line 2107: l_index_tbl DBMS_SQL.NUMBER_TABLE;

2103: -- key of temp table used to identify the derived result
2104: l_key po_session_gt.key%TYPE;
2105:
2106: -- table used to save the index of the each row
2107: l_index_tbl DBMS_SQL.NUMBER_TABLE;
2108: BEGIN
2109: d_position := 0;
2110:
2111: IF (PO_LOG.d_proc) THEN

Line 2825: l_index_tbl DBMS_SQL.NUMBER_TABLE;

2821: -- key of temp table used to identify the derived result
2822: l_key po_session_gt.key%TYPE;
2823:
2824: -- table used to save the index of the each row
2825: l_index_tbl DBMS_SQL.NUMBER_TABLE;
2826: BEGIN
2827: d_position := 0;
2828:
2829: IF (PO_LOG.d_proc) THEN

Line 3062: l_index_tbl DBMS_SQL.NUMBER_TABLE;

3058: -- key of temp table used to identify the derived result
3059: l_key po_session_gt.key%TYPE;
3060:
3061: -- table used to save the index of the each row
3062: l_index_tbl DBMS_SQL.NUMBER_TABLE;
3063:
3064: -- information defaulted from line type
3065: l_li_category_id_tbl PO_TBL_NUMBER;
3066: l_li_unit_of_measure_tbl PO_TBL_VARCHAR30;

Line 3546: l_num_list DBMS_SQL.NUMBER_TABLE;

3542: -- key of temp table used to identify the derived result
3543: l_key po_session_gt.key%TYPE;
3544:
3545: -- table used to save the index of the each row
3546: l_num_list DBMS_SQL.NUMBER_TABLE;
3547:
3548: -- information defaulted from existing po line
3549: l_index_tbl PO_TBL_NUMBER;
3550: l_order_type_tbl PO_TBL_VARCHAR30;

Line 3677: l_index_tbl DBMS_SQL.NUMBER_TABLE;

3673: d_api_name CONSTANT VARCHAR2(30) := 'match_lines';
3674: d_module CONSTANT VARCHAR2(255) := d_pkg_name || d_api_name || '.';
3675: d_position NUMBER;
3676:
3677: l_index_tbl DBMS_SQL.NUMBER_TABLE;
3678:
3679: l_create_lines PO_PDOI_TYPES.lines_rec_type;
3680: l_update_lines PO_PDOI_TYPES.lines_rec_type;
3681:

Line 4101: x_processing_row_tbl IN OUT NOCOPY DBMS_SQL.NUMBER_TABLE,

4097: PROCEDURE uniqueness_check
4098: (
4099: p_type IN NUMBER,
4100: p_group_num IN NUMBER,
4101: x_processing_row_tbl IN OUT NOCOPY DBMS_SQL.NUMBER_TABLE,
4102: x_lines IN OUT NOCOPY PO_PDOI_TYPES.lines_rec_type,
4103: x_expire_line_id_tbl OUT NOCOPY DBMS_SQL.NUMBER_TABLE
4104: ) IS
4105:

Line 4103: x_expire_line_id_tbl OUT NOCOPY DBMS_SQL.NUMBER_TABLE

4099: p_type IN NUMBER,
4100: p_group_num IN NUMBER,
4101: x_processing_row_tbl IN OUT NOCOPY DBMS_SQL.NUMBER_TABLE,
4102: x_lines IN OUT NOCOPY PO_PDOI_TYPES.lines_rec_type,
4103: x_expire_line_id_tbl OUT NOCOPY DBMS_SQL.NUMBER_TABLE
4104: ) IS
4105:
4106: d_api_name CONSTANT VARCHAR2(30) := 'uniqueness_check';
4107: d_module CONSTANT VARCHAR2(255) := d_pkg_name || d_api_name || '.';

Line 4114: l_index_tbl DBMS_SQL.NUMBER_TABLE;

4110: -- key of temp table used to identify the records
4111: l_key po_session_gt.key%TYPE;
4112:
4113: -- table storing the index of records within the batch
4114: l_index_tbl DBMS_SQL.NUMBER_TABLE;
4115: l_index NUMBER;
4116:
4117: -- store the index of lines that need to be expired
4118: l_expire_line_index_tbl PO_TBL_NUMBER;

Line 4368: l_create_index_tbl DBMS_SQL.NUMBER_TABLE;

4364: d_module CONSTANT VARCHAR2(255) := d_pkg_name || d_api_name || '.';
4365: d_position NUMBER;
4366:
4367: -- store index of rows to be copied to different records
4368: l_create_index_tbl DBMS_SQL.NUMBER_TABLE;
4369: l_update_index_tbl DBMS_SQL.NUMBER_TABLE;
4370: BEGIN
4371: d_position := 0;
4372:

Line 4369: l_update_index_tbl DBMS_SQL.NUMBER_TABLE;

4365: d_position NUMBER;
4366:
4367: -- store index of rows to be copied to different records
4368: l_create_index_tbl DBMS_SQL.NUMBER_TABLE;
4369: l_update_index_tbl DBMS_SQL.NUMBER_TABLE;
4370: BEGIN
4371: d_position := 0;
4372:
4373: IF (PO_LOG.d_proc) THEN

Line 4708: p_index_tbl IN DBMS_SQL.NUMBER_TABLE,

4704: ------------------------------------------------------------------------
4705: PROCEDURE derive_item_id
4706: (
4707: p_key IN po_session_gt.key%TYPE,
4708: p_index_tbl IN DBMS_SQL.NUMBER_TABLE,
4709: p_vendor_id_tbl IN PO_TBL_NUMBER,
4710: p_intf_header_id_tbl IN PO_TBL_NUMBER,
4711: p_intf_line_id_tbl IN PO_TBL_NUMBER,
4712: p_vendor_product_num_tbl IN PO_TBL_VARCHAR30,

Line 4731: l_error_exist_tbl DBMS_SQL.NUMBER_TABLE;

4727: -- variable to hold index of the current processing row
4728: l_index NUMBER;
4729:
4730: -- variables to indicate whether multiple_buyer_part error is already inserted
4731: l_error_exist_tbl DBMS_SQL.NUMBER_TABLE;
4732: BEGIN
4733: d_position := 0;
4734:
4735: IF (PO_LOG.d_proc) THEN

Line 4931: p_index_tbl IN DBMS_SQL.NUMBER_TABLE,

4927: ------------------------------------------------------------------------
4928: PROCEDURE derive_job_business_group_id
4929: (
4930: p_key IN po_session_gt.key%TYPE,
4931: p_index_tbl IN DBMS_SQL.NUMBER_TABLE,
4932: p_job_business_group_name_tbl IN PO_TBL_VARCHAR2000,
4933: x_job_business_group_id_tbl IN OUT NOCOPY PO_TBL_NUMBER
4934: ) IS
4935:

Line 5031: p_index_tbl IN DBMS_SQL.NUMBER_TABLE,

5027: ------------------------------------------------------------------------
5028: PROCEDURE derive_job_id
5029: (
5030: p_key IN po_session_gt.key%TYPE,
5031: p_index_tbl IN DBMS_SQL.NUMBER_TABLE,
5032: p_file_line_language_tbl IN PO_TBL_VARCHAR5,
5033: p_job_business_group_name_tbl IN PO_TBL_VARCHAR2000,
5034: p_job_name_tbl IN PO_TBL_VARCHAR2000,
5035: x_job_business_group_id_tbl IN OUT NOCOPY PO_TBL_NUMBER,

Line 5333: p_index_tbl IN DBMS_SQL.NUMBER_TABLE,

5329: ------------------------------------------------------------------------
5330: PROCEDURE derive_ip_category_id
5331: (
5332: p_key IN po_session_gt.key%TYPE,
5333: p_index_tbl IN DBMS_SQL.NUMBER_TABLE,
5334: p_file_line_language_tbl IN PO_TBL_VARCHAR5,
5335: p_ip_category_tbl IN PO_TBL_VARCHAR2000,
5336: x_ip_category_id_tbl IN OUT NOCOPY PO_TBL_NUMBER
5337: ) IS

Line 5463: p_index_tbl IN DBMS_SQL.NUMBER_TABLE,

5459: ------------------------------------------------------------------------
5460: PROCEDURE derive_unit_of_measure
5461: (
5462: p_key IN po_session_gt.key%TYPE,
5463: p_index_tbl IN DBMS_SQL.NUMBER_TABLE,
5464: p_uom_code_tbl IN PO_TBL_VARCHAR5,
5465: x_unit_of_measure_tbl IN OUT NOCOPY PO_TBL_VARCHAR30
5466: ) IS
5467:

Line 5555: p_index_tbl IN DBMS_SQL.NUMBER_TABLE,

5551: ------------------------------------------------------------------------
5552: PROCEDURE derive_line_type_id
5553: (
5554: p_key IN po_session_gt.key%TYPE,
5555: p_index_tbl IN DBMS_SQL.NUMBER_TABLE,
5556: p_file_line_language_tbl IN PO_TBL_VARCHAR5,
5557: p_line_type_tbl IN PO_TBL_VARCHAR30,
5558: x_line_type_id_tbl IN OUT NOCOPY PO_TBL_NUMBER
5559: ) IS

Line 5652: p_index_tbl IN DBMS_SQL.NUMBER_TABLE,

5648: ------------------------------------------------------------------------
5649: PROCEDURE derive_un_number_id
5650: (
5651: p_key IN po_session_gt.key%TYPE,
5652: p_index_tbl IN DBMS_SQL.NUMBER_TABLE,
5653: p_un_number_tbl IN PO_TBL_VARCHAR30,
5654: x_un_number_id_tbl IN OUT NOCOPY PO_TBL_NUMBER
5655: ) IS
5656:

Line 5742: p_index_tbl IN DBMS_SQL.NUMBER_TABLE,

5738: ------------------------------------------------------------------------
5739: PROCEDURE derive_hazard_class_id
5740: (
5741: p_key IN po_session_gt.key%TYPE,
5742: p_index_tbl IN DBMS_SQL.NUMBER_TABLE,
5743: p_hazard_class_tbl IN PO_TBL_VARCHAR100,
5744: x_hazard_class_id_tbl IN OUT NOCOPY PO_TBL_NUMBER
5745: ) IS
5746:

Line 5831: p_index_tbl IN DBMS_SQL.NUMBER_TABLE,

5827: ------------------------------------------------------------------------
5828: PROCEDURE derive_template_id
5829: (
5830: p_key IN po_session_gt.key%TYPE,
5831: p_index_tbl IN DBMS_SQL.NUMBER_TABLE,
5832: p_template_name_tbl IN PO_TBL_VARCHAR30,
5833: x_template_id_tbl IN OUT NOCOPY PO_TBL_NUMBER
5834: ) IS
5835:

Line 5937: p_index_tbl IN DBMS_SQL.NUMBER_TABLE,

5933: ------------------------------------------------------------------------
5934: PROCEDURE default_info_from_line_type
5935: (
5936: p_key IN po_session_gt.key%TYPE,
5937: p_index_tbl IN DBMS_SQL.NUMBER_TABLE,
5938: p_line_type_id_tbl IN PO_TBL_NUMBER,
5939: x_order_type_lookup_code_tbl IN OUT NOCOPY PO_TBL_VARCHAR30,
5940: x_purchase_basis_tbl IN OUT NOCOPY PO_TBL_VARCHAR30,
5941: x_matching_basis_tbl IN OUT NOCOPY PO_TBL_VARCHAR30,

Line 6096: p_index_tbl IN DBMS_SQL.NUMBER_TABLE,

6092: ------------------------------------------------------------------------
6093: PROCEDURE default_info_from_item
6094: (
6095: p_key IN po_session_gt.key%TYPE,
6096: p_index_tbl IN DBMS_SQL.NUMBER_TABLE,
6097: p_item_id_tbl IN PO_TBL_NUMBER,
6098: x_item_desc_tbl OUT NOCOPY PO_TBL_VARCHAR2000,
6099: x_unit_of_measure_tbl OUT NOCOPY PO_TBL_VARCHAR30,
6100: x_unit_price_tbl OUT NOCOPY PO_TBL_NUMBER,

Line 6275: p_index_tbl IN DBMS_SQL.NUMBER_TABLE,

6271: ------------------------------------------------------------------------
6272: PROCEDURE default_info_from_job
6273: (
6274: p_key IN po_session_gt.key%TYPE,
6275: p_index_tbl IN DBMS_SQL.NUMBER_TABLE,
6276: p_job_id_tbl IN PO_TBL_NUMBER,
6277: x_item_desc_tbl OUT NOCOPY PO_TBL_VARCHAR2000,
6278: x_category_id_tbl OUT NOCOPY PO_TBL_NUMBER
6279: ) IS

Line 6382: p_index_tbl IN DBMS_SQL.NUMBER_TABLE,

6378: ------------------------------------------------------------------------
6379: PROCEDURE default_po_cat_id_from_ip
6380: (
6381: p_key IN po_session_gt.key%TYPE,
6382: p_index_tbl IN DBMS_SQL.NUMBER_TABLE,
6383: p_ip_category_id_tbl IN PO_TBL_NUMBER,
6384: x_po_category_id_tbl IN OUT NOCOPY PO_TBL_NUMBER
6385: ) IS
6386:

Line 6470: p_index_tbl IN DBMS_SQL.NUMBER_TABLE,

6466: ------------------------------------------------------------------------
6467: PROCEDURE default_ip_cat_id_from_po
6468: (
6469: p_key IN po_session_gt.key%TYPE,
6470: p_index_tbl IN DBMS_SQL.NUMBER_TABLE,
6471: p_po_category_id_tbl IN PO_TBL_NUMBER,
6472: x_ip_category_id_tbl IN OUT NOCOPY PO_TBL_NUMBER
6473: ) IS
6474:

Line 6558: p_index_tbl IN DBMS_SQL.NUMBER_TABLE,

6554: ------------------------------------------------------------------------
6555: PROCEDURE default_hc_id_from_un_number
6556: (
6557: p_key IN po_session_gt.key%TYPE,
6558: p_index_tbl IN DBMS_SQL.NUMBER_TABLE,
6559: p_un_number_tbl IN PO_TBL_VARCHAR30,
6560: x_hazard_class_id_tbl IN OUT NOCOPY PO_TBL_NUMBER
6561: ) IS
6562:

Line 6646: p_index_tbl DBMS_SQL.NUMBER_TABLE,

6642: --End of Comments
6643: ------------------------------------------------------------------------
6644: PROCEDURE match_lines_on_line_num
6645: (
6646: p_index_tbl DBMS_SQL.NUMBER_TABLE,
6647: x_lines IN OUT NOCOPY PO_PDOI_TYPES.lines_rec_type
6648: ) IS
6649:
6650: d_api_name CONSTANT VARCHAR2(30) := 'match_lines_on_line_num';

Line 6662: --TYPE line_ref_type IS TABLE OF DBMS_SQL.NUMBER_TABLE INDEX BY PLS_INTEGER;

6658: l_index_tbl PO_TBL_NUMBER;
6659: l_result_tbl PO_TBL_NUMBER;
6660:
6661: -- hash table of po_line_id based on po_header_id and line num
6662: --TYPE line_ref_type IS TABLE OF DBMS_SQL.NUMBER_TABLE INDEX BY PLS_INTEGER;
6663: -- Added as part of bug 8836290 to handle line_num's decimals also without grouping
6664: TYPE line_ref_internal_type IS TABLE OF NUMBER INDEX BY VARCHAR2(32);
6665: TYPE line_ref_type IS TABLE OF line_ref_internal_type INDEX BY PLS_INTEGER;
6666: l_line_reference_tbl line_ref_type;

Line 6809: l_processing_line_tbl DBMS_SQL.NUMBER_TABLE;

6805: l_key po_session_gt.key%TYPE;
6806: l_data_key po_session_gt.key%TYPE;
6807:
6808: -- identify lines that are going to be processed
6809: l_processing_line_tbl DBMS_SQL.NUMBER_TABLE;
6810: l_num_list DBMS_SQL.NUMBER_TABLE;
6811:
6812: -- po line that has been found as a match for current line
6813: l_index_tbl PO_TBL_NUMBER;

Line 6810: l_num_list DBMS_SQL.NUMBER_TABLE;

6806: l_data_key po_session_gt.key%TYPE;
6807:
6808: -- identify lines that are going to be processed
6809: l_processing_line_tbl DBMS_SQL.NUMBER_TABLE;
6810: l_num_list DBMS_SQL.NUMBER_TABLE;
6811:
6812: -- po line that has been found as a match for current line
6813: l_index_tbl PO_TBL_NUMBER;
6814: l_po_line_id_tbl PO_TBL_NUMBER;

Line 7145: p_source_index_tbl IN DBMS_SQL.NUMBER_TABLE,

7141: ------------------------------------------------------------------------
7142: PROCEDURE copy_lines
7143: (
7144: p_source_lines IN PO_PDOI_TYPES.lines_rec_type,
7145: p_source_index_tbl IN DBMS_SQL.NUMBER_TABLE,
7146: x_target_lines IN OUT NOCOPY PO_PDOI_TYPES.lines_rec_type
7147: ) IS
7148:
7149: d_api_name CONSTANT VARCHAR2(30) := 'copy_lines';

Line 7399: x_processing_row_tbl IN OUT NOCOPY DBMS_SQL.NUMBER_TABLE,

7395: PROCEDURE uniqueness_check_on_desc
7396: (
7397: p_key IN po_session_gt.key%TYPE,
7398: p_group_num IN NUMBER,
7399: x_processing_row_tbl IN OUT NOCOPY DBMS_SQL.NUMBER_TABLE,
7400: x_lines IN OUT NOCOPY PO_PDOI_TYPES.lines_rec_type
7401: ) IS
7402:
7403: d_api_name CONSTANT VARCHAR2(30) := 'uniqueness_check_on_desc';

Line 7653: x_processing_row_tbl IN OUT NOCOPY DBMS_SQL.NUMBER_TABLE,

7649: PROCEDURE uniqueness_check_on_item
7650: (
7651: p_key IN po_session_gt.key%TYPE,
7652: p_group_num IN NUMBER,
7653: x_processing_row_tbl IN OUT NOCOPY DBMS_SQL.NUMBER_TABLE,
7654: x_lines IN OUT NOCOPY PO_PDOI_TYPES.lines_rec_type
7655: ) IS
7656:
7657: d_api_name CONSTANT VARCHAR2(30) := 'uniqueness_check_on_item';

Line 7955: x_processing_row_tbl IN OUT NOCOPY DBMS_SQL.NUMBER_TABLE,

7951: PROCEDURE uniqueness_check_on_vpn
7952: (
7953: p_key IN po_session_gt.key%TYPE,
7954: p_group_num IN NUMBER,
7955: x_processing_row_tbl IN OUT NOCOPY DBMS_SQL.NUMBER_TABLE,
7956: x_lines IN OUT NOCOPY PO_PDOI_TYPES.lines_rec_type
7957: ) IS
7958:
7959: d_api_name CONSTANT VARCHAR2(30) := 'uniqueness_check_on_vpn';

Line 8213: x_processing_row_tbl IN OUT NOCOPY DBMS_SQL.NUMBER_TABLE,

8209: PROCEDURE uniqueness_check_on_job
8210: (
8211: p_key IN po_session_gt.key%TYPE,
8212: p_group_num IN NUMBER,
8213: x_processing_row_tbl IN OUT NOCOPY DBMS_SQL.NUMBER_TABLE,
8214: x_lines IN OUT NOCOPY PO_PDOI_TYPES.lines_rec_type
8215: ) IS
8216:
8217: d_api_name CONSTANT VARCHAR2(30) := 'uniqueness_check_on_job';

Line 8468: x_processing_row_tbl IN OUT NOCOPY DBMS_SQL.NUMBER_TABLE,

8464: PROCEDURE uniqueness_check_on_line_num
8465: (
8466: p_key IN po_session_gt.key%TYPE,
8467: p_group_num IN NUMBER,
8468: x_processing_row_tbl IN OUT NOCOPY DBMS_SQL.NUMBER_TABLE,
8469: x_lines IN OUT NOCOPY PO_PDOI_TYPES.lines_rec_type
8470: ) IS
8471:
8472: d_api_name CONSTANT VARCHAR2(30) := 'uniqueness_check_on_line_num';

Line 8690: x_processing_row_tbl IN OUT NOCOPY DBMS_SQL.NUMBER_TABLE,

8686: p_key IN po_session_gt.key%TYPE,
8687: p_group_num IN NUMBER,
8688: p_target_lines_index_tbl IN PO_TBL_NUMBER,
8689: p_check_line_num_assign IN VARCHAR2,
8690: x_processing_row_tbl IN OUT NOCOPY DBMS_SQL.NUMBER_TABLE,
8691: x_lines IN OUT NOCOPY PO_PDOI_TYPES.lines_rec_type
8692: ) IS
8693:
8694:

Line 8800: l_index_tbl DBMS_SQL.NUMBER_TABLE;

8796:
8797: l_key po_session_gt.key%TYPE;
8798:
8799: -- table used to save the index of the each row
8800: l_index_tbl DBMS_SQL.NUMBER_TABLE;
8801: l_index NUMBER;
8802: BEGIN
8803: d_position := 0;
8804:

Line 8917: l_index_tbl DBMS_SQL.number_table;

8913: d_api_name CONSTANT VARCHAR2(30) := 'populate_error_flag';
8914: d_module CONSTANT VARCHAR2(255) := d_pkg_name || d_api_name || '.';
8915: d_position NUMBER;
8916:
8917: l_index_tbl DBMS_SQL.number_table;
8918:
8919: BEGIN
8920: d_position := 0;
8921:

Line 9104: p_index_tbl IN DBMS_SQL.NUMBER_TABLE,

9100:
9101: PROCEDURE derive_contract_type
9102: (
9103: p_key IN po_session_gt.key%TYPE,
9104: p_index_tbl IN DBMS_SQL.NUMBER_TABLE,
9105: p_contract_type_display_tbl IN PO_TBL_VARCHAR240,
9106: x_contract_type_tbl IN OUT NOCOPY PO_TBL_VARCHAR240
9107: ) IS
9108:

Line 9175: p_index_tbl IN DBMS_SQL.NUMBER_TABLE,

9171:
9172: PROCEDURE derive_cost_constraint
9173: (
9174: p_key IN po_session_gt.key%TYPE,
9175: p_index_tbl IN DBMS_SQL.NUMBER_TABLE,
9176: p_cost_constraint_display_tbl IN PO_TBL_VARCHAR240,
9177: x_cost_constraint_tbl IN OUT NOCOPY PO_TBL_VARCHAR30
9178: ) IS
9179:

Line 9245: p_index_tbl IN DBMS_SQL.NUMBER_TABLE,

9241:
9242: PROCEDURE derive_clm_idc_type
9243: (
9244: p_key IN po_session_gt.key%TYPE,
9245: p_index_tbl IN DBMS_SQL.NUMBER_TABLE,
9246: p_clm_idc_type_display_tbl IN PO_TBL_VARCHAR240,
9247: x_clm_idc_type_tbl IN OUT NOCOPY PO_TBL_VARCHAR240
9248: ) IS
9249:

Line 9315: p_index_tbl IN DBMS_SQL.NUMBER_TABLE,

9311:
9312: PROCEDURE derive_clm_base_line_num
9313: (
9314: p_key IN po_session_gt.key%TYPE,
9315: p_index_tbl IN DBMS_SQL.NUMBER_TABLE,
9316: p_clm_base_line_num_disp_tbl IN PO_TBL_VARCHAR240,
9317: p_intf_line_id_tbl IN PO_TBL_NUMBER,
9318: p_intf_header_id_tbl IN PO_TBL_NUMBER,
9319: p_line_num_display_tbl IN PO_TBL_VARCHAR100,

Line 9396: p_index_tbl IN DBMS_SQL.NUMBER_TABLE,

9392:
9393: PROCEDURE derive_from_header_id
9394: (
9395: p_key IN po_session_gt.key%TYPE,
9396: p_index_tbl IN DBMS_SQL.NUMBER_TABLE,
9397: p_from_header_disp_tbl IN PO_TBL_VARCHAR240,
9398: x_from_header_id_tbl IN OUT NOCOPY PO_TBL_NUMBER
9399: ) IS
9400:

Line 9470: p_index_tbl IN DBMS_SQL.NUMBER_TABLE,

9466:
9467: PROCEDURE derive_from_line_id
9468: (
9469: p_key IN po_session_gt.key%TYPE,
9470: p_index_tbl IN DBMS_SQL.NUMBER_TABLE,
9471: p_from_line_disp_tbl IN PO_TBL_VARCHAR240,
9472: p_from_header_id_tbl IN PO_TBL_NUMBER,
9473: x_from_line_id_tbl IN OUT NOCOPY PO_TBL_NUMBER
9474: ) IS

Line 9546: p_index_tbl IN DBMS_SQL.NUMBER_TABLE,

9542:
9543: PROCEDURE default_clm_option_indicator
9544: (
9545: p_key IN po_session_gt.key%TYPE,
9546: p_index_tbl IN DBMS_SQL.NUMBER_TABLE,
9547: p_intf_line_id_tbl IN PO_TBL_NUMBER,
9548: p_clm_base_line_num_tbl IN PO_TBL_NUMBER,
9549: x_clm_option_indicator_tbl IN OUT NOCOPY PO_TBL_VARCHAR1
9550: ) IS

Line 9621: p_index_tbl IN DBMS_SQL.NUMBER_TABLE,

9617:
9618: PROCEDURE default_clm_option_num
9619: (
9620: p_key IN po_session_gt.key%TYPE,
9621: p_index_tbl IN DBMS_SQL.NUMBER_TABLE,
9622: p_intf_header_id_tbl IN PO_TBL_NUMBER,
9623: p_intf_line_id_tbl IN PO_TBL_NUMBER,
9624: p_clm_base_line_num_tbl IN PO_TBL_NUMBER,
9625: p_clm_option_indicator_tbl IN PO_TBL_VARCHAR1,

Line 9709: p_index_tbl IN DBMS_SQL.NUMBER_TABLE,

9705:
9706: PROCEDURE default_from_header_id
9707: (
9708: p_key IN po_session_gt.key%TYPE,
9709: p_index_tbl IN DBMS_SQL.NUMBER_TABLE,
9710: p_intf_header_id_tbl IN PO_TBL_NUMBER,
9711: p_intf_line_id_tbl IN PO_TBL_NUMBER,
9712: x_from_header_id_tbl IN OUT NOCOPY PO_TBL_NUMBER
9713: ) IS