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_SS_APPL_FEE_PKG dependencies on IGS_AD_GEN_009

Line 87: l_offer_resp_outcome_status := IGS_AD_GEN_009.ADMP_GET_SYS_AORS('ACCEPTED');

83:
84: BEGIN
85:
86:
87: l_offer_resp_outcome_status := IGS_AD_GEN_009.ADMP_GET_SYS_AORS('ACCEPTED');
88: IF l_offer_resp_outcome_status IS NULL THEN
89: RAISE invalidsysstatus;
90: END IF;
91:

Line 298: l_offer_adm_outcome_status := IGS_AD_GEN_009.ADMP_GET_SYS_AOS('OFFER');

294: l_apcs_pre_enrol_ind VARCHAR2(1);
295:
296: BEGIN
297:
298: l_offer_adm_outcome_status := IGS_AD_GEN_009.ADMP_GET_SYS_AOS('OFFER');
299: l_old_adm_outcome_status := IGS_AD_GEN_009.ADMP_GET_SYS_AOS('PENDING');
300:
301: l_offer_resp_status := IGS_AD_GEN_009.ADMP_GET_SYS_AORS('PENDING');
302: l_offer_old_resp_status := IGS_AD_GEN_009.ADMP_GET_SYS_AORS('NOT-APPLIC');

Line 299: l_old_adm_outcome_status := IGS_AD_GEN_009.ADMP_GET_SYS_AOS('PENDING');

295:
296: BEGIN
297:
298: l_offer_adm_outcome_status := IGS_AD_GEN_009.ADMP_GET_SYS_AOS('OFFER');
299: l_old_adm_outcome_status := IGS_AD_GEN_009.ADMP_GET_SYS_AOS('PENDING');
300:
301: l_offer_resp_status := IGS_AD_GEN_009.ADMP_GET_SYS_AORS('PENDING');
302: l_offer_old_resp_status := IGS_AD_GEN_009.ADMP_GET_SYS_AORS('NOT-APPLIC');
303:

Line 301: l_offer_resp_status := IGS_AD_GEN_009.ADMP_GET_SYS_AORS('PENDING');

297:
298: l_offer_adm_outcome_status := IGS_AD_GEN_009.ADMP_GET_SYS_AOS('OFFER');
299: l_old_adm_outcome_status := IGS_AD_GEN_009.ADMP_GET_SYS_AOS('PENDING');
300:
301: l_offer_resp_status := IGS_AD_GEN_009.ADMP_GET_SYS_AORS('PENDING');
302: l_offer_old_resp_status := IGS_AD_GEN_009.ADMP_GET_SYS_AORS('NOT-APPLIC');
303:
304: IF l_offer_adm_outcome_status IS NULL OR l_old_adm_outcome_status IS NULL THEN
305: RAISE invalidsysstatus;

Line 302: l_offer_old_resp_status := IGS_AD_GEN_009.ADMP_GET_SYS_AORS('NOT-APPLIC');

298: l_offer_adm_outcome_status := IGS_AD_GEN_009.ADMP_GET_SYS_AOS('OFFER');
299: l_old_adm_outcome_status := IGS_AD_GEN_009.ADMP_GET_SYS_AOS('PENDING');
300:
301: l_offer_resp_status := IGS_AD_GEN_009.ADMP_GET_SYS_AORS('PENDING');
302: l_offer_old_resp_status := IGS_AD_GEN_009.ADMP_GET_SYS_AORS('NOT-APPLIC');
303:
304: IF l_offer_adm_outcome_status IS NULL OR l_old_adm_outcome_status IS NULL THEN
305: RAISE invalidsysstatus;
306: END IF;

Line 480: lvc_user_application_status := igs_ad_gen_009.admp_get_sys_ads('SATISFIED');

476: lvc_user_conditional_status VARCHAR2(30);
477:
478: BEGIN
479: --Get the user defined Statuses for the corresponding system defined Statuses
480: lvc_user_application_status := igs_ad_gen_009.admp_get_sys_ads('SATISFIED');
481: lvc_user_entry_qual_status := igs_ad_gen_009.admp_get_sys_aeqs('QUALIFIED');
482: lvc_user_outcome_status := igs_ad_gen_009.admp_get_sys_aos('PENDING');
483: lvc_user_conditional_status := igs_ad_gen_009.admp_get_sys_acos('NOT-APPLIC');
484:

Line 481: lvc_user_entry_qual_status := igs_ad_gen_009.admp_get_sys_aeqs('QUALIFIED');

477:
478: BEGIN
479: --Get the user defined Statuses for the corresponding system defined Statuses
480: lvc_user_application_status := igs_ad_gen_009.admp_get_sys_ads('SATISFIED');
481: lvc_user_entry_qual_status := igs_ad_gen_009.admp_get_sys_aeqs('QUALIFIED');
482: lvc_user_outcome_status := igs_ad_gen_009.admp_get_sys_aos('PENDING');
483: lvc_user_conditional_status := igs_ad_gen_009.admp_get_sys_acos('NOT-APPLIC');
484:
485: --If any of User defined Status is NULL copy the error message into x_msg_data and set the corresponding x_return_status to 'E'

Line 482: lvc_user_outcome_status := igs_ad_gen_009.admp_get_sys_aos('PENDING');

478: BEGIN
479: --Get the user defined Statuses for the corresponding system defined Statuses
480: lvc_user_application_status := igs_ad_gen_009.admp_get_sys_ads('SATISFIED');
481: lvc_user_entry_qual_status := igs_ad_gen_009.admp_get_sys_aeqs('QUALIFIED');
482: lvc_user_outcome_status := igs_ad_gen_009.admp_get_sys_aos('PENDING');
483: lvc_user_conditional_status := igs_ad_gen_009.admp_get_sys_acos('NOT-APPLIC');
484:
485: --If any of User defined Status is NULL copy the error message into x_msg_data and set the corresponding x_return_status to 'E'
486: IF ((lvc_user_application_status IS NULL) OR (lvc_user_entry_qual_status IS NULL) OR

Line 483: lvc_user_conditional_status := igs_ad_gen_009.admp_get_sys_acos('NOT-APPLIC');

479: --Get the user defined Statuses for the corresponding system defined Statuses
480: lvc_user_application_status := igs_ad_gen_009.admp_get_sys_ads('SATISFIED');
481: lvc_user_entry_qual_status := igs_ad_gen_009.admp_get_sys_aeqs('QUALIFIED');
482: lvc_user_outcome_status := igs_ad_gen_009.admp_get_sys_aos('PENDING');
483: lvc_user_conditional_status := igs_ad_gen_009.admp_get_sys_acos('NOT-APPLIC');
484:
485: --If any of User defined Status is NULL copy the error message into x_msg_data and set the corresponding x_return_status to 'E'
486: IF ((lvc_user_application_status IS NULL) OR (lvc_user_entry_qual_status IS NULL) OR
487: (lvc_user_outcome_status IS NULL) OR (lvc_user_conditional_status IS NULL)) THEN

Line 510: lvc_user_application_status := igs_ad_gen_009.admp_get_sys_ads('NOT-APPLIC');

506:
507: -- hreddych 3419856 For a NON-AWARD Appl Type the Entry Qual Status and Appl Comp Status
508: -- should be NOT-APPLIC
509: IF l_adm_proc_type = 'NON-AWARD' THEN
510: lvc_user_application_status := igs_ad_gen_009.admp_get_sys_ads('NOT-APPLIC');
511: lvc_user_entry_qual_status := igs_ad_gen_009.admp_get_sys_aeqs('NOT-APPLIC');
512: END IF;
513:
514: --Check whether the Admission Entry qualification status be updated

Line 511: lvc_user_entry_qual_status := igs_ad_gen_009.admp_get_sys_aeqs('NOT-APPLIC');

507: -- hreddych 3419856 For a NON-AWARD Appl Type the Entry Qual Status and Appl Comp Status
508: -- should be NOT-APPLIC
509: IF l_adm_proc_type = 'NON-AWARD' THEN
510: lvc_user_application_status := igs_ad_gen_009.admp_get_sys_ads('NOT-APPLIC');
511: lvc_user_entry_qual_status := igs_ad_gen_009.admp_get_sys_aeqs('NOT-APPLIC');
512: END IF;
513:
514: --Check whether the Admission Entry qualification status be updated
515: --to system admission entry qualification