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_AD_GEN_002 dependencies on IGS_AD_GEN_007

Line 2579: v_s_adm_appl_status := IGS_AD_GEN_007.ADMP_GET_SAAS(p_adm_appl_status);

2575: -- v_exit_loop NUMBER DEFAULT 0;
2576: v_s_adm_offer_dfrmnt_status igs_ad_ofrdfrmt_stat.s_adm_offer_dfrmnt_status%TYPE;
2577: BEGIN
2578: -- Determine the system admission application status.
2579: v_s_adm_appl_status := IGS_AD_GEN_007.ADMP_GET_SAAS(p_adm_appl_status);
2580: -- Derive the admission application status.
2581: IF v_s_adm_appl_status IN (
2582: cst_received,
2583: cst_withdrawn,

Line 2603: v_s_appl_inst_stat := NVL(IGS_AD_GEN_007.ADMP_GET_SAAS(v_aca_rec.appl_inst_status),'-1');

2599: v_s_adm_offer_resp_status := IGS_AD_GEN_008.ADMP_GET_SAORS(
2600: v_aca_rec.adm_offer_resp_status);
2601: v_s_adm_offer_dfrmnt_status := IGS_AD_GEN_008.ADMP_GET_SAODS(
2602: v_aca_rec.adm_offer_dfrmnt_status);
2603: v_s_appl_inst_stat := NVL(IGS_AD_GEN_007.ADMP_GET_SAAS(v_aca_rec.appl_inst_status),'-1');
2604: -- Check if the outcome of the admission course
2605: -- application instance is complete or has been resolved.
2606: IF NOT( v_s_adm_outcome_status IN (cst_cancelled, cst_voided, cst_withdrawn,cst_no_quota, cst_rejected)
2607: OR

Line 3156: IF NVL(IGS_AD_GEN_007.ADMP_GET_SAAS(l_appl_inst_status),'-1') = cst_withdrawn THEN

3152:
3153: IF (p_nominated_course_cd IS NOT NULL and p_sequence_number IS NOT NULL)
3154: THEN
3155:
3156: IF NVL(IGS_AD_GEN_007.ADMP_GET_SAAS(l_appl_inst_status),'-1') = cst_withdrawn THEN
3157: fnd_message.set_name('IGS','IGS_AD_APPL_INST_WITHD');
3158: igs_ge_msg_stack.add;
3159: app_exception.raise_exception; -- application instance is withdrawn
3160: END IF;

Line 3192: IF ( IGS_AD_GEN_007.ADMP_GET_SAAS(l_adm_appl_status_new) IN (cst_completed, cst_withdrawn)

3188: -- igs_ad_app_req_pkg calls this procedure the variable g_pkg_cst_completed_chk will be 'N' . For all other cases it will be 'Y'.
3189: --If this procedure is called from igs_ad_app_req_pkg then the check for complete application should not be performed. -- rghosh(bug#2901627)
3190:
3191: IF NVL(igs_ad_app_req_pkg.g_pkg_cst_completed_chk,'Y') = 'Y' THEN -- modified igsm 5301 arvsrini
3192: IF ( IGS_AD_GEN_007.ADMP_GET_SAAS(l_adm_appl_status_new) IN (cst_completed, cst_withdrawn)
3193: OR -- added OR condition for re-open build - ADTD001 - IGS.M
3194: l_is_inst_complete -- appilcation instance is resolved ( logically completed)
3195: )
3196: AND -- added AND condition for re-open build - ADTD001 - IGS.M

Line 3211: IF IGS_AD_GEN_007.ADMP_GET_SAAS(l_adm_appl_status_new) = cst_withdrawn THEN

3207: igs_ge_msg_stack.add;
3208: app_exception.raise_exception;
3209: END IF;
3210: ELSE
3211: IF IGS_AD_GEN_007.ADMP_GET_SAAS(l_adm_appl_status_new) = cst_withdrawn THEN
3212: fnd_message.set_name('IGS','IGS_AD_CANNOT_CHG_APPL_DTL');
3213: igs_ge_msg_stack.add;
3214: app_exception.raise_exception;
3215: END IF;

Line 4193: NVL(IGS_AD_GEN_007.ADMP_GET_SAAS(acai.APPL_INST_STATUS),'NULL') <> 'WITHDRAWN' AND

4189: acai.future_term_adm_appl_number IS NULL AND
4190: acai.future_term_sequence_number IS NULL AND
4191: acai.def_term_adm_appl_num IS NULL AND
4192: acai.def_appl_sequence_num IS NULL AND
4193: NVL(IGS_AD_GEN_007.ADMP_GET_SAAS(acai.APPL_INST_STATUS),'NULL') <> 'WITHDRAWN' AND
4194: IGS_AD_GEN_008.ADMP_GET_SAOS(acai.ADM_OUTCOME_STATUS) = 'PENDING'
4195: FOR UPDATE NOWAIT;
4196:
4197: c_inst_rec c_inst%ROWTYPE;