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.PON_UNSOL_CREATE_PO_PKG dependencies on DBMS_SQL

Line 263: l_cursorName := DBMS_SQL.Open_Cursor;

259: from pon_auction_headers_all
260: where auction_header_id = p_auction_header_id;
261:
262:
263: l_cursorName := DBMS_SQL.Open_Cursor;
264: l_cur_interface_line_id := -9999;
265:
266: OPEN c_descriptors;
267: LOOP

Line 307: DBMS_SQL.Parse(l_cursorName, l_po_attr_values_stmt, DBMS_SQL.NATIVE);

303: ')';
304:
305: --log_message(l_po_attr_values_stmt);
306:
307: DBMS_SQL.Parse(l_cursorName, l_po_attr_values_stmt, DBMS_SQL.NATIVE);
308:
309: DBMS_SQL.Bind_Variable(l_cursorName, ':1', p_interface_header_id);
310: DBMS_SQL.Bind_Variable(l_cursorName, ':2', l_cur_interface_line_id);
311: DBMS_SQL.Bind_Variable(l_cursorName, ':3', l_cur_attr_values_id);

Line 309: DBMS_SQL.Bind_Variable(l_cursorName, ':1', p_interface_header_id);

305: --log_message(l_po_attr_values_stmt);
306:
307: DBMS_SQL.Parse(l_cursorName, l_po_attr_values_stmt, DBMS_SQL.NATIVE);
308:
309: DBMS_SQL.Bind_Variable(l_cursorName, ':1', p_interface_header_id);
310: DBMS_SQL.Bind_Variable(l_cursorName, ':2', l_cur_interface_line_id);
311: DBMS_SQL.Bind_Variable(l_cursorName, ':3', l_cur_attr_values_id);
312: DBMS_SQL.Bind_Variable(l_cursorName, ':4', l_cur_ip_category_id);
313: DBMS_SQL.Bind_Variable(l_cursorName, ':5', l_cur_item_id);

Line 310: DBMS_SQL.Bind_Variable(l_cursorName, ':2', l_cur_interface_line_id);

306:
307: DBMS_SQL.Parse(l_cursorName, l_po_attr_values_stmt, DBMS_SQL.NATIVE);
308:
309: DBMS_SQL.Bind_Variable(l_cursorName, ':1', p_interface_header_id);
310: DBMS_SQL.Bind_Variable(l_cursorName, ':2', l_cur_interface_line_id);
311: DBMS_SQL.Bind_Variable(l_cursorName, ':3', l_cur_attr_values_id);
312: DBMS_SQL.Bind_Variable(l_cursorName, ':4', l_cur_ip_category_id);
313: DBMS_SQL.Bind_Variable(l_cursorName, ':5', l_cur_item_id);
314: DBMS_SQL.Bind_Variable(l_cursorName, ':6', l_cur_org_id);

Line 311: DBMS_SQL.Bind_Variable(l_cursorName, ':3', l_cur_attr_values_id);

307: DBMS_SQL.Parse(l_cursorName, l_po_attr_values_stmt, DBMS_SQL.NATIVE);
308:
309: DBMS_SQL.Bind_Variable(l_cursorName, ':1', p_interface_header_id);
310: DBMS_SQL.Bind_Variable(l_cursorName, ':2', l_cur_interface_line_id);
311: DBMS_SQL.Bind_Variable(l_cursorName, ':3', l_cur_attr_values_id);
312: DBMS_SQL.Bind_Variable(l_cursorName, ':4', l_cur_ip_category_id);
313: DBMS_SQL.Bind_Variable(l_cursorName, ':5', l_cur_item_id);
314: DBMS_SQL.Bind_Variable(l_cursorName, ':6', l_cur_org_id);
315: DBMS_SQL.Bind_Variable(l_cursorName, ':7', p_login_id);

Line 312: DBMS_SQL.Bind_Variable(l_cursorName, ':4', l_cur_ip_category_id);

308:
309: DBMS_SQL.Bind_Variable(l_cursorName, ':1', p_interface_header_id);
310: DBMS_SQL.Bind_Variable(l_cursorName, ':2', l_cur_interface_line_id);
311: DBMS_SQL.Bind_Variable(l_cursorName, ':3', l_cur_attr_values_id);
312: DBMS_SQL.Bind_Variable(l_cursorName, ':4', l_cur_ip_category_id);
313: DBMS_SQL.Bind_Variable(l_cursorName, ':5', l_cur_item_id);
314: DBMS_SQL.Bind_Variable(l_cursorName, ':6', l_cur_org_id);
315: DBMS_SQL.Bind_Variable(l_cursorName, ':7', p_login_id);
316: DBMS_SQL.Bind_Variable(l_cursorName, ':8', p_user_id);

Line 313: DBMS_SQL.Bind_Variable(l_cursorName, ':5', l_cur_item_id);

309: DBMS_SQL.Bind_Variable(l_cursorName, ':1', p_interface_header_id);
310: DBMS_SQL.Bind_Variable(l_cursorName, ':2', l_cur_interface_line_id);
311: DBMS_SQL.Bind_Variable(l_cursorName, ':3', l_cur_attr_values_id);
312: DBMS_SQL.Bind_Variable(l_cursorName, ':4', l_cur_ip_category_id);
313: DBMS_SQL.Bind_Variable(l_cursorName, ':5', l_cur_item_id);
314: DBMS_SQL.Bind_Variable(l_cursorName, ':6', l_cur_org_id);
315: DBMS_SQL.Bind_Variable(l_cursorName, ':7', p_login_id);
316: DBMS_SQL.Bind_Variable(l_cursorName, ':8', p_user_id);
317: DBMS_SQL.Bind_Variable(l_cursorName, ':9', sysdate);

Line 314: DBMS_SQL.Bind_Variable(l_cursorName, ':6', l_cur_org_id);

310: DBMS_SQL.Bind_Variable(l_cursorName, ':2', l_cur_interface_line_id);
311: DBMS_SQL.Bind_Variable(l_cursorName, ':3', l_cur_attr_values_id);
312: DBMS_SQL.Bind_Variable(l_cursorName, ':4', l_cur_ip_category_id);
313: DBMS_SQL.Bind_Variable(l_cursorName, ':5', l_cur_item_id);
314: DBMS_SQL.Bind_Variable(l_cursorName, ':6', l_cur_org_id);
315: DBMS_SQL.Bind_Variable(l_cursorName, ':7', p_login_id);
316: DBMS_SQL.Bind_Variable(l_cursorName, ':8', p_user_id);
317: DBMS_SQL.Bind_Variable(l_cursorName, ':9', sysdate);
318: DBMS_SQL.Bind_Variable(l_cursorName, ':10', p_user_id);

Line 315: DBMS_SQL.Bind_Variable(l_cursorName, ':7', p_login_id);

311: DBMS_SQL.Bind_Variable(l_cursorName, ':3', l_cur_attr_values_id);
312: DBMS_SQL.Bind_Variable(l_cursorName, ':4', l_cur_ip_category_id);
313: DBMS_SQL.Bind_Variable(l_cursorName, ':5', l_cur_item_id);
314: DBMS_SQL.Bind_Variable(l_cursorName, ':6', l_cur_org_id);
315: DBMS_SQL.Bind_Variable(l_cursorName, ':7', p_login_id);
316: DBMS_SQL.Bind_Variable(l_cursorName, ':8', p_user_id);
317: DBMS_SQL.Bind_Variable(l_cursorName, ':9', sysdate);
318: DBMS_SQL.Bind_Variable(l_cursorName, ':10', p_user_id);
319: DBMS_SQL.Bind_Variable(l_cursorName, ':11', sysdate);

Line 316: DBMS_SQL.Bind_Variable(l_cursorName, ':8', p_user_id);

312: DBMS_SQL.Bind_Variable(l_cursorName, ':4', l_cur_ip_category_id);
313: DBMS_SQL.Bind_Variable(l_cursorName, ':5', l_cur_item_id);
314: DBMS_SQL.Bind_Variable(l_cursorName, ':6', l_cur_org_id);
315: DBMS_SQL.Bind_Variable(l_cursorName, ':7', p_login_id);
316: DBMS_SQL.Bind_Variable(l_cursorName, ':8', p_user_id);
317: DBMS_SQL.Bind_Variable(l_cursorName, ':9', sysdate);
318: DBMS_SQL.Bind_Variable(l_cursorName, ':10', p_user_id);
319: DBMS_SQL.Bind_Variable(l_cursorName, ':11', sysdate);
320:

Line 317: DBMS_SQL.Bind_Variable(l_cursorName, ':9', sysdate);

313: DBMS_SQL.Bind_Variable(l_cursorName, ':5', l_cur_item_id);
314: DBMS_SQL.Bind_Variable(l_cursorName, ':6', l_cur_org_id);
315: DBMS_SQL.Bind_Variable(l_cursorName, ':7', p_login_id);
316: DBMS_SQL.Bind_Variable(l_cursorName, ':8', p_user_id);
317: DBMS_SQL.Bind_Variable(l_cursorName, ':9', sysdate);
318: DBMS_SQL.Bind_Variable(l_cursorName, ':10', p_user_id);
319: DBMS_SQL.Bind_Variable(l_cursorName, ':11', sysdate);
320:
321: FOR i in 1 .. l_numValuesCount

Line 318: DBMS_SQL.Bind_Variable(l_cursorName, ':10', p_user_id);

314: DBMS_SQL.Bind_Variable(l_cursorName, ':6', l_cur_org_id);
315: DBMS_SQL.Bind_Variable(l_cursorName, ':7', p_login_id);
316: DBMS_SQL.Bind_Variable(l_cursorName, ':8', p_user_id);
317: DBMS_SQL.Bind_Variable(l_cursorName, ':9', sysdate);
318: DBMS_SQL.Bind_Variable(l_cursorName, ':10', p_user_id);
319: DBMS_SQL.Bind_Variable(l_cursorName, ':11', sysdate);
320:
321: FOR i in 1 .. l_numValuesCount
322: LOOP

Line 319: DBMS_SQL.Bind_Variable(l_cursorName, ':11', sysdate);

315: DBMS_SQL.Bind_Variable(l_cursorName, ':7', p_login_id);
316: DBMS_SQL.Bind_Variable(l_cursorName, ':8', p_user_id);
317: DBMS_SQL.Bind_Variable(l_cursorName, ':9', sysdate);
318: DBMS_SQL.Bind_Variable(l_cursorName, ':10', p_user_id);
319: DBMS_SQL.Bind_Variable(l_cursorName, ':11', sysdate);
320:
321: FOR i in 1 .. l_numValuesCount
322: LOOP
323: DBMS_SQL.Bind_Variable(l_cursorName, ':' || (i+l_num_txt_offset), l_numValues(i));

Line 323: DBMS_SQL.Bind_Variable(l_cursorName, ':' || (i+l_num_txt_offset), l_numValues(i));

319: DBMS_SQL.Bind_Variable(l_cursorName, ':11', sysdate);
320:
321: FOR i in 1 .. l_numValuesCount
322: LOOP
323: DBMS_SQL.Bind_Variable(l_cursorName, ':' || (i+l_num_txt_offset), l_numValues(i));
324: END LOOP;
325:
326: FOR i in 1 ..l_txtValuesCount
327: LOOP

Line 328: DBMS_SQL.Bind_Variable(l_cursorName, ':' || (i+l_num_txt_offset+l_numValuesCount), l_txtValues(i));

324: END LOOP;
325:
326: FOR i in 1 ..l_txtValuesCount
327: LOOP
328: DBMS_SQL.Bind_Variable(l_cursorName, ':' || (i+l_num_txt_offset+l_numValuesCount), l_txtValues(i));
329: END LOOP;
330:
331: l_cursorResult := DBMS_SQL.Execute(l_cursorName);
332:

Line 331: l_cursorResult := DBMS_SQL.Execute(l_cursorName);

327: LOOP
328: DBMS_SQL.Bind_Variable(l_cursorName, ':' || (i+l_num_txt_offset+l_numValuesCount), l_txtValues(i));
329: END LOOP;
330:
331: l_cursorResult := DBMS_SQL.Execute(l_cursorName);
332:
333: END IF;
334:
335: -- process translateable text descriptors

Line 373: DBMS_SQL.Parse(l_cursorName, l_po_attr_values_tlp_stmt, DBMS_SQL.NATIVE);

369: ')';
370:
371: --log_message(l_po_attr_values_tlp_stmt);
372:
373: DBMS_SQL.Parse(l_cursorName, l_po_attr_values_tlp_stmt, DBMS_SQL.NATIVE);
374:
375: DBMS_SQL.Bind_Variable(l_cursorName, ':1', p_interface_header_id);
376: DBMS_SQL.Bind_Variable(l_cursorName, ':2', l_cur_interface_line_id);
377: DBMS_SQL.Bind_Variable(l_cursorName, ':3', l_cur_attr_values_tlp_id);

Line 375: DBMS_SQL.Bind_Variable(l_cursorName, ':1', p_interface_header_id);

371: --log_message(l_po_attr_values_tlp_stmt);
372:
373: DBMS_SQL.Parse(l_cursorName, l_po_attr_values_tlp_stmt, DBMS_SQL.NATIVE);
374:
375: DBMS_SQL.Bind_Variable(l_cursorName, ':1', p_interface_header_id);
376: DBMS_SQL.Bind_Variable(l_cursorName, ':2', l_cur_interface_line_id);
377: DBMS_SQL.Bind_Variable(l_cursorName, ':3', l_cur_attr_values_tlp_id);
378: DBMS_SQL.Bind_Variable(l_cursorName, ':4', l_cur_ip_category_id);
379: DBMS_SQL.Bind_Variable(l_cursorName, ':5', l_cur_item_id);

Line 376: DBMS_SQL.Bind_Variable(l_cursorName, ':2', l_cur_interface_line_id);

372:
373: DBMS_SQL.Parse(l_cursorName, l_po_attr_values_tlp_stmt, DBMS_SQL.NATIVE);
374:
375: DBMS_SQL.Bind_Variable(l_cursorName, ':1', p_interface_header_id);
376: DBMS_SQL.Bind_Variable(l_cursorName, ':2', l_cur_interface_line_id);
377: DBMS_SQL.Bind_Variable(l_cursorName, ':3', l_cur_attr_values_tlp_id);
378: DBMS_SQL.Bind_Variable(l_cursorName, ':4', l_cur_ip_category_id);
379: DBMS_SQL.Bind_Variable(l_cursorName, ':5', l_cur_item_id);
380: DBMS_SQL.Bind_Variable(l_cursorName, ':6', l_cur_org_id);

Line 377: DBMS_SQL.Bind_Variable(l_cursorName, ':3', l_cur_attr_values_tlp_id);

373: DBMS_SQL.Parse(l_cursorName, l_po_attr_values_tlp_stmt, DBMS_SQL.NATIVE);
374:
375: DBMS_SQL.Bind_Variable(l_cursorName, ':1', p_interface_header_id);
376: DBMS_SQL.Bind_Variable(l_cursorName, ':2', l_cur_interface_line_id);
377: DBMS_SQL.Bind_Variable(l_cursorName, ':3', l_cur_attr_values_tlp_id);
378: DBMS_SQL.Bind_Variable(l_cursorName, ':4', l_cur_ip_category_id);
379: DBMS_SQL.Bind_Variable(l_cursorName, ':5', l_cur_item_id);
380: DBMS_SQL.Bind_Variable(l_cursorName, ':6', l_cur_org_id);
381: DBMS_SQL.Bind_Variable(l_cursorName, ':7', l_language_code);

Line 378: DBMS_SQL.Bind_Variable(l_cursorName, ':4', l_cur_ip_category_id);

374:
375: DBMS_SQL.Bind_Variable(l_cursorName, ':1', p_interface_header_id);
376: DBMS_SQL.Bind_Variable(l_cursorName, ':2', l_cur_interface_line_id);
377: DBMS_SQL.Bind_Variable(l_cursorName, ':3', l_cur_attr_values_tlp_id);
378: DBMS_SQL.Bind_Variable(l_cursorName, ':4', l_cur_ip_category_id);
379: DBMS_SQL.Bind_Variable(l_cursorName, ':5', l_cur_item_id);
380: DBMS_SQL.Bind_Variable(l_cursorName, ':6', l_cur_org_id);
381: DBMS_SQL.Bind_Variable(l_cursorName, ':7', l_language_code);
382: DBMS_SQL.Bind_Variable(l_cursorName, ':8', l_cur_item_description);

Line 379: DBMS_SQL.Bind_Variable(l_cursorName, ':5', l_cur_item_id);

375: DBMS_SQL.Bind_Variable(l_cursorName, ':1', p_interface_header_id);
376: DBMS_SQL.Bind_Variable(l_cursorName, ':2', l_cur_interface_line_id);
377: DBMS_SQL.Bind_Variable(l_cursorName, ':3', l_cur_attr_values_tlp_id);
378: DBMS_SQL.Bind_Variable(l_cursorName, ':4', l_cur_ip_category_id);
379: DBMS_SQL.Bind_Variable(l_cursorName, ':5', l_cur_item_id);
380: DBMS_SQL.Bind_Variable(l_cursorName, ':6', l_cur_org_id);
381: DBMS_SQL.Bind_Variable(l_cursorName, ':7', l_language_code);
382: DBMS_SQL.Bind_Variable(l_cursorName, ':8', l_cur_item_description);
383: DBMS_SQL.Bind_Variable(l_cursorName, ':9', p_login_id);

Line 380: DBMS_SQL.Bind_Variable(l_cursorName, ':6', l_cur_org_id);

376: DBMS_SQL.Bind_Variable(l_cursorName, ':2', l_cur_interface_line_id);
377: DBMS_SQL.Bind_Variable(l_cursorName, ':3', l_cur_attr_values_tlp_id);
378: DBMS_SQL.Bind_Variable(l_cursorName, ':4', l_cur_ip_category_id);
379: DBMS_SQL.Bind_Variable(l_cursorName, ':5', l_cur_item_id);
380: DBMS_SQL.Bind_Variable(l_cursorName, ':6', l_cur_org_id);
381: DBMS_SQL.Bind_Variable(l_cursorName, ':7', l_language_code);
382: DBMS_SQL.Bind_Variable(l_cursorName, ':8', l_cur_item_description);
383: DBMS_SQL.Bind_Variable(l_cursorName, ':9', p_login_id);
384: DBMS_SQL.Bind_Variable(l_cursorName, ':10', p_user_id);

Line 381: DBMS_SQL.Bind_Variable(l_cursorName, ':7', l_language_code);

377: DBMS_SQL.Bind_Variable(l_cursorName, ':3', l_cur_attr_values_tlp_id);
378: DBMS_SQL.Bind_Variable(l_cursorName, ':4', l_cur_ip_category_id);
379: DBMS_SQL.Bind_Variable(l_cursorName, ':5', l_cur_item_id);
380: DBMS_SQL.Bind_Variable(l_cursorName, ':6', l_cur_org_id);
381: DBMS_SQL.Bind_Variable(l_cursorName, ':7', l_language_code);
382: DBMS_SQL.Bind_Variable(l_cursorName, ':8', l_cur_item_description);
383: DBMS_SQL.Bind_Variable(l_cursorName, ':9', p_login_id);
384: DBMS_SQL.Bind_Variable(l_cursorName, ':10', p_user_id);
385: DBMS_SQL.Bind_Variable(l_cursorName, ':11', sysdate);

Line 382: DBMS_SQL.Bind_Variable(l_cursorName, ':8', l_cur_item_description);

378: DBMS_SQL.Bind_Variable(l_cursorName, ':4', l_cur_ip_category_id);
379: DBMS_SQL.Bind_Variable(l_cursorName, ':5', l_cur_item_id);
380: DBMS_SQL.Bind_Variable(l_cursorName, ':6', l_cur_org_id);
381: DBMS_SQL.Bind_Variable(l_cursorName, ':7', l_language_code);
382: DBMS_SQL.Bind_Variable(l_cursorName, ':8', l_cur_item_description);
383: DBMS_SQL.Bind_Variable(l_cursorName, ':9', p_login_id);
384: DBMS_SQL.Bind_Variable(l_cursorName, ':10', p_user_id);
385: DBMS_SQL.Bind_Variable(l_cursorName, ':11', sysdate);
386: DBMS_SQL.Bind_Variable(l_cursorName, ':12', p_user_id);

Line 383: DBMS_SQL.Bind_Variable(l_cursorName, ':9', p_login_id);

379: DBMS_SQL.Bind_Variable(l_cursorName, ':5', l_cur_item_id);
380: DBMS_SQL.Bind_Variable(l_cursorName, ':6', l_cur_org_id);
381: DBMS_SQL.Bind_Variable(l_cursorName, ':7', l_language_code);
382: DBMS_SQL.Bind_Variable(l_cursorName, ':8', l_cur_item_description);
383: DBMS_SQL.Bind_Variable(l_cursorName, ':9', p_login_id);
384: DBMS_SQL.Bind_Variable(l_cursorName, ':10', p_user_id);
385: DBMS_SQL.Bind_Variable(l_cursorName, ':11', sysdate);
386: DBMS_SQL.Bind_Variable(l_cursorName, ':12', p_user_id);
387: DBMS_SQL.Bind_Variable(l_cursorName, ':13', sysdate);

Line 384: DBMS_SQL.Bind_Variable(l_cursorName, ':10', p_user_id);

380: DBMS_SQL.Bind_Variable(l_cursorName, ':6', l_cur_org_id);
381: DBMS_SQL.Bind_Variable(l_cursorName, ':7', l_language_code);
382: DBMS_SQL.Bind_Variable(l_cursorName, ':8', l_cur_item_description);
383: DBMS_SQL.Bind_Variable(l_cursorName, ':9', p_login_id);
384: DBMS_SQL.Bind_Variable(l_cursorName, ':10', p_user_id);
385: DBMS_SQL.Bind_Variable(l_cursorName, ':11', sysdate);
386: DBMS_SQL.Bind_Variable(l_cursorName, ':12', p_user_id);
387: DBMS_SQL.Bind_Variable(l_cursorName, ':13', sysdate);
388:

Line 385: DBMS_SQL.Bind_Variable(l_cursorName, ':11', sysdate);

381: DBMS_SQL.Bind_Variable(l_cursorName, ':7', l_language_code);
382: DBMS_SQL.Bind_Variable(l_cursorName, ':8', l_cur_item_description);
383: DBMS_SQL.Bind_Variable(l_cursorName, ':9', p_login_id);
384: DBMS_SQL.Bind_Variable(l_cursorName, ':10', p_user_id);
385: DBMS_SQL.Bind_Variable(l_cursorName, ':11', sysdate);
386: DBMS_SQL.Bind_Variable(l_cursorName, ':12', p_user_id);
387: DBMS_SQL.Bind_Variable(l_cursorName, ':13', sysdate);
388:
389: FOR i in 1 .. l_transTxtValuesCount

Line 386: DBMS_SQL.Bind_Variable(l_cursorName, ':12', p_user_id);

382: DBMS_SQL.Bind_Variable(l_cursorName, ':8', l_cur_item_description);
383: DBMS_SQL.Bind_Variable(l_cursorName, ':9', p_login_id);
384: DBMS_SQL.Bind_Variable(l_cursorName, ':10', p_user_id);
385: DBMS_SQL.Bind_Variable(l_cursorName, ':11', sysdate);
386: DBMS_SQL.Bind_Variable(l_cursorName, ':12', p_user_id);
387: DBMS_SQL.Bind_Variable(l_cursorName, ':13', sysdate);
388:
389: FOR i in 1 .. l_transTxtValuesCount
390: LOOP

Line 387: DBMS_SQL.Bind_Variable(l_cursorName, ':13', sysdate);

383: DBMS_SQL.Bind_Variable(l_cursorName, ':9', p_login_id);
384: DBMS_SQL.Bind_Variable(l_cursorName, ':10', p_user_id);
385: DBMS_SQL.Bind_Variable(l_cursorName, ':11', sysdate);
386: DBMS_SQL.Bind_Variable(l_cursorName, ':12', p_user_id);
387: DBMS_SQL.Bind_Variable(l_cursorName, ':13', sysdate);
388:
389: FOR i in 1 .. l_transTxtValuesCount
390: LOOP
391: DBMS_SQL.Bind_Variable(l_cursorName, ':' || (i+l_trans_txt_offset), l_transTxtValues(i));

Line 391: DBMS_SQL.Bind_Variable(l_cursorName, ':' || (i+l_trans_txt_offset), l_transTxtValues(i));

387: DBMS_SQL.Bind_Variable(l_cursorName, ':13', sysdate);
388:
389: FOR i in 1 .. l_transTxtValuesCount
390: LOOP
391: DBMS_SQL.Bind_Variable(l_cursorName, ':' || (i+l_trans_txt_offset), l_transTxtValues(i));
392: END LOOP;
393:
394: l_cursorResult := DBMS_SQL.Execute(l_cursorName);
395:

Line 394: l_cursorResult := DBMS_SQL.Execute(l_cursorName);

390: LOOP
391: DBMS_SQL.Bind_Variable(l_cursorName, ':' || (i+l_trans_txt_offset), l_transTxtValues(i));
392: END LOOP;
393:
394: l_cursorResult := DBMS_SQL.Execute(l_cursorName);
395:
396: END IF;
397:
398: EXIT WHEN c_descriptors%NOTFOUND;

Line 461: IF DBMS_SQL.IS_OPEN(l_cursorName) THEN

457:
458: END LOOP;
459: CLOSE c_descriptors;
460:
461: IF DBMS_SQL.IS_OPEN(l_cursorName) THEN
462: DBMS_SQL.CLOSE_CURSOR(l_cursorName);
463: END IF;
464:
465:

Line 462: DBMS_SQL.CLOSE_CURSOR(l_cursorName);

458: END LOOP;
459: CLOSE c_descriptors;
460:
461: IF DBMS_SQL.IS_OPEN(l_cursorName) THEN
462: DBMS_SQL.CLOSE_CURSOR(l_cursorName);
463: END IF;
464:
465:
466: END INSERT_UNSOL_IP_DESCRIPTORS;