APPS.IGS_HE_EXTRACT_PKG dependencies on IGS_HE_AD_DTL

Line 20: g_he_ad_dtl igs_he_ad_dtl%ROWTYPE;

16: g_he_st_prog igs_he_st_prog%ROWTYPE;
17: g_ps_ver igs_ps_ver%ROWTYPE;
18: g_he_poous igs_he_poous%ROWTYPE;
19: g_pe_person igs_pe_person%ROWTYPE;
20: g_he_ad_dtl igs_he_ad_dtl%ROWTYPE;
21:
22: g_records_found BOOLEAN := FALSE;
23:
24: g_prog_rec_flag BOOLEAN := FALSE;

Line 457: (p_person_id igs_he_ad_dtl.person_id%TYPE,

453: AND param_type IN ('PROGRAM' ,'DORMANT','VISIT_EXCHANGE','POST_CODE' )
454: ORDER BY param_type;
455:
456: CURSOR c_specst
457: (p_person_id igs_he_ad_dtl.person_id%TYPE,
458: p_admission_appl_number igs_he_ad_dtl.admission_appl_number%TYPE,
459: p_nominated_course_cd igs_he_ad_dtl.nominated_course_cd%TYPE ,
460: p_sequence_number igs_he_ad_dtl.sequence_number%TYPE) IS
461: SELECT special_student_cd

Line 458: p_admission_appl_number igs_he_ad_dtl.admission_appl_number%TYPE,

454: ORDER BY param_type;
455:
456: CURSOR c_specst
457: (p_person_id igs_he_ad_dtl.person_id%TYPE,
458: p_admission_appl_number igs_he_ad_dtl.admission_appl_number%TYPE,
459: p_nominated_course_cd igs_he_ad_dtl.nominated_course_cd%TYPE ,
460: p_sequence_number igs_he_ad_dtl.sequence_number%TYPE) IS
461: SELECT special_student_cd
462: FROM igs_he_ad_dtl_all

Line 459: p_nominated_course_cd igs_he_ad_dtl.nominated_course_cd%TYPE ,

455:
456: CURSOR c_specst
457: (p_person_id igs_he_ad_dtl.person_id%TYPE,
458: p_admission_appl_number igs_he_ad_dtl.admission_appl_number%TYPE,
459: p_nominated_course_cd igs_he_ad_dtl.nominated_course_cd%TYPE ,
460: p_sequence_number igs_he_ad_dtl.sequence_number%TYPE) IS
461: SELECT special_student_cd
462: FROM igs_he_ad_dtl_all
463: WHERE person_id = p_person_id

Line 460: p_sequence_number igs_he_ad_dtl.sequence_number%TYPE) IS

456: CURSOR c_specst
457: (p_person_id igs_he_ad_dtl.person_id%TYPE,
458: p_admission_appl_number igs_he_ad_dtl.admission_appl_number%TYPE,
459: p_nominated_course_cd igs_he_ad_dtl.nominated_course_cd%TYPE ,
460: p_sequence_number igs_he_ad_dtl.sequence_number%TYPE) IS
461: SELECT special_student_cd
462: FROM igs_he_ad_dtl_all
463: WHERE person_id = p_person_id
464: AND admission_appl_number = p_admission_appl_number

Line 462: FROM igs_he_ad_dtl_all

458: p_admission_appl_number igs_he_ad_dtl.admission_appl_number%TYPE,
459: p_nominated_course_cd igs_he_ad_dtl.nominated_course_cd%TYPE ,
460: p_sequence_number igs_he_ad_dtl.sequence_number%TYPE) IS
461: SELECT special_student_cd
462: FROM igs_he_ad_dtl_all
463: WHERE person_id = p_person_id
464: AND admission_appl_number = p_admission_appl_number
465: AND nominated_course_cd = p_nominated_course_cd
466: AND sequence_number = p_sequence_number;