APPS.JAI_RCV_RGM_CLAIMS_PKG dependencies on JAI_RCV_LINES

Line 374: FROM JAI_RCV_LINES

370: CURSOR cur_lines(cp_shipment_header_id IN rcv_shipment_headers.shipment_header_id%TYPE,
371: cp_shipment_line_id IN rcv_shipment_lines.shipment_line_id%TYPE)
372: IS
373: SELECT shipment_header_id, shipment_line_id
374: FROM JAI_RCV_LINES
375: WHERE shipment_header_id = NVL(cp_shipment_header_id, shipment_header_id)
376: AND shipment_line_id = NVL(cp_shipment_line_id, shipment_line_id)
377: ORDER BY shipment_line_id;
378:

Line 701: FROM JAI_RCV_LINES a,

697: cp_shipment_line_id IN rcv_shipment_lines.shipment_line_id%TYPE)
698: IS
699: SELECT a.shipment_line_id, a.transaction_id, a.inventory_item_id, a.receipt_num, b.line_num
700: , excise_invoice_no, excise_invoice_date -- brathod, Bug# 6109941
701: FROM JAI_RCV_LINES a,
702: rcv_shipment_lines b
703: WHERE a.shipment_header_id = b.shipment_header_id
704: AND a.shipment_line_id = b.shipment_line_id
705: AND a.shipment_header_id = NVL(cp_shipment_header_id,a.shipment_header_id)

Line 1028: p_receipt_num IN JAI_RCV_LINES.receipt_num%TYPE DEFAULT NULL,

1024:
1025: PROCEDURE update_rcv_lines(
1026: p_shipment_header_id IN rcv_shipment_headers.shipment_header_id%TYPE,
1027: p_shipment_line_id IN rcv_shipment_lines.shipment_line_id%TYPE DEFAULT NULL,
1028: p_receipt_num IN JAI_RCV_LINES.receipt_num%TYPE DEFAULT NULL,
1029: p_recoverable_amount IN jai_rcv_rgm_lines.recoverable_amount%TYPE DEFAULT NULL,
1030: p_recovered_amount IN jai_rcv_rgm_lines.recovered_amount%TYPE DEFAULT NULL,
1031: p_term_id IN jai_rgm_terms.term_id%TYPE DEFAULT -999,
1032: p_invoice_no IN JAI_RCV_TRANSACTIONS.vat_invoice_no%TYPE, --File.Sql.35 Cbabu DEFAULT '-X9X',

Line 1829: JAI_RCV_LINES b

1825: IS
1826: SELECT a.vat_invoice_no, a.vat_invoice_date, b.transaction_id, a.tax_transaction_id,
1827: a.excise_invoice_no , a.excise_invoice_Date /*bduvarag Bug5899383*/
1828: FROM JAI_RCV_TRANSACTIONS a,
1829: JAI_RCV_LINES b
1830: WHERE a.transaction_id = b.transaction_id
1831: AND b.shipment_header_id = cp_shipment_header_id
1832: AND b.shipment_line_id = cp_shipment_line_id;
1833:

Line 1952: UPDATE JAI_RCV_LINES

1948: -- Bug 6109941, Removed update statement of dff attribute columns of
1949: -- RCV_SHIPMENT_HEADERS and RCV_TRASACTIONS tables
1950: --
1951:
1952: UPDATE JAI_RCV_LINES
1953: SET excise_invoice_no = rec_claims.invoice_no,
1954: excise_invoice_Date = rec_claims.invoice_date
1955: WHERE shipment_header_id = rec_claims.shipment_header_id
1956: AND excise_invoice_no IS NULL;