eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.IGS_AD_DEF_APPL_PKG dependencies on IGS_AD_PS_APPL_INST

Line 40: p_admission_appl_number IGS_AD_PS_APPL_INST.admission_appl_number%TYPE,

36: *******************************************************************************/
37: PROCEDURE cmn_handle_application
38: (
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,

Line 41: p_nominated_course_cd IGS_AD_PS_APPL_INST.nominated_course_cd%TYPE,

37: PROCEDURE cmn_handle_application
38: (
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,

Line 42: p_sequence_number IGS_AD_PS_APPL_INST.sequence_number%TYPE ,

38: (
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,

Line 47: p_offer_dt igs_ad_ps_appl_inst.offer_dt%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:
51: /*******************************************************************************

Line 48: p_offer_response_dt igs_ad_ps_appl_inst.offer_response_dt%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:
51: /*******************************************************************************
52: Created by : Ramesh Rengarajan

Line 66: p_sequence_number igs_ad_ps_appl_inst.sequence_number%TYPE,

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

Line 72: p_new_sequence_number OUT NOCOPY igs_ad_ps_appl_inst.sequence_number%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
76: Date created: 06 AUG 2002

Line 88: p_nominated_course_cd IGS_AD_PS_APPL_INST.NOMINATED_COURSE_CD%TYPE,

84: Who When What
85: *******************************************************************************/
86:
87: FUNCTION validate_offer_validations( p_person_id HZ_PARTIES.PARTY_ID%TYPE,
88: p_nominated_course_cd IGS_AD_PS_APPL_INST.NOMINATED_COURSE_CD%TYPE,
89: p_admission_appl_number IGS_AD_PS_APPL_INST.admission_appl_number%TYPE,
90: p_sequence_number IGS_AD_PS_APPL_INST.sequence_number%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,

Line 89: p_admission_appl_number IGS_AD_PS_APPL_INST.admission_appl_number%TYPE,

85: *******************************************************************************/
86:
87: FUNCTION validate_offer_validations( p_person_id HZ_PARTIES.PARTY_ID%TYPE,
88: p_nominated_course_cd IGS_AD_PS_APPL_INST.NOMINATED_COURSE_CD%TYPE,
89: p_admission_appl_number IGS_AD_PS_APPL_INST.admission_appl_number%TYPE,
90: p_sequence_number IGS_AD_PS_APPL_INST.sequence_number%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,

Line 90: p_sequence_number IGS_AD_PS_APPL_INST.sequence_number%TYPE,

86:
87: FUNCTION validate_offer_validations( p_person_id HZ_PARTIES.PARTY_ID%TYPE,
88: p_nominated_course_cd IGS_AD_PS_APPL_INST.NOMINATED_COURSE_CD%TYPE,
89: p_admission_appl_number IGS_AD_PS_APPL_INST.admission_appl_number%TYPE,
90: p_sequence_number IGS_AD_PS_APPL_INST.sequence_number%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,

Line 91: p_old_admission_appl_number IGS_AD_PS_APPL_INST.admission_appl_number%TYPE,

87: FUNCTION validate_offer_validations( p_person_id HZ_PARTIES.PARTY_ID%TYPE,
88: p_nominated_course_cd IGS_AD_PS_APPL_INST.NOMINATED_COURSE_CD%TYPE,
89: p_admission_appl_number IGS_AD_PS_APPL_INST.admission_appl_number%TYPE,
90: p_sequence_number IGS_AD_PS_APPL_INST.sequence_number%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,

Line 92: p_old_sequence_number IGS_AD_PS_APPL_INST.sequence_number%TYPE,

88: p_nominated_course_cd IGS_AD_PS_APPL_INST.NOMINATED_COURSE_CD%TYPE,
89: p_admission_appl_number IGS_AD_PS_APPL_INST.admission_appl_number%TYPE,
90: p_sequence_number IGS_AD_PS_APPL_INST.sequence_number%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,

Line 93: p_offer_dt igs_ad_ps_appl_inst.offer_dt%TYPE,

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

Line 94: p_offer_response_dt igs_ad_ps_appl_inst.offer_response_dt%TYPE,

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

Line 113: p_nominated_course_cd IGS_AD_PS_APPL_INST.NOMINATED_COURSE_CD%TYPE,

109: Who When What
110: *******************************************************************************/
111:
112: FUNCTION copy_entrycomp_qual_status( p_person_id HZ_PARTIES.PARTY_ID%TYPE,
113: p_nominated_course_cd IGS_AD_PS_APPL_INST.NOMINATED_COURSE_CD%TYPE,
114: p_admission_appl_number IGS_AD_PS_APPL_INST.admission_appl_number%TYPE,
115: p_sequence_number IGS_AD_PS_APPL_INST.sequence_number%TYPE,
116: p_new_admission_appl_number IGS_AD_PS_APPL_INST.admission_appl_number%TYPE,
117: p_new_sequence_number IGS_AD_PS_APPL_INST.sequence_number%TYPE ) RETURN BOOLEAN;

Line 114: p_admission_appl_number IGS_AD_PS_APPL_INST.admission_appl_number%TYPE,

110: *******************************************************************************/
111:
112: FUNCTION copy_entrycomp_qual_status( p_person_id HZ_PARTIES.PARTY_ID%TYPE,
113: p_nominated_course_cd IGS_AD_PS_APPL_INST.NOMINATED_COURSE_CD%TYPE,
114: p_admission_appl_number IGS_AD_PS_APPL_INST.admission_appl_number%TYPE,
115: p_sequence_number IGS_AD_PS_APPL_INST.sequence_number%TYPE,
116: p_new_admission_appl_number IGS_AD_PS_APPL_INST.admission_appl_number%TYPE,
117: p_new_sequence_number IGS_AD_PS_APPL_INST.sequence_number%TYPE ) RETURN BOOLEAN;
118:

Line 115: p_sequence_number IGS_AD_PS_APPL_INST.sequence_number%TYPE,

111:
112: FUNCTION copy_entrycomp_qual_status( p_person_id HZ_PARTIES.PARTY_ID%TYPE,
113: p_nominated_course_cd IGS_AD_PS_APPL_INST.NOMINATED_COURSE_CD%TYPE,
114: p_admission_appl_number IGS_AD_PS_APPL_INST.admission_appl_number%TYPE,
115: p_sequence_number IGS_AD_PS_APPL_INST.sequence_number%TYPE,
116: p_new_admission_appl_number IGS_AD_PS_APPL_INST.admission_appl_number%TYPE,
117: p_new_sequence_number IGS_AD_PS_APPL_INST.sequence_number%TYPE ) RETURN BOOLEAN;
118:
119: /*******************************************************************************

Line 116: p_new_admission_appl_number IGS_AD_PS_APPL_INST.admission_appl_number%TYPE,

112: FUNCTION copy_entrycomp_qual_status( p_person_id HZ_PARTIES.PARTY_ID%TYPE,
113: p_nominated_course_cd IGS_AD_PS_APPL_INST.NOMINATED_COURSE_CD%TYPE,
114: p_admission_appl_number IGS_AD_PS_APPL_INST.admission_appl_number%TYPE,
115: p_sequence_number IGS_AD_PS_APPL_INST.sequence_number%TYPE,
116: p_new_admission_appl_number IGS_AD_PS_APPL_INST.admission_appl_number%TYPE,
117: p_new_sequence_number IGS_AD_PS_APPL_INST.sequence_number%TYPE ) RETURN BOOLEAN;
118:
119: /*******************************************************************************
120: Created by : hreddych

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

113: p_nominated_course_cd IGS_AD_PS_APPL_INST.NOMINATED_COURSE_CD%TYPE,
114: p_admission_appl_number IGS_AD_PS_APPL_INST.admission_appl_number%TYPE,
115: p_sequence_number IGS_AD_PS_APPL_INST.sequence_number%TYPE,
116: p_new_admission_appl_number IGS_AD_PS_APPL_INST.admission_appl_number%TYPE,
117: p_new_sequence_number IGS_AD_PS_APPL_INST.sequence_number%TYPE ) RETURN BOOLEAN;
118:
119: /*******************************************************************************
120: Created by : hreddych
121: Date created: 16 OCT 2002

Line 133: p_admission_appl_number IGS_AD_PS_APPL_INST.admission_appl_number%TYPE,

129: apadegal 06-Oct-2005 Changed it to a Function to handle exceptions in pre-enrolment.
130: *******************************************************************************/
131:
132: FUNCTION Update_offer_response_accepted (p_person_id HZ_PARTIES.party_id%TYPE,
133: p_admission_appl_number IGS_AD_PS_APPL_INST.admission_appl_number%TYPE,
134: p_nominated_course_cd IGS_AD_PS_APPL_INST.NOMINATED_COURSE_CD%TYPE,
135: p_sequence_number IGS_AD_PS_APPL_INST.sequence_number%TYPE) RETURN BOOLEAN;
136: END IGS_AD_DEF_APPL_PKG;

Line 134: p_nominated_course_cd IGS_AD_PS_APPL_INST.NOMINATED_COURSE_CD%TYPE,

130: *******************************************************************************/
131:
132: FUNCTION Update_offer_response_accepted (p_person_id HZ_PARTIES.party_id%TYPE,
133: p_admission_appl_number IGS_AD_PS_APPL_INST.admission_appl_number%TYPE,
134: p_nominated_course_cd IGS_AD_PS_APPL_INST.NOMINATED_COURSE_CD%TYPE,
135: p_sequence_number IGS_AD_PS_APPL_INST.sequence_number%TYPE) RETURN BOOLEAN;
136: END IGS_AD_DEF_APPL_PKG;

Line 135: p_sequence_number IGS_AD_PS_APPL_INST.sequence_number%TYPE) RETURN BOOLEAN;

131:
132: FUNCTION Update_offer_response_accepted (p_person_id HZ_PARTIES.party_id%TYPE,
133: p_admission_appl_number IGS_AD_PS_APPL_INST.admission_appl_number%TYPE,
134: p_nominated_course_cd IGS_AD_PS_APPL_INST.NOMINATED_COURSE_CD%TYPE,
135: p_sequence_number IGS_AD_PS_APPL_INST.sequence_number%TYPE) RETURN BOOLEAN;
136: END IGS_AD_DEF_APPL_PKG;