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_011 dependencies on IGS_AD_PS_APPL

Line 149: -- Routine to create a history for the IGS_AD_PS_APPL_INST table.

145: lv_old_update_on DATE := p_old_update_on;
146:
147:
148: BEGIN -- admp_ins_acai_hist
149: -- Routine to create a history for the IGS_AD_PS_APPL_INST table.
150: DECLARE
151: v_changed_flag BOOLEAN DEFAULT FALSE;
152: v_acaih_rec IGS_AD_PS_APLINSTHST%ROWTYPE;
153: lv_rowid VARCHAR2(25);

Line 167: CURSOR cur_ad_ps_appl ( cp_person_id igs_ad_ps_appl.person_id%type ,

163: AND sequence_number = p_sequence_number
164: AND hist_start_dt = p_old_update_on;
165:
166: -- begin apadegal adtd001 igs.m
167: CURSOR cur_ad_ps_appl ( cp_person_id igs_ad_ps_appl.person_id%type ,
168: cp_admission_appl_number igs_ad_ps_appl.admission_appl_number%type ,
169: cp_nominated_course_cd igs_ad_ps_appl.nominated_course_cd%type ) IS
170: SELECT req_for_reconsideration_ind
171: FROM igs_ad_ps_appl

Line 168: cp_admission_appl_number igs_ad_ps_appl.admission_appl_number%type ,

164: AND hist_start_dt = p_old_update_on;
165:
166: -- begin apadegal adtd001 igs.m
167: CURSOR cur_ad_ps_appl ( cp_person_id igs_ad_ps_appl.person_id%type ,
168: cp_admission_appl_number igs_ad_ps_appl.admission_appl_number%type ,
169: cp_nominated_course_cd igs_ad_ps_appl.nominated_course_cd%type ) IS
170: SELECT req_for_reconsideration_ind
171: FROM igs_ad_ps_appl
172: WHERE person_id = cp_person_id and

Line 169: cp_nominated_course_cd igs_ad_ps_appl.nominated_course_cd%type ) IS

165:
166: -- begin apadegal adtd001 igs.m
167: CURSOR cur_ad_ps_appl ( cp_person_id igs_ad_ps_appl.person_id%type ,
168: cp_admission_appl_number igs_ad_ps_appl.admission_appl_number%type ,
169: cp_nominated_course_cd igs_ad_ps_appl.nominated_course_cd%type ) IS
170: SELECT req_for_reconsideration_ind
171: FROM igs_ad_ps_appl
172: WHERE person_id = cp_person_id and
173: admission_appl_number = cp_admission_appl_number and

Line 171: FROM igs_ad_ps_appl

167: CURSOR cur_ad_ps_appl ( cp_person_id igs_ad_ps_appl.person_id%type ,
168: cp_admission_appl_number igs_ad_ps_appl.admission_appl_number%type ,
169: cp_nominated_course_cd igs_ad_ps_appl.nominated_course_cd%type ) IS
170: SELECT req_for_reconsideration_ind
171: FROM igs_ad_ps_appl
172: WHERE person_id = cp_person_id and
173: admission_appl_number = cp_admission_appl_number and
174: nominated_course_cd = cp_nominated_course_cd;
175: -- end apadegal adtd001 igs.m

Line 188: -- Check if any of the old IGS_AD_PS_APPL_INST values are different from

184:
185: l_latest_hist_dt c_latest_hist_dt%ROWTYPE;
186:
187: BEGIN
188: -- Check if any of the old IGS_AD_PS_APPL_INST values are different from
189: -- the associated new IGS_AD_PS_APPL_INST values.
190: IF NVL(p_new_adm_cal_type,'NULL') <> NVL(p_old_adm_cal_type,'NULL') THEN
191: v_acaih_rec.adm_cal_type := p_old_adm_cal_type;
192: v_changed_flag := TRUE;

Line 189: -- the associated new IGS_AD_PS_APPL_INST values.

185: l_latest_hist_dt c_latest_hist_dt%ROWTYPE;
186:
187: BEGIN
188: -- Check if any of the old IGS_AD_PS_APPL_INST values are different from
189: -- the associated new IGS_AD_PS_APPL_INST values.
190: IF NVL(p_new_adm_cal_type,'NULL') <> NVL(p_old_adm_cal_type,'NULL') THEN
191: v_acaih_rec.adm_cal_type := p_old_adm_cal_type;
192: v_changed_flag := TRUE;
193: END IF;

Line 642: -- Routine to create a history for the IGS_AD_PS_APPL table.

638: l_sc_app_short_name VARCHAR2(50);
639: l_sc_message_name VARCHAR2(50);
640:
641: BEGIN -- admp_ins_aca_hist
642: -- Routine to create a history for the IGS_AD_PS_APPL table.
643: DECLARE
644: v_changed_flag BOOLEAN DEFAULT FALSE;
645: v_acah_rec IGS_AD_PS_APPL_HIST%ROWTYPE;
646: lv_rowid VARCHAR2(25);

Line 645: v_acah_rec IGS_AD_PS_APPL_HIST%ROWTYPE;

641: BEGIN -- admp_ins_aca_hist
642: -- Routine to create a history for the IGS_AD_PS_APPL table.
643: DECLARE
644: v_changed_flag BOOLEAN DEFAULT FALSE;
645: v_acah_rec IGS_AD_PS_APPL_HIST%ROWTYPE;
646: lv_rowid VARCHAR2(25);
647: l_org_id NUMBER(15);
648: BEGIN
649: -- Check if any of the old IGS_AD_PS_APPL values are different from the

Line 649: -- Check if any of the old IGS_AD_PS_APPL values are different from the

645: v_acah_rec IGS_AD_PS_APPL_HIST%ROWTYPE;
646: lv_rowid VARCHAR2(25);
647: l_org_id NUMBER(15);
648: BEGIN
649: -- Check if any of the old IGS_AD_PS_APPL values are different from the
650: -- associated new IGS_AD_PS_APPL values.
651: IF NVL(p_new_transfer_course_cd, 'NULL') <>
652: NVL(p_old_transfer_course_cd, 'NULL') THEN
653: v_acah_rec.transfer_course_cd := p_old_transfer_course_cd;

Line 650: -- associated new IGS_AD_PS_APPL values.

646: lv_rowid VARCHAR2(25);
647: l_org_id NUMBER(15);
648: BEGIN
649: -- Check if any of the old IGS_AD_PS_APPL values are different from the
650: -- associated new IGS_AD_PS_APPL values.
651: IF NVL(p_new_transfer_course_cd, 'NULL') <>
652: NVL(p_old_transfer_course_cd, 'NULL') THEN
653: v_acah_rec.transfer_course_cd := p_old_transfer_course_cd;
654: v_changed_flag := TRUE;

Line 690: -- Ceate an IGS_AD_PS_APPL_HIST history record.

686: v_acah_rec.nominated_course_cd := p_nominated_course_cd;
687: v_acah_rec.hist_start_dt := p_old_update_on;
688: v_acah_rec.hist_end_dt := p_new_update_on;
689: v_acah_rec.hist_who := p_old_update_who;
690: -- Ceate an IGS_AD_PS_APPL_HIST history record.
691: l_org_id := igs_ge_gen_003.get_org_id;
692: IGS_AD_PS_APPL_Hist_Pkg.Insert_Row (
693: X_Mode => 'R',
694: X_RowId => lv_rowid,

Line 692: IGS_AD_PS_APPL_Hist_Pkg.Insert_Row (

688: v_acah_rec.hist_end_dt := p_new_update_on;
689: v_acah_rec.hist_who := p_old_update_who;
690: -- Ceate an IGS_AD_PS_APPL_HIST history record.
691: l_org_id := igs_ge_gen_003.get_org_id;
692: IGS_AD_PS_APPL_Hist_Pkg.Insert_Row (
693: X_Mode => 'R',
694: X_RowId => lv_rowid,
695: X_Hist_Who => v_acah_rec.hist_who,
696: X_Transfer_Course_Cd => v_acah_rec.transfer_course_cd,

Line 1116: cp_pgm_of_study igs_ad_ps_appl_inst.nominated_course_cd%TYPE,

1112: cp_admission_cat igs_ad_appl.admission_cat%TYPE,
1113: cp_s_admission_process_type igs_ad_appl.s_admission_process_type%TYPE,
1114: cp_correspondence_type igs_ad_appl_ltr.correspondence_type%TYPE,
1115: cp_adm_outcome_status igs_ad_ou_stat.adm_outcome_status%TYPE,
1116: cp_pgm_of_study igs_ad_ps_appl_inst.nominated_course_cd%TYPE,
1117: cp_response_status igs_ad_ofr_resp_stat.adm_offer_resp_status%TYPE,
1118: cp_residency_class igs_pe_res_dtls_v.residency_class%TYPE,
1119: cp_residency_stat igs_pe_res_dtls_v.residency_status%TYPE,
1120: cp_org_unit_code igs_ps_ver.responsible_org_unit_cd%TYPE

Line 1135: igs_ad_ps_appl_inst acaiv, --Bug 3150054 Replaced igs_ad_ps_appl_inst_aplinst_v with igs_ad_ps_appl_inst

1131: padv.country country,
1132: padv.postal_code postal_code
1133: FROM igs_ad_appl aa,
1134: igs_ad_appl_ltr aal,
1135: igs_ad_ps_appl_inst acaiv, --Bug 3150054 Replaced igs_ad_ps_appl_inst_aplinst_v with igs_ad_ps_appl_inst
1136: igs_ps_ver pv,
1137: igs_pe_addr_v padv,
1138: igs_pe_res_dtls_v prdv
1139: WHERE aa.acad_cal_type LIKE cp_acad_cal_type

Line 1324: igs_ad_ps_appl_inst acaiv, --Bug 3150054 Replaced igs_ad_ps_appl_inst_aplinst_v with igs_ad_ps_appl_inst

1320: padv.country country,
1321: padv.postal_code postal_code
1322: FROM igs_ad_appl aa,
1323: igs_ad_appl_ltr aal,
1324: igs_ad_ps_appl_inst acaiv, --Bug 3150054 Replaced igs_ad_ps_appl_inst_aplinst_v with igs_ad_ps_appl_inst
1325: igs_ps_ver pv,
1326: igs_pe_addr_v padv,
1327: igs_pe_res_dtls_v prdv
1328: WHERE aa.acad_cal_type LIKE :1

Line 1437: p_program_of_study igs_ad_ps_appl_inst.nominated_course_cd%TYPE;

1433: p_adm_ci_sequence_number igs_ca_inst.sequence_number%TYPE;
1434: /*
1435: ** Start of code for enhancement# 1818444.
1436: */
1437: p_program_of_study igs_ad_ps_appl_inst.nominated_course_cd%TYPE;
1438: p_response_status igs_ad_ofr_resp_stat.adm_offer_resp_status%TYPE;
1439: p_residency_class igs_pe_res_dtls_v.residency_class%TYPE;
1440: p_residency_status igs_pe_res_dtls_v.residency_status%TYPE;
1441: p_person_id_group igs_pe_persid_group_all.group_id%TYPE;