DBA Data[Home] [Help]

APPS.JAI_RCV_TRX_PROCESSING_PKG dependencies on JAI_RCV_EXCISE_PROCESSING_PKG

Line 83: - Modified the condition which if satisfied makes a call to jai_rcv_excise_processing_pkg.process_transaction

79: - Calls to transaction_preprocessor and transaction_postprocessed are made to do processing required before and after
80: actual processing
81: - Changes in PROCESS_TRANSACTION procedure
82: - Opened up the code to execute procedure for all localization supported receiving transactions
83: - Modified the condition which if satisfied makes a call to jai_rcv_excise_processing_pkg.process_transaction
84: - Added p_process_special_reason, p_process_special_qty parameters in call to jai_rcv_excise_processing_pkg.process_transaction
85: - Modified POPULATE_DETAILS procedure to populate tax_transaction_id and third_party_flag values. Tax_Transaction_id is the
86: transaction_id related to parent transaction for which taxes are defaulted/attached. usually this is either RECEIVE or MATCH trx
87: - Also changes are made to update ja_in_rcv_transaction.transaction_type to RECEIVE incase of MATCH transaction

Line 84: - Added p_process_special_reason, p_process_special_qty parameters in call to jai_rcv_excise_processing_pkg.process_transaction

80: actual processing
81: - Changes in PROCESS_TRANSACTION procedure
82: - Opened up the code to execute procedure for all localization supported receiving transactions
83: - Modified the condition which if satisfied makes a call to jai_rcv_excise_processing_pkg.process_transaction
84: - Added p_process_special_reason, p_process_special_qty parameters in call to jai_rcv_excise_processing_pkg.process_transaction
85: - Modified POPULATE_DETAILS procedure to populate tax_transaction_id and third_party_flag values. Tax_Transaction_id is the
86: transaction_id related to parent transaction for which taxes are defaulted/attached. usually this is either RECEIVE or MATCH trx
87: - Also changes are made to update ja_in_rcv_transaction.transaction_type to RECEIVE incase of MATCH transaction
88: - Modifed VALIDATE_TRANSACTION to function properly. In this procedure different validations are applied that are

Line 536: Fix : Call to procedure jai_rcv_excise_processing_pkg.process_transaction is made even for a receipt

532: generated.
533:
534: 47. 03-Oct-2012 vkavulur Bug#13362352
535: Issue : RG IS NOT GETTING REVERSED FOR OSP ITEM RECEIPT ON DELIVER
536: Fix : Call to procedure jai_rcv_excise_processing_pkg.process_transaction is made even for a receipt
537: having destination type as 'SHOP FLOOR' to reverse the quantity in RG
538: 48. 07-nov-12 vkaranam for bug#14346451
539: Issue: RG registers are getting updated if the item is not excisable
540: fix :online_qty_flag is set depending on the item_excisable_flag

Line 599: r_tax jai_rcv_excise_processing_pkg.tax_breakup;

595: WHERE transaction_id = cp_transaction_id;
596:
597: r_trx c_trx%ROWTYPE;
598: r_base_trx c_base_trx%ROWTYPE;
599: r_tax jai_rcv_excise_processing_pkg.tax_breakup;
600:
601: ln_cenvat_amount NUMBER;
602: ln_other_cenvat_amt NUMBER;
603: lv_breakup_type VARCHAR2(10);

Line 659: jai_rcv_excise_processing_pkg.get_tax_amount_breakup(

655: IF r_trx.organization_type = 'T' THEN
656: lv_breakup_type := 'RG23D';
657: END IF;
658:
659: jai_rcv_excise_processing_pkg.get_tax_amount_breakup(
660: p_shipment_line_id => r_trx.shipment_line_id,
661: p_transaction_id => r_trx.transaction_id,
662: p_curr_conv_rate => r_trx.currency_conversion_rate,
663: pr_tax => r_tax,

Line 709: jai_rcv_excise_processing_pkg.other_cenvat_rg_recording(

705: );
706:
707: -- Vijay Shankar for Bug#3940588 EDUCATION CESS
708: IF r_tax.excise_edu_cess <> 0 THEN
709: jai_rcv_excise_processing_pkg.other_cenvat_rg_recording(
710: p_source_register => jai_constants.reg_receipt_cenvat,
711: p_source_register_id => r_trx.transaction_id,
712: p_tax_type => jai_constants.tax_type_exc_edu_cess,
713: p_credit => r_tax.excise_edu_cess,

Line 725: jai_rcv_excise_processing_pkg.other_cenvat_rg_recording(

721: RETURN;
722: END IF;
723: /*Added by kunkumar for forward porting bug#5989740, start*/
724: IF r_tax.sh_exc_edu_cess <> 0 THEN
725: jai_rcv_excise_processing_pkg.other_cenvat_rg_recording(
726: p_source_register => jai_constants.reg_receipt_cenvat,
727: p_source_register_id => r_trx.transaction_id,
728: p_tax_type => jai_constants.tax_type_sh_exc_edu_cess,
729: p_credit => r_tax.sh_exc_edu_cess,

Line 741: jai_rcv_excise_processing_pkg.other_cenvat_rg_recording(

737: RETURN;
738: END IF;
739:
740: IF r_tax.sh_cvd_edu_cess <> 0 THEN
741: jai_rcv_excise_processing_pkg.other_cenvat_rg_recording(
742: p_source_register => jai_constants.reg_receipt_cenvat,
743: p_source_register_id => r_trx.transaction_id,
744: p_tax_type => jai_constants.tax_type_sh_cvd_edu_cess,
745: p_credit => r_tax.sh_cvd_edu_cess,

Line 760: jai_rcv_excise_processing_pkg.other_cenvat_rg_recording(

756:
757:
758:
759: IF r_tax.cvd_edu_cess <> 0 THEN
760: jai_rcv_excise_processing_pkg.other_cenvat_rg_recording(
761: p_source_register => jai_constants.reg_receipt_cenvat,
762: p_source_register_id => r_trx.transaction_id,
763: p_tax_type => jai_constants.tax_type_cvd_edu_cess,
764: p_credit => r_tax.cvd_edu_cess,

Line 1026: r_tax jai_rcv_excise_processing_pkg.tax_breakup;

1022: lv_codepath VARCHAR2(1996);
1023: ln_processed_cnt NUMBER(10); --File.Sql.35 Cbabu := 0;
1024: ln_errored_cnt NUMBER(10); --File.Sql.35 Cbabu := 0;
1025:
1026: r_tax jai_rcv_excise_processing_pkg.tax_breakup;
1027: lv_breakup_type VARCHAR2(15);
1028:
1029: lv_ttype_correct JAI_RCV_TRANSACTIONS.transaction_type%type ;
1030: lv_ttype_deliver JAI_RCV_TRANSACTIONS.transaction_type%type ;

Line 1180: lv_process_special_reason := jai_rcv_excise_processing_pkg.second_50ptg_claim;

1176: END IF;
1177:
1178: IF lv_2nd_claim_flag = 'Y' THEN
1179: ln_qty_to_claim := r_receipt_cenvat_dtl.quantity_for_2nd_claim;
1180: lv_process_special_reason := jai_rcv_excise_processing_pkg.second_50ptg_claim;
1181: END IF;
1182:
1183: process_transaction(
1184: p_transaction_id => temp_rec.transaction_id,

Line 1285: jai_rcv_excise_processing_pkg.get_tax_amount_breakup(

1281: lv_breakup_type := 'RG23D';
1282: END IF;
1283:
1284: lv_codepath := jai_general_pkg.plot_codepath(21, lv_codepath);
1285: jai_rcv_excise_processing_pkg.get_tax_amount_breakup(
1286: p_shipment_line_id => loop_trx.shipment_line_id,
1287: p_transaction_id => loop_trx.transaction_id,
1288: p_curr_conv_rate => r_trx.currency_conversion_rate,
1289: pr_tax => r_tax, -- OUT Variable with Breakup

Line 2998: jai_rcv_excise_processing_pkg.rtv_processing_for_ssi(

2994: END IF;
2995:
2996: /* following procedure call is a replacement for SSI functinoality of JAINRTVN. This is created due to DFF removal */
2997: if lv_excise_processing_reqd = jai_constants.yes and rtv_rec.receipt_excise_rate <> rtv_rec.rtv_excise_rate then
2998: jai_rcv_excise_processing_pkg.rtv_processing_for_ssi(
2999: pn_transaction_id => rtv_rec.transaction_id,
3000: pv_codepath => lv_codepath,
3001: pv_process_status => lv_ssi_cenvat_rg_flag,
3002: pv_process_message => lv_ssi_cenvat_rg_message

Line 3314: jai_rcv_excise_processing_pkg.rg_i_entry(

3310: ELSE
3311: lv_qty_register_entry_type := 'Cr'; /* Reverted back the code for Bug #13110424 */
3312: END IF;
3313:
3314: jai_rcv_excise_processing_pkg.rg_i_entry(
3315: p_transaction_id => r_trx.transaction_id,
3316: pr_tax => NULL,
3317: p_register_entry_type => lv_qty_register_entry_type, /*bug 7662347*/
3318: p_register_id => ln_part_i_register_id,

Line 3335: jai_rcv_excise_processing_pkg.derive_cgin_scenario(

3331: FND_FILE.put_line(FND_FILE.log, 'Register Type:'||lv_register_type);
3332:
3333: -- to determine the way in which CGIN Items are Processed
3334: IF lv_register_type = 'C' THEN
3335: jai_rcv_excise_processing_pkg.derive_cgin_scenario(
3336: p_transaction_id => p_transaction_id,
3337: p_cgin_code => lv_cgin_code,
3338: p_process_status => lv_process_status,
3339: p_process_message => lv_process_message,

Line 3359: jai_rcv_excise_processing_pkg.rg23_part_i_entry(

3355: ELSE
3356: lv_qty_register_entry_type := 'Cr';
3357: END IF;
3358:
3359: jai_rcv_excise_processing_pkg.rg23_part_i_entry(
3360: p_transaction_id => r_trx.transaction_id,
3361: pr_tax => NULL,
3362: p_register_entry_type => lv_qty_register_entry_type, /*bug 7662347*/
3363: p_register_id => ln_part_i_register_id,

Line 3400: OR (p_process_special_reason = jai_rcv_excise_processing_pkg.second_50ptg_claim AND ln_cenvat_claimed_ptg < 100)

3396: )
3397: -- following condition will be satisfied during 2nd 50% claim of CGIN items when called from JAINMVAT form
3398: -- Vijay Shankar for Bug#3940588. RECEIPTS DEPLUG
3399: OR (p_called_from='JAINMVAT' AND r_trx.cenvat_rg_status='Y')
3400: OR (p_process_special_reason = jai_rcv_excise_processing_pkg.second_50ptg_claim AND ln_cenvat_claimed_ptg < 100)
3401: )
3402: THEN
3403:
3404: SAVEPOINT process_cenvat_rg_flag;

Line 3416: jai_rcv_excise_processing_pkg.process_transaction(

3412: -- this call passes the cenvat related accounting and register entries based on transaction type
3413: lv_statement_id := '8';
3414: p_codepath := jai_general_pkg.plot_codepath(9, p_codepath);
3415:
3416: jai_rcv_excise_processing_pkg.process_transaction(
3417: p_transaction_id => p_transaction_id,
3418: p_process_status => p_cenvat_rg_flag,
3419: p_cenvat_claimed_ptg => ln_cenvat_claimed_ptg,
3420: p_process_message => p_cenvat_rg_message,