APPS.JAI_AR_RCTLA_TRIGGER_PKG dependencies on JAI_CMN_RG_23AC_I_TRXS

Line 2619: JAI_CMN_RG_23AC_I_TXNS_S is replaced by JAI_CMN_RG_23AC_I_TRXS_S

2615: 06-Jul-2005 Ramananda for bug#4477004. File Version: 116.4
2616: GL Sources and GL Categories got changed. Refer bug for the details
2617:
2618: 31 14-Jul-2005 rchandan for bug#4487676. File Version: 117.2
2619: JAI_CMN_RG_23AC_I_TXNS_S is replaced by JAI_CMN_RG_23AC_I_TRXS_S
2620:
2621: 32 26-Jul-2005 rallamse for bug#4510143 File Version 120.2
2622: Changed the legal_entity_id to get from function get_legal_entity_id.
2623: Replaced legal_entity_id with ln_legal_entity_id( holds value of get_legal_entity_id )

Line 3421: 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 */

3417: v_last_updated_by ,
3418: v_last_update_login
3419: );
3420:
3421: 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 */
3422:
3423: jai_om_rg_pkg.ja_in_rg23_part_II_entry(
3424: v_reg_code ,
3425: v_reg_type ,

Line 3452: 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 */

3448: null ,
3449: null
3450: );
3451:
3452: 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 */
3453:
3454: SELECT JAI_CMN_RG_23AC_II_TRXS_S.currval INTO v_rg23_part_ii_no FROM dual;
3455:
3456: UPDATE JAI_CMN_RG_23AC_I_TRXS

Line 3456: UPDATE JAI_CMN_RG_23AC_I_TRXS

3452: 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 */
3453:
3454: SELECT JAI_CMN_RG_23AC_II_TRXS_S.currval INTO v_rg23_part_ii_no FROM dual;
3455:
3456: UPDATE JAI_CMN_RG_23AC_I_TRXS
3457: SET REGISTER_ID_PART_II = v_rg23_part_ii_no,
3458: charge_account_id = (
3459: SELECT
3460: charge_account_id

Line 3495: UPDATE JAI_CMN_RG_23AC_I_TRXS

3491: );
3492:
3493:
3494: SELECT JAI_CMN_RG_PLA_TRXS_S1.currval INTO v_pla_register_no FROM dual;
3495: UPDATE JAI_CMN_RG_23AC_I_TRXS
3496: SET REGISTER_ID_PART_II = v_pla_register_no,
3497: charge_account_id = (SELECT charge_account_id FROM JAI_CMN_RG_PLA_TRXS
3498: WHERE register_id = v_pla_register_no)
3499: WHERE register_id = v_rg23_part_i_no;