APPS.IGS_EN_GEN_010 dependencies on IGS_AV_ADV_STANDING

Line 7118: -- are created in igs_av_adv_standing_all table for all institutions.

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
7120: -- exemption_institution_cd parameter so that only the child records
7121: -- corresponding to current parent record in igs_av_adv_standing_all table
7122: -- are selected. Modified the cursors cur_unit_bas_dtls, cur_alt_unit_dtls

Line 7121: -- corresponding to current parent record in igs_av_adv_standing_all table

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
7120: -- exemption_institution_cd parameter so that only the child records
7121: -- corresponding to current parent record in igs_av_adv_standing_all table
7122: -- are selected. Modified the cursors cur_unit_bas_dtls, cur_alt_unit_dtls
7123: -- and cur_unit_lvl_bas_dtls to pass correct foreign key. Bug# 3461036.
7124: -------------------------------------------------------------------------------------------------
7125: --

Line 7134: FROM igs_av_adv_standing

7130: -- Cursor to get Exemption_Institution_Cd of the parent Program.
7131: --
7132: CURSOR cur_adv_stnd (cp_person_id NUMBER, cp_course_cd VARCHAR2, cp_version_number NUMBER) IS
7133: SELECT exemption_institution_cd
7134: FROM igs_av_adv_standing
7135: WHERE person_id = cp_person_id
7136: AND course_cd = cp_course_cd
7137: AND version_number = cp_version_number;
7138: --

Line 7151: FROM igs_av_adv_standing avs

7147: cp_exemption_institution_cd VARCHAR2
7148: ) IS
7149: SELECT avs.ROWID,
7150: avs.*
7151: FROM igs_av_adv_standing avs
7152: WHERE avs.person_id = cp_person_id
7153: AND avs.course_cd = cp_course_cd_new
7154: AND avs.version_number = cp_version_number_new
7155: AND avs.exemption_institution_cd = cp_exemption_institution_cd;

Line 7353: igs_av_adv_standing_pkg.insert_row (

7349: --
7350: IF (v_transfer_type = 'NORMAL_TRANSFER') THEN
7351: BEGIN
7352: l_rowid1 := NULL;
7353: igs_av_adv_standing_pkg.insert_row (
7354: x_rowid => l_rowid1,
7355: x_person_id => p_person_id,
7356: x_course_cd => p_course_cd_new,
7357: x_version_number => p_version_number_new,

Line 7371: g_module_head || 'adv_stand_trans.igs_av_adv_standing_pkg_insert_exception',

7367: --
7368: IF (fnd_log.level_exception >= fnd_log.g_current_runtime_level) THEN
7369: fnd_log.string (
7370: fnd_log.level_exception,
7371: g_module_head || 'adv_stand_trans.igs_av_adv_standing_pkg_insert_exception',
7372: 'Error:' || SQLERRM
7373: );
7374: END IF;
7375: RAISE;