APPS.JAI_AR_RCTLA_TRIGGER_PKG dependencies on JAI_CMN_RG_23AC_I_TRXS

Line 2829: JAI_CMN_RG_23AC_I_TXNS_S is replaced by JAI_CMN_RG_23AC_I_TRXS_S

2825: 06-Jul-2005 Ramananda for bug#4477004. File Version: 116.4
2826: GL Sources and GL Categories got changed. Refer bug for the details
2827:
2828: 31 14-Jul-2005 rchandan for bug#4487676. File Version: 117.2
2829: JAI_CMN_RG_23AC_I_TXNS_S is replaced by JAI_CMN_RG_23AC_I_TRXS_S
2830:
2831: 32 26-Jul-2005 rallamse for bug#4510143 File Version 120.2
2832: Changed the legal_entity_id to get from function get_legal_entity_id.
2833: Replaced legal_entity_id with ln_legal_entity_id( holds value of get_legal_entity_id )

Line 3682: SELECT JAI_CMN_RG_23AC_I_TRXS_S.currval INTO v_part_i_register_id FROM dual; /* txns changed to trxs by rchandan for bug#4487676 */

3678: v_last_updated_by ,
3679: v_last_update_login
3680: );
3681:
3682: SELECT JAI_CMN_RG_23AC_I_TRXS_S.currval INTO v_part_i_register_id FROM dual; /* txns changed to trxs by rchandan for bug#4487676 */
3683:
3684: jai_om_rg_pkg.ja_in_rg23_part_II_entry(
3685: v_reg_code ,
3686: v_reg_type ,

Line 3713: SELECT JAI_CMN_RG_23AC_I_TRXS_S.currval INTO v_rg23_part_i_no FROM dual; /* txns changed to trxs by rchandan for bug# bug#4487676 */

3709: null ,
3710: null
3711: );
3712:
3713: SELECT JAI_CMN_RG_23AC_I_TRXS_S.currval INTO v_rg23_part_i_no FROM dual; /* txns changed to trxs by rchandan for bug# bug#4487676 */
3714:
3715: SELECT JAI_CMN_RG_23AC_II_TRXS_S.currval INTO v_rg23_part_ii_no FROM dual;
3716:
3717: UPDATE JAI_CMN_RG_23AC_I_TRXS

Line 3717: UPDATE JAI_CMN_RG_23AC_I_TRXS

3713: SELECT JAI_CMN_RG_23AC_I_TRXS_S.currval INTO v_rg23_part_i_no FROM dual; /* txns changed to trxs by rchandan for bug# bug#4487676 */
3714:
3715: SELECT JAI_CMN_RG_23AC_II_TRXS_S.currval INTO v_rg23_part_ii_no FROM dual;
3716:
3717: UPDATE JAI_CMN_RG_23AC_I_TRXS
3718: SET REGISTER_ID_PART_II = v_rg23_part_ii_no,
3719: charge_account_id = (
3720: SELECT
3721: charge_account_id

Line 3756: UPDATE JAI_CMN_RG_23AC_I_TRXS

3752: );
3753:
3754:
3755: SELECT JAI_CMN_RG_PLA_TRXS_S1.currval INTO v_pla_register_no FROM dual;
3756: UPDATE JAI_CMN_RG_23AC_I_TRXS
3757: SET REGISTER_ID_PART_II = v_pla_register_no,
3758: charge_account_id = (SELECT charge_account_id FROM JAI_CMN_RG_PLA_TRXS
3759: WHERE register_id = v_pla_register_no)
3760: WHERE register_id = v_rg23_part_i_no;