186:
187: 17. 17-Jul-2005 Sanjikum for Bug#4495135, File Version 117.1
188: Following changes are done in procedure - populate_details
189: 1) Added the variable - ln_tax_apportion_factor and populated the same using - get_apportion_factor(p_transaction_id)
190: 2) Added the call to jai_rcv_transactions_pkg.update_row to update jai_rcv_transactions.tax_apportion_factor
191:
192: 18. 27/07/2005 Ramananda for Bug#4516577, Version 120.2
193: Problem
194: -------
2590: end if;
2591: end if;
2592:
2593: lv_statement_id := '31.1';
2594: jai_rcv_transactions_pkg.update_attributes(
2595: p_transaction_id => rtv_rec.transaction_id,
2596: p_attribute1 => lv_excise_inv_gen_action,
2597: p_attribute2 => lv_vat_inv_gen_action
2598: );
3039: p_codepath := jai_general_pkg.plot_codepath(18, p_codepath);
3040:
3041: IF p_simulate_flag = 'N' THEN
3042:
3043: jai_rcv_transactions_pkg.update_process_flags(
3044: p_transaction_id => p_transaction_id,
3045: p_process_flag => p_process_flag,
3046: p_process_message => p_process_message,
3047: p_cenvat_rg_flag => p_cenvat_rg_flag,
3472: FND_FILE.put_line(FND_FILE.log, '... RecNum:'||r_shp_hdr_dtls.receipt_num ||',p_cenvat_amount:'||ln_cenvat_amount );
3473: END IF;
3474:
3475: p_codepath := jai_general_pkg.plot_codepath(17, p_codepath);
3476: jai_rcv_transactions_pkg.update_row(
3477: p_transaction_id => p_transaction_id,
3478: p_parent_transaction_type => r_parent_base_trx.transaction_type,
3479: p_receipt_num => r_shp_hdr_dtls.receipt_num,
3480: p_inventory_item_id => r_shp_line_dtls.item_id,
3509: p_codepath := jai_general_pkg.plot_codepath(19, p_codepath);
3510: --This update can't be merged with the above, as get_apportion_factor uses the column tax_transaction_id
3511: --which is updated only in the above update
3512:
3513: jai_rcv_transactions_pkg.update_row(
3514: p_transaction_id => p_transaction_id,
3515: p_tax_apportion_factor => ln_tax_apportion_factor
3516: );
3517: --End Added by Sanjikum for Bug#4495135
4281: FETCH c_excise_invoice_no INTO r_exc_inv_no;
4282: CLOSE c_excise_invoice_no;
4283:
4284: -- this is to update excise invoice no in case of Offline Claim or somehow excise invoice is not update in POPULATE_DETAILS
4285: jai_rcv_transactions_pkg.update_excise_invoice_no(
4286: p_transaction_id => p_transaction_id,
4287: p_excise_invoice_no => r_exc_inv_no.excise_invoice_no,
4288: p_excise_invoice_date => r_exc_inv_no.excise_invoice_date
4289: );
4387: IF p_simulate_flag = 'N' THEN
4388: lv_codepath := jai_general_pkg.plot_codepath(43, lv_codepath);
4389: lv_statement_id := '43';
4390: /* Call to update the Flag values as the validation is completed */
4391: jai_rcv_transactions_pkg.update_process_flags(
4392: p_transaction_id => p_transaction_id,
4393: p_process_flag => p_process_flag,
4394: p_process_message => p_process_message,
4395: p_cenvat_rg_flag => p_cenvat_rg_flag,
4411: IF ( Check_57F4_transaction( p_transaction_id ) = 'YES' ) THEN
4412: lv_excise_inv_gen_action := INV_GEN_STATUS_PENDING;
4413: END IF ;
4414:
4415: jai_rcv_transactions_pkg.update_attributes(
4416: p_transaction_id => p_transaction_id,
4417: p_attribute1 => lv_excise_inv_gen_action,
4418: p_attribute2 => lv_vat_inv_gen_action
4419: );