APPS.IGS_AD_AC_COMP dependencies on IGS_AD_PS_APPL_INST_ALL

Line 121: || samaresh 02-DEC-2001 Bug # 2097333 : Impact of addition of the waitlist_status field to igs_ad_ps_appl_inst_all

117: || Purpose : This procedure will update given Application Instance to the COMPLETE all the Tracking Items under this are COMPLTE
118: || Known limitations, enhancements or remarks :
119: || Change History :
120: || Who When What
121: || samaresh 02-DEC-2001 Bug # 2097333 : Impact of addition of the waitlist_status field to igs_ad_ps_appl_inst_all
122: || (reverse chronological order - newest change first)
123: */
124:
125: -- Get the details of

Line 378: TYPE c_dyn_pig_checkrecTyp IS RECORD ( person_id igs_ad_ps_appl_inst_all.person_id%TYPE,

374:
375:
376: TYPE c_dyn_pig_checkCurTyp IS REF CURSOR;
377: c_dyn_pig_check c_dyn_pig_checkCurTyp;
378: TYPE c_dyn_pig_checkrecTyp IS RECORD ( person_id igs_ad_ps_appl_inst_all.person_id%TYPE,
379: admission_appl_number igs_ad_ps_appl_inst_all.admission_appl_number%TYPE,
380: course_cd igs_ad_ps_appl_inst_all.course_cd%TYPE,
381: sequence_number igs_ad_ps_appl_inst_all.sequence_number%TYPE);
382: c_dyn_pig_check_rec c_dyn_pig_checkrecTyp ;

Line 379: admission_appl_number igs_ad_ps_appl_inst_all.admission_appl_number%TYPE,

375:
376: TYPE c_dyn_pig_checkCurTyp IS REF CURSOR;
377: c_dyn_pig_check c_dyn_pig_checkCurTyp;
378: TYPE c_dyn_pig_checkrecTyp IS RECORD ( person_id igs_ad_ps_appl_inst_all.person_id%TYPE,
379: admission_appl_number igs_ad_ps_appl_inst_all.admission_appl_number%TYPE,
380: course_cd igs_ad_ps_appl_inst_all.course_cd%TYPE,
381: sequence_number igs_ad_ps_appl_inst_all.sequence_number%TYPE);
382: c_dyn_pig_check_rec c_dyn_pig_checkrecTyp ;
383:

Line 380: course_cd igs_ad_ps_appl_inst_all.course_cd%TYPE,

376: TYPE c_dyn_pig_checkCurTyp IS REF CURSOR;
377: c_dyn_pig_check c_dyn_pig_checkCurTyp;
378: TYPE c_dyn_pig_checkrecTyp IS RECORD ( person_id igs_ad_ps_appl_inst_all.person_id%TYPE,
379: admission_appl_number igs_ad_ps_appl_inst_all.admission_appl_number%TYPE,
380: course_cd igs_ad_ps_appl_inst_all.course_cd%TYPE,
381: sequence_number igs_ad_ps_appl_inst_all.sequence_number%TYPE);
382: c_dyn_pig_check_rec c_dyn_pig_checkrecTyp ;
383:
384:

Line 381: sequence_number igs_ad_ps_appl_inst_all.sequence_number%TYPE);

377: c_dyn_pig_check c_dyn_pig_checkCurTyp;
378: TYPE c_dyn_pig_checkrecTyp IS RECORD ( person_id igs_ad_ps_appl_inst_all.person_id%TYPE,
379: admission_appl_number igs_ad_ps_appl_inst_all.admission_appl_number%TYPE,
380: course_cd igs_ad_ps_appl_inst_all.course_cd%TYPE,
381: sequence_number igs_ad_ps_appl_inst_all.sequence_number%TYPE);
382: c_dyn_pig_check_rec c_dyn_pig_checkrecTyp ;
383:
384:
385: lv_status VARCHAR2(1);