DBA Data[Home] [Help]

APPS.JAI_RCV_THIRD_PARTY_PKG dependencies on JAI_RCV_TP_INVOICES_S

Line 599: select jai_rcv_tp_invoices_s1.nextval /* renamed the sequence to point to the correct sequence name - ssumaith - sequence change process */

595: where vendor_id = p_vendor_id
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)

Line 1039: SELECT jai_rcv_tp_invoices_s.nextval

1035: open c_get_goods_received_date(c_thirdparty_tax_rec.vendor_id , c_thirdparty_tax_rec.vendor_site_id);
1036: fetch c_get_goods_received_date into ld_goods_received_date;
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