APPS.JAI_RCV_THIRD_PARTY_PKG dependencies on DUAL

Line 178: select jai_rcv_tp_batches_s.nextval from dual;

174: group by shipment_header_id
175: order by shipment_header_id;
176:
177: cursor c_get_tp_batch_id is
178: select jai_rcv_tp_batches_s.nextval from dual;
179:
180: cursor c_no_of_invoice_generated(cp_batch_id number) is
181: select count(batch_invoice_id)
182: from jai_rcv_tp_invoices

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

207: fnd_file.put_line(fnd_file.log, 'Operating unit ln_org_id is -> '||ln_org_id);
208:
209: /*End of bug 5490479 */
210: /* This is to identify the path in SQL TRACE file if any problem occured */
211: SELECT 'jai_rcv_third_party_pkg.process_pending_receipts' INTO lv_temp FROM DUAL;
212:
213: open c_get_tp_batch_id;
214: fetch c_get_tp_batch_id into ln_batch_id;
215: close c_get_tp_batch_id;

Line 600: from dual;

596: and vendor_site_id = p_vendor_site_id;
597:
598: cursor c_get_inv_run_no is
599: select jai_rcv_tp_invoices_s1.nextval /* renamed the sequence to point to the correct sequence name - ssumaith - sequence change process */
600: from dual;
601:
602: cursor c_check_if_already_processed(p_shipment_header_id number) is
603: select count(transaction_id)
604: from JAI_RCV_TRANSACTIONS

Line 710: into lv_temp from dual;

706: ln_line_number := 0;
707:
708: -- This is to identify the path in SQL TRACE file if any problem occured
709: select 'jai_rcv_third_party_pkg.process_receipt : shipment header - ' || to_char(p_shipment_header_id)
710: into lv_temp from dual;
711:
712: if p_debug >= 1 then
713: Fnd_File.put_line(Fnd_File.LOG, ' ** Debug Level 1 : ' ||
714: 'Start of procedure jai_rcv_third_party_pkg.process_receipt for shipment header :' ||

Line 1041: FROM DUAL;

1037: close c_get_goods_received_date;
1038:
1039: SELECT jai_rcv_tp_invoices_s.nextval
1040: INTO ln_batch_invoice_id
1041: FROM DUAL;
1042:
1043: --Tax table need to be inserted once only
1044: --added by eric for inclusive tax on 20-dec,2007, Begin
1045: -----------------------------------------------------------------------

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

1301: LOOP
1302:
1303: Fnd_File.put_line(Fnd_File.LOG, ' ');
1304: Fnd_File.put_line(Fnd_File.LOG, '**** Debug Level 3 : Loop Begin');
1305: --SELECT jai_rcv_tp_inv_details_s.nextval INTO ln_batch_line_id FROM DUAL;
1306:
1307: --tax table need to be populated once only
1308: --added by eric for inclusive tax on 20-dec,2007, Begin
1309: -----------------------------------------------------------------------