APPS.IGS_AD_VAL_ACAI_FTR_OFFER dependencies on IGS_AD_APPL_ALL

Line 26: FUNCTION copy_candidacy_records(p_new_admission_appl_number IGS_AD_APPL_ALL.admission_appl_number%TYPE,

22: rghosh 15-may-2003 Bug#2871426(Evaluator Entry and Assignment) Added the closed ind check in the cursor c_evaluators_cur
23: and in the call to insert row of igs_ad_appl_eval_pkg
24: *******************************************************************************/
25:
26: FUNCTION copy_candidacy_records(p_new_admission_appl_number IGS_AD_APPL_ALL.admission_appl_number%TYPE,
27: p_new_sequence_number IGS_AD_PS_APPL_INST_ALL.sequence_number%TYPE,
28: p_person_id HZ_PARTIES.party_id%TYPE,
29: p_old_admission_appl_number IGS_AD_APPL.admission_appl_number%TYPE,
30: p_old_sequence_number IGS_AD_PS_APPL_INST_ALL.sequence_number%TYPE,

Line 572: CURSOR c_get_acad_cal_info(cp_person_id igs_ad_appl_all.person_id%TYPE,

568:
569: l_exists VARCHAR2(1);
570: l_pers_grp VARCHAR2(1);
571:
572: CURSOR c_get_acad_cal_info(cp_person_id igs_ad_appl_all.person_id%TYPE,
573: cp_admission_appl_number igs_ad_appl_all.admission_appl_number%TYPE) IS
574: SELECT acad_cal_type,acad_ci_sequence_number
575: FROM igs_ad_appl_all
576: WHERE person_id = cp_person_id

Line 573: cp_admission_appl_number igs_ad_appl_all.admission_appl_number%TYPE) IS

569: l_exists VARCHAR2(1);
570: l_pers_grp VARCHAR2(1);
571:
572: CURSOR c_get_acad_cal_info(cp_person_id igs_ad_appl_all.person_id%TYPE,
573: cp_admission_appl_number igs_ad_appl_all.admission_appl_number%TYPE) IS
574: SELECT acad_cal_type,acad_ci_sequence_number
575: FROM igs_ad_appl_all
576: WHERE person_id = cp_person_id
577: AND admission_appl_number = cp_admission_appl_number;

Line 575: FROM igs_ad_appl_all

571:
572: CURSOR c_get_acad_cal_info(cp_person_id igs_ad_appl_all.person_id%TYPE,
573: cp_admission_appl_number igs_ad_appl_all.admission_appl_number%TYPE) IS
574: SELECT acad_cal_type,acad_ci_sequence_number
575: FROM igs_ad_appl_all
576: WHERE person_id = cp_person_id
577: AND admission_appl_number = cp_admission_appl_number;
578:
579: l_get_acad_cal_info c_get_acad_cal_info%ROWTYPE;

Line 996: CURSOR c_sys_def_appl_type(cp_adm_cat igs_ad_appl_all.admission_cat%TYPE,

992: AND aca.person_id = acai.person_id
993: AND aca.admission_appl_number = acai.admission_appl_number
994: AND aca.nominated_course_cd = acai.nominated_course_cd;
995:
996: CURSOR c_sys_def_appl_type(cp_adm_cat igs_ad_appl_all.admission_cat%TYPE,
997: cp_s_adm_prc_typ igs_ad_appl_all.s_admission_process_type%TYPE
998: )
999: IS
1000: SELECT admission_application_type

Line 997: cp_s_adm_prc_typ igs_ad_appl_all.s_admission_process_type%TYPE

993: AND aca.admission_appl_number = acai.admission_appl_number
994: AND aca.nominated_course_cd = acai.nominated_course_cd;
995:
996: CURSOR c_sys_def_appl_type(cp_adm_cat igs_ad_appl_all.admission_cat%TYPE,
997: cp_s_adm_prc_typ igs_ad_appl_all.s_admission_process_type%TYPE
998: )
999: IS
1000: SELECT admission_application_type
1001: FROM igs_ad_ss_appl_typ

Line 1018: l_application_type igs_ad_appl_all.application_type%TYPE;

1014: l_return_type VARCHAR2(100);
1015: l_error_code VARCHAR2(100);
1016: l_adm_appl_status igs_ad_appl.adm_appl_status%TYPE;
1017: l_admission_appl_number igs_ad_appl.admission_appl_number%TYPE;
1018: l_application_type igs_ad_appl_all.application_type%TYPE;
1019: ------------------- End Variable Declarations------------------------------------------------------
1020: BEGIN
1021:
1022: FOR c_appl_inst_rec IN c_appl_inst LOOP