DBA Data[Home] [Help]

APPS.JAI_RCV_RT_TRIGGER_PKG dependencies on JAI_RCV_HEADERS

Line 251: from jai_rcv_headers

247: r_rcv_hdr c_rcv_hdr%ROWTYPE;
248: v_chk number(5);
249: CURSOR c_jai_rcv_hdr_chk(cp_shipment_header_id number) is
250: select 1
251: from jai_rcv_headers
252: where shipment_header_id = cp_shipment_header_id;
253:
254: v_error_mesg VARCHAR2(200); -- added by Aparajita for bug#2514979 on 18/08/2002.
255: v_receipt_source_code rcv_shipment_headers.receipt_source_code%type; --ashish for bug # 2613817

Line 667: INSERT INTO jai_rcv_headers(

663: close c_jai_rcv_hdr_chk;
664:
665: if v_chk is null then
666:
667: INSERT INTO jai_rcv_headers(
668: SHIPMENT_HEADER_ID
669: ,RECEIPT_SOURCE_CODE
670: ,RECEIPT_NUM
671: ,SHIPMENT_NUM