APPS.IGS_HE_VERIFY_RETURN_PKG dependencies on IGS_HE_EXTRACT_FIELDS_PKG

Line 399: l_awd_table igs_he_extract_fields_pkg.awd_table;

395: l_prog_type igs_ps_ver_all.course_type%TYPE;
396: l_prev_pid_type igs_pe_alt_pers_id.person_id_type%TYPE := 'X' ;
397: l_api_person_id igs_pe_alt_pers_id.api_person_id%TYPE;
398: l_id NUMBER;
399: l_awd_table igs_he_extract_fields_pkg.awd_table;
400: l_prog_rec_flag BOOLEAN := FALSE;
401: l_prog_type_rec_flag BOOLEAN := FALSE;
402: l_awd_conf_start_dt igs_he_submsn_awd.award_start_date%TYPE;
403: l_awd_conf_end_dt igs_he_submsn_awd.award_end_date%TYPE;

Line 420: igs_he_extract_fields_pkg.get_awd_dtls( p_submission_name, l_awd_table, l_prog_rec_flag, l_prog_type_rec_flag);

416: fnd_message.set_token('DATE',TO_CHAR(SYSDATE,'DD-MON-YYYY HH24:MI:SS'));
417: fnd_file.put_line(fnd_file.log,fnd_message.get());
418:
419: -- Get award conferral dates (to be used in c_get_spa)
420: igs_he_extract_fields_pkg.get_awd_dtls( p_submission_name, l_awd_table, l_prog_rec_flag, l_prog_type_rec_flag);
421: igs_he_extract_fields_pkg.get_min_max_awd_dates( p_submission_name, g_he_submsn_header.enrolment_start_date, g_he_submsn_header.enrolment_end_date, l_awd_conf_start_dt, l_awd_conf_end_dt);
422:
423: -- Examine each spa record for eligibility
424: FOR l_std_inst IN c_get_spa(l_awd_conf_start_dt, l_awd_conf_end_dt) LOOP

Line 421: igs_he_extract_fields_pkg.get_min_max_awd_dates( p_submission_name, g_he_submsn_header.enrolment_start_date, g_he_submsn_header.enrolment_end_date, l_awd_conf_start_dt, l_awd_conf_end_dt);

417: fnd_file.put_line(fnd_file.log,fnd_message.get());
418:
419: -- Get award conferral dates (to be used in c_get_spa)
420: igs_he_extract_fields_pkg.get_awd_dtls( p_submission_name, l_awd_table, l_prog_rec_flag, l_prog_type_rec_flag);
421: igs_he_extract_fields_pkg.get_min_max_awd_dates( p_submission_name, g_he_submsn_header.enrolment_start_date, g_he_submsn_header.enrolment_end_date, l_awd_conf_start_dt, l_awd_conf_end_dt);
422:
423: -- Examine each spa record for eligibility
424: FOR l_std_inst IN c_get_spa(l_awd_conf_start_dt, l_awd_conf_end_dt) LOOP
425:

Line 471: igs_he_extract_fields_pkg.get_awd_conferral_dates(l_awd_table,

467: FETCH c_prog_type INTO l_prog_type;
468: CLOSE c_prog_type;
469:
470:
471: igs_he_extract_fields_pkg.get_awd_conferral_dates(l_awd_table,
472: p_submission_name,
473: l_prog_rec_flag,
474: l_prog_type_rec_flag,
475: l_std_inst.course_cd,

Line 486: igs_he_extract_fields_pkg.get_awd_conferral_dates(l_awd_table,

482: ELSE
483:
484: -- If there are award conferral dates specified at the program level only,
485: -- then check if any relate to this particular student program attempt
486: igs_he_extract_fields_pkg.get_awd_conferral_dates(l_awd_table,
487: p_submission_name,
488: l_prog_rec_flag,
489: l_prog_type_rec_flag,
490: l_std_inst.course_cd,