APPS.JAI_OM_RG_PKG dependencies on JAI_CMN_RG_23AC_II_TRXS

Line 810: with the way JAI_CMN_RG_23AC_II_TRXS works.

806:
807: Code changes done in the package include calculating the cess amount for the current customer trx line id.
808:
809: Code changes done in the trigger include sending the customer trx line id when pla is hit . This is inline
810: with the way JAI_CMN_RG_23AC_II_TRXS works.
811:
812: Dependency Due to this bug:-
813: jai_jai_t.sql (120.1)
814:

Line 868: p_register_id JAI_CMN_RG_23AC_II_TRXS.register_id%type ,

864: end ja_in_ar_cess_register_entries;
865:
866: /**********************************************************************************************************************/
867: procedure ja_in_cess_register_entries(
868: p_register_id JAI_CMN_RG_23AC_II_TRXS.register_id%type ,
869: p_register_type varchar2 ,
870: p_inv_orgn_id JAI_CMN_INVENTORY_ORGS.organization_id%type ,
871: p_je_source_name gl_interface.USER_JE_SOURCE_NAME%type ,
872: p_je_category_name gl_interface.USER_JE_CATEGORY_NAME%type ,

Line 2425: FROM JAI_CMN_RG_23AC_II_TRXS

2421: ln_sh_cess_amount number;/*Bug 5989740 bduvarag*/
2422:
2423: CURSOR balance_cur(p_previous_serial_no IN NUMBER) IS
2424: SELECT NVL(opening_balance,0),NVL(closing_balance,0)
2425: FROM JAI_CMN_RG_23AC_II_TRXS
2426: WHERE organization_id = p_org_id AND
2427: location_id = p_location_id AND
2428: slno = p_previous_serial_no AND
2429: register_type = p_register_type AND

Line 2446: FROM JAI_CMN_RG_23AC_II_TRXS

2442: location_id = p_location_id;
2443:
2444: CURSOR serial_no_cur IS
2445: SELECT NVL(MAX(slno),0) , NVL(MAX(slno),0) + 1
2446: FROM JAI_CMN_RG_23AC_II_TRXS
2447: WHERE organization_id = p_org_id AND
2448: location_id = p_location_id AND
2449: fin_year = p_fin_year AND
2450: register_type = p_register_type;

Line 2617: Fnd_File.PUT_LINE(Fnd_File.LOG, 'before insert into JAI_CMN_RG_23AC_II_TRXS');

2613: END IF;
2614: END IF;
2615:
2616: END IF;
2617: Fnd_File.PUT_LINE(Fnd_File.LOG, 'before insert into JAI_CMN_RG_23AC_II_TRXS');
2618:
2619: select JAI_CMN_RG_23AC_II_TRXS_S.NEXTVAL
2620: into ln_register_id
2621: from dual;

Line 2619: select JAI_CMN_RG_23AC_II_TRXS_S.NEXTVAL

2615:
2616: END IF;
2617: Fnd_File.PUT_LINE(Fnd_File.LOG, 'before insert into JAI_CMN_RG_23AC_II_TRXS');
2618:
2619: select JAI_CMN_RG_23AC_II_TRXS_S.NEXTVAL
2620: into ln_register_id
2621: from dual;
2622:
2623: INSERT INTO JAI_CMN_RG_23AC_II_TRXS (register_id,

Line 2623: INSERT INTO JAI_CMN_RG_23AC_II_TRXS (register_id,

2619: select JAI_CMN_RG_23AC_II_TRXS_S.NEXTVAL
2620: into ln_register_id
2621: from dual;
2622:
2623: INSERT INTO JAI_CMN_RG_23AC_II_TRXS (register_id,
2624: fin_year,
2625: slno,
2626: inventory_item_id,
2627: organization_id,

Line 2683: Fnd_File.PUT_LINE(Fnd_File.LOG, 'after insert into JAI_CMN_RG_23AC_II_TRXS');

2679: p_last_updated_by,
2680: p_remarks
2681: );
2682:
2683: Fnd_File.PUT_LINE(Fnd_File.LOG, 'after insert into JAI_CMN_RG_23AC_II_TRXS');
2684: -- Code has been modified here by Aparajita on 08/03/2002 for bug # 2496388
2685:
2686: IF p_register_code <>'BOND_REG' THEN
2687:

Line 2751: update JAI_CMN_RG_23AC_II_TRXS

2747: P_REFERENCE_25 => P_REF_25 ,
2748: P_REFERENCE_26 => P_REF_26
2749: );
2750:
2751: update JAI_CMN_RG_23AC_II_TRXS
2752: set other_tax_debit = ln_cess_amount + ln_sh_cess_amount/*Bug 5989740 bduvarag*/
2753: where register_id = ln_register_id;
2754:
2755: END IF;