APPS.JAI_MTL_TRXS_PKG dependencies on RCV_SHIPMENT_LINES

Line 4801: p_shipment_line_id IN rcv_shipment_lines.shipment_line_id%TYPE DEFAULT NULL,

4797: end cgvat_reposit_entry;
4798: PROCEDURE claim_balance_cgvat(
4799: p_term_id IN jai_rgm_terms.term_id%TYPE DEFAULT NULL,
4800: p_shipment_header_id IN rcv_shipment_headers.shipment_header_id%TYPE DEFAULT NULL,
4801: p_shipment_line_id IN rcv_shipment_lines.shipment_line_id%TYPE DEFAULT NULL,
4802: p_transaction_id IN rcv_transactions.transaction_id%TYPE DEFAULT NULL,
4803: p_tax_type IN jai_cmn_taxes_all.tax_type%TYPE DEFAULT NULL,
4804: p_tax_id IN jai_cmn_taxes_all.tax_id%TYPE DEFAULT NULL,
4805: p_receipt_num IN VARCHAR2,

Line 4820: cp_shipment_line_id IN rcv_shipment_lines.shipment_line_id%TYPE)

4816: p_process_message OUT NOCOPY VARCHAR2)
4817: IS
4818:
4819: CURSOR cur_lines(cp_shipment_header_id IN rcv_shipment_headers.shipment_header_id%TYPE,
4820: cp_shipment_line_id IN rcv_shipment_lines.shipment_line_id%TYPE)
4821: IS
4822: SELECT shipment_header_id, shipment_line_id
4823: FROM jai_rcv_lines
4824: WHERE shipment_header_id = NVL(cp_shipment_header_id, shipment_header_id)

Line 4832: CURSOR cur_txns(cp_shipment_line_id IN rcv_shipment_lines.shipment_line_id%TYPE,

4828: and inventory_item_id=p_inventory_item_id
4829: ORDER BY shipment_line_id;
4830:
4831:
4832: CURSOR cur_txns(cp_shipment_line_id IN rcv_shipment_lines.shipment_line_id%TYPE,
4833: cp_transaction_id IN rcv_transactions.transaction_id%TYPE)
4834: IS
4835: SELECT transaction_id,
4836: transaction_type,

Line 4879: CURSOR cur_term(cp_shipment_line_id IN rcv_shipment_lines.shipment_line_id%TYPE)

4875: AND a.tax_id = b.tax_id
4876: AND a.modvat_flag = 'Y'
4877: AND NVL(a.tax_amount,0) <> 0;
4878:
4879: CURSOR cur_term(cp_shipment_line_id IN rcv_shipment_lines.shipment_line_id%TYPE)
4880: IS
4881: SELECT term_id, rcv_rgm_line_id, receipt_date
4882: FROM jai_rcv_rgm_lines
4883: WHERE shipment_line_id = cp_shipment_line_id