APPS.JAI_AR_IMPORT_POPU_PKG dependencies on JAI_CMN_RG_23AC_I_TRXS

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

4175: v_last_updated_by ,
4176: v_last_update_login
4177: );
4178:
4179: 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 */
4180:
4181: jai_om_rg_pkg.ja_in_rg23_part_II_entry(
4182: v_reg_code ,
4183: v_reg_type ,

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

4206: null ,
4207: null
4208: );
4209:
4210: 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 */
4211:
4212: SELECT JAI_CMN_RG_23AC_II_TRXS_S.currval INTO v_rg23_part_ii_no FROM dual;
4213:
4214: UPDATE JAI_CMN_RG_23AC_I_TRXS

Line 4214: UPDATE JAI_CMN_RG_23AC_I_TRXS

4210: 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 */
4211:
4212: SELECT JAI_CMN_RG_23AC_II_TRXS_S.currval INTO v_rg23_part_ii_no FROM dual;
4213:
4214: UPDATE JAI_CMN_RG_23AC_I_TRXS
4215: SET REGISTER_ID_PART_II = v_rg23_part_ii_no,
4216: charge_account_id = (
4217: SELECT
4218: charge_account_id

Line 4253: UPDATE JAI_CMN_RG_23AC_I_TRXS

4249: );
4250:
4251:
4252: SELECT JAI_CMN_RG_PLA_TRXS_S1.currval INTO v_pla_register_no FROM dual;
4253: UPDATE JAI_CMN_RG_23AC_I_TRXS
4254: SET REGISTER_ID_PART_II = v_pla_register_no,
4255: charge_account_id = (SELECT charge_account_id FROM JAI_CMN_RG_PLA_TRXS
4256: WHERE register_id = v_pla_register_no)
4257: WHERE register_id = v_rg23_part_i_no;