[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
836: FOR UPDATE OF cenvat_rg_status, cenvat_rg_message
837: order by shipment_line_id, transaction_id;
838:
839: CURSOR c_trxs_to_be_claimed IS
840: SELECT * FROM JAI_RCV_CENVAT_CLAIM_T
841: WHERE batch_identifier = p_batch_id
842: AND error_flag IS NULL
843: FOR UPDATE OF transaction_id
844: ORDER BY transaction_id;
1185: p_process_flag := lv_cenvat_rg_flag;
1186: p_process_message := lv_cenvat_rg_message;
1187: ln_errored_cnt := ln_errored_cnt + 1;
1188:
1189: UPDATE JAI_RCV_CENVAT_CLAIM_T
1190: SET error_flag = 'Y',
1191: error_description = substr(lv_cenvat_rg_message,1,150),
1192: process_date = sysdate
1193: WHERE CURRENT OF c_trxs_to_be_claimed;
1195: ELSE
1196:
1197: lv_codepath := jai_general_pkg.plot_codepath(29, lv_codepath);
1198: -- Finally after the processing is completed, we need to delete the record from temp table
1199: DELETE FROM JAI_RCV_CENVAT_CLAIM_T
1200: WHERE CURRENT OF c_trxs_to_be_claimed;
1201:
1202: END IF;
1203: