DBA Data[Home] [Help]

APPS.IGS_AD_DEF_APPL_PKG dependencies on IGS_AD_APPL

Line 43: p_def_acad_cal_type igs_ad_appl.acad_cal_type%TYPE ,

39: p_person_id hz_parties.party_id%TYPE,
40: p_admission_appl_number IGS_AD_PS_APPL_INST.admission_appl_number%TYPE,
41: p_nominated_course_cd IGS_AD_PS_APPL_INST.nominated_course_cd%TYPE,
42: p_sequence_number IGS_AD_PS_APPL_INST.sequence_number%TYPE ,
43: p_def_acad_cal_type igs_ad_appl.acad_cal_type%TYPE ,
44: p_def_acad_cal_seq_no igs_ad_appl.acad_ci_sequence_number%TYPE,
45: p_def_adm_cal_type igs_ad_appl.adm_cal_type%TYPE,
46: p_def_adm_cal_seq_no igs_ad_appl.adm_ci_sequence_number%TYPE,
47: p_offer_dt igs_ad_ps_appl_inst.offer_dt%TYPE,

Line 44: p_def_acad_cal_seq_no igs_ad_appl.acad_ci_sequence_number%TYPE,

40: p_admission_appl_number IGS_AD_PS_APPL_INST.admission_appl_number%TYPE,
41: p_nominated_course_cd IGS_AD_PS_APPL_INST.nominated_course_cd%TYPE,
42: p_sequence_number IGS_AD_PS_APPL_INST.sequence_number%TYPE ,
43: p_def_acad_cal_type igs_ad_appl.acad_cal_type%TYPE ,
44: p_def_acad_cal_seq_no igs_ad_appl.acad_ci_sequence_number%TYPE,
45: p_def_adm_cal_type igs_ad_appl.adm_cal_type%TYPE,
46: p_def_adm_cal_seq_no igs_ad_appl.adm_ci_sequence_number%TYPE,
47: p_offer_dt igs_ad_ps_appl_inst.offer_dt%TYPE,
48: p_offer_response_dt igs_ad_ps_appl_inst.offer_response_dt%TYPE

Line 45: p_def_adm_cal_type igs_ad_appl.adm_cal_type%TYPE,

41: p_nominated_course_cd IGS_AD_PS_APPL_INST.nominated_course_cd%TYPE,
42: p_sequence_number IGS_AD_PS_APPL_INST.sequence_number%TYPE ,
43: p_def_acad_cal_type igs_ad_appl.acad_cal_type%TYPE ,
44: p_def_acad_cal_seq_no igs_ad_appl.acad_ci_sequence_number%TYPE,
45: p_def_adm_cal_type igs_ad_appl.adm_cal_type%TYPE,
46: p_def_adm_cal_seq_no igs_ad_appl.adm_ci_sequence_number%TYPE,
47: p_offer_dt igs_ad_ps_appl_inst.offer_dt%TYPE,
48: p_offer_response_dt igs_ad_ps_appl_inst.offer_response_dt%TYPE
49: );

Line 46: p_def_adm_cal_seq_no igs_ad_appl.adm_ci_sequence_number%TYPE,

42: p_sequence_number IGS_AD_PS_APPL_INST.sequence_number%TYPE ,
43: p_def_acad_cal_type igs_ad_appl.acad_cal_type%TYPE ,
44: p_def_acad_cal_seq_no igs_ad_appl.acad_ci_sequence_number%TYPE,
45: p_def_adm_cal_type igs_ad_appl.adm_cal_type%TYPE,
46: p_def_adm_cal_seq_no igs_ad_appl.adm_ci_sequence_number%TYPE,
47: p_offer_dt igs_ad_ps_appl_inst.offer_dt%TYPE,
48: p_offer_response_dt igs_ad_ps_appl_inst.offer_response_dt%TYPE
49: );
50:

Line 64: p_admission_appl_number igs_ad_appl.admission_appl_number%TYPE,

60: Change History: (who, when, what: )
61: Who When What
62: *******************************************************************************/
63: FUNCTION handle_application( p_person_id hz_parties.party_id%TYPE,
64: p_admission_appl_number igs_ad_appl.admission_appl_number%TYPE,
65: p_nominated_course_cd igs_ad_ps_appl.nominated_course_cd%TYPE,
66: p_sequence_number igs_ad_ps_appl_inst.sequence_number%TYPE,
67: p_def_acad_cal_type igs_ad_appl.acad_cal_type%TYPE,
68: p_def_acad_cal_seq_no igs_ad_appl.acad_ci_sequence_number%TYPE,

Line 67: p_def_acad_cal_type igs_ad_appl.acad_cal_type%TYPE,

63: FUNCTION handle_application( p_person_id hz_parties.party_id%TYPE,
64: p_admission_appl_number igs_ad_appl.admission_appl_number%TYPE,
65: p_nominated_course_cd igs_ad_ps_appl.nominated_course_cd%TYPE,
66: p_sequence_number igs_ad_ps_appl_inst.sequence_number%TYPE,
67: p_def_acad_cal_type igs_ad_appl.acad_cal_type%TYPE,
68: p_def_acad_cal_seq_no igs_ad_appl.acad_ci_sequence_number%TYPE,
69: p_def_adm_cal_type igs_ad_appl.adm_cal_type%TYPE,
70: p_def_adm_cal_seq_no igs_ad_appl.adm_ci_sequence_number%TYPE,
71: p_new_admission_appl_number OUT NOCOPY igs_ad_appl.admission_appl_number%TYPE,

Line 68: p_def_acad_cal_seq_no igs_ad_appl.acad_ci_sequence_number%TYPE,

64: p_admission_appl_number igs_ad_appl.admission_appl_number%TYPE,
65: p_nominated_course_cd igs_ad_ps_appl.nominated_course_cd%TYPE,
66: p_sequence_number igs_ad_ps_appl_inst.sequence_number%TYPE,
67: p_def_acad_cal_type igs_ad_appl.acad_cal_type%TYPE,
68: p_def_acad_cal_seq_no igs_ad_appl.acad_ci_sequence_number%TYPE,
69: p_def_adm_cal_type igs_ad_appl.adm_cal_type%TYPE,
70: p_def_adm_cal_seq_no igs_ad_appl.adm_ci_sequence_number%TYPE,
71: p_new_admission_appl_number OUT NOCOPY igs_ad_appl.admission_appl_number%TYPE,
72: p_new_sequence_number OUT NOCOPY igs_ad_ps_appl_inst.sequence_number%TYPE)

Line 69: p_def_adm_cal_type igs_ad_appl.adm_cal_type%TYPE,

65: p_nominated_course_cd igs_ad_ps_appl.nominated_course_cd%TYPE,
66: p_sequence_number igs_ad_ps_appl_inst.sequence_number%TYPE,
67: p_def_acad_cal_type igs_ad_appl.acad_cal_type%TYPE,
68: p_def_acad_cal_seq_no igs_ad_appl.acad_ci_sequence_number%TYPE,
69: p_def_adm_cal_type igs_ad_appl.adm_cal_type%TYPE,
70: p_def_adm_cal_seq_no igs_ad_appl.adm_ci_sequence_number%TYPE,
71: p_new_admission_appl_number OUT NOCOPY igs_ad_appl.admission_appl_number%TYPE,
72: p_new_sequence_number OUT NOCOPY igs_ad_ps_appl_inst.sequence_number%TYPE)
73: RETURN BOOLEAN;

Line 70: p_def_adm_cal_seq_no igs_ad_appl.adm_ci_sequence_number%TYPE,

66: p_sequence_number igs_ad_ps_appl_inst.sequence_number%TYPE,
67: p_def_acad_cal_type igs_ad_appl.acad_cal_type%TYPE,
68: p_def_acad_cal_seq_no igs_ad_appl.acad_ci_sequence_number%TYPE,
69: p_def_adm_cal_type igs_ad_appl.adm_cal_type%TYPE,
70: p_def_adm_cal_seq_no igs_ad_appl.adm_ci_sequence_number%TYPE,
71: p_new_admission_appl_number OUT NOCOPY igs_ad_appl.admission_appl_number%TYPE,
72: p_new_sequence_number OUT NOCOPY igs_ad_ps_appl_inst.sequence_number%TYPE)
73: RETURN BOOLEAN;
74: /*******************************************************************************

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

67: p_def_acad_cal_type igs_ad_appl.acad_cal_type%TYPE,
68: p_def_acad_cal_seq_no igs_ad_appl.acad_ci_sequence_number%TYPE,
69: p_def_adm_cal_type igs_ad_appl.adm_cal_type%TYPE,
70: p_def_adm_cal_seq_no igs_ad_appl.adm_ci_sequence_number%TYPE,
71: p_new_admission_appl_number OUT NOCOPY igs_ad_appl.admission_appl_number%TYPE,
72: p_new_sequence_number OUT NOCOPY igs_ad_ps_appl_inst.sequence_number%TYPE)
73: RETURN BOOLEAN;
74: /*******************************************************************************
75: Created by : Ramesh Rengarajan

Line 95: p_def_acad_cal_type igs_ad_appl.acad_cal_type%TYPE,

91: p_old_admission_appl_number IGS_AD_PS_APPL_INST.admission_appl_number%TYPE,
92: p_old_sequence_number IGS_AD_PS_APPL_INST.sequence_number%TYPE,
93: p_offer_dt igs_ad_ps_appl_inst.offer_dt%TYPE,
94: p_offer_response_dt igs_ad_ps_appl_inst.offer_response_dt%TYPE,
95: p_def_acad_cal_type igs_ad_appl.acad_cal_type%TYPE,
96: p_def_acad_cal_seq_no igs_ad_appl.acad_ci_sequence_number%TYPE,
97: p_def_adm_cal_type igs_ad_appl.adm_cal_type%TYPE,
98: p_def_adm_cal_seq_no igs_ad_appl.adm_ci_sequence_number%TYPE,
99: p_start_dt DATE) RETURN BOOLEAN;

Line 96: p_def_acad_cal_seq_no igs_ad_appl.acad_ci_sequence_number%TYPE,

92: p_old_sequence_number IGS_AD_PS_APPL_INST.sequence_number%TYPE,
93: p_offer_dt igs_ad_ps_appl_inst.offer_dt%TYPE,
94: p_offer_response_dt igs_ad_ps_appl_inst.offer_response_dt%TYPE,
95: p_def_acad_cal_type igs_ad_appl.acad_cal_type%TYPE,
96: p_def_acad_cal_seq_no igs_ad_appl.acad_ci_sequence_number%TYPE,
97: p_def_adm_cal_type igs_ad_appl.adm_cal_type%TYPE,
98: p_def_adm_cal_seq_no igs_ad_appl.adm_ci_sequence_number%TYPE,
99: p_start_dt DATE) RETURN BOOLEAN;
100: /*******************************************************************************

Line 97: p_def_adm_cal_type igs_ad_appl.adm_cal_type%TYPE,

93: p_offer_dt igs_ad_ps_appl_inst.offer_dt%TYPE,
94: p_offer_response_dt igs_ad_ps_appl_inst.offer_response_dt%TYPE,
95: p_def_acad_cal_type igs_ad_appl.acad_cal_type%TYPE,
96: p_def_acad_cal_seq_no igs_ad_appl.acad_ci_sequence_number%TYPE,
97: p_def_adm_cal_type igs_ad_appl.adm_cal_type%TYPE,
98: p_def_adm_cal_seq_no igs_ad_appl.adm_ci_sequence_number%TYPE,
99: p_start_dt DATE) RETURN BOOLEAN;
100: /*******************************************************************************
101: Created by : Ramesh Rengarajan

Line 98: p_def_adm_cal_seq_no igs_ad_appl.adm_ci_sequence_number%TYPE,

94: p_offer_response_dt igs_ad_ps_appl_inst.offer_response_dt%TYPE,
95: p_def_acad_cal_type igs_ad_appl.acad_cal_type%TYPE,
96: p_def_acad_cal_seq_no igs_ad_appl.acad_ci_sequence_number%TYPE,
97: p_def_adm_cal_type igs_ad_appl.adm_cal_type%TYPE,
98: p_def_adm_cal_seq_no igs_ad_appl.adm_ci_sequence_number%TYPE,
99: p_start_dt DATE) RETURN BOOLEAN;
100: /*******************************************************************************
101: Created by : Ramesh Rengarajan
102: Date created: 06 AUG 2002