[Home] [Help]
217: ) IS
218:
219: CURSOR c_receipt_cenvat_dtl(cp_transaction_id IN NUMBER) IS
220: SELECT vendor_changed_flag, vendor_id, vendor_site_id
221: FROM JAI_RCV_CENVAT_CLAIMS
222: WHERE transaction_id = cp_transaction_id;
223:
224: r_receipt_cenvat_dtl c_receipt_cenvat_dtl%ROWTYPE;
225: lv_object_name CONSTANT VARCHAR2 (61) := 'jai_rcv_excise_processing_pkg.get_changed_vendor_dtls';
340: END IF;
341:
342: /* Start, Vijay Shankar for Bug#3940588 */
343: IF r_trx.transaction_type IN ('RECEIVE', 'MATCH') THEN
344: UPDATE JAI_RCV_CENVAT_CLAIMS
345: SET cenvat_claimed_ptg = p_cenvat_claimed_ptg,
346: cenvat_sequence = nvl(cenvat_sequence, 0) + 1,
347: cenvat_claimed_amt = nvl(cenvat_claimed_amt, 0) + p_cenvat_claimed_amt,
348: other_cenvat_claimed_amt = nvl(other_cenvat_claimed_amt,0) + p_other_cenvat_claimed_amt,
361: where transaction_id = p_transaction_id;
362:
363: ELSE
364:
365: UPDATE JAI_RCV_CENVAT_CLAIMS
366: SET quantity_for_2nd_claim = nvl(quantity_for_2nd_claim,0) + ln_trx_qty_for_2nd_claim,
367: last_update_date = sysdate,
368: last_updated_by = fnd_global.user_id,
369: last_update_login = fnd_global.login_id
383:
384: FND_FILE.put_line(FND_FILE.log, '^CENVAT_RG_PKG.post_cenvat_processor. v_excise_rf->'||v_excise_rf||'-v_excise_edu_cess_rf->'||v_excise_edu_cess_rf||'-v_excise_she_cess_rf->'||v_excise_she_cess_rf);
385:
386: IF r_trx.transaction_type = 'RECEIVE' THEN
387: UPDATE JAI_RCV_CENVAT_CLAIMS
388: SET cenvat_amt_for_2nd_claim = ROUND((NVL(cenvat_amount,0))-(NVL(cenvat_claimed_amt,0)),v_excise_rf),
389: other_cenvat_amt_for_2nd_claim = ROUND((NVL(other_cenvat_amt,0))-(NVL(other_cenvat_claimed_amt,0)),v_excise_edu_cess_rf) ,
390: last_update_date = sysdate,
391: last_updated_by = fnd_global.user_id,
403:
404: FND_FILE.put_line(FND_FILE.log, '^CENVAT_RG_PKG.post_cenvat_processor.ln_trx_equivalent_of_receive->'||ln_trx_equivalent_of_receive);
405: FND_FILE.put_line(FND_FILE.log, '^CENVAT_RG_PKG.post_cenvat_processor.v_changed_cenvat_quantity->'||v_changed_cenvat_quantity);
406:
407: UPDATE JAI_RCV_CENVAT_CLAIMS
408: SET cenvat_amt_for_2nd_claim = ROUND(nvl(v_changed_cenvat_quantity, 0) *nvl(cenvat_amount, 0) / nvl(ln_trx_equivalent_of_receive, 0), v_excise_rf) -cenvat_claimed_amt,
409: other_cenvat_amt_for_2nd_claim = ROUND(nvl(v_changed_cenvat_quantity, 0) *nvl(other_cenvat_amt, 0) / nvl(ln_trx_equivalent_of_receive, 0), v_excise_edu_cess_rf) -other_cenvat_claimed_amt,
410: last_update_date = sysdate,
411: last_updated_by = fnd_global.user_id,
1153: - Added a RECORD Definition for tax breakup as TAX_BREAUP and modified to use this as a parameter in all the calls
1154: that passes cenvat accounting and register entries. this change is made from an extensible perspective of breakup
1155: - added the following procedures
1156: - get_vendor_changed_dtls : Retuns the changed excise vendor details as OUT Parameters
1157: - post_cenvat_processor : Updates JAI_RCV_CENVAT_CLAIMS, JAI_RCV_LINES tables with claim details
1158: - other_cenvat_rg_recording : Inserts a record into JAI_CMN_RG_OTHERS table with the parameters passed to the call
1159: - added the parameters p_process_special_reason and qty in PROCESS_TRANSACTION. These are used incase the accounting
1160: and rg entries should consider these values for TAX_BREAUP instead of main transaction values.
1161: These parameters are mainly added for RECEIPTS DEPLUG to support second Claim functionality of CGIN items
1626: lv_receive_part_ii_type := 'RG23C';
1627:
1628: -- Vijay Shankar for Bug#3940588. The same is coded at the end of procedure
1629: -- this is to increase the cenvat_claimed_amt to the tune of second 50% that is claimed now on RECEIVE transaction
1630: UPDATE JAI_RCV_CENVAT_CLAIMS
1631: SET cenvat_claimed_amt = nvl(cenvat_claimed_amt,0)
1632: + (r_half_tax.basic_excise +
1633: r_half_tax.addl_excise +
1634: r_half_tax.other_excise +
1970: ELSE
1971: p_cenvat_claimed_ptg := 100;
1972: END IF;
1973:
1974: -- CALL TO Post Processor updated claim related stuff in JAI_RCV_CENVAT_CLAIMS and JAI_RCV_LINES at RECEIVE trx level
1975: -- Vijay Shankar for Bug#3940588
1976: post_cenvat_processor(
1977: p_transaction_id => p_transaction_id,
1978: p_cenvat_claimed_ptg => p_cenvat_claimed_ptg,
5160: ) RETURN NUMBER IS
5161:
5162: CURSOR c_cenvat_claimed_ptg(cp_shipment_line_id IN NUMBER) IS
5163: SELECT nvl(cenvat_claimed_ptg,0)
5164: FROM JAI_RCV_CENVAT_CLAIMS
5165: WHERE shipment_line_id = cp_shipment_line_id;
5166:
5167: ln_cenvat_claimed_ptg NUMBER;
5168: lv_object_name CONSTANT VARCHAR2 (61) := 'jai_rcv_excise_processing_pkg.get_receive_claimed_ptg';