APPS.IGS_AD_VAL_ACAI_FTR_OFFER dependencies on IGS_AD_PS_APPL

Line 20: p_nominated_course_cd igs_ad_ps_appl.nominated_course_cd%TYPE,

16: PROCEDURE admp_val_offer_future_term( errbuf out NOCOPY varchar2,
17: retcode out NOCOPY number ,
18: p_person_id hz_parties.party_id%TYPE,
19: p_group_id igs_pe_persid_group.group_id%TYPE,
20: p_nominated_course_cd igs_ad_ps_appl.nominated_course_cd%TYPE,
21: p_prev_acad_adm_cal VARCHAR2,
22: p_future_acad_adm_cal VARCHAR2,
23: p_offer_dt VARCHAR2,
24: p_offer_response_dt VARCHAR2,

Line 30: p_nominated_course_cd igs_ad_ps_appl.nominated_course_cd%TYPE,

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,
34: p_fut_adm_cal_type igs_ad_appl.adm_cal_type%TYPE,

Line 31: p_sequence_number igs_ad_ps_appl_inst.sequence_number%TYPE,

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,
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,

Line 37: p_new_sequence_number OUT NOCOPY igs_ad_ps_appl_inst.sequence_number%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,
41: p_new_sequence_number IGS_AD_PS_APPL_INST.sequence_number%TYPE,

Line 41: p_new_sequence_number IGS_AD_PS_APPL_INST.sequence_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,
45: p_nominated_course_cd IGS_AD_PS_APPL.nominated_course_cd%TYPE,

Line 44: p_old_sequence_number IGS_AD_PS_APPL_INST.sequence_number%TYPE,

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)
48: RETURN BOOLEAN ;

Line 45: p_nominated_course_cd IGS_AD_PS_APPL.nominated_course_cd%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)
48: RETURN BOOLEAN ;
49:

Line 51: p_nominated_course_cd IGS_AD_PS_APPL_INST.NOMINATED_COURSE_CD%TYPE,

47: p_process VARCHAR2)
48: RETURN BOOLEAN ;
49:
50: FUNCTION validate_offer_validations( p_person_id HZ_PARTIES.PARTY_ID%TYPE,
51: p_nominated_course_cd IGS_AD_PS_APPL_INST.NOMINATED_COURSE_CD%TYPE,
52: p_admission_appl_number IGS_AD_PS_APPL_INST.admission_appl_number%TYPE,
53: p_sequence_number IGS_AD_PS_APPL_INST.sequence_number%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,

Line 52: p_admission_appl_number IGS_AD_PS_APPL_INST.admission_appl_number%TYPE,

48: RETURN BOOLEAN ;
49:
50: FUNCTION validate_offer_validations( p_person_id HZ_PARTIES.PARTY_ID%TYPE,
51: p_nominated_course_cd IGS_AD_PS_APPL_INST.NOMINATED_COURSE_CD%TYPE,
52: p_admission_appl_number IGS_AD_PS_APPL_INST.admission_appl_number%TYPE,
53: p_sequence_number IGS_AD_PS_APPL_INST.sequence_number%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,

Line 53: p_sequence_number IGS_AD_PS_APPL_INST.sequence_number%TYPE,

49:
50: FUNCTION validate_offer_validations( p_person_id HZ_PARTIES.PARTY_ID%TYPE,
51: p_nominated_course_cd IGS_AD_PS_APPL_INST.NOMINATED_COURSE_CD%TYPE,
52: p_admission_appl_number IGS_AD_PS_APPL_INST.admission_appl_number%TYPE,
53: p_sequence_number IGS_AD_PS_APPL_INST.sequence_number%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,

Line 54: p_old_admission_appl_number IGS_AD_PS_APPL_INST.admission_appl_number%TYPE,

50: FUNCTION validate_offer_validations( p_person_id HZ_PARTIES.PARTY_ID%TYPE,
51: p_nominated_course_cd IGS_AD_PS_APPL_INST.NOMINATED_COURSE_CD%TYPE,
52: p_admission_appl_number IGS_AD_PS_APPL_INST.admission_appl_number%TYPE,
53: p_sequence_number IGS_AD_PS_APPL_INST.sequence_number%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,

Line 55: p_old_sequence_number IGS_AD_PS_APPL_INST.sequence_number%TYPE,

51: p_nominated_course_cd IGS_AD_PS_APPL_INST.NOMINATED_COURSE_CD%TYPE,
52: p_admission_appl_number IGS_AD_PS_APPL_INST.admission_appl_number%TYPE,
53: p_sequence_number IGS_AD_PS_APPL_INST.sequence_number%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,

Line 56: p_offer_dt igs_ad_ps_appl_inst.offer_dt%TYPE,

52: p_admission_appl_number IGS_AD_PS_APPL_INST.admission_appl_number%TYPE,
53: p_sequence_number IGS_AD_PS_APPL_INST.sequence_number%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,

Line 57: p_offer_response_dt igs_ad_ps_appl_inst.offer_response_dt%TYPE,

53: p_sequence_number IGS_AD_PS_APPL_INST.sequence_number%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,

Line 65: p_nominated_course_cd IGS_AD_PS_APPL_INST.NOMINATED_COURSE_CD%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,
66: p_admission_appl_number IGS_AD_PS_APPL_INST.admission_appl_number%TYPE,
67: p_sequence_number IGS_AD_PS_APPL_INST.sequence_number%TYPE,
68: p_new_admission_appl_number IGS_AD_PS_APPL_INST.admission_appl_number%TYPE,
69: p_new_sequence_number IGS_AD_PS_APPL_INST.sequence_number%TYPE ) RETURN BOOLEAN;

Line 66: p_admission_appl_number IGS_AD_PS_APPL_INST.admission_appl_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,
66: p_admission_appl_number IGS_AD_PS_APPL_INST.admission_appl_number%TYPE,
67: p_sequence_number IGS_AD_PS_APPL_INST.sequence_number%TYPE,
68: p_new_admission_appl_number IGS_AD_PS_APPL_INST.admission_appl_number%TYPE,
69: p_new_sequence_number IGS_AD_PS_APPL_INST.sequence_number%TYPE ) RETURN BOOLEAN;
70: END igs_ad_val_acai_ftr_offer;

Line 67: p_sequence_number IGS_AD_PS_APPL_INST.sequence_number%TYPE,

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,
66: p_admission_appl_number IGS_AD_PS_APPL_INST.admission_appl_number%TYPE,
67: p_sequence_number IGS_AD_PS_APPL_INST.sequence_number%TYPE,
68: p_new_admission_appl_number IGS_AD_PS_APPL_INST.admission_appl_number%TYPE,
69: p_new_sequence_number IGS_AD_PS_APPL_INST.sequence_number%TYPE ) RETURN BOOLEAN;
70: END igs_ad_val_acai_ftr_offer;

Line 68: p_new_admission_appl_number IGS_AD_PS_APPL_INST.admission_appl_number%TYPE,

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,
66: p_admission_appl_number IGS_AD_PS_APPL_INST.admission_appl_number%TYPE,
67: p_sequence_number IGS_AD_PS_APPL_INST.sequence_number%TYPE,
68: p_new_admission_appl_number IGS_AD_PS_APPL_INST.admission_appl_number%TYPE,
69: p_new_sequence_number IGS_AD_PS_APPL_INST.sequence_number%TYPE ) RETURN BOOLEAN;
70: END igs_ad_val_acai_ftr_offer;

Line 69: p_new_sequence_number IGS_AD_PS_APPL_INST.sequence_number%TYPE ) RETURN BOOLEAN;

65: p_nominated_course_cd IGS_AD_PS_APPL_INST.NOMINATED_COURSE_CD%TYPE,
66: p_admission_appl_number IGS_AD_PS_APPL_INST.admission_appl_number%TYPE,
67: p_sequence_number IGS_AD_PS_APPL_INST.sequence_number%TYPE,
68: p_new_admission_appl_number IGS_AD_PS_APPL_INST.admission_appl_number%TYPE,
69: p_new_sequence_number IGS_AD_PS_APPL_INST.sequence_number%TYPE ) RETURN BOOLEAN;
70: END igs_ad_val_acai_ftr_offer;