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_UPD_INITIALISE dependencies on IGS_AD_PS_APPL_INST

Line 22: -- IGS_AD_PS_APPL_INST are updated when

18: p_creation_dt IN DATE )
19: IS
20: BEGIN -- admp_upd_acaiu_init
21: -- This module updates IGS_AD_PS_APLINSTUNT when
22: -- IGS_AD_PS_APPL_INST are updated when
23: -- initialising an admission period as a result of reconsideration or deferment
24: -- This module is called from IGS_AD_GEN_012.ADMP_UPD_ACAI_RECON and IGS_AD_GEN_012.ADMP_UPD_ACAI_DEFER.
25: DECLARE
26: e_resource_busy EXCEPTION;

Line 141: p_person_id IN igs_ad_ps_appl_inst. person_id%TYPE,

137: END admp_upd_acaiu_init;
138:
139:
140: FUNCTION perform_pre_enrol (
141: p_person_id IN igs_ad_ps_appl_inst. person_id%TYPE,
142: p_admission_appl_number IN igs_ad_ps_appl_inst. admission_appl_number%TYPE,
143: p_nominated_course_cd IN igs_ad_ps_appl_inst.nominated_course_cd%TYPE,
144: p_sequence_number IN igs_ad_ps_appl_inst.sequence_number%TYPE,
145: p_confirm_ind IN VARCHAR2,

Line 142: p_admission_appl_number IN igs_ad_ps_appl_inst. admission_appl_number%TYPE,

138:
139:
140: FUNCTION perform_pre_enrol (
141: p_person_id IN igs_ad_ps_appl_inst. person_id%TYPE,
142: p_admission_appl_number IN igs_ad_ps_appl_inst. admission_appl_number%TYPE,
143: p_nominated_course_cd IN igs_ad_ps_appl_inst.nominated_course_cd%TYPE,
144: p_sequence_number IN igs_ad_ps_appl_inst.sequence_number%TYPE,
145: p_confirm_ind IN VARCHAR2,
146: p_check_eligibility_ind IN VARCHAR2,

Line 143: p_nominated_course_cd IN igs_ad_ps_appl_inst.nominated_course_cd%TYPE,

139:
140: FUNCTION perform_pre_enrol (
141: p_person_id IN igs_ad_ps_appl_inst. person_id%TYPE,
142: p_admission_appl_number IN igs_ad_ps_appl_inst. admission_appl_number%TYPE,
143: p_nominated_course_cd IN igs_ad_ps_appl_inst.nominated_course_cd%TYPE,
144: p_sequence_number IN igs_ad_ps_appl_inst.sequence_number%TYPE,
145: p_confirm_ind IN VARCHAR2,
146: p_check_eligibility_ind IN VARCHAR2,
147: p_message_name OUT NOCOPY VARCHAR2

Line 144: p_sequence_number IN igs_ad_ps_appl_inst.sequence_number%TYPE,

140: FUNCTION perform_pre_enrol (
141: p_person_id IN igs_ad_ps_appl_inst. person_id%TYPE,
142: p_admission_appl_number IN igs_ad_ps_appl_inst. admission_appl_number%TYPE,
143: p_nominated_course_cd IN igs_ad_ps_appl_inst.nominated_course_cd%TYPE,
144: p_sequence_number IN igs_ad_ps_appl_inst.sequence_number%TYPE,
145: p_confirm_ind IN VARCHAR2,
146: p_check_eligibility_ind IN VARCHAR2,
147: p_message_name OUT NOCOPY VARCHAR2
148: )

Line 168: CURSOR c_pre_enrol (cp_person_id IN igs_ad_ps_appl_inst. person_id%TYPE,

164: ----------------------------------------------------------------
165: v_message_name VARCHAR2(2000) ;
166: v_warn_level VARCHAR2(10);
167:
168: CURSOR c_pre_enrol (cp_person_id IN igs_ad_ps_appl_inst. person_id%TYPE,
169: cp_admission_appl_number IN igs_ad_ps_appl_inst. admission_appl_number%TYPE,
170: cp_nominated_course_cd IN igs_ad_ps_appl_inst.nominated_course_cd%TYPE,
171: cp_sequence_number IN igs_ad_ps_appl_inst.sequence_number%TYPE) IS
172: SELECT a.enrolment_cat,b.acad_cal_type,b.acad_ci_sequence_number

Line 169: cp_admission_appl_number IN igs_ad_ps_appl_inst. admission_appl_number%TYPE,

165: v_message_name VARCHAR2(2000) ;
166: v_warn_level VARCHAR2(10);
167:
168: CURSOR c_pre_enrol (cp_person_id IN igs_ad_ps_appl_inst. person_id%TYPE,
169: cp_admission_appl_number IN igs_ad_ps_appl_inst. admission_appl_number%TYPE,
170: cp_nominated_course_cd IN igs_ad_ps_appl_inst.nominated_course_cd%TYPE,
171: cp_sequence_number IN igs_ad_ps_appl_inst.sequence_number%TYPE) IS
172: SELECT a.enrolment_cat,b.acad_cal_type,b.acad_ci_sequence_number
173: FROM igs_ad_ps_appl_inst a, igs_ad_appl b

Line 170: cp_nominated_course_cd IN igs_ad_ps_appl_inst.nominated_course_cd%TYPE,

166: v_warn_level VARCHAR2(10);
167:
168: CURSOR c_pre_enrol (cp_person_id IN igs_ad_ps_appl_inst. person_id%TYPE,
169: cp_admission_appl_number IN igs_ad_ps_appl_inst. admission_appl_number%TYPE,
170: cp_nominated_course_cd IN igs_ad_ps_appl_inst.nominated_course_cd%TYPE,
171: cp_sequence_number IN igs_ad_ps_appl_inst.sequence_number%TYPE) IS
172: SELECT a.enrolment_cat,b.acad_cal_type,b.acad_ci_sequence_number
173: FROM igs_ad_ps_appl_inst a, igs_ad_appl b
174: WHERE a.person_id = cp_person_id

Line 171: cp_sequence_number IN igs_ad_ps_appl_inst.sequence_number%TYPE) IS

167:
168: CURSOR c_pre_enrol (cp_person_id IN igs_ad_ps_appl_inst. person_id%TYPE,
169: cp_admission_appl_number IN igs_ad_ps_appl_inst. admission_appl_number%TYPE,
170: cp_nominated_course_cd IN igs_ad_ps_appl_inst.nominated_course_cd%TYPE,
171: cp_sequence_number IN igs_ad_ps_appl_inst.sequence_number%TYPE) IS
172: SELECT a.enrolment_cat,b.acad_cal_type,b.acad_ci_sequence_number
173: FROM igs_ad_ps_appl_inst a, igs_ad_appl b
174: WHERE a.person_id = cp_person_id
175: AND a.admission_appl_number = cp_admission_appl_number

Line 173: FROM igs_ad_ps_appl_inst a, igs_ad_appl b

169: cp_admission_appl_number IN igs_ad_ps_appl_inst. admission_appl_number%TYPE,
170: cp_nominated_course_cd IN igs_ad_ps_appl_inst.nominated_course_cd%TYPE,
171: cp_sequence_number IN igs_ad_ps_appl_inst.sequence_number%TYPE) IS
172: SELECT a.enrolment_cat,b.acad_cal_type,b.acad_ci_sequence_number
173: FROM igs_ad_ps_appl_inst a, igs_ad_appl b
174: WHERE a.person_id = cp_person_id
175: AND a.admission_appl_number = cp_admission_appl_number
176: AND a.nominated_course_cd = cp_nominated_course_cd
177: AND a.sequence_number=cp_sequence_number

Line 322: p_person_id IN igs_ad_ps_appl_inst. person_id%TYPE,

318: RETURN FALSE;
319: END perform_pre_enrol;
320:
321: PROCEDURE perform_pre_enrol (
322: p_person_id IN igs_ad_ps_appl_inst. person_id%TYPE,
323: p_admission_appl_number IN igs_ad_ps_appl_inst. admission_appl_number%TYPE,
324: p_nominated_course_cd IN igs_ad_ps_appl_inst.nominated_course_cd%TYPE,
325: p_sequence_number IN igs_ad_ps_appl_inst.sequence_number%TYPE,
326: p_confirm_ind IN VARCHAR2,

Line 323: p_admission_appl_number IN igs_ad_ps_appl_inst. admission_appl_number%TYPE,

319: END perform_pre_enrol;
320:
321: PROCEDURE perform_pre_enrol (
322: p_person_id IN igs_ad_ps_appl_inst. person_id%TYPE,
323: p_admission_appl_number IN igs_ad_ps_appl_inst. admission_appl_number%TYPE,
324: p_nominated_course_cd IN igs_ad_ps_appl_inst.nominated_course_cd%TYPE,
325: p_sequence_number IN igs_ad_ps_appl_inst.sequence_number%TYPE,
326: p_confirm_ind IN VARCHAR2,
327: p_check_eligibility_ind IN VARCHAR2

Line 324: p_nominated_course_cd IN igs_ad_ps_appl_inst.nominated_course_cd%TYPE,

320:
321: PROCEDURE perform_pre_enrol (
322: p_person_id IN igs_ad_ps_appl_inst. person_id%TYPE,
323: p_admission_appl_number IN igs_ad_ps_appl_inst. admission_appl_number%TYPE,
324: p_nominated_course_cd IN igs_ad_ps_appl_inst.nominated_course_cd%TYPE,
325: p_sequence_number IN igs_ad_ps_appl_inst.sequence_number%TYPE,
326: p_confirm_ind IN VARCHAR2,
327: p_check_eligibility_ind IN VARCHAR2
328: )

Line 325: p_sequence_number IN igs_ad_ps_appl_inst.sequence_number%TYPE,

321: PROCEDURE perform_pre_enrol (
322: p_person_id IN igs_ad_ps_appl_inst. person_id%TYPE,
323: p_admission_appl_number IN igs_ad_ps_appl_inst. admission_appl_number%TYPE,
324: p_nominated_course_cd IN igs_ad_ps_appl_inst.nominated_course_cd%TYPE,
325: p_sequence_number IN igs_ad_ps_appl_inst.sequence_number%TYPE,
326: p_confirm_ind IN VARCHAR2,
327: p_check_eligibility_ind IN VARCHAR2
328: )
329: IS

Line 497: p_person_id IN igs_ad_ps_appl_inst.person_id%TYPE,

493: END get_msg_name_mapping;
494:
495: -- procedure to update the person statistics (moved the code from IGSAI18 )
496: PROCEDURE update_per_stats (
497: p_person_id IN igs_ad_ps_appl_inst.person_id%TYPE,
498: p_admission_appl_number IN igs_ad_ps_appl_inst.admission_appl_number%TYPE DEFAULT NULL,
499: p_acptd_or_reopnd_ind IN VARCHAR2 DEFAULT NULL
500: )
501: IS

Line 498: p_admission_appl_number IN igs_ad_ps_appl_inst.admission_appl_number%TYPE DEFAULT NULL,

494:
495: -- procedure to update the person statistics (moved the code from IGSAI18 )
496: PROCEDURE update_per_stats (
497: p_person_id IN igs_ad_ps_appl_inst.person_id%TYPE,
498: p_admission_appl_number IN igs_ad_ps_appl_inst.admission_appl_number%TYPE DEFAULT NULL,
499: p_acptd_or_reopnd_ind IN VARCHAR2 DEFAULT NULL
500: )
501: IS
502:

Line 548: igs_ad_ps_appl_inst_all inst,

544: SELECT apl.adm_cal_type,
545: apl.adm_ci_sequence_number ,
546: ca.start_dt
547: FROM igs_ad_appl_all apl ,
548: igs_ad_ps_appl_inst_all inst,
549: igs_ca_inst_all ca
550: WHERE apl.person_id = P_PERSON_ID
551: AND apl.person_id = inst.person_id
552: AND apl.admission_appl_number = inst.admission_appl_number