DBA Data[Home] [Help]

APPS.JAI_RCV_THIRD_PARTY_PKG dependencies on JAI_RCV_TP_INVOICES_S

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

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

Line 1081: SELECT jai_rcv_tp_invoices_s.nextval

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