APPS.IGS_AD_VAL_ACAI_FTR_OFFER dependencies on IGS_AD_APPL

Line 29: p_admission_appl_number igs_ad_appl.admission_appl_number%TYPE,

25: p_application_type VARCHAR2 DEFAULT NULL,
26: p_application_id NUMBER DEFAULT NULL);
27:
28: FUNCTION handle_application( p_person_id hz_parties.party_id%TYPE,
29: p_admission_appl_number igs_ad_appl.admission_appl_number%TYPE,
30: p_nominated_course_cd igs_ad_ps_appl.nominated_course_cd%TYPE,
31: p_sequence_number igs_ad_ps_appl_inst.sequence_number%TYPE,
32: p_fut_acad_cal_type igs_ad_appl.acad_cal_type%TYPE,
33: p_fut_acad_cal_seq_no igs_ad_appl.acad_ci_sequence_number%TYPE,

Line 32: p_fut_acad_cal_type igs_ad_appl.acad_cal_type%TYPE,

28: FUNCTION handle_application( p_person_id hz_parties.party_id%TYPE,
29: p_admission_appl_number igs_ad_appl.admission_appl_number%TYPE,
30: p_nominated_course_cd igs_ad_ps_appl.nominated_course_cd%TYPE,
31: p_sequence_number igs_ad_ps_appl_inst.sequence_number%TYPE,
32: p_fut_acad_cal_type igs_ad_appl.acad_cal_type%TYPE,
33: p_fut_acad_cal_seq_no igs_ad_appl.acad_ci_sequence_number%TYPE,
34: p_fut_adm_cal_type igs_ad_appl.adm_cal_type%TYPE,
35: p_fut_adm_cal_seq_no igs_ad_appl.adm_ci_sequence_number%TYPE,
36: p_new_admission_appl_number OUT NOCOPY igs_ad_appl.admission_appl_number%TYPE,

Line 33: p_fut_acad_cal_seq_no igs_ad_appl.acad_ci_sequence_number%TYPE,

29: p_admission_appl_number igs_ad_appl.admission_appl_number%TYPE,
30: p_nominated_course_cd igs_ad_ps_appl.nominated_course_cd%TYPE,
31: p_sequence_number igs_ad_ps_appl_inst.sequence_number%TYPE,
32: p_fut_acad_cal_type igs_ad_appl.acad_cal_type%TYPE,
33: p_fut_acad_cal_seq_no igs_ad_appl.acad_ci_sequence_number%TYPE,
34: p_fut_adm_cal_type igs_ad_appl.adm_cal_type%TYPE,
35: p_fut_adm_cal_seq_no igs_ad_appl.adm_ci_sequence_number%TYPE,
36: p_new_admission_appl_number OUT NOCOPY igs_ad_appl.admission_appl_number%TYPE,
37: p_new_sequence_number OUT NOCOPY igs_ad_ps_appl_inst.sequence_number%TYPE)

Line 34: p_fut_adm_cal_type igs_ad_appl.adm_cal_type%TYPE,

30: p_nominated_course_cd igs_ad_ps_appl.nominated_course_cd%TYPE,
31: p_sequence_number igs_ad_ps_appl_inst.sequence_number%TYPE,
32: p_fut_acad_cal_type igs_ad_appl.acad_cal_type%TYPE,
33: p_fut_acad_cal_seq_no igs_ad_appl.acad_ci_sequence_number%TYPE,
34: p_fut_adm_cal_type igs_ad_appl.adm_cal_type%TYPE,
35: p_fut_adm_cal_seq_no igs_ad_appl.adm_ci_sequence_number%TYPE,
36: p_new_admission_appl_number OUT NOCOPY igs_ad_appl.admission_appl_number%TYPE,
37: p_new_sequence_number OUT NOCOPY igs_ad_ps_appl_inst.sequence_number%TYPE)
38: RETURN BOOLEAN;

Line 35: p_fut_adm_cal_seq_no igs_ad_appl.adm_ci_sequence_number%TYPE,

31: p_sequence_number igs_ad_ps_appl_inst.sequence_number%TYPE,
32: p_fut_acad_cal_type igs_ad_appl.acad_cal_type%TYPE,
33: p_fut_acad_cal_seq_no igs_ad_appl.acad_ci_sequence_number%TYPE,
34: p_fut_adm_cal_type igs_ad_appl.adm_cal_type%TYPE,
35: p_fut_adm_cal_seq_no igs_ad_appl.adm_ci_sequence_number%TYPE,
36: p_new_admission_appl_number OUT NOCOPY igs_ad_appl.admission_appl_number%TYPE,
37: p_new_sequence_number OUT NOCOPY igs_ad_ps_appl_inst.sequence_number%TYPE)
38: RETURN BOOLEAN;
39:

Line 36: p_new_admission_appl_number OUT NOCOPY igs_ad_appl.admission_appl_number%TYPE,

32: p_fut_acad_cal_type igs_ad_appl.acad_cal_type%TYPE,
33: p_fut_acad_cal_seq_no igs_ad_appl.acad_ci_sequence_number%TYPE,
34: p_fut_adm_cal_type igs_ad_appl.adm_cal_type%TYPE,
35: p_fut_adm_cal_seq_no igs_ad_appl.adm_ci_sequence_number%TYPE,
36: p_new_admission_appl_number OUT NOCOPY igs_ad_appl.admission_appl_number%TYPE,
37: p_new_sequence_number OUT NOCOPY igs_ad_ps_appl_inst.sequence_number%TYPE)
38: RETURN BOOLEAN;
39:
40: FUNCTION copy_child_records( p_new_admission_appl_number IGS_AD_APPL.admission_appl_number%TYPE,

Line 40: FUNCTION copy_child_records( p_new_admission_appl_number IGS_AD_APPL.admission_appl_number%TYPE,

36: p_new_admission_appl_number OUT NOCOPY igs_ad_appl.admission_appl_number%TYPE,
37: p_new_sequence_number OUT NOCOPY igs_ad_ps_appl_inst.sequence_number%TYPE)
38: RETURN BOOLEAN;
39:
40: FUNCTION copy_child_records( p_new_admission_appl_number IGS_AD_APPL.admission_appl_number%TYPE,
41: p_new_sequence_number IGS_AD_PS_APPL_INST.sequence_number%TYPE,
42: p_person_id HZ_PARTIES.party_id%TYPE,
43: p_old_admission_appl_number IGS_AD_APPL.admission_appl_number%TYPE,
44: p_old_sequence_number IGS_AD_PS_APPL_INST.sequence_number%TYPE,

Line 43: p_old_admission_appl_number IGS_AD_APPL.admission_appl_number%TYPE,

39:
40: FUNCTION copy_child_records( p_new_admission_appl_number IGS_AD_APPL.admission_appl_number%TYPE,
41: p_new_sequence_number IGS_AD_PS_APPL_INST.sequence_number%TYPE,
42: p_person_id HZ_PARTIES.party_id%TYPE,
43: p_old_admission_appl_number IGS_AD_APPL.admission_appl_number%TYPE,
44: p_old_sequence_number IGS_AD_PS_APPL_INST.sequence_number%TYPE,
45: p_nominated_course_cd IGS_AD_PS_APPL.nominated_course_cd%TYPE,
46: p_start_dt DATE,
47: p_process VARCHAR2)

Line 58: p_fut_acad_cal_type igs_ad_appl.acad_cal_type%TYPE,

54: p_old_admission_appl_number IGS_AD_PS_APPL_INST.admission_appl_number%TYPE,
55: p_old_sequence_number IGS_AD_PS_APPL_INST.sequence_number%TYPE,
56: p_offer_dt igs_ad_ps_appl_inst.offer_dt%TYPE,
57: p_offer_response_dt igs_ad_ps_appl_inst.offer_response_dt%TYPE,
58: p_fut_acad_cal_type igs_ad_appl.acad_cal_type%TYPE,
59: p_fut_acad_cal_seq_no igs_ad_appl.acad_ci_sequence_number%TYPE,
60: p_fut_adm_cal_type igs_ad_appl.adm_cal_type%TYPE,
61: p_fut_adm_cal_seq_no igs_ad_appl.adm_ci_sequence_number%TYPE,
62: p_start_dt DATE) RETURN BOOLEAN;

Line 59: p_fut_acad_cal_seq_no igs_ad_appl.acad_ci_sequence_number%TYPE,

55: p_old_sequence_number IGS_AD_PS_APPL_INST.sequence_number%TYPE,
56: p_offer_dt igs_ad_ps_appl_inst.offer_dt%TYPE,
57: p_offer_response_dt igs_ad_ps_appl_inst.offer_response_dt%TYPE,
58: p_fut_acad_cal_type igs_ad_appl.acad_cal_type%TYPE,
59: p_fut_acad_cal_seq_no igs_ad_appl.acad_ci_sequence_number%TYPE,
60: p_fut_adm_cal_type igs_ad_appl.adm_cal_type%TYPE,
61: p_fut_adm_cal_seq_no igs_ad_appl.adm_ci_sequence_number%TYPE,
62: p_start_dt DATE) RETURN BOOLEAN;
63:

Line 60: p_fut_adm_cal_type igs_ad_appl.adm_cal_type%TYPE,

56: p_offer_dt igs_ad_ps_appl_inst.offer_dt%TYPE,
57: p_offer_response_dt igs_ad_ps_appl_inst.offer_response_dt%TYPE,
58: p_fut_acad_cal_type igs_ad_appl.acad_cal_type%TYPE,
59: p_fut_acad_cal_seq_no igs_ad_appl.acad_ci_sequence_number%TYPE,
60: p_fut_adm_cal_type igs_ad_appl.adm_cal_type%TYPE,
61: p_fut_adm_cal_seq_no igs_ad_appl.adm_ci_sequence_number%TYPE,
62: p_start_dt DATE) RETURN BOOLEAN;
63:
64: FUNCTION copy_entrycomp_qual_status( p_person_id HZ_PARTIES.PARTY_ID%TYPE,

Line 61: p_fut_adm_cal_seq_no igs_ad_appl.adm_ci_sequence_number%TYPE,

57: p_offer_response_dt igs_ad_ps_appl_inst.offer_response_dt%TYPE,
58: p_fut_acad_cal_type igs_ad_appl.acad_cal_type%TYPE,
59: p_fut_acad_cal_seq_no igs_ad_appl.acad_ci_sequence_number%TYPE,
60: p_fut_adm_cal_type igs_ad_appl.adm_cal_type%TYPE,
61: p_fut_adm_cal_seq_no igs_ad_appl.adm_ci_sequence_number%TYPE,
62: p_start_dt DATE) RETURN BOOLEAN;
63:
64: FUNCTION copy_entrycomp_qual_status( p_person_id HZ_PARTIES.PARTY_ID%TYPE,
65: p_nominated_course_cd IGS_AD_PS_APPL_INST.NOMINATED_COURSE_CD%TYPE,