[Home] [Help]
7103: --
7104: --Change History:
7105: --Who When What
7106: --pmarada 27-nov-2001 Added AV_STND_UNIT_ID column in Igs_Av_Stnd_Unit_Pkg.Insert_Row
7107: -- Added AV_STND_UNIT_ID column in Igs_Av_Std_Unt_basis_Pkg.Insert_Row
7108: -- and obsolated some columns
7109: -- Added AV_STND_UNIT_LVL_ID column in IGS_AV_STD_ULVLBASIS_PKG.Insert_Row
7110: -- and obsolated some columns
7111: -- Added AV_STND_UNIT_ID column in Igs_Av_Stnd_alt_unit_Pkg.Insert_Row
7110: -- and obsolated some columns
7111: -- Added AV_STND_UNIT_ID column in Igs_Av_Stnd_alt_unit_Pkg.Insert_Row
7112: -- and obsolated some columns
7113: --rvivekan 10-dec-2002 Obsoleted column credit_percentage as a part of bug#3270446
7114: --ptandon 11-Dec-2003 Modified calls to Igs_Av_Std_Unt_Basis_Pkg.Insert_Row,
7115: -- Igs_Av_Stnd_Alt_Unit_Pkg.Insert_Row and Igs_Av_Std_Ulvlbasis_Pkg.Insert_Row
7116: -- to pass new value for Advanced Standing Unit ID as part of Bug# 3271754.
7117: --ptandon 23-Feb-2004 Put the cursor cur_adv_stnd in a cursor FOR LOOP so that transfer records
7118: -- are created in igs_av_adv_standing_all table for all institutions.
7490: FETCH cur_unit_bas_dtls INTO rec_unit_bas_dtls;
7491: IF cur_unit_bas_dtls%FOUND THEN
7492: BEGIN
7493: l_rowid3 := NULL;
7494: igs_av_std_unt_basis_pkg.insert_row (
7495: x_mode => 'R',
7496: x_rowid => l_rowid3,
7497: x_av_stnd_unit_id => rec_unit_dtls.av_stnd_unit_id,
7498: x_basis_course_type => rec_unit_bas_dtls.basis_course_type,
7505: --
7506: IF (fnd_log.level_exception >= fnd_log.g_current_runtime_level) THEN
7507: fnd_log.string (
7508: fnd_log.level_exception,
7509: g_module_head || 'adv_stand_trans.igs_av_std_unt_basis_pkg_insert_exception',
7510: 'Error:' || SQLERRM
7511: );
7512: END IF;
7513: RAISE;