[Home] [Help]
3079: SELECT NVL(opening_balance,0),NVL(closing_balance,0),
3080: NVL(basic_opening_balance,0) ,NVL(basic_closing_balance,0),
3081: NVL(additional_opening_balance,0) ,NVL(additional_closing_balance,0),
3082: NVL(other_opening_balance,0), NVL(other_closing_balance,0)
3083: FROM JAI_CMN_RG_PLA_TRXS
3084: WHERE organization_id = p_org_id AND
3085: location_id = p_location_id AND
3086: slno = p_previous_serial_no AND
3087: fin_year = p_fin_year;
3103: WHERE A.site_use_id = p_customer_site_id);
3104:
3105: CURSOR serial_no_cur IS
3106: SELECT NVL(MAX(slno),0) , NVL(MAX(slno),0) + 1
3107: FROM JAI_CMN_RG_PLA_TRXS
3108: WHERE organization_id = p_org_id AND
3109: location_id = p_location_id AND
3110: fin_year = p_fin_year;
3111:
3156: */
3157: CURSOR cur_get_pla_reg_id
3158: IS
3159: SELECT
3160: jai_cmn_rg_pla_trxs_s1.nextval
3161: FROM
3162: dual;
3163:
3164: ln_register_id JAI_CMN_RG_PLA_TRXS.REGISTER_ID%TYPE;
3160: jai_cmn_rg_pla_trxs_s1.nextval
3161: FROM
3162: dual;
3163:
3164: ln_register_id JAI_CMN_RG_PLA_TRXS.REGISTER_ID%TYPE;
3165:
3166: lv_object_name CONSTANT VARCHAR2 (61) := 'jai_om_rg_pkg.ja_in_pla_entry';
3167: --Added by Xiao for Open Interface ER bug#11683927 on 03-Mar-2011, begin
3168: --------------------------------------------------------------------------------------
3387: CLOSE cur_get_pla_reg_id ;
3388:
3389: IF v_register_code ='EXPORT_EXCISE' AND v_export_oriented_unit='Y' THEN
3390:
3391: fnd_file.put_line(fnd_file.log, '15 before insert into update into JAI_CMN_RG_PLA_TRXS , slno ' || v_serial_no
3392: ||' ,register_id ->' || ln_register_id
3393: ||' ,organization_id ->' || p_org_id
3394: ||' ,location_id ->' || p_location_id
3395: ||' ,inventory_item_id ->' || p_inventory_item_id
3426:
3427:
3428: /* Modified by Ramananda for removal of SQL LITERALs :bug#4428980*/
3429:
3430: INSERT INTO JAI_CMN_RG_PLA_TRXS(register_id,
3431: slno,
3432: organization_id,
3433: location_id,
3434: inventory_item_id,
3498: v_other_opening_balance,
3499: v_other_closing_balance
3500: ) returning register_id into ln_register_id;
3501:
3502: fnd_file.put_line(fnd_file.log, '16 after insert into JAI_CMN_RG_PLA_TRXS');
3503:
3504: v_excise_amount := NVL(p_dr_basic_ed,0) + NVL(p_dr_additional_ed,0) + NVL(p_dr_other_ed,0);
3505:
3506: UPDATE JAI_CMN_RG_BALANCES
3511: WHERE organization_id = p_org_id
3512: AND location_id = p_location_id;
3513: fnd_file.put_line(fnd_file.log, '17 after update into JAI_CMN_RG_BALANCES');
3514: ELSE
3515: fnd_file.put_line(fnd_file.log, '18 before insert into update into JAI_CMN_RG_PLA_TRXS , slno ' || v_serial_no
3516: ||' , register_id ->' || ln_register_id
3517: ||' , organization_id ->' || p_org_id
3518: ||' , location_id ->' || p_location_id
3519: ||' , inventory_item_id ->' || p_inventory_item_id
3542: ||' , last_updated_by ->' || p_last_updated_by
3543: );
3544:
3545: /* Modified by Ramananda for removal of SQL LITERALs :bug#4428980*/
3546: INSERT INTO JAI_CMN_RG_PLA_TRXS(
3547: register_id,
3548: slno,
3549: organization_id,
3550: location_id,
3603: p_last_update_date,
3604: p_last_updated_by
3605: ) returning register_id into ln_register_id;
3606:
3607: fnd_file.put_line(fnd_file.log, '19 after insert into JAI_CMN_RG_PLA_TRXS');
3608:
3609: v_excise_amount := NVL(p_dr_basic_ed,0) + NVL(p_dr_additional_ed,0) + NVL(p_dr_other_ed,0);
3610:
3611: UPDATE JAI_CMN_RG_BALANCES
3683: );
3684: Fnd_File.PUT_LINE(Fnd_File.LOG, 'after calling ja_in_cess_register_entries procedure');
3685:
3686:
3687: update JAI_CMN_RG_PLA_TRXS
3688: set other_tax_debit = ln_cess_amount + ln_sh_cess_amount -- Date 04/06/2007 by Sacsethi for bug 6109941
3689: where register_id = ln_register_id;
3690:
3691: EXCEPTION