DBA Data[Home] [Help]

APPS.ICX_POR_ITEM_UPLOAD_VALIDATE dependencies on DBMS_SQL

Line 77: l_cursor_id := DBMS_SQL.open_cursor;

73: 'AND tl.language (+) = ''' || p_language || ''') ' ||
74: 'WHERE line_number between :startrow AND :endrow';
75: end if;
76:
77: l_cursor_id := DBMS_SQL.open_cursor;
78: xErrLoc := 110;
79: DBMS_SQL.parse(l_cursor_id, l_sql_string, DBMS_SQL.NATIVE);
80: xErrLoc := 120;
81: DBMS_SQL.bind_variable(l_cursor_id, ':startrow', p_start_row);

Line 79: DBMS_SQL.parse(l_cursor_id, l_sql_string, DBMS_SQL.NATIVE);

75: end if;
76:
77: l_cursor_id := DBMS_SQL.open_cursor;
78: xErrLoc := 110;
79: DBMS_SQL.parse(l_cursor_id, l_sql_string, DBMS_SQL.NATIVE);
80: xErrLoc := 120;
81: DBMS_SQL.bind_variable(l_cursor_id, ':startrow', p_start_row);
82: xErrLoc := 130;
83: DBMS_SQL.bind_variable(l_cursor_id, ':endrow', p_end_row);

Line 81: DBMS_SQL.bind_variable(l_cursor_id, ':startrow', p_start_row);

77: l_cursor_id := DBMS_SQL.open_cursor;
78: xErrLoc := 110;
79: DBMS_SQL.parse(l_cursor_id, l_sql_string, DBMS_SQL.NATIVE);
80: xErrLoc := 120;
81: DBMS_SQL.bind_variable(l_cursor_id, ':startrow', p_start_row);
82: xErrLoc := 130;
83: DBMS_SQL.bind_variable(l_cursor_id, ':endrow', p_end_row);
84: xErrLoc := 140;
85: if ( g_operating_unit_id is not null) then -- BUG#2228935

Line 83: DBMS_SQL.bind_variable(l_cursor_id, ':endrow', p_end_row);

79: DBMS_SQL.parse(l_cursor_id, l_sql_string, DBMS_SQL.NATIVE);
80: xErrLoc := 120;
81: DBMS_SQL.bind_variable(l_cursor_id, ':startrow', p_start_row);
82: xErrLoc := 130;
83: DBMS_SQL.bind_variable(l_cursor_id, ':endrow', p_end_row);
84: xErrLoc := 140;
85: if ( g_operating_unit_id is not null) then -- BUG#2228935
86: DBMS_SQL.bind_variable(l_cursor_id, ':oper_unit_id', g_operating_unit_id);
87: end if;

Line 86: DBMS_SQL.bind_variable(l_cursor_id, ':oper_unit_id', g_operating_unit_id);

82: xErrLoc := 130;
83: DBMS_SQL.bind_variable(l_cursor_id, ':endrow', p_end_row);
84: xErrLoc := 140;
85: if ( g_operating_unit_id is not null) then -- BUG#2228935
86: DBMS_SQL.bind_variable(l_cursor_id, ':oper_unit_id', g_operating_unit_id);
87: end if;
88: xErrLoc := 14000;
89: l_result_count := DBMS_SQL.execute(l_cursor_id);
90: xErrLoc := 150;

Line 89: l_result_count := DBMS_SQL.execute(l_cursor_id);

85: if ( g_operating_unit_id is not null) then -- BUG#2228935
86: DBMS_SQL.bind_variable(l_cursor_id, ':oper_unit_id', g_operating_unit_id);
87: end if;
88: xErrLoc := 14000;
89: l_result_count := DBMS_SQL.execute(l_cursor_id);
90: xErrLoc := 150;
91: DBMS_SQL.close_cursor(l_cursor_id);
92:
93: commit;

Line 91: DBMS_SQL.close_cursor(l_cursor_id);

87: end if;
88: xErrLoc := 14000;
89: l_result_count := DBMS_SQL.execute(l_cursor_id);
90: xErrLoc := 150;
91: DBMS_SQL.close_cursor(l_cursor_id);
92:
93: commit;
94:
95: -- Now validate:

Line 160: l_cursor_id := DBMS_SQL.open_cursor;

156: ' AND it2.buyer_name = buy.name (+) ' ||
157: ' AND :bus_group_id = buy.business_group_id (+)) ' ||
158: 'WHERE line_number between :startrow AND :endrow';
159:
160: l_cursor_id := DBMS_SQL.open_cursor;
161: xErrLoc := 210;
162: DBMS_SQL.parse(l_cursor_id, l_sql_string, DBMS_SQL.NATIVE);
163: xErrLoc := 220;
164: DBMS_SQL.bind_variable(l_cursor_id, ':startrow', p_start_row);

Line 162: DBMS_SQL.parse(l_cursor_id, l_sql_string, DBMS_SQL.NATIVE);

158: 'WHERE line_number between :startrow AND :endrow';
159:
160: l_cursor_id := DBMS_SQL.open_cursor;
161: xErrLoc := 210;
162: DBMS_SQL.parse(l_cursor_id, l_sql_string, DBMS_SQL.NATIVE);
163: xErrLoc := 220;
164: DBMS_SQL.bind_variable(l_cursor_id, ':startrow', p_start_row);
165: xErrLoc := 230;
166: DBMS_SQL.bind_variable(l_cursor_id, ':endrow', p_end_row);

Line 164: DBMS_SQL.bind_variable(l_cursor_id, ':startrow', p_start_row);

160: l_cursor_id := DBMS_SQL.open_cursor;
161: xErrLoc := 210;
162: DBMS_SQL.parse(l_cursor_id, l_sql_string, DBMS_SQL.NATIVE);
163: xErrLoc := 220;
164: DBMS_SQL.bind_variable(l_cursor_id, ':startrow', p_start_row);
165: xErrLoc := 230;
166: DBMS_SQL.bind_variable(l_cursor_id, ':endrow', p_end_row);
167: xErrLoc := 240;
168: -- Bug#1581013

Line 166: DBMS_SQL.bind_variable(l_cursor_id, ':endrow', p_end_row);

162: DBMS_SQL.parse(l_cursor_id, l_sql_string, DBMS_SQL.NATIVE);
163: xErrLoc := 220;
164: DBMS_SQL.bind_variable(l_cursor_id, ':startrow', p_start_row);
165: xErrLoc := 230;
166: DBMS_SQL.bind_variable(l_cursor_id, ':endrow', p_end_row);
167: xErrLoc := 240;
168: -- Bug#1581013
169: DBMS_SQL.bind_variable(l_cursor_id, ':all_buyer_list_name', p_exchange_operator_name);
170: xErrLoc := 245;

Line 169: DBMS_SQL.bind_variable(l_cursor_id, ':all_buyer_list_name', p_exchange_operator_name);

165: xErrLoc := 230;
166: DBMS_SQL.bind_variable(l_cursor_id, ':endrow', p_end_row);
167: xErrLoc := 240;
168: -- Bug#1581013
169: DBMS_SQL.bind_variable(l_cursor_id, ':all_buyer_list_name', p_exchange_operator_name);
170: xErrLoc := 245;
171: DBMS_SQL.bind_variable(l_cursor_id, ':bus_group_id', l_bus_group_id);
172: xErrLoc := 250;
173: l_result_count := DBMS_SQL.execute(l_cursor_id);

Line 171: DBMS_SQL.bind_variable(l_cursor_id, ':bus_group_id', l_bus_group_id);

167: xErrLoc := 240;
168: -- Bug#1581013
169: DBMS_SQL.bind_variable(l_cursor_id, ':all_buyer_list_name', p_exchange_operator_name);
170: xErrLoc := 245;
171: DBMS_SQL.bind_variable(l_cursor_id, ':bus_group_id', l_bus_group_id);
172: xErrLoc := 250;
173: l_result_count := DBMS_SQL.execute(l_cursor_id);
174: xErrLoc := 260;
175: DBMS_SQL.close_cursor(l_cursor_id);

Line 173: l_result_count := DBMS_SQL.execute(l_cursor_id);

169: DBMS_SQL.bind_variable(l_cursor_id, ':all_buyer_list_name', p_exchange_operator_name);
170: xErrLoc := 245;
171: DBMS_SQL.bind_variable(l_cursor_id, ':bus_group_id', l_bus_group_id);
172: xErrLoc := 250;
173: l_result_count := DBMS_SQL.execute(l_cursor_id);
174: xErrLoc := 260;
175: DBMS_SQL.close_cursor(l_cursor_id);
176:
177: commit;

Line 175: DBMS_SQL.close_cursor(l_cursor_id);

171: DBMS_SQL.bind_variable(l_cursor_id, ':bus_group_id', l_bus_group_id);
172: xErrLoc := 250;
173: l_result_count := DBMS_SQL.execute(l_cursor_id);
174: xErrLoc := 260;
175: DBMS_SQL.close_cursor(l_cursor_id);
176:
177: commit;
178:
179: xErrLoc := 300;

Line 187: l_cursor_id := DBMS_SQL.open_cursor;

183:
184: l_sql_string := 'SELECT vendor_id ' ||
185: 'FROM po_vendors supp, ' || p_table_name || ' it2 ' ||
186: 'WHERE supp.vendor_name = it2.supplier_name ';
187: l_cursor_id := DBMS_SQL.open_cursor;
188: xErrLoc := 301;
189: DBMS_SQL.parse(l_cursor_id, l_sql_string, DBMS_SQL.NATIVE);
190: xErrLoc := 302;
191: DBMS_SQL.define_column(l_cursor_id, 1, l_supplier_id);

Line 189: DBMS_SQL.parse(l_cursor_id, l_sql_string, DBMS_SQL.NATIVE);

185: 'FROM po_vendors supp, ' || p_table_name || ' it2 ' ||
186: 'WHERE supp.vendor_name = it2.supplier_name ';
187: l_cursor_id := DBMS_SQL.open_cursor;
188: xErrLoc := 301;
189: DBMS_SQL.parse(l_cursor_id, l_sql_string, DBMS_SQL.NATIVE);
190: xErrLoc := 302;
191: DBMS_SQL.define_column(l_cursor_id, 1, l_supplier_id);
192: xErrLoc := 303;
193: l_result_count := DBMS_SQL.execute(l_cursor_id);

Line 191: DBMS_SQL.define_column(l_cursor_id, 1, l_supplier_id);

187: l_cursor_id := DBMS_SQL.open_cursor;
188: xErrLoc := 301;
189: DBMS_SQL.parse(l_cursor_id, l_sql_string, DBMS_SQL.NATIVE);
190: xErrLoc := 302;
191: DBMS_SQL.define_column(l_cursor_id, 1, l_supplier_id);
192: xErrLoc := 303;
193: l_result_count := DBMS_SQL.execute(l_cursor_id);
194: xErrLoc := 304;
195:

Line 193: l_result_count := DBMS_SQL.execute(l_cursor_id);

189: DBMS_SQL.parse(l_cursor_id, l_sql_string, DBMS_SQL.NATIVE);
190: xErrLoc := 302;
191: DBMS_SQL.define_column(l_cursor_id, 1, l_supplier_id);
192: xErrLoc := 303;
193: l_result_count := DBMS_SQL.execute(l_cursor_id);
194: xErrLoc := 304;
195:
196: IF DBMS_SQL.fetch_rows(l_cursor_id) <> 0 THEN
197: DBMS_SQL.column_value(l_cursor_id, 1, l_supplier_id);

Line 196: IF DBMS_SQL.fetch_rows(l_cursor_id) <> 0 THEN

192: xErrLoc := 303;
193: l_result_count := DBMS_SQL.execute(l_cursor_id);
194: xErrLoc := 304;
195:
196: IF DBMS_SQL.fetch_rows(l_cursor_id) <> 0 THEN
197: DBMS_SQL.column_value(l_cursor_id, 1, l_supplier_id);
198: END IF;
199:
200: xErrLoc := 305;

Line 197: DBMS_SQL.column_value(l_cursor_id, 1, l_supplier_id);

193: l_result_count := DBMS_SQL.execute(l_cursor_id);
194: xErrLoc := 304;
195:
196: IF DBMS_SQL.fetch_rows(l_cursor_id) <> 0 THEN
197: DBMS_SQL.column_value(l_cursor_id, 1, l_supplier_id);
198: END IF;
199:
200: xErrLoc := 305;
201:

Line 202: DBMS_SQL.close_cursor(l_cursor_id);

198: END IF;
199:
200: xErrLoc := 305;
201:
202: DBMS_SQL.close_cursor(l_cursor_id);
203:
204: -- SELECT organization_id INTO l_organization_id FROM hr_all_organization_units
205: -- WHERE name = p_exchange_operator_name;
206: -- AND type = 'EXCHANGE_OPERATOR'; ?? DIV ??

Line 277: l_cursor_id := DBMS_SQL.open_cursor;

273: ' AND it2.currency_code = pl.currency_code (+) ' ||
274: ' AND pl.supplier_id (+) = :supplier_id ' ||
275: ' AND supp.vendor_name (+) = it2.supplier_name ' ||
276: ') WHERE line_number BETWEEN :startrow AND :endrow ';
277: l_cursor_id := DBMS_SQL.open_cursor;
278:
279: xErrLoc := 410;
280: DBMS_SQL.parse(l_cursor_id, l_sql_string, DBMS_SQL.NATIVE);
281: xErrLoc := 420;

Line 280: DBMS_SQL.parse(l_cursor_id, l_sql_string, DBMS_SQL.NATIVE);

276: ') WHERE line_number BETWEEN :startrow AND :endrow ';
277: l_cursor_id := DBMS_SQL.open_cursor;
278:
279: xErrLoc := 410;
280: DBMS_SQL.parse(l_cursor_id, l_sql_string, DBMS_SQL.NATIVE);
281: xErrLoc := 420;
282: DBMS_SQL.bind_variable(l_cursor_id, ':startrow', p_start_row);
283: xErrLoc := 430;
284: DBMS_SQL.bind_variable(l_cursor_id, ':endrow', p_end_row);

Line 282: DBMS_SQL.bind_variable(l_cursor_id, ':startrow', p_start_row);

278:
279: xErrLoc := 410;
280: DBMS_SQL.parse(l_cursor_id, l_sql_string, DBMS_SQL.NATIVE);
281: xErrLoc := 420;
282: DBMS_SQL.bind_variable(l_cursor_id, ':startrow', p_start_row);
283: xErrLoc := 430;
284: DBMS_SQL.bind_variable(l_cursor_id, ':endrow', p_end_row);
285: xErrLoc := 435;
286: DBMS_SQL.bind_variable(l_cursor_id, ':supplier_id', l_supplier_id);

Line 284: DBMS_SQL.bind_variable(l_cursor_id, ':endrow', p_end_row);

280: DBMS_SQL.parse(l_cursor_id, l_sql_string, DBMS_SQL.NATIVE);
281: xErrLoc := 420;
282: DBMS_SQL.bind_variable(l_cursor_id, ':startrow', p_start_row);
283: xErrLoc := 430;
284: DBMS_SQL.bind_variable(l_cursor_id, ':endrow', p_end_row);
285: xErrLoc := 435;
286: DBMS_SQL.bind_variable(l_cursor_id, ':supplier_id', l_supplier_id);
287: xErrLoc := 440;
288: DBMS_SQL.bind_variable(l_cursor_id, ':language', p_language);

Line 286: DBMS_SQL.bind_variable(l_cursor_id, ':supplier_id', l_supplier_id);

282: DBMS_SQL.bind_variable(l_cursor_id, ':startrow', p_start_row);
283: xErrLoc := 430;
284: DBMS_SQL.bind_variable(l_cursor_id, ':endrow', p_end_row);
285: xErrLoc := 435;
286: DBMS_SQL.bind_variable(l_cursor_id, ':supplier_id', l_supplier_id);
287: xErrLoc := 440;
288: DBMS_SQL.bind_variable(l_cursor_id, ':language', p_language);
289: xErrLoc := 470;
290: l_result_count := DBMS_SQL.execute(l_cursor_id);

Line 288: DBMS_SQL.bind_variable(l_cursor_id, ':language', p_language);

284: DBMS_SQL.bind_variable(l_cursor_id, ':endrow', p_end_row);
285: xErrLoc := 435;
286: DBMS_SQL.bind_variable(l_cursor_id, ':supplier_id', l_supplier_id);
287: xErrLoc := 440;
288: DBMS_SQL.bind_variable(l_cursor_id, ':language', p_language);
289: xErrLoc := 470;
290: l_result_count := DBMS_SQL.execute(l_cursor_id);
291: xErrLoc := 480;
292: DBMS_SQL.close_cursor(l_cursor_id);

Line 290: l_result_count := DBMS_SQL.execute(l_cursor_id);

286: DBMS_SQL.bind_variable(l_cursor_id, ':supplier_id', l_supplier_id);
287: xErrLoc := 440;
288: DBMS_SQL.bind_variable(l_cursor_id, ':language', p_language);
289: xErrLoc := 470;
290: l_result_count := DBMS_SQL.execute(l_cursor_id);
291: xErrLoc := 480;
292: DBMS_SQL.close_cursor(l_cursor_id);
293:
294: xErrLoc := 700;

Line 292: DBMS_SQL.close_cursor(l_cursor_id);

288: DBMS_SQL.bind_variable(l_cursor_id, ':language', p_language);
289: xErrLoc := 470;
290: l_result_count := DBMS_SQL.execute(l_cursor_id);
291: xErrLoc := 480;
292: DBMS_SQL.close_cursor(l_cursor_id);
293:
294: xErrLoc := 700;
295:
296: -- Bug#1975528

Line 367: l_cursor_id := DBMS_SQL.open_cursor;

363: ') WHERE line_number BETWEEN :startrow AND :endrow ';
364:
365: end if;
366:
367: l_cursor_id := DBMS_SQL.open_cursor;
368: xErrLoc := 710;
369: DBMS_SQL.parse(l_cursor_id, l_sql_string, DBMS_SQL.NATIVE);
370: xErrLoc := 720;
371: DBMS_SQL.bind_variable(l_cursor_id, ':startrow', p_start_row);

Line 369: DBMS_SQL.parse(l_cursor_id, l_sql_string, DBMS_SQL.NATIVE);

365: end if;
366:
367: l_cursor_id := DBMS_SQL.open_cursor;
368: xErrLoc := 710;
369: DBMS_SQL.parse(l_cursor_id, l_sql_string, DBMS_SQL.NATIVE);
370: xErrLoc := 720;
371: DBMS_SQL.bind_variable(l_cursor_id, ':startrow', p_start_row);
372: xErrLoc := 730;
373: DBMS_SQL.bind_variable(l_cursor_id, ':endrow', p_end_row);

Line 371: DBMS_SQL.bind_variable(l_cursor_id, ':startrow', p_start_row);

367: l_cursor_id := DBMS_SQL.open_cursor;
368: xErrLoc := 710;
369: DBMS_SQL.parse(l_cursor_id, l_sql_string, DBMS_SQL.NATIVE);
370: xErrLoc := 720;
371: DBMS_SQL.bind_variable(l_cursor_id, ':startrow', p_start_row);
372: xErrLoc := 730;
373: DBMS_SQL.bind_variable(l_cursor_id, ':endrow', p_end_row);
374: xErrLoc := 740;
375: l_result_count := DBMS_SQL.execute(l_cursor_id);

Line 373: DBMS_SQL.bind_variable(l_cursor_id, ':endrow', p_end_row);

369: DBMS_SQL.parse(l_cursor_id, l_sql_string, DBMS_SQL.NATIVE);
370: xErrLoc := 720;
371: DBMS_SQL.bind_variable(l_cursor_id, ':startrow', p_start_row);
372: xErrLoc := 730;
373: DBMS_SQL.bind_variable(l_cursor_id, ':endrow', p_end_row);
374: xErrLoc := 740;
375: l_result_count := DBMS_SQL.execute(l_cursor_id);
376: xErrLoc := 750;
377: DBMS_SQL.close_cursor(l_cursor_id);

Line 375: l_result_count := DBMS_SQL.execute(l_cursor_id);

371: DBMS_SQL.bind_variable(l_cursor_id, ':startrow', p_start_row);
372: xErrLoc := 730;
373: DBMS_SQL.bind_variable(l_cursor_id, ':endrow', p_end_row);
374: xErrLoc := 740;
375: l_result_count := DBMS_SQL.execute(l_cursor_id);
376: xErrLoc := 750;
377: DBMS_SQL.close_cursor(l_cursor_id);
378:
379:

Line 377: DBMS_SQL.close_cursor(l_cursor_id);

373: DBMS_SQL.bind_variable(l_cursor_id, ':endrow', p_end_row);
374: xErrLoc := 740;
375: l_result_count := DBMS_SQL.execute(l_cursor_id);
376: xErrLoc := 750;
377: DBMS_SQL.close_cursor(l_cursor_id);
378:
379:
380: xErrLoc := 500;
381: --Bug#1581013: Removed code to check for the uniqueness of the pricelist name

Line 397: l_cursor_id := DBMS_SQL.open_cursor;

393: ' AND ca.language = ''' || p_language || ''') ' ||
394: 'WHERE it1.system_action = ''UPDATE'' AND it1.rt_item_id IS NOT NULL ' ||
395: 'AND line_number BETWEEN :startrow AND :endrow ';
396:
397: l_cursor_id := DBMS_SQL.open_cursor;
398: xErrLoc := 610;
399: DBMS_SQL.parse(l_cursor_id, l_sql_string, DBMS_SQL.NATIVE);
400: xErrLoc := 620;
401: DBMS_SQL.bind_variable(l_cursor_id, ':startrow', p_start_row);

Line 399: DBMS_SQL.parse(l_cursor_id, l_sql_string, DBMS_SQL.NATIVE);

395: 'AND line_number BETWEEN :startrow AND :endrow ';
396:
397: l_cursor_id := DBMS_SQL.open_cursor;
398: xErrLoc := 610;
399: DBMS_SQL.parse(l_cursor_id, l_sql_string, DBMS_SQL.NATIVE);
400: xErrLoc := 620;
401: DBMS_SQL.bind_variable(l_cursor_id, ':startrow', p_start_row);
402: xErrLoc := 630;
403: DBMS_SQL.bind_variable(l_cursor_id, ':endrow', p_end_row);

Line 401: DBMS_SQL.bind_variable(l_cursor_id, ':startrow', p_start_row);

397: l_cursor_id := DBMS_SQL.open_cursor;
398: xErrLoc := 610;
399: DBMS_SQL.parse(l_cursor_id, l_sql_string, DBMS_SQL.NATIVE);
400: xErrLoc := 620;
401: DBMS_SQL.bind_variable(l_cursor_id, ':startrow', p_start_row);
402: xErrLoc := 630;
403: DBMS_SQL.bind_variable(l_cursor_id, ':endrow', p_end_row);
404: xErrLoc := 640;
405: l_result_count := DBMS_SQL.execute(l_cursor_id);

Line 403: DBMS_SQL.bind_variable(l_cursor_id, ':endrow', p_end_row);

399: DBMS_SQL.parse(l_cursor_id, l_sql_string, DBMS_SQL.NATIVE);
400: xErrLoc := 620;
401: DBMS_SQL.bind_variable(l_cursor_id, ':startrow', p_start_row);
402: xErrLoc := 630;
403: DBMS_SQL.bind_variable(l_cursor_id, ':endrow', p_end_row);
404: xErrLoc := 640;
405: l_result_count := DBMS_SQL.execute(l_cursor_id);
406: xErrLoc := 650;
407: DBMS_SQL.close_cursor(l_cursor_id);

Line 405: l_result_count := DBMS_SQL.execute(l_cursor_id);

401: DBMS_SQL.bind_variable(l_cursor_id, ':startrow', p_start_row);
402: xErrLoc := 630;
403: DBMS_SQL.bind_variable(l_cursor_id, ':endrow', p_end_row);
404: xErrLoc := 640;
405: l_result_count := DBMS_SQL.execute(l_cursor_id);
406: xErrLoc := 650;
407: DBMS_SQL.close_cursor(l_cursor_id);
408:
409: commit;

Line 407: DBMS_SQL.close_cursor(l_cursor_id);

403: DBMS_SQL.bind_variable(l_cursor_id, ':endrow', p_end_row);
404: xErrLoc := 640;
405: l_result_count := DBMS_SQL.execute(l_cursor_id);
406: xErrLoc := 650;
407: DBMS_SQL.close_cursor(l_cursor_id);
408:
409: commit;
410:
411:

Line 447: l_cursor_id := DBMS_SQL.open_cursor;

443: -- Bug#2352152 : Constraint for currency check
444: 'AND NVL(it2.currency_code,''USD'') = NVL(it1.currency_code,''USD'') ' ||
445: 'AND it2.row_type = it1.row_type )';
446:
447: l_cursor_id := DBMS_SQL.open_cursor;
448: xErrLoc := 110;
449: DBMS_SQL.parse(l_cursor_id, l_sql_string, DBMS_SQL.NATIVE);
450: xErrLoc := 120;
451: l_result_count := DBMS_SQL.execute(l_cursor_id);

Line 449: DBMS_SQL.parse(l_cursor_id, l_sql_string, DBMS_SQL.NATIVE);

445: 'AND it2.row_type = it1.row_type )';
446:
447: l_cursor_id := DBMS_SQL.open_cursor;
448: xErrLoc := 110;
449: DBMS_SQL.parse(l_cursor_id, l_sql_string, DBMS_SQL.NATIVE);
450: xErrLoc := 120;
451: l_result_count := DBMS_SQL.execute(l_cursor_id);
452: xErrLoc := 130;
453: DBMS_SQL.close_cursor(l_cursor_id);

Line 451: l_result_count := DBMS_SQL.execute(l_cursor_id);

447: l_cursor_id := DBMS_SQL.open_cursor;
448: xErrLoc := 110;
449: DBMS_SQL.parse(l_cursor_id, l_sql_string, DBMS_SQL.NATIVE);
450: xErrLoc := 120;
451: l_result_count := DBMS_SQL.execute(l_cursor_id);
452: xErrLoc := 130;
453: DBMS_SQL.close_cursor(l_cursor_id);
454:
455: xErrLoc := 140;

Line 453: DBMS_SQL.close_cursor(l_cursor_id);

449: DBMS_SQL.parse(l_cursor_id, l_sql_string, DBMS_SQL.NATIVE);
450: xErrLoc := 120;
451: l_result_count := DBMS_SQL.execute(l_cursor_id);
452: xErrLoc := 130;
453: DBMS_SQL.close_cursor(l_cursor_id);
454:
455: xErrLoc := 140;
456:
457: /*

Line 477: l_cursor_id := DBMS_SQL.open_cursor;

473: 'AND it2.supplier_id = it1.supplier_id ' ||
474: 'AND it2.row_type = it1.row_type ) ' ||
475: 'AND it1.error_message IS NULL ';
476:
477: l_cursor_id := DBMS_SQL.open_cursor;
478: xErrLoc := 150;
479: DBMS_SQL.parse(l_cursor_id, l_sql_string, DBMS_SQL.NATIVE);
480: xErrLoc := 160;
481: l_result_count := DBMS_SQL.execute(l_cursor_id);

Line 479: DBMS_SQL.parse(l_cursor_id, l_sql_string, DBMS_SQL.NATIVE);

475: 'AND it1.error_message IS NULL ';
476:
477: l_cursor_id := DBMS_SQL.open_cursor;
478: xErrLoc := 150;
479: DBMS_SQL.parse(l_cursor_id, l_sql_string, DBMS_SQL.NATIVE);
480: xErrLoc := 160;
481: l_result_count := DBMS_SQL.execute(l_cursor_id);
482: xErrLoc := 170;
483: DBMS_SQL.close_cursor(l_cursor_id);

Line 481: l_result_count := DBMS_SQL.execute(l_cursor_id);

477: l_cursor_id := DBMS_SQL.open_cursor;
478: xErrLoc := 150;
479: DBMS_SQL.parse(l_cursor_id, l_sql_string, DBMS_SQL.NATIVE);
480: xErrLoc := 160;
481: l_result_count := DBMS_SQL.execute(l_cursor_id);
482: xErrLoc := 170;
483: DBMS_SQL.close_cursor(l_cursor_id);
484:
485: commit;

Line 483: DBMS_SQL.close_cursor(l_cursor_id);

479: DBMS_SQL.parse(l_cursor_id, l_sql_string, DBMS_SQL.NATIVE);
480: xErrLoc := 160;
481: l_result_count := DBMS_SQL.execute(l_cursor_id);
482: xErrLoc := 170;
483: DBMS_SQL.close_cursor(l_cursor_id);
484:
485: commit;
486:
487: EXCEPTION

Line 518: l_cursor_id := DBMS_SQL.open_cursor;

514: 'OR (it1.row_type = ''PRICE'' ' ||
515: 'AND it1.system_action IN (''ADD'',''DELETE'')))) ' ||
516: 'WHERE line_number between :startrow AND :endrow';
517:
518: l_cursor_id := DBMS_SQL.open_cursor;
519: xErrLoc := 110;
520: DBMS_SQL.parse(l_cursor_id, l_sql_string, DBMS_SQL.NATIVE);
521: xErrLoc := 120;
522: DBMS_SQL.bind_variable(l_cursor_id, ':startrow', p_start_row);

Line 520: DBMS_SQL.parse(l_cursor_id, l_sql_string, DBMS_SQL.NATIVE);

516: 'WHERE line_number between :startrow AND :endrow';
517:
518: l_cursor_id := DBMS_SQL.open_cursor;
519: xErrLoc := 110;
520: DBMS_SQL.parse(l_cursor_id, l_sql_string, DBMS_SQL.NATIVE);
521: xErrLoc := 120;
522: DBMS_SQL.bind_variable(l_cursor_id, ':startrow', p_start_row);
523: xErrLoc := 130;
524: DBMS_SQL.bind_variable(l_cursor_id, ':endrow', p_end_row);

Line 522: DBMS_SQL.bind_variable(l_cursor_id, ':startrow', p_start_row);

518: l_cursor_id := DBMS_SQL.open_cursor;
519: xErrLoc := 110;
520: DBMS_SQL.parse(l_cursor_id, l_sql_string, DBMS_SQL.NATIVE);
521: xErrLoc := 120;
522: DBMS_SQL.bind_variable(l_cursor_id, ':startrow', p_start_row);
523: xErrLoc := 130;
524: DBMS_SQL.bind_variable(l_cursor_id, ':endrow', p_end_row);
525: xErrLoc := 140;
526: l_result_count := DBMS_SQL.execute(l_cursor_id);

Line 524: DBMS_SQL.bind_variable(l_cursor_id, ':endrow', p_end_row);

520: DBMS_SQL.parse(l_cursor_id, l_sql_string, DBMS_SQL.NATIVE);
521: xErrLoc := 120;
522: DBMS_SQL.bind_variable(l_cursor_id, ':startrow', p_start_row);
523: xErrLoc := 130;
524: DBMS_SQL.bind_variable(l_cursor_id, ':endrow', p_end_row);
525: xErrLoc := 140;
526: l_result_count := DBMS_SQL.execute(l_cursor_id);
527: xErrLoc := 150;
528: DBMS_SQL.close_cursor(l_cursor_id);

Line 526: l_result_count := DBMS_SQL.execute(l_cursor_id);

522: DBMS_SQL.bind_variable(l_cursor_id, ':startrow', p_start_row);
523: xErrLoc := 130;
524: DBMS_SQL.bind_variable(l_cursor_id, ':endrow', p_end_row);
525: xErrLoc := 140;
526: l_result_count := DBMS_SQL.execute(l_cursor_id);
527: xErrLoc := 150;
528: DBMS_SQL.close_cursor(l_cursor_id);
529:
530: commit;

Line 528: DBMS_SQL.close_cursor(l_cursor_id);

524: DBMS_SQL.bind_variable(l_cursor_id, ':endrow', p_end_row);
525: xErrLoc := 140;
526: l_result_count := DBMS_SQL.execute(l_cursor_id);
527: xErrLoc := 150;
528: DBMS_SQL.close_cursor(l_cursor_id);
529:
530: commit;
531:
532: EXCEPTION

Line 584: l_cursor_id := DBMS_SQL.open_cursor;

580: l_sql_string :=
581: 'SELECT count(*) - count(distinct supplier_name || supplier_part_num) ' ||
582: 'FROM ' || p_table_name;
583:
584: l_cursor_id := DBMS_SQL.open_cursor;
585: xErrLoc := 110;
586: DBMS_SQL.parse(l_cursor_id, l_sql_string, DBMS_SQL.NATIVE);
587: xErrLoc := 120;
588: DBMS_SQL.define_column(l_cursor_id, 1, l_count1);

Line 586: DBMS_SQL.parse(l_cursor_id, l_sql_string, DBMS_SQL.NATIVE);

582: 'FROM ' || p_table_name;
583:
584: l_cursor_id := DBMS_SQL.open_cursor;
585: xErrLoc := 110;
586: DBMS_SQL.parse(l_cursor_id, l_sql_string, DBMS_SQL.NATIVE);
587: xErrLoc := 120;
588: DBMS_SQL.define_column(l_cursor_id, 1, l_count1);
589: xErrLoc := 130;
590: l_result_count := DBMS_SQL.execute(l_cursor_id);

Line 588: DBMS_SQL.define_column(l_cursor_id, 1, l_count1);

584: l_cursor_id := DBMS_SQL.open_cursor;
585: xErrLoc := 110;
586: DBMS_SQL.parse(l_cursor_id, l_sql_string, DBMS_SQL.NATIVE);
587: xErrLoc := 120;
588: DBMS_SQL.define_column(l_cursor_id, 1, l_count1);
589: xErrLoc := 130;
590: l_result_count := DBMS_SQL.execute(l_cursor_id);
591: xErrLoc := 140;
592:

Line 590: l_result_count := DBMS_SQL.execute(l_cursor_id);

586: DBMS_SQL.parse(l_cursor_id, l_sql_string, DBMS_SQL.NATIVE);
587: xErrLoc := 120;
588: DBMS_SQL.define_column(l_cursor_id, 1, l_count1);
589: xErrLoc := 130;
590: l_result_count := DBMS_SQL.execute(l_cursor_id);
591: xErrLoc := 140;
592:
593: LOOP
594: IF DBMS_SQL.fetch_rows(l_cursor_id) = 0 THEN

Line 594: IF DBMS_SQL.fetch_rows(l_cursor_id) = 0 THEN

590: l_result_count := DBMS_SQL.execute(l_cursor_id);
591: xErrLoc := 140;
592:
593: LOOP
594: IF DBMS_SQL.fetch_rows(l_cursor_id) = 0 THEN
595: EXIT;
596: END IF;
597:
598: DBMS_SQL.column_value(l_cursor_id, 1, l_count1);

Line 598: DBMS_SQL.column_value(l_cursor_id, 1, l_count1);

594: IF DBMS_SQL.fetch_rows(l_cursor_id) = 0 THEN
595: EXIT;
596: END IF;
597:
598: DBMS_SQL.column_value(l_cursor_id, 1, l_count1);
599: END LOOP;
600:
601: xErrLoc := 150;
602: DBMS_SQL.close_cursor(l_cursor_id);

Line 602: DBMS_SQL.close_cursor(l_cursor_id);

598: DBMS_SQL.column_value(l_cursor_id, 1, l_count1);
599: END LOOP;
600:
601: xErrLoc := 150;
602: DBMS_SQL.close_cursor(l_cursor_id);
603: */
604:
605: --BUG#2228935
606: l_bus_group_id := p_job_supplier_id;

Line 616: l_cursor_id := DBMS_SQL.open_cursor;

612: 'AND buy.name = ipus.operating_unit ' ||
613: 'AND ipus.job_number = it.job_number ' ||
614: 'AND ROWNUM < 2';
615:
616: l_cursor_id := DBMS_SQL.open_cursor;
617: xErrLoc := 110;
618: DBMS_SQL.parse(l_cursor_id, l_sql_string, DBMS_SQL.NATIVE);
619: xErrLoc := 120;
620: DBMS_SQL.bind_variable(l_cursor_id, ':bus_group_id', l_bus_group_id);

Line 618: DBMS_SQL.parse(l_cursor_id, l_sql_string, DBMS_SQL.NATIVE);

614: 'AND ROWNUM < 2';
615:
616: l_cursor_id := DBMS_SQL.open_cursor;
617: xErrLoc := 110;
618: DBMS_SQL.parse(l_cursor_id, l_sql_string, DBMS_SQL.NATIVE);
619: xErrLoc := 120;
620: DBMS_SQL.bind_variable(l_cursor_id, ':bus_group_id', l_bus_group_id);
621: xErrLoc := 130;
622: DBMS_SQL.define_column(l_cursor_id, 1, g_operating_unit_id);

Line 620: DBMS_SQL.bind_variable(l_cursor_id, ':bus_group_id', l_bus_group_id);

616: l_cursor_id := DBMS_SQL.open_cursor;
617: xErrLoc := 110;
618: DBMS_SQL.parse(l_cursor_id, l_sql_string, DBMS_SQL.NATIVE);
619: xErrLoc := 120;
620: DBMS_SQL.bind_variable(l_cursor_id, ':bus_group_id', l_bus_group_id);
621: xErrLoc := 130;
622: DBMS_SQL.define_column(l_cursor_id, 1, g_operating_unit_id);
623: xErrLoc := 130;
624: l_result_count := DBMS_SQL.execute(l_cursor_id);

Line 622: DBMS_SQL.define_column(l_cursor_id, 1, g_operating_unit_id);

618: DBMS_SQL.parse(l_cursor_id, l_sql_string, DBMS_SQL.NATIVE);
619: xErrLoc := 120;
620: DBMS_SQL.bind_variable(l_cursor_id, ':bus_group_id', l_bus_group_id);
621: xErrLoc := 130;
622: DBMS_SQL.define_column(l_cursor_id, 1, g_operating_unit_id);
623: xErrLoc := 130;
624: l_result_count := DBMS_SQL.execute(l_cursor_id);
625: xErrLoc := 140;
626:

Line 624: l_result_count := DBMS_SQL.execute(l_cursor_id);

620: DBMS_SQL.bind_variable(l_cursor_id, ':bus_group_id', l_bus_group_id);
621: xErrLoc := 130;
622: DBMS_SQL.define_column(l_cursor_id, 1, g_operating_unit_id);
623: xErrLoc := 130;
624: l_result_count := DBMS_SQL.execute(l_cursor_id);
625: xErrLoc := 140;
626:
627: IF DBMS_SQL.fetch_rows(l_cursor_id) <> 0 THEN
628: DBMS_SQL.column_value(l_cursor_id, 1, g_operating_unit_id);

Line 627: IF DBMS_SQL.fetch_rows(l_cursor_id) <> 0 THEN

623: xErrLoc := 130;
624: l_result_count := DBMS_SQL.execute(l_cursor_id);
625: xErrLoc := 140;
626:
627: IF DBMS_SQL.fetch_rows(l_cursor_id) <> 0 THEN
628: DBMS_SQL.column_value(l_cursor_id, 1, g_operating_unit_id);
629: ELSE
630: g_operating_unit_id := null;
631: END IF;

Line 628: DBMS_SQL.column_value(l_cursor_id, 1, g_operating_unit_id);

624: l_result_count := DBMS_SQL.execute(l_cursor_id);
625: xErrLoc := 140;
626:
627: IF DBMS_SQL.fetch_rows(l_cursor_id) <> 0 THEN
628: DBMS_SQL.column_value(l_cursor_id, 1, g_operating_unit_id);
629: ELSE
630: g_operating_unit_id := null;
631: END IF;
632:

Line 634: DBMS_SQL.close_cursor(l_cursor_id);

630: g_operating_unit_id := null;
631: END IF;
632:
633: xErrLoc := 150;
634: DBMS_SQL.close_cursor(l_cursor_id);
635:
636: xErrLoc := 160;
637:
638: WHILE l_end_row < p_row_count LOOP