APPS.IGS_EN_GEN_010 dependencies on IGS_AV_STND_ALT_UNIT_PKG

Line 7111: -- Added AV_STND_UNIT_ID column in Igs_Av_Stnd_alt_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
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

Line 7115: -- Igs_Av_Stnd_Alt_Unit_Pkg.Insert_Row and Igs_Av_Std_Ulvlbasis_Pkg.Insert_Row

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.
7119: -- Also modified the cursors cur_unit_dtls and cur_unit_lvl_dtls to pass

Line 7524: igs_av_stnd_alt_unit_pkg.insert_row (

7520: IF rec_unit_dtls.s_adv_stnd_recognition_type = 'PRECLUSION' THEN
7521: FOR rec_alt_unit_dtls IN cur_alt_unit_dtls (l_av_stnd_unit_id) LOOP
7522: BEGIN
7523: l_rowid4 := NULL;
7524: igs_av_stnd_alt_unit_pkg.insert_row (
7525: x_mode => 'R',
7526: x_rowid => l_rowid4,
7527: x_av_stnd_unit_id => rec_unit_dtls.av_stnd_unit_id,
7528: x_alt_unit_cd => rec_alt_unit_dtls.alt_unit_cd,

Line 7538: g_module_head || 'adv_stand_trans.igs_av_stnd_alt_unit_pkg_insert_exception',

7534: --
7535: IF (fnd_log.level_exception >= fnd_log.g_current_runtime_level) THEN
7536: fnd_log.string (
7537: fnd_log.level_exception,
7538: g_module_head || 'adv_stand_trans.igs_av_stnd_alt_unit_pkg_insert_exception',
7539: 'Error:' || SQLERRM
7540: );
7541: END IF;
7542: RAISE;