APPS.IGS_EN_GEN_010 dependencies on IGS_AV_STND_UNIT_PKG

Line 62: -- Modified the call to the igs_av_stnd_unit_pkg and igs_av_stnd_unit_lvl_pkg as per the bug# 2401170.

58: -- Program attempt got confirmed - due to the Enhancement Bug#2347141
59: --smadadli 14-may-2002 Modified procedures copy_hesa_details , enrp_ins_snew_prenrl , enrp_ins_sret_prenrl for bug#2350629
60: --pmarada 23 -May-2002 Modified the c_us_version_number cursor, to fetch the next year from the program offerring option.
61: --nalkumar 05-June-2002 Removed the referances of the igs_av_stnd_unit/unit_lvl_pkg.(PREV_UNIT_CD and TEST_DETAILS_ID) parameter.
62: -- Modified the call to the igs_av_stnd_unit_pkg and igs_av_stnd_unit_lvl_pkg as per the bug# 2401170.
63: --smaddali 12-jun-2002 bug 2391799 modified procedure enrpl_copy_adm_unit_sets
64: --Nishikant 07OCT2002 UK Enhancement Build - Enh Bug#2580731 - Added the parameter p_selection_date in the Function Enrp_Ins_Sret_Prenrl
65: --kkillams 16-06-2003 Three new parameters are added to the Enrp_Ins_Snew_Prenrl and Enrp_Ins_Sret_Prenrl functions
66: -- ENRP_INS_PRE_POS, ENRPL_CREATE_POS_SUA,ENRPL_COPY_ADM_SUA and ENRPL_COPY_PARAM_SUA procedures are modified as per TD

Line 7106: --pmarada 27-nov-2001 Added AV_STND_UNIT_ID column in Igs_Av_Stnd_Unit_Pkg.Insert_Row

7102: --Known limitations/enhancements and/or remarks:
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

Line 7440: igs_av_stnd_unit_pkg.insert_row (

7436: --
7437: BEGIN
7438: l_rowid2 := NULL;
7439: l_av_stnd_unit_id := rec_unit_dtls.av_stnd_unit_id;
7440: igs_av_stnd_unit_pkg.insert_row (
7441: x_mode => 'R',
7442: x_rowid => l_rowid2,
7443: x_person_id => p_person_id,
7444: x_as_course_cd => p_course_cd_new,

Line 7480: g_module_head || 'adv_stand_trans.igs_av_stnd_unit_pkg_insert_exception',

7476: --
7477: IF (fnd_log.level_exception >= fnd_log.g_current_runtime_level) THEN
7478: fnd_log.string (
7479: fnd_log.level_exception,
7480: g_module_head || 'adv_stand_trans.igs_av_stnd_unit_pkg_insert_exception',
7481: 'Error:' || SQLERRM
7482: );
7483: END IF;
7484: RAISE;

Line 7550: igs_av_stnd_unit_pkg.update_row (

7546: ELSIF ((v_transfer_type = 'REVERSE_TRANSFER') AND
7547: (rec_dest_unit_dtls_found) AND
7548: (rec_dest_unit_dtls.s_adv_stnd_granting_status = 'TRANSFERRED')) THEN
7549: BEGIN
7550: igs_av_stnd_unit_pkg.update_row (
7551: x_mode => 'R',
7552: x_rowid => rec_dest_unit_dtls.ROWID,
7553: x_person_id => rec_dest_unit_dtls.person_id,
7554: x_as_course_cd => rec_dest_unit_dtls.as_course_cd,

Line 7588: g_module_head || 'adv_stand_trans.igs_av_stnd_unit_pkg_dest_update_exception',

7584: --
7585: IF (fnd_log.level_exception >= fnd_log.g_current_runtime_level) THEN
7586: fnd_log.string (
7587: fnd_log.level_exception,
7588: g_module_head || 'adv_stand_trans.igs_av_stnd_unit_pkg_dest_update_exception',
7589: 'Error:' || SQLERRM
7590: );
7591: END IF;
7592: RAISE;

Line 7602: igs_av_stnd_unit_pkg.update_row (

7598: v_unt_transfer_flag := 'N';
7599: END IF;
7600: BEGIN
7601: IF (v_unt_transfer_flag = 'Y') THEN
7602: igs_av_stnd_unit_pkg.update_row (
7603: x_mode => 'R',
7604: x_rowid => rec_unit_dtls.ROWID,
7605: x_person_id => rec_unit_dtls.person_id,
7606: x_as_course_cd => rec_unit_dtls.as_course_cd,

Line 7641: g_module_head || 'adv_stand_trans.igs_av_stnd_unit_pkg_src_update_exception',

7637: --
7638: IF (fnd_log.level_exception >= fnd_log.g_current_runtime_level) THEN
7639: fnd_log.string (
7640: fnd_log.level_exception,
7641: g_module_head || 'adv_stand_trans.igs_av_stnd_unit_pkg_src_update_exception',
7642: 'Error:' || SQLERRM
7643: );
7644: END IF;
7645: RAISE;