APPS.IGS_AD_TI_COMP dependencies on IGS_AD_PS_APPL_INST_ALL

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

669:
670:
671: TYPE c_dyn_pig_checkCurTyp IS REF CURSOR;
672: c_dyn_pig_check c_dyn_pig_checkCurTyp;
673: TYPE c_dyn_pig_checkrecTyp IS RECORD ( person_id igs_ad_ps_appl_inst_all.person_id%TYPE,
674: admission_appl_number igs_ad_ps_appl_inst_all.admission_appl_number%TYPE,
675: nominated_course_cd igs_ad_ps_appl_inst_all.nominated_course_cd%TYPE,
676: sequence_number igs_ad_ps_appl_inst_all.sequence_number%TYPE);
677: c_dyn_pig_check_rec c_dyn_pig_checkrecTyp ;

Line 674: admission_appl_number igs_ad_ps_appl_inst_all.admission_appl_number%TYPE,

670:
671: TYPE c_dyn_pig_checkCurTyp IS REF CURSOR;
672: c_dyn_pig_check c_dyn_pig_checkCurTyp;
673: TYPE c_dyn_pig_checkrecTyp IS RECORD ( person_id igs_ad_ps_appl_inst_all.person_id%TYPE,
674: admission_appl_number igs_ad_ps_appl_inst_all.admission_appl_number%TYPE,
675: nominated_course_cd igs_ad_ps_appl_inst_all.nominated_course_cd%TYPE,
676: sequence_number igs_ad_ps_appl_inst_all.sequence_number%TYPE);
677: c_dyn_pig_check_rec c_dyn_pig_checkrecTyp ;
678:

Line 675: nominated_course_cd igs_ad_ps_appl_inst_all.nominated_course_cd%TYPE,

671: TYPE c_dyn_pig_checkCurTyp IS REF CURSOR;
672: c_dyn_pig_check c_dyn_pig_checkCurTyp;
673: TYPE c_dyn_pig_checkrecTyp IS RECORD ( person_id igs_ad_ps_appl_inst_all.person_id%TYPE,
674: admission_appl_number igs_ad_ps_appl_inst_all.admission_appl_number%TYPE,
675: nominated_course_cd igs_ad_ps_appl_inst_all.nominated_course_cd%TYPE,
676: sequence_number igs_ad_ps_appl_inst_all.sequence_number%TYPE);
677: c_dyn_pig_check_rec c_dyn_pig_checkrecTyp ;
678:
679: lv_status VARCHAR2(1) := 'S'; /*Defaulted to 'S' and the function will return 'F' in case of failure */

Line 676: sequence_number igs_ad_ps_appl_inst_all.sequence_number%TYPE);

672: c_dyn_pig_check c_dyn_pig_checkCurTyp;
673: TYPE c_dyn_pig_checkrecTyp IS RECORD ( person_id igs_ad_ps_appl_inst_all.person_id%TYPE,
674: admission_appl_number igs_ad_ps_appl_inst_all.admission_appl_number%TYPE,
675: nominated_course_cd igs_ad_ps_appl_inst_all.nominated_course_cd%TYPE,
676: sequence_number igs_ad_ps_appl_inst_all.sequence_number%TYPE);
677: c_dyn_pig_check_rec c_dyn_pig_checkrecTyp ;
678:
679: lv_status VARCHAR2(1) := 'S'; /*Defaulted to 'S' and the function will return 'F' in case of failure */
680: lv_sql_stmt VARCHAR(32767);