[Home] [Help]
58:
59: Following are the changes made for the purpose of RECEIPTsDEPLUG of Old Code and link it with New Corrections Code
60: - Added the procedures/functions
61: - PROCESS_DEFERRED_CENVAT_CLAIM : Will be invoked when request for JAINRVCTP is submitted from JAINMVAT form.
62: This is coded to process records of JAI_RCV_CENVAT_CLAIM_T table that needs to be claimed/unclaimed.
63: Incase of Unclaim, the transactions that are not yet processed/pending for claim or excise is not included in
64: cost are processed for Cenvat Costing. This happens for DELIVER, RTR and related CORRECTIONS
65: - GET_EQUIVALENT_QTY_OF_RECEIVE : Function that Returns quantity equivalent to RECEIVE UOM. Useful incase there
66: are changed between RECEIVE and other receiving transactions
1051: FOR UPDATE OF cenvat_rg_status, cenvat_rg_message
1052: order by shipment_line_id, transaction_id;
1053:
1054: CURSOR c_trxs_to_be_claimed IS
1055: SELECT * FROM JAI_RCV_CENVAT_CLAIM_T
1056: WHERE batch_identifier = p_batch_id
1057: AND error_flag IS NULL
1058: FOR UPDATE OF transaction_id
1059: ORDER BY transaction_id;
1527: p_process_flag := lv_cenvat_rg_flag;
1528: p_process_message := lv_cenvat_rg_message;
1529: ln_errored_cnt := ln_errored_cnt + 1;
1530:
1531: UPDATE JAI_RCV_CENVAT_CLAIM_T
1532: SET error_flag = 'Y',
1533: error_description = substr(lv_cenvat_rg_message,1,150),
1534: process_date = sysdate
1535: WHERE CURRENT OF c_trxs_to_be_claimed;
1537: ELSE
1538:
1539: lv_codepath := jai_general_pkg.plot_codepath(29, lv_codepath);
1540: -- Finally after the processing is completed, we need to delete the record from temp table
1541: DELETE FROM JAI_RCV_CENVAT_CLAIM_T
1542: WHERE CURRENT OF c_trxs_to_be_claimed;
1543:
1544: END IF;
1545: