eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.IGS_EN_GEN_010 dependencies on IGS_AV_STND_UNIT

Line 54: -- IGS_AV_STND_UNIT_LVL_PKG (Bug# 2233334)

50: -- to table handler procedure calls as part of CCR - ENCR022.
51: --Nalin Kumar 28-Jan-2002 Added Procedure 'enrp_ins_sca_ukstat_trnsfr' and modified function enrp_ins_susa_trnsfr
52: -- procedure as pert of the HESA Intregation DLD (ENCR019). Bug# 2201753.
53: --prraj 21-Feb-2002 Added column QUAL_DETS_ID to the tbh calls of pkg
54: -- IGS_AV_STND_UNIT_LVL_PKG (Bug# 2233334)
55: --Added refernces to column ORG_UNIT_CD in call to IGS_EN_SU_ATTEMPT TBH call as a part of bug 1964697
56: --pmarada 24-Feb-2002 Added the copy-hesa_details Procedure, for the hesa requirment.
57: --Nishikant 03-May-2002 The Local procedure enrpl_copy_adm_unit_sets got modified to make Unit Sets Confirmed if
58: -- Program attempt got confirmed - due to the Enhancement Bug#2347141

Line 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.

57: --Nishikant 03-May-2002 The Local procedure enrpl_copy_adm_unit_sets got modified to make Unit Sets Confirmed if
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

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 7169: FROM igs_av_stnd_unit_all asu

7165: cp_exemption_institution_cd VARCHAR2
7166: ) IS
7167: SELECT asu.ROWID,
7168: asu.*
7169: FROM igs_av_stnd_unit_all asu
7170: WHERE asu.person_id = cp_person_id
7171: AND asu.as_course_cd = cp_course_cd
7172: AND asu.as_version_number = cp_version_number
7173: AND asu.exemption_institution_cd = cp_exemption_institution_cd

Line 7176: l_av_stnd_unit_id igs_av_stnd_unit.av_stnd_unit_id%TYPE;

7172: AND asu.as_version_number = cp_version_number
7173: AND asu.exemption_institution_cd = cp_exemption_institution_cd
7174: AND asu.s_adv_stnd_granting_status IN ('APPROVED', 'GRANTED');
7175: --
7176: l_av_stnd_unit_id igs_av_stnd_unit.av_stnd_unit_id%TYPE;
7177: --
7178: -- To get the Advance Standing Unit details records for the Destination Program.
7179: --
7180: CURSOR cur_dest_unit_dtls (

Line 7193: FROM igs_av_stnd_unit_all asu

7189: cp_tst_rslt_dtls_id NUMBER
7190: ) IS
7191: SELECT asu.ROWID,
7192: asu.*
7193: FROM igs_av_stnd_unit_all asu
7194: WHERE asu.person_id = cp_person_id
7195: AND asu.as_course_cd = cp_as_course_cd
7196: AND asu.as_version_number = cp_as_version_number
7197: AND asu.s_adv_stnd_type = cp_s_adv_stnd_type

Line 7204: l_dest_av_stnd_unit_id igs_av_stnd_unit.av_stnd_unit_id%TYPE;

7200: AND asu.exemption_institution_cd = cp_exemption_institution_cd
7201: AND (asu.unit_details_id = cp_unit_details_id
7202: OR asu.tst_rslt_dtls_id = cp_tst_rslt_dtls_id);
7203: --
7204: l_dest_av_stnd_unit_id igs_av_stnd_unit.av_stnd_unit_id%TYPE;
7205: rec_dest_unit_dtls cur_dest_unit_dtls%ROWTYPE;
7206: rec_dest_unit_dtls_found BOOLEAN;
7207: --
7208: -- To get the Advance Standing Basics Unit details records for the Source Program.

Line 7236: FROM igs_av_stnd_unit_lvl_all asule

7232: cp_exemption_institution_cd VARCHAR2
7233: ) IS
7234: SELECT asule.ROWID,
7235: asule.*
7236: FROM igs_av_stnd_unit_lvl_all asule
7237: WHERE asule.person_id = cp_person_id
7238: AND asule.as_course_cd = cp_course_cd
7239: AND asule.as_version_number = cp_version_number
7240: AND asule.exemption_institution_cd = cp_exemption_institution_cd

Line 7243: l_av_stnd_unit_lvl_id igs_av_stnd_unit_lvl.av_stnd_unit_lvl_id%TYPE;

7239: AND asule.as_version_number = cp_version_number
7240: AND asule.exemption_institution_cd = cp_exemption_institution_cd
7241: AND asule.s_adv_stnd_granting_status IN ('APPROVED', 'GRANTED');
7242: --
7243: l_av_stnd_unit_lvl_id igs_av_stnd_unit_lvl.av_stnd_unit_lvl_id%TYPE;
7244: --
7245: -- To get the Advance Standing Unit Level records for the Destination Program.
7246: --
7247: CURSOR cur_dest_unit_lvl_dtls (

Line 7261: FROM igs_av_stnd_unit_lvl_all asule

7257: cp_qual_dets_id NUMBER
7258: ) IS
7259: SELECT asule.ROWID,
7260: asule.*
7261: FROM igs_av_stnd_unit_lvl_all asule
7262: WHERE asule.person_id = cp_person_id
7263: AND asule.as_course_cd = cp_as_course_cd
7264: AND asule.as_version_number = cp_as_version_number
7265: AND asule.s_adv_stnd_type = cp_s_adv_stnd_type

Line 7273: l_dest_av_stnd_unit_lvl_id igs_av_stnd_unit_lvl.av_stnd_unit_lvl_id%TYPE;

7269: AND (asule.unit_details_id = cp_unit_details_id
7270: OR asule.tst_rslt_dtls_id = cp_tst_rslt_dtls_id
7271: OR asule.qual_dets_id = cp_qual_dets_id);
7272: --
7273: l_dest_av_stnd_unit_lvl_id igs_av_stnd_unit_lvl.av_stnd_unit_lvl_id%TYPE;
7274: rec_dest_unit_lvl_dtls cur_dest_unit_lvl_dtls%ROWTYPE;
7275: rec_dest_unit_lvl_dtls_found BOOLEAN;
7276: --
7277: -- To get the Advance Standing Basics Unit Level records for the Source Program.

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;

Line 7711: igs_av_stnd_unit_lvl_pkg.insert_row (

7707: NOT (rec_dest_unit_lvl_dtls_found))) THEN
7708: BEGIN
7709: l_rowid5 := NULL;
7710: l_av_stnd_unit_lvl_id := rec_unit_lvl_dtls.av_stnd_unit_lvl_id;
7711: igs_av_stnd_unit_lvl_pkg.insert_row (
7712: x_mode => 'R',
7713: x_rowid => l_rowid5,
7714: x_person_id => p_person_id,
7715: x_as_course_cd => p_course_cd_new,

Line 7746: g_module_head || 'adv_stand_trans.igs_av_stnd_unit_lvl_pkg_insert_exception',

7742: --
7743: IF (fnd_log.level_exception >= fnd_log.g_current_runtime_level) THEN
7744: fnd_log.string (
7745: fnd_log.level_exception,
7746: g_module_head || 'adv_stand_trans.igs_av_stnd_unit_lvl_pkg_insert_exception',
7747: 'Error:' || SQLERRM
7748: );
7749: END IF;
7750: RAISE;

Line 7776: g_module_head || 'adv_stand_trans.igs_av_stnd_unit_lvl_pkg_insert_exception',

7772: --
7773: IF (fnd_log.level_exception >= fnd_log.g_current_runtime_level) THEN
7774: fnd_log.string (
7775: fnd_log.level_exception,
7776: g_module_head || 'adv_stand_trans.igs_av_stnd_unit_lvl_pkg_insert_exception',
7777: 'Error:' || SQLERRM
7778: );
7779: END IF;
7780: RAISE;

Line 7788: igs_av_stnd_unit_lvl_pkg.update_row (

7784: ELSIF ((v_transfer_type = 'REVERSE_TRANSFER') AND
7785: (rec_dest_unit_lvl_dtls_found) AND
7786: (rec_dest_unit_lvl_dtls.s_adv_stnd_granting_status = 'TRANSFERRED')) THEN
7787: BEGIN
7788: igs_av_stnd_unit_lvl_pkg.update_row (
7789: x_mode => 'R',
7790: x_rowid => rec_dest_unit_lvl_dtls.ROWID,
7791: x_person_id => rec_dest_unit_lvl_dtls.person_id,
7792: x_as_course_cd => rec_dest_unit_lvl_dtls.as_course_cd,

Line 7821: g_module_head || 'adv_stand_trans.igs_av_stnd_unit_lvl_pkg_dest_update_exception',

7817: --
7818: IF (fnd_log.level_exception >= fnd_log.g_current_runtime_level) THEN
7819: fnd_log.string (
7820: fnd_log.level_exception,
7821: g_module_head || 'adv_stand_trans.igs_av_stnd_unit_lvl_pkg_dest_update_exception',
7822: 'Error:' || SQLERRM
7823: );
7824: END IF;
7825: RAISE;

Line 7835: igs_av_stnd_unit_lvl_pkg.update_row (

7831: v_unt_lvl_transfer_flag := 'N';
7832: END IF;
7833: BEGIN
7834: IF (v_unt_lvl_transfer_flag = 'Y') THEN
7835: igs_av_stnd_unit_lvl_pkg.update_row (
7836: x_mode => 'R',
7837: x_rowid => rec_unit_lvl_dtls.ROWID,
7838: x_person_id => rec_unit_lvl_dtls.person_id,
7839: x_as_course_cd => rec_unit_lvl_dtls.as_course_cd,

Line 7869: g_module_head || 'adv_stand_trans.igs_av_stnd_unit_lvl_pkg_src_update_exception',

7865: --
7866: IF (fnd_log.level_exception >= fnd_log.g_current_runtime_level) THEN
7867: fnd_log.string (
7868: fnd_log.level_exception,
7869: g_module_head || 'adv_stand_trans.igs_av_stnd_unit_lvl_pkg_src_update_exception',
7870: 'Error:' || SQLERRM
7871: );
7872: END IF;
7873: RAISE;