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

Line 220: cur_ins := DBMS_SQL.OPEN_CURSOR;

216:
217: END IF;
218:
219: /* Now open, parse, execute the sql */
220: cur_ins := DBMS_SQL.OPEN_CURSOR;
221: DBMS_SQL.PARSE(cur_ins, l_ins_sql, DBMS_SQL.NATIVE);
222:
223: /* binds */
224: DBMS_SQL.BIND_VARIABLE(cur_ins, ':worker_number1', p_worker_number);

Line 221: DBMS_SQL.PARSE(cur_ins, l_ins_sql, DBMS_SQL.NATIVE);

217: END IF;
218:
219: /* Now open, parse, execute the sql */
220: cur_ins := DBMS_SQL.OPEN_CURSOR;
221: DBMS_SQL.PARSE(cur_ins, l_ins_sql, DBMS_SQL.NATIVE);
222:
223: /* binds */
224: DBMS_SQL.BIND_VARIABLE(cur_ins, ':worker_number1', p_worker_number);
225: DBMS_SQL.BIND_VARIABLE(cur_ins, ':worker_number2', p_worker_number);

Line 224: DBMS_SQL.BIND_VARIABLE(cur_ins, ':worker_number1', p_worker_number);

220: cur_ins := DBMS_SQL.OPEN_CURSOR;
221: DBMS_SQL.PARSE(cur_ins, l_ins_sql, DBMS_SQL.NATIVE);
222:
223: /* binds */
224: DBMS_SQL.BIND_VARIABLE(cur_ins, ':worker_number1', p_worker_number);
225: DBMS_SQL.BIND_VARIABLE(cur_ins, ':worker_number2', p_worker_number);
226: -- third and fourth (dynamic) parts of statement
227: IF l_pay_any = 'Y'
228: THEN

Line 225: DBMS_SQL.BIND_VARIABLE(cur_ins, ':worker_number2', p_worker_number);

221: DBMS_SQL.PARSE(cur_ins, l_ins_sql, DBMS_SQL.NATIVE);
222:
223: /* binds */
224: DBMS_SQL.BIND_VARIABLE(cur_ins, ':worker_number1', p_worker_number);
225: DBMS_SQL.BIND_VARIABLE(cur_ins, ':worker_number2', p_worker_number);
226: -- third and fourth (dynamic) parts of statement
227: IF l_pay_any = 'Y'
228: THEN
229: DBMS_SQL.BIND_VARIABLE(cur_ins, ':worker_number3', p_worker_number);

Line 229: DBMS_SQL.BIND_VARIABLE(cur_ins, ':worker_number3', p_worker_number);

225: DBMS_SQL.BIND_VARIABLE(cur_ins, ':worker_number2', p_worker_number);
226: -- third and fourth (dynamic) parts of statement
227: IF l_pay_any = 'Y'
228: THEN
229: DBMS_SQL.BIND_VARIABLE(cur_ins, ':worker_number3', p_worker_number);
230: END IF;
231:
232: IF l_pay_top_down = 'Y'
233: THEN

Line 234: DBMS_SQL.BIND_VARIABLE(cur_ins, ':worker_number4', p_worker_number);

230: END IF;
231:
232: IF l_pay_top_down = 'Y'
233: THEN
234: DBMS_SQL.BIND_VARIABLE(cur_ins, ':worker_number4', p_worker_number);
235: END IF;
236: l_rows_inserted := DBMS_SQL.EXECUTE(cur_ins);
237: DBMS_SQL.CLOSE_CURSOR(cur_ins);
238:

Line 236: l_rows_inserted := DBMS_SQL.EXECUTE(cur_ins);

232: IF l_pay_top_down = 'Y'
233: THEN
234: DBMS_SQL.BIND_VARIABLE(cur_ins, ':worker_number4', p_worker_number);
235: END IF;
236: l_rows_inserted := DBMS_SQL.EXECUTE(cur_ins);
237: DBMS_SQL.CLOSE_CURSOR(cur_ins);
238:
239: END IF; /* end pay_unrelated */
240:

Line 237: DBMS_SQL.CLOSE_CURSOR(cur_ins);

233: THEN
234: DBMS_SQL.BIND_VARIABLE(cur_ins, ':worker_number4', p_worker_number);
235: END IF;
236: l_rows_inserted := DBMS_SQL.EXECUTE(cur_ins);
237: DBMS_SQL.CLOSE_CURSOR(cur_ins);
238:
239: END IF; /* end pay_unrelated */
240:
241: IF PG_DEBUG in ('Y', 'C') THEN

Line 463: cur_ins := DBMS_SQL.OPEN_CURSOR;

459:
460: END IF;
461:
462: /* Now open, parse, execute the sql */
463: cur_ins := DBMS_SQL.OPEN_CURSOR;
464: DBMS_SQL.PARSE(cur_ins, l_ins_sql, DBMS_SQL.NATIVE);
465:
466: /* binds */
467: DBMS_SQL.BIND_VARIABLE(cur_ins, ':transmission_id1', p_transmission_id);

Line 464: DBMS_SQL.PARSE(cur_ins, l_ins_sql, DBMS_SQL.NATIVE);

460: END IF;
461:
462: /* Now open, parse, execute the sql */
463: cur_ins := DBMS_SQL.OPEN_CURSOR;
464: DBMS_SQL.PARSE(cur_ins, l_ins_sql, DBMS_SQL.NATIVE);
465:
466: /* binds */
467: DBMS_SQL.BIND_VARIABLE(cur_ins, ':transmission_id1', p_transmission_id);
468: DBMS_SQL.BIND_VARIABLE(cur_ins, ':pay_rec_type1',p_payment_rec_type);

Line 467: DBMS_SQL.BIND_VARIABLE(cur_ins, ':transmission_id1', p_transmission_id);

463: cur_ins := DBMS_SQL.OPEN_CURSOR;
464: DBMS_SQL.PARSE(cur_ins, l_ins_sql, DBMS_SQL.NATIVE);
465:
466: /* binds */
467: DBMS_SQL.BIND_VARIABLE(cur_ins, ':transmission_id1', p_transmission_id);
468: DBMS_SQL.BIND_VARIABLE(cur_ins, ':pay_rec_type1',p_payment_rec_type);
469: DBMS_SQL.BIND_VARIABLE(cur_ins, ':transmission_id2', p_transmission_id);
470: DBMS_SQL.BIND_VARIABLE(cur_ins, ':pay_rec_type2',p_payment_rec_type);
471: -- third and fourth (dynamic) parts of statement

Line 468: DBMS_SQL.BIND_VARIABLE(cur_ins, ':pay_rec_type1',p_payment_rec_type);

464: DBMS_SQL.PARSE(cur_ins, l_ins_sql, DBMS_SQL.NATIVE);
465:
466: /* binds */
467: DBMS_SQL.BIND_VARIABLE(cur_ins, ':transmission_id1', p_transmission_id);
468: DBMS_SQL.BIND_VARIABLE(cur_ins, ':pay_rec_type1',p_payment_rec_type);
469: DBMS_SQL.BIND_VARIABLE(cur_ins, ':transmission_id2', p_transmission_id);
470: DBMS_SQL.BIND_VARIABLE(cur_ins, ':pay_rec_type2',p_payment_rec_type);
471: -- third and fourth (dynamic) parts of statement
472: IF l_pay_any = 'Y'

Line 469: DBMS_SQL.BIND_VARIABLE(cur_ins, ':transmission_id2', p_transmission_id);

465:
466: /* binds */
467: DBMS_SQL.BIND_VARIABLE(cur_ins, ':transmission_id1', p_transmission_id);
468: DBMS_SQL.BIND_VARIABLE(cur_ins, ':pay_rec_type1',p_payment_rec_type);
469: DBMS_SQL.BIND_VARIABLE(cur_ins, ':transmission_id2', p_transmission_id);
470: DBMS_SQL.BIND_VARIABLE(cur_ins, ':pay_rec_type2',p_payment_rec_type);
471: -- third and fourth (dynamic) parts of statement
472: IF l_pay_any = 'Y'
473: THEN

Line 470: DBMS_SQL.BIND_VARIABLE(cur_ins, ':pay_rec_type2',p_payment_rec_type);

466: /* binds */
467: DBMS_SQL.BIND_VARIABLE(cur_ins, ':transmission_id1', p_transmission_id);
468: DBMS_SQL.BIND_VARIABLE(cur_ins, ':pay_rec_type1',p_payment_rec_type);
469: DBMS_SQL.BIND_VARIABLE(cur_ins, ':transmission_id2', p_transmission_id);
470: DBMS_SQL.BIND_VARIABLE(cur_ins, ':pay_rec_type2',p_payment_rec_type);
471: -- third and fourth (dynamic) parts of statement
472: IF l_pay_any = 'Y'
473: THEN
474: DBMS_SQL.BIND_VARIABLE(cur_ins, ':transmission_id3', p_transmission_id);

Line 474: DBMS_SQL.BIND_VARIABLE(cur_ins, ':transmission_id3', p_transmission_id);

470: DBMS_SQL.BIND_VARIABLE(cur_ins, ':pay_rec_type2',p_payment_rec_type);
471: -- third and fourth (dynamic) parts of statement
472: IF l_pay_any = 'Y'
473: THEN
474: DBMS_SQL.BIND_VARIABLE(cur_ins, ':transmission_id3', p_transmission_id);
475: DBMS_SQL.BIND_VARIABLE(cur_ins, ':pay_rec_type3',p_payment_rec_type);
476: END IF;
477:
478: IF l_pay_top_down = 'Y'

Line 475: DBMS_SQL.BIND_VARIABLE(cur_ins, ':pay_rec_type3',p_payment_rec_type);

471: -- third and fourth (dynamic) parts of statement
472: IF l_pay_any = 'Y'
473: THEN
474: DBMS_SQL.BIND_VARIABLE(cur_ins, ':transmission_id3', p_transmission_id);
475: DBMS_SQL.BIND_VARIABLE(cur_ins, ':pay_rec_type3',p_payment_rec_type);
476: END IF;
477:
478: IF l_pay_top_down = 'Y'
479: THEN

Line 480: DBMS_SQL.BIND_VARIABLE(cur_ins, ':transmission_id4', p_transmission_id);

476: END IF;
477:
478: IF l_pay_top_down = 'Y'
479: THEN
480: DBMS_SQL.BIND_VARIABLE(cur_ins, ':transmission_id4', p_transmission_id);
481: DBMS_SQL.BIND_VARIABLE(cur_ins, ':pay_rec_type4',p_payment_rec_type);
482: END IF;
483: l_rows_inserted := DBMS_SQL.EXECUTE(cur_ins);
484: DBMS_SQL.CLOSE_CURSOR(cur_ins);

Line 481: DBMS_SQL.BIND_VARIABLE(cur_ins, ':pay_rec_type4',p_payment_rec_type);

477:
478: IF l_pay_top_down = 'Y'
479: THEN
480: DBMS_SQL.BIND_VARIABLE(cur_ins, ':transmission_id4', p_transmission_id);
481: DBMS_SQL.BIND_VARIABLE(cur_ins, ':pay_rec_type4',p_payment_rec_type);
482: END IF;
483: l_rows_inserted := DBMS_SQL.EXECUTE(cur_ins);
484: DBMS_SQL.CLOSE_CURSOR(cur_ins);
485: END IF;

Line 483: l_rows_inserted := DBMS_SQL.EXECUTE(cur_ins);

479: THEN
480: DBMS_SQL.BIND_VARIABLE(cur_ins, ':transmission_id4', p_transmission_id);
481: DBMS_SQL.BIND_VARIABLE(cur_ins, ':pay_rec_type4',p_payment_rec_type);
482: END IF;
483: l_rows_inserted := DBMS_SQL.EXECUTE(cur_ins);
484: DBMS_SQL.CLOSE_CURSOR(cur_ins);
485: END IF;
486:
487: ELSE

Line 484: DBMS_SQL.CLOSE_CURSOR(cur_ins);

480: DBMS_SQL.BIND_VARIABLE(cur_ins, ':transmission_id4', p_transmission_id);
481: DBMS_SQL.BIND_VARIABLE(cur_ins, ':pay_rec_type4',p_payment_rec_type);
482: END IF;
483: l_rows_inserted := DBMS_SQL.EXECUTE(cur_ins);
484: DBMS_SQL.CLOSE_CURSOR(cur_ins);
485: END IF;
486:
487: ELSE
488: /* Relationships already built, no action required */

Line 706: cur_ins := DBMS_SQL.OPEN_CURSOR;

702:
703: END IF;
704:
705: /* Now execute the sql */
706: cur_ins := DBMS_SQL.OPEN_CURSOR;
707: DBMS_SQL.PARSE(cur_ins, l_ins_sql, DBMS_SQL.NATIVE);
708:
709: /* binds */
710: DBMS_SQL.BIND_VARIABLE(cur_ins, ':customer_id1', p_customer_id);

Line 707: DBMS_SQL.PARSE(cur_ins, l_ins_sql, DBMS_SQL.NATIVE);

703: END IF;
704:
705: /* Now execute the sql */
706: cur_ins := DBMS_SQL.OPEN_CURSOR;
707: DBMS_SQL.PARSE(cur_ins, l_ins_sql, DBMS_SQL.NATIVE);
708:
709: /* binds */
710: DBMS_SQL.BIND_VARIABLE(cur_ins, ':customer_id1', p_customer_id);
711: DBMS_SQL.BIND_VARIABLE(cur_ins, ':customer_id2', p_customer_id);

Line 710: DBMS_SQL.BIND_VARIABLE(cur_ins, ':customer_id1', p_customer_id);

706: cur_ins := DBMS_SQL.OPEN_CURSOR;
707: DBMS_SQL.PARSE(cur_ins, l_ins_sql, DBMS_SQL.NATIVE);
708:
709: /* binds */
710: DBMS_SQL.BIND_VARIABLE(cur_ins, ':customer_id1', p_customer_id);
711: DBMS_SQL.BIND_VARIABLE(cur_ins, ':customer_id2', p_customer_id);
712: DBMS_SQL.BIND_VARIABLE(cur_ins, ':customer_id3', p_customer_id);
713: -- third and fourth (dynamic) parts of statement
714: IF l_pay_any = 'Y'

Line 711: DBMS_SQL.BIND_VARIABLE(cur_ins, ':customer_id2', p_customer_id);

707: DBMS_SQL.PARSE(cur_ins, l_ins_sql, DBMS_SQL.NATIVE);
708:
709: /* binds */
710: DBMS_SQL.BIND_VARIABLE(cur_ins, ':customer_id1', p_customer_id);
711: DBMS_SQL.BIND_VARIABLE(cur_ins, ':customer_id2', p_customer_id);
712: DBMS_SQL.BIND_VARIABLE(cur_ins, ':customer_id3', p_customer_id);
713: -- third and fourth (dynamic) parts of statement
714: IF l_pay_any = 'Y'
715: THEN

Line 712: DBMS_SQL.BIND_VARIABLE(cur_ins, ':customer_id3', p_customer_id);

708:
709: /* binds */
710: DBMS_SQL.BIND_VARIABLE(cur_ins, ':customer_id1', p_customer_id);
711: DBMS_SQL.BIND_VARIABLE(cur_ins, ':customer_id2', p_customer_id);
712: DBMS_SQL.BIND_VARIABLE(cur_ins, ':customer_id3', p_customer_id);
713: -- third and fourth (dynamic) parts of statement
714: IF l_pay_any = 'Y'
715: THEN
716: DBMS_SQL.BIND_VARIABLE(cur_ins, ':customer_id4', p_customer_id);

Line 716: DBMS_SQL.BIND_VARIABLE(cur_ins, ':customer_id4', p_customer_id);

712: DBMS_SQL.BIND_VARIABLE(cur_ins, ':customer_id3', p_customer_id);
713: -- third and fourth (dynamic) parts of statement
714: IF l_pay_any = 'Y'
715: THEN
716: DBMS_SQL.BIND_VARIABLE(cur_ins, ':customer_id4', p_customer_id);
717: DBMS_SQL.BIND_VARIABLE(cur_ins, ':apply_date1', p_apply_date);
718: DBMS_SQL.BIND_VARIABLE(cur_ins, ':apply_date2', p_apply_date);
719: DBMS_SQL.BIND_VARIABLE(cur_ins, ':apply_date3', p_apply_date);
720: DBMS_SQL.BIND_VARIABLE(cur_ins, ':apply_date4', p_apply_date);

Line 717: DBMS_SQL.BIND_VARIABLE(cur_ins, ':apply_date1', p_apply_date);

713: -- third and fourth (dynamic) parts of statement
714: IF l_pay_any = 'Y'
715: THEN
716: DBMS_SQL.BIND_VARIABLE(cur_ins, ':customer_id4', p_customer_id);
717: DBMS_SQL.BIND_VARIABLE(cur_ins, ':apply_date1', p_apply_date);
718: DBMS_SQL.BIND_VARIABLE(cur_ins, ':apply_date2', p_apply_date);
719: DBMS_SQL.BIND_VARIABLE(cur_ins, ':apply_date3', p_apply_date);
720: DBMS_SQL.BIND_VARIABLE(cur_ins, ':apply_date4', p_apply_date);
721: DBMS_SQL.BIND_VARIABLE(cur_ins, ':apply_date5', p_apply_date);

Line 718: DBMS_SQL.BIND_VARIABLE(cur_ins, ':apply_date2', p_apply_date);

714: IF l_pay_any = 'Y'
715: THEN
716: DBMS_SQL.BIND_VARIABLE(cur_ins, ':customer_id4', p_customer_id);
717: DBMS_SQL.BIND_VARIABLE(cur_ins, ':apply_date1', p_apply_date);
718: DBMS_SQL.BIND_VARIABLE(cur_ins, ':apply_date2', p_apply_date);
719: DBMS_SQL.BIND_VARIABLE(cur_ins, ':apply_date3', p_apply_date);
720: DBMS_SQL.BIND_VARIABLE(cur_ins, ':apply_date4', p_apply_date);
721: DBMS_SQL.BIND_VARIABLE(cur_ins, ':apply_date5', p_apply_date);
722: DBMS_SQL.BIND_VARIABLE(cur_ins, ':apply_date6', p_apply_date);

Line 719: DBMS_SQL.BIND_VARIABLE(cur_ins, ':apply_date3', p_apply_date);

715: THEN
716: DBMS_SQL.BIND_VARIABLE(cur_ins, ':customer_id4', p_customer_id);
717: DBMS_SQL.BIND_VARIABLE(cur_ins, ':apply_date1', p_apply_date);
718: DBMS_SQL.BIND_VARIABLE(cur_ins, ':apply_date2', p_apply_date);
719: DBMS_SQL.BIND_VARIABLE(cur_ins, ':apply_date3', p_apply_date);
720: DBMS_SQL.BIND_VARIABLE(cur_ins, ':apply_date4', p_apply_date);
721: DBMS_SQL.BIND_VARIABLE(cur_ins, ':apply_date5', p_apply_date);
722: DBMS_SQL.BIND_VARIABLE(cur_ins, ':apply_date6', p_apply_date);
723: END IF;

Line 720: DBMS_SQL.BIND_VARIABLE(cur_ins, ':apply_date4', p_apply_date);

716: DBMS_SQL.BIND_VARIABLE(cur_ins, ':customer_id4', p_customer_id);
717: DBMS_SQL.BIND_VARIABLE(cur_ins, ':apply_date1', p_apply_date);
718: DBMS_SQL.BIND_VARIABLE(cur_ins, ':apply_date2', p_apply_date);
719: DBMS_SQL.BIND_VARIABLE(cur_ins, ':apply_date3', p_apply_date);
720: DBMS_SQL.BIND_VARIABLE(cur_ins, ':apply_date4', p_apply_date);
721: DBMS_SQL.BIND_VARIABLE(cur_ins, ':apply_date5', p_apply_date);
722: DBMS_SQL.BIND_VARIABLE(cur_ins, ':apply_date6', p_apply_date);
723: END IF;
724:

Line 721: DBMS_SQL.BIND_VARIABLE(cur_ins, ':apply_date5', p_apply_date);

717: DBMS_SQL.BIND_VARIABLE(cur_ins, ':apply_date1', p_apply_date);
718: DBMS_SQL.BIND_VARIABLE(cur_ins, ':apply_date2', p_apply_date);
719: DBMS_SQL.BIND_VARIABLE(cur_ins, ':apply_date3', p_apply_date);
720: DBMS_SQL.BIND_VARIABLE(cur_ins, ':apply_date4', p_apply_date);
721: DBMS_SQL.BIND_VARIABLE(cur_ins, ':apply_date5', p_apply_date);
722: DBMS_SQL.BIND_VARIABLE(cur_ins, ':apply_date6', p_apply_date);
723: END IF;
724:
725: IF l_pay_top_down = 'Y'

Line 722: DBMS_SQL.BIND_VARIABLE(cur_ins, ':apply_date6', p_apply_date);

718: DBMS_SQL.BIND_VARIABLE(cur_ins, ':apply_date2', p_apply_date);
719: DBMS_SQL.BIND_VARIABLE(cur_ins, ':apply_date3', p_apply_date);
720: DBMS_SQL.BIND_VARIABLE(cur_ins, ':apply_date4', p_apply_date);
721: DBMS_SQL.BIND_VARIABLE(cur_ins, ':apply_date5', p_apply_date);
722: DBMS_SQL.BIND_VARIABLE(cur_ins, ':apply_date6', p_apply_date);
723: END IF;
724:
725: IF l_pay_top_down = 'Y'
726: THEN

Line 727: DBMS_SQL.BIND_VARIABLE(cur_ins, ':customer_id5', p_customer_id);

723: END IF;
724:
725: IF l_pay_top_down = 'Y'
726: THEN
727: DBMS_SQL.BIND_VARIABLE(cur_ins, ':customer_id5', p_customer_id);
728: DBMS_SQL.BIND_VARIABLE(cur_ins, ':apply_date7', p_apply_date);
729: END IF;
730: l_rows_inserted := DBMS_SQL.EXECUTE(cur_ins);
731: DBMS_SQL.CLOSE_CURSOR(cur_ins);

Line 728: DBMS_SQL.BIND_VARIABLE(cur_ins, ':apply_date7', p_apply_date);

724:
725: IF l_pay_top_down = 'Y'
726: THEN
727: DBMS_SQL.BIND_VARIABLE(cur_ins, ':customer_id5', p_customer_id);
728: DBMS_SQL.BIND_VARIABLE(cur_ins, ':apply_date7', p_apply_date);
729: END IF;
730: l_rows_inserted := DBMS_SQL.EXECUTE(cur_ins);
731: DBMS_SQL.CLOSE_CURSOR(cur_ins);
732: /* end */

Line 730: l_rows_inserted := DBMS_SQL.EXECUTE(cur_ins);

726: THEN
727: DBMS_SQL.BIND_VARIABLE(cur_ins, ':customer_id5', p_customer_id);
728: DBMS_SQL.BIND_VARIABLE(cur_ins, ':apply_date7', p_apply_date);
729: END IF;
730: l_rows_inserted := DBMS_SQL.EXECUTE(cur_ins);
731: DBMS_SQL.CLOSE_CURSOR(cur_ins);
732: /* end */
733: END IF;
734: ELSE

Line 731: DBMS_SQL.CLOSE_CURSOR(cur_ins);

727: DBMS_SQL.BIND_VARIABLE(cur_ins, ':customer_id5', p_customer_id);
728: DBMS_SQL.BIND_VARIABLE(cur_ins, ':apply_date7', p_apply_date);
729: END IF;
730: l_rows_inserted := DBMS_SQL.EXECUTE(cur_ins);
731: DBMS_SQL.CLOSE_CURSOR(cur_ins);
732: /* end */
733: END IF;
734: ELSE
735: /* Relationships already built, no action required */