APPS.JAI_OM_RG_PKG dependencies on JAI_CMN_RG_23AC_II_TRXS

Line 850: with the way JAI_CMN_RG_23AC_II_TRXS works.

846:
847: Code changes done in the package include calculating the cess amount for the current customer trx line id.
848:
849: Code changes done in the trigger include sending the customer trx line id when pla is hit . This is inline
850: with the way JAI_CMN_RG_23AC_II_TRXS works.
851:
852: Dependency Due to this bug:-
853: jai_jai_t.sql (120.1)
854: 2 15-jul-2009 vkaranam for bug#8679064,file version 120.8.12000000.10

Line 914: p_register_id JAI_CMN_RG_23AC_II_TRXS.register_id%type ,

910: end ja_in_ar_cess_register_entries;
911:
912: /**********************************************************************************************************************/
913: procedure ja_in_cess_register_entries(
914: p_register_id JAI_CMN_RG_23AC_II_TRXS.register_id%type ,
915: p_register_type varchar2 ,
916: p_inv_orgn_id JAI_CMN_INVENTORY_ORGS.organization_id%type ,
917: p_je_source_name gl_interface.USER_JE_SOURCE_NAME%type ,
918: p_je_category_name gl_interface.USER_JE_CATEGORY_NAME%type ,

Line 2590: FROM JAI_CMN_RG_23AC_II_TRXS

2586: ln_sh_cess_amount number;/*Bug 5989740 bduvarag*/
2587:
2588: CURSOR balance_cur(p_previous_serial_no IN NUMBER) IS
2589: SELECT NVL(opening_balance,0),NVL(closing_balance,0)
2590: FROM JAI_CMN_RG_23AC_II_TRXS
2591: WHERE organization_id = p_org_id AND
2592: location_id = p_location_id AND
2593: slno = p_previous_serial_no AND
2594: register_type = p_register_type AND

Line 2611: FROM JAI_CMN_RG_23AC_II_TRXS

2607: location_id = p_location_id;
2608:
2609: CURSOR serial_no_cur IS
2610: SELECT NVL(MAX(slno),0) , NVL(MAX(slno),0) + 1
2611: FROM JAI_CMN_RG_23AC_II_TRXS
2612: WHERE organization_id = p_org_id AND
2613: location_id = p_location_id AND
2614: fin_year = p_fin_year AND
2615: register_type = p_register_type;

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

2808: END IF;
2809: END IF;
2810:
2811: END IF;
2812: Fnd_File.PUT_LINE(Fnd_File.LOG, 'before insert into JAI_CMN_RG_23AC_II_TRXS');
2813: --Added by Xiao for Open Interface ER bug#11683927 on 03-Mar-2011, begin
2814: --------------------------------------------------------------------------------------
2815: /*
2816: OPEN get_external_flag_cur;

Line 2850: select JAI_CMN_RG_23AC_II_TRXS_S.NEXTVAL

2846: END IF ; */--Comments by zhiwei for Bug#12537533
2847: --------------------------------------------------------------------------------------
2848: --Added by Xiao for Open Interface ER bug#11683927 on 03-Mar-2011, end
2849:
2850: select JAI_CMN_RG_23AC_II_TRXS_S.NEXTVAL
2851: into ln_register_id
2852: from dual;
2853:
2854: INSERT INTO JAI_CMN_RG_23AC_II_TRXS (register_id,

Line 2854: INSERT INTO JAI_CMN_RG_23AC_II_TRXS (register_id,

2850: select JAI_CMN_RG_23AC_II_TRXS_S.NEXTVAL
2851: into ln_register_id
2852: from dual;
2853:
2854: INSERT INTO JAI_CMN_RG_23AC_II_TRXS (register_id,
2855: fin_year,
2856: slno,
2857: inventory_item_id,
2858: organization_id,

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

2910: p_last_updated_by,
2911: p_remarks
2912: );
2913:
2914: Fnd_File.PUT_LINE(Fnd_File.LOG, 'after insert into JAI_CMN_RG_23AC_II_TRXS');
2915: -- Code has been modified here by Aparajita on 08/03/2002 for bug # 2496388
2916:
2917:
2918: IF p_register_code <>'BOND_REG' THEN

Line 2983: update JAI_CMN_RG_23AC_II_TRXS

2979: P_REFERENCE_25 => P_REF_25 ,
2980: P_REFERENCE_26 => P_REF_26
2981: );
2982:
2983: update JAI_CMN_RG_23AC_II_TRXS
2984: set other_tax_debit = ln_cess_amount + ln_sh_cess_amount/*Bug 5989740 bduvarag*/
2985: where register_id = ln_register_id;
2986:
2987: END IF;