[Home] [Help]
1370: start additions by sriram - bug# 3607101
1371: */
1372: cursor c_ont_source_code is
1373: select FND_PROFILE.VALUE('ONT_SOURCE_CODE')
1374: from dual;
1375: v_ont_source_code ra_interface_lines_all.interface_line_context%type;
1376: /*
1377: ends here additions by sriram -bug#3607101
1378: */
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 ,
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
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
3718: SET REGISTER_ID_PART_II = v_rg23_part_ii_no,
3719: charge_account_id = (
3751: v_last_update_login
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)
4657: start additions by sriram - bug#3680721
4658: */
4659: cursor c_ont_source_code is
4660: select FND_PROFILE.VALUE('ONT_SOURCE_CODE')
4661: from dual;
4662: v_ont_source_code ra_interface_lines_all.interface_line_context%type;
4663: /*
4664: ends here additions by sriram -bug#3680721
4665: */