APPS.JAI_MTL_TRXS_PKG dependencies on RCV_SHIPMENT_LINES

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

4352: end cgvat_reposit_entry;
4353: PROCEDURE claim_balance_cgvat(
4354: p_term_id IN jai_rgm_terms.term_id%TYPE DEFAULT NULL,
4355: p_shipment_header_id IN rcv_shipment_headers.shipment_header_id%TYPE DEFAULT NULL,
4356: p_shipment_line_id IN rcv_shipment_lines.shipment_line_id%TYPE DEFAULT NULL,
4357: p_transaction_id IN rcv_transactions.transaction_id%TYPE DEFAULT NULL,
4358: p_tax_type IN jai_cmn_taxes_all.tax_type%TYPE DEFAULT NULL,
4359: p_tax_id IN jai_cmn_taxes_all.tax_id%TYPE DEFAULT NULL,
4360: p_receipt_num IN VARCHAR2,

Line 4375: cp_shipment_line_id IN rcv_shipment_lines.shipment_line_id%TYPE)

4371: p_process_message OUT NOCOPY VARCHAR2)
4372: IS
4373:
4374: CURSOR cur_lines(cp_shipment_header_id IN rcv_shipment_headers.shipment_header_id%TYPE,
4375: cp_shipment_line_id IN rcv_shipment_lines.shipment_line_id%TYPE)
4376: IS
4377: SELECT shipment_header_id, shipment_line_id
4378: FROM jai_rcv_lines
4379: WHERE shipment_header_id = NVL(cp_shipment_header_id, shipment_header_id)

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

4383: and inventory_item_id=p_inventory_item_id
4384: ORDER BY shipment_line_id;
4385:
4386:
4387: CURSOR cur_txns(cp_shipment_line_id IN rcv_shipment_lines.shipment_line_id%TYPE,
4388: cp_transaction_id IN rcv_transactions.transaction_id%TYPE)
4389: IS
4390: SELECT transaction_id,
4391: transaction_type,

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

4433: AND a.tax_id = b.tax_id
4434: AND a.modvat_flag = 'Y'
4435: AND NVL(a.tax_amount,0) <> 0;
4436:
4437: CURSOR cur_term(cp_shipment_line_id IN rcv_shipment_lines.shipment_line_id%TYPE)
4438: IS
4439: SELECT term_id, rcv_rgm_line_id, receipt_date
4440: FROM jai_rcv_rgm_lines
4441: WHERE shipment_line_id = cp_shipment_line_id