[Home] [Help]
1299: start additions by sriram - bug# 3607101
1300: */
1301: cursor c_ont_source_code is
1302: select FND_PROFILE.VALUE('ONT_SOURCE_CODE')
1303: from dual;
1304: v_ont_source_code ra_interface_lines_all.interface_line_context%type;
1305: /*
1306: ends here additions by sriram -bug#3607101
1307: */
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 ,
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
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
3457: SET REGISTER_ID_PART_II = v_rg23_part_ii_no,
3458: charge_account_id = (
3490: v_last_update_login
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)
4326: start additions by sriram - bug#3680721
4327: */
4328: cursor c_ont_source_code is
4329: select FND_PROFILE.VALUE('ONT_SOURCE_CODE')
4330: from dual;
4331: v_ont_source_code ra_interface_lines_all.interface_line_context%type;
4332: /*
4333: ends here additions by sriram -bug#3680721
4334: */