APPS.JAI_RCV_RT_TRIGGER_PKG dependencies on RCV_SHIPMENT_HEADERS

Line 298: v_shipment_header_id rcv_shipment_headers.shipment_header_id % type;

294: REM
295: REM +======================================================================+
296: */
297: PROCEDURE BRI_T1 ( pr_old t_rec%type , pr_new in out t_rec%type , pv_action varchar2 , pv_return_code out nocopy varchar2 , pv_return_message out nocopy varchar2 ) IS
298: v_shipment_header_id rcv_shipment_headers.shipment_header_id % type;
299: /* Commented rallamse bug#4479131 PADDR Elimination
300: v_rowid JAI_CMN_LOCATORS_T.row_id%type;
301: */
302: -- CSahoo for Bug 5344225

Line 312: FROM rcv_shipment_headers

308:
309: CURSOR c_rcv_hdr IS
310: SELECT rowid, receipt_source_code, receipt_num, shipment_num, shipped_date, organization_id,
311: vendor_id, vendor_site_id, customer_id, customer_site_id
312: FROM rcv_shipment_headers
313: WHERE shipment_header_id = pr_new.shipment_header_id;
314:
315: /* Vijay Shankar for Bug#4346453. RCV DFF Elim. Enh. */
316: r_rcv_hdr c_rcv_hdr%ROWTYPE;

Line 324: v_receipt_source_code rcv_shipment_headers.receipt_source_code%type; --ashish for bug # 2613817

320: from jai_rcv_headers
321: where shipment_header_id = cp_shipment_header_id;
322:
323: v_error_mesg VARCHAR2(200); -- added by Aparajita for bug#2514979 on 18/08/2002.
324: v_receipt_source_code rcv_shipment_headers.receipt_source_code%type; --ashish for bug # 2613817
325:
326: -- Vijay Shankar for Enhancement Bug# 3496408
327: -- lv_opm_flag MTL_PARAMETERS_VIEW.process_enabled_flag%TYPE;
328: lv_process_mode VARCHAR2(1);

Line 397: rcv_shipment_headers RSH

393: IS
394: SELECT
395: '1'
396: FROM
397: rcv_shipment_headers RSH
398: WHERE
399: RSH.shipment_header_id = p_shipment_header_id
400: AND asn_type = 'ASN';
401: lv_asn_type VARCHAR2(1);

Line 567: Information from the header DFF is captured into the rcv_shipment_headers table.

563:
564: When a user creates a new receipt against a purchase order, he needs to enter the following information
565: through a DFF : invoice no, invoice_date, Claim Cenvat On Receipt etc.
566: This DFF is provided at two places, header and line.
567: Information from the header DFF is captured into the rcv_shipment_headers table.
568: Information from the lines DFF is captured into the rcv_transactions table.
569: This information is retrieved into our base tables JAI_RCV_TRANSACTIONS and JAI_RCV_LINES.
570: At this time, a facility has been provided for the user to default the information
571: given at the header level DFF to all the lines only if these columns are null at the

Line 884: FROM rcv_shipment_headers

880: attribute4,
881: attribute5, --ashish for bug # 2613817
882: receipt_source_code,
883: attribute_category
884: FROM rcv_shipment_headers
885: WHERE shipment_header_id = v_shipment_header_id)
886: LOOP
887:
888: IF head_rec.attribute_category = 'India Receipt' THEN