APPS.JAI_RCV_THIRD_PARTY_PKG dependencies on DUAL

Line 199: select jai_rcv_tp_batches_s.nextval from dual;

195: GROUP BY jrt.shipment_header_id
196: ORDER BY jrt.shipment_header_id;
197:
198: cursor c_get_tp_batch_id is
199: select jai_rcv_tp_batches_s.nextval from dual;
200:
201: cursor c_no_of_invoice_generated(cp_batch_id number) is
202: select count(batch_invoice_id)
203: from jai_rcv_tp_invoices

Line 232: SELECT 'jai_rcv_third_party_pkg.process_pending_receipts' INTO lv_temp FROM DUAL;

228: fnd_file.put_line(fnd_file.log, 'Operating unit ln_org_id is -> '||ln_org_id);
229:
230: /*End of bug 5490479 */
231: /* This is to identify the path in SQL TRACE file if any problem occured */
232: SELECT 'jai_rcv_third_party_pkg.process_pending_receipts' INTO lv_temp FROM DUAL;
233:
234: open c_get_tp_batch_id;
235: fetch c_get_tp_batch_id into ln_batch_id;
236: close c_get_tp_batch_id;

Line 621: from dual;

617: and vendor_site_id = p_vendor_site_id;
618:
619: cursor c_get_inv_run_no is
620: select jai_rcv_tp_invoices_s1.nextval /* renamed the sequence to point to the correct sequence name - ssumaith - sequence change process */
621: from dual;
622:
623: cursor c_check_if_already_processed(p_shipment_header_id number) is
624: select count(transaction_id)
625: from JAI_RCV_TRANSACTIONS

Line 752: into lv_temp from dual;

748: ln_line_number := 1; /* modified by vumaasha for bug 8965721 */
749:
750: -- This is to identify the path in SQL TRACE file if any problem occured
751: select 'jai_rcv_third_party_pkg.process_receipt : shipment header - ' || to_char(p_shipment_header_id)
752: into lv_temp from dual;
753:
754: if p_debug >= 1 then
755: Fnd_File.put_line(Fnd_File.LOG, ' ** Debug Level 1 : ' ||
756: 'Start of procedure jai_rcv_third_party_pkg.process_receipt for shipment header :' ||

Line 1083: FROM DUAL;

1079: close c_get_goods_received_date;
1080:
1081: SELECT jai_rcv_tp_invoices_s.nextval
1082: INTO ln_batch_invoice_id
1083: FROM DUAL;
1084:
1085: --Tax table need to be inserted once only
1086: --added by eric for inclusive tax on 20-dec,2007, Begin
1087: -----------------------------------------------------------------------

Line 1421: --SELECT jai_rcv_tp_inv_details_s.nextval INTO ln_batch_line_id FROM DUAL;

1417: LOOP
1418:
1419: Fnd_File.put_line(Fnd_File.LOG, ' ');
1420: Fnd_File.put_line(Fnd_File.LOG, '**** Debug Level 3 : Loop Begin');
1421: --SELECT jai_rcv_tp_inv_details_s.nextval INTO ln_batch_line_id FROM DUAL;
1422:
1423: --tax table need to be populated once only
1424: --added by eric for inclusive tax on 20-dec,2007, Begin
1425: -----------------------------------------------------------------------