APPS.IGS_AD_IMP_027 dependencies on IGS_AD_APPL

Line 57: CURSOR c_appl_dtls_cur(cp_person_id igs_ad_appl.person_id%TYPE,

53: WHERE interface_run_id = p_interface_run_id
54: AND status = '2'
55: ORDER BY person_id,admission_appl_number;
56:
57: CURSOR c_appl_dtls_cur(cp_person_id igs_ad_appl.person_id%TYPE,
58: cp_adm_appl_number igs_ad_appl.admission_appl_number%TYPE) IS
59: SELECT
60: acad_cal_type,
61: acad_ci_sequence_number,

Line 58: cp_adm_appl_number igs_ad_appl.admission_appl_number%TYPE) IS

54: AND status = '2'
55: ORDER BY person_id,admission_appl_number;
56:
57: CURSOR c_appl_dtls_cur(cp_person_id igs_ad_appl.person_id%TYPE,
58: cp_adm_appl_number igs_ad_appl.admission_appl_number%TYPE) IS
59: SELECT
60: acad_cal_type,
61: acad_ci_sequence_number,
62: adm_cal_type,

Line 67: igs_ad_appl

63: adm_ci_sequence_number,
64: admission_cat,
65: s_admission_process_type
66: FROM
67: igs_ad_appl
68: WHERE
69: person_id = cp_person_id AND
70: admission_appl_number = cp_adm_appl_number;
71:

Line 166: FROM igs_ad_appl_hist

162: , status ='3'
163: WHERE STATUS = '2'
164: AND interface_run_id = p_interface_run_id
165: AND EXISTS ( SELECT 1
166: FROM igs_ad_appl_hist
167: WHERE person_id = in_rec.person_id
168: AND admission_appl_number = in_rec.admission_appl_number);
169:
170: COMMIT;

Line 179: FROM igs_ad_appl

175: , status ='3'
176: WHERE STATUS = '2'
177: AND interface_run_id = p_interface_run_id
178: AND NOT EXISTS ( SELECT 1
179: FROM igs_ad_appl
180: WHERE person_id = in_rec.person_id
181: AND admission_appl_number = in_rec.admission_appl_number);
182:
183: COMMIT;

Line 220: igs_ad_appl_hist_pkg.insert_row (

216: OPEN c_appl_dtls_cur(appl_hist_rec.person_id, appl_hist_rec.admission_appl_number);
217: FETCH c_appl_dtls_cur INTO appl_dtls_rec;
218: CLOSE c_appl_dtls_cur;
219:
220: igs_ad_appl_hist_pkg.insert_row (
221: x_rowid => l_rowid,
222: x_org_id => NULL,
223: x_person_id => appl_hist_rec.person_id,
224: x_admission_appl_number => appl_hist_rec.admission_appl_number,

Line 348: CURSOR c_applinst_dup_hist_cur(cp_person_id igs_ad_appl.person_id%TYPE,

344: || Who When What
345: ||
346: */
347:
348: CURSOR c_applinst_dup_hist_cur(cp_person_id igs_ad_appl.person_id%TYPE,
349: cp_adm_appl_number igs_ad_appl.admission_appl_number%TYPE,
350: cp_nominated_course_cd igs_ad_ps_appl_inst.nominated_course_cd%TYPE,
351: cp_sequence_number igs_ad_ps_appl_inst.sequence_number%TYPE,
352: cp_hist_start_dt igs_ad_appl_hist.hist_start_dt%TYPE) IS

Line 349: cp_adm_appl_number igs_ad_appl.admission_appl_number%TYPE,

345: ||
346: */
347:
348: CURSOR c_applinst_dup_hist_cur(cp_person_id igs_ad_appl.person_id%TYPE,
349: cp_adm_appl_number igs_ad_appl.admission_appl_number%TYPE,
350: cp_nominated_course_cd igs_ad_ps_appl_inst.nominated_course_cd%TYPE,
351: cp_sequence_number igs_ad_ps_appl_inst.sequence_number%TYPE,
352: cp_hist_start_dt igs_ad_appl_hist.hist_start_dt%TYPE) IS
353: SELECT

Line 352: cp_hist_start_dt igs_ad_appl_hist.hist_start_dt%TYPE) IS

348: CURSOR c_applinst_dup_hist_cur(cp_person_id igs_ad_appl.person_id%TYPE,
349: cp_adm_appl_number igs_ad_appl.admission_appl_number%TYPE,
350: cp_nominated_course_cd igs_ad_ps_appl_inst.nominated_course_cd%TYPE,
351: cp_sequence_number igs_ad_ps_appl_inst.sequence_number%TYPE,
352: cp_hist_start_dt igs_ad_appl_hist.hist_start_dt%TYPE) IS
353: SELECT
354: 'X'
355: FROM igs_ad_ps_aplinsthst
356: WHERE person_id = cp_person_id

Line 364: CURSOR c_applinst_dtls_cur(cp_person_id igs_ad_appl.person_id%TYPE,

360: AND hist_start_dt = cp_hist_start_dt;
361:
362: c_applinst_dup_hist_rec c_applinst_dup_hist_cur%ROWTYPE;
363:
364: CURSOR c_applinst_dtls_cur(cp_person_id igs_ad_appl.person_id%TYPE,
365: cp_adm_appl_number igs_ad_appl.admission_appl_number%TYPE,
366: cp_nominated_course_cd igs_ad_ps_appl_inst.nominated_course_cd%TYPE,
367: cp_sequence_number igs_ad_ps_appl_inst.sequence_number%TYPE) IS
368: SELECT

Line 365: cp_adm_appl_number igs_ad_appl.admission_appl_number%TYPE,

361:
362: c_applinst_dup_hist_rec c_applinst_dup_hist_cur%ROWTYPE;
363:
364: CURSOR c_applinst_dtls_cur(cp_person_id igs_ad_appl.person_id%TYPE,
365: cp_adm_appl_number igs_ad_appl.admission_appl_number%TYPE,
366: cp_nominated_course_cd igs_ad_ps_appl_inst.nominated_course_cd%TYPE,
367: cp_sequence_number igs_ad_ps_appl_inst.sequence_number%TYPE) IS
368: SELECT
369: apl.acad_cal_type,

Line 380: igs_ad_appl apl,

376: aplinst.crv_version_number,
377: aplinst.late_adm_fee_status,
378: aplinst.correspondence_cat
379: FROM
380: igs_ad_appl apl,
381: igs_ad_ps_appl_inst aplinst
382: WHERE
383: apl.person_id = aplinst.person_id
384: AND apl.admission_appl_number = aplinst.admission_appl_number