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_APP_REQ

Line 3003: l_TotalRemitt igs_ad_app_req.fee_amount%TYPE :=0;

2999: Change History: (who, when, what: )
3000: Who When What
3001: *******************************************************************************/
3002: l_FeeAmt igs_ad_appl_all.appl_fee_amt%TYPE :=0;
3003: l_TotalRemitt igs_ad_app_req.fee_amount%TYPE :=0;
3004: l_WaivedTemp igs_ad_app_req.fee_amount%TYPE :=0;
3005: lOverallStatus igs_lookup_values.meaning%TYPE;
3006: CURSOR c_adm_fee_amt IS
3007: SELECT appl_fee_amt

Line 3004: l_WaivedTemp igs_ad_app_req.fee_amount%TYPE :=0;

3000: Who When What
3001: *******************************************************************************/
3002: l_FeeAmt igs_ad_appl_all.appl_fee_amt%TYPE :=0;
3003: l_TotalRemitt igs_ad_app_req.fee_amount%TYPE :=0;
3004: l_WaivedTemp igs_ad_app_req.fee_amount%TYPE :=0;
3005: lOverallStatus igs_lookup_values.meaning%TYPE;
3006: CURSOR c_adm_fee_amt IS
3007: SELECT appl_fee_amt
3008: FROM igs_ad_appl_all

Line 3019: FROM igs_ad_app_req req,

3015: AND lookup_code = p_sys_fee_status;
3016: CURSOR c_fee_amount IS
3017: SELECT req.fee_amount,
3018: cc.system_status fee_status
3019: FROM igs_ad_app_req req,
3020: igs_ad_code_classes cc
3021: WHERE req.person_id = p_person_id
3022: AND req.admission_appl_number = p_admission_appl_number
3023: AND cc.CLASS = 'SYS_FEE_STATUS'

Line 3187: -- the variable g_pkg_cst_completed_chk is getting populated to a value of 'N' from the package igs_ad_app_req_pkg. So if the package

3183: -------end APADEGAL - ADTD001 RE-OPEN BUILD- IGS.M
3184:
3185:
3186:
3187: -- the variable g_pkg_cst_completed_chk is getting populated to a value of 'N' from the package igs_ad_app_req_pkg. So if the package
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

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

3184:
3185:
3186:
3187: -- the variable g_pkg_cst_completed_chk is getting populated to a value of 'N' from the package igs_ad_app_req_pkg. So if the package
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)

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

3185:
3186:
3187: -- the variable g_pkg_cst_completed_chk is getting populated to a value of 'N' from the package igs_ad_app_req_pkg. So if the package
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

Line 3191: IF NVL(igs_ad_app_req_pkg.g_pkg_cst_completed_chk,'Y') = 'Y' THEN -- modified igsm 5301 arvsrini

3187: -- the variable g_pkg_cst_completed_chk is getting populated to a value of 'N' from the package igs_ad_app_req_pkg. So if the package
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: )

Line 3292: CURSOR c_igs_ad_app_req (cp_person_id igs_ad_app_req.person_id%TYPE,

3288: SELECT person_id, admission_appl_number, appl_fee_amt
3289: FROM igs_ad_appl_all
3290: WHERE application_id = cp_application_id;
3291: rec_igs_ad_appl_all c_igs_ad_appl_all%ROWTYPE;
3292: CURSOR c_igs_ad_app_req (cp_person_id igs_ad_app_req.person_id%TYPE,
3293: cp_admission_appl_number igs_ad_app_req.admission_appl_number%TYPE) IS
3294: SELECT 'X'
3295: FROM igs_ad_app_req
3296: WHERE person_id = cp_person_id

Line 3293: cp_admission_appl_number igs_ad_app_req.admission_appl_number%TYPE) IS

3289: FROM igs_ad_appl_all
3290: WHERE application_id = cp_application_id;
3291: rec_igs_ad_appl_all c_igs_ad_appl_all%ROWTYPE;
3292: CURSOR c_igs_ad_app_req (cp_person_id igs_ad_app_req.person_id%TYPE,
3293: cp_admission_appl_number igs_ad_app_req.admission_appl_number%TYPE) IS
3294: SELECT 'X'
3295: FROM igs_ad_app_req
3296: WHERE person_id = cp_person_id
3297: AND admission_appl_number = cp_admission_appl_number;

Line 3295: FROM igs_ad_app_req

3291: rec_igs_ad_appl_all c_igs_ad_appl_all%ROWTYPE;
3292: CURSOR c_igs_ad_app_req (cp_person_id igs_ad_app_req.person_id%TYPE,
3293: cp_admission_appl_number igs_ad_app_req.admission_appl_number%TYPE) IS
3294: SELECT 'X'
3295: FROM igs_ad_app_req
3296: WHERE person_id = cp_person_id
3297: AND admission_appl_number = cp_admission_appl_number;
3298: BEGIN
3299: IF p_application_id IS NULL THEN

Line 3309: OPEN c_igs_ad_app_req(rec_igs_ad_appl_all.person_id, rec_igs_ad_appl_all.admission_appl_number);

3305: IF (rec_igs_ad_appl_all.appl_fee_amt is NULL OR
3306: rec_igs_ad_appl_all.appl_fee_amt = 0) THEN
3307: RETURN 'NOFEEDUE';
3308: ELSE
3309: OPEN c_igs_ad_app_req(rec_igs_ad_appl_all.person_id, rec_igs_ad_appl_all.admission_appl_number);
3310: FETCH c_igs_ad_app_req INTO l_fee_exists;
3311: CLOSE c_igs_ad_app_req;
3312: IF l_fee_exists is NULL THEN
3313: RETURN 'PENDING';

Line 3310: FETCH c_igs_ad_app_req INTO l_fee_exists;

3306: rec_igs_ad_appl_all.appl_fee_amt = 0) THEN
3307: RETURN 'NOFEEDUE';
3308: ELSE
3309: OPEN c_igs_ad_app_req(rec_igs_ad_appl_all.person_id, rec_igs_ad_appl_all.admission_appl_number);
3310: FETCH c_igs_ad_app_req INTO l_fee_exists;
3311: CLOSE c_igs_ad_app_req;
3312: IF l_fee_exists is NULL THEN
3313: RETURN 'PENDING';
3314: ELSE

Line 3311: CLOSE c_igs_ad_app_req;

3307: RETURN 'NOFEEDUE';
3308: ELSE
3309: OPEN c_igs_ad_app_req(rec_igs_ad_appl_all.person_id, rec_igs_ad_appl_all.admission_appl_number);
3310: FETCH c_igs_ad_app_req INTO l_fee_exists;
3311: CLOSE c_igs_ad_app_req;
3312: IF l_fee_exists is NULL THEN
3313: RETURN 'PENDING';
3314: ELSE
3315: RETURN 'PARTIAL';