APPS.IGS_AD_APP_REQ_PKG dependencies on IGS_AD_APPL

Line 140: FROM igs_ad_appl_stat

136: -- Cursor to get the application processing status for an application
137: CURSOR c_appl_status (cp_person_id igs_ad_app_req.person_id%TYPE,
138: cp_admission_appl_number igs_ad_app_req.admission_appl_number%TYPE) IS
139: SELECT s_adm_appl_status
140: FROM igs_ad_appl_stat
141: WHERE adm_appl_status = ( SELECT adm_appl_status
142: FROM igs_ad_appl
143: WHERE person_id = cp_person_id
144: AND admission_appl_number = cp_admission_appl_number );

Line 142: FROM igs_ad_appl

138: cp_admission_appl_number igs_ad_app_req.admission_appl_number%TYPE) IS
139: SELECT s_adm_appl_status
140: FROM igs_ad_appl_stat
141: WHERE adm_appl_status = ( SELECT adm_appl_status
142: FROM igs_ad_appl
143: WHERE person_id = cp_person_id
144: AND admission_appl_number = cp_admission_appl_number );
145:
146: l_appl_status igs_ad_appl.adm_appl_status%TYPE;

Line 146: l_appl_status igs_ad_appl.adm_appl_status%TYPE;

142: FROM igs_ad_appl
143: WHERE person_id = cp_person_id
144: AND admission_appl_number = cp_admission_appl_number );
145:
146: l_appl_status igs_ad_appl.adm_appl_status%TYPE;
147:
148: -- Cursor to get the fee type
149: CURSOR cur_enr_dpt(cp_applicant_fee_type igs_ad_app_req.applicant_fee_type%TYPE) IS
150: SELECT system_status

Line 167: FROM igs_ad_appl

163: -- Cursor to get the application date of the application
164: CURSOR c_appl_dt(cp_person_id igs_ad_app_req.person_id%TYPE,
165: cp_admission_appl_number igs_ad_app_req.admission_appl_number%TYPE) IS
166: SELECT appl_dt
167: FROM igs_ad_appl
168: where person_id = cp_person_id
169: and admission_appl_number = cp_admission_appl_number;
170:
171: l_appl_dt igs_ad_appl.appl_dt%TYPE;

Line 171: l_appl_dt igs_ad_appl.appl_dt%TYPE;

167: FROM igs_ad_appl
168: where person_id = cp_person_id
169: and admission_appl_number = cp_admission_appl_number;
170:
171: l_appl_dt igs_ad_appl.appl_dt%TYPE;
172: l_manage_acc igs_fi_control_all.manage_accounts%TYPE;
173: l_message_name fnd_new_messages.message_name%TYPE;
174:
175: BEGIN

Line 252: fnd_message.set_name('IGS','IGS_AD_APPL_DATE_ERROR');

248:
249: -- the fee date cannot be earlier than the application date
250: /* relaxed this validation as per bug 4027871
251: IF new_references.fee_date < l_appl_dt THEN
252: fnd_message.set_name('IGS','IGS_AD_APPL_DATE_ERROR');
253: fnd_message.set_token ('NAME',fnd_message.get_string('IGS','IGS_AD_FEE_DATE'));
254: igs_ge_msg_stack.add;
255: app_exception.raise_exception;
256: END IF;

Line 344: ELSIF NOT Igs_Ad_Appl_Pkg.Get_PK_For_Validation (

340: (old_references.admission_appl_number = new_references.admission_appl_number)) OR
341: ((new_references.person_id IS NULL) OR
342: (new_references.admission_appl_number IS NULL))) THEN
343: NULL;
344: ELSIF NOT Igs_Ad_Appl_Pkg.Get_PK_For_Validation (
345: new_references.person_id,
346: new_references.admission_appl_number
347: ) THEN
348: FND_MESSAGE.SET_NAME('IGS','IGS_GE_PK_UK_NOT_FOUND');

Line 349: FND_MESSAGE.SET_TOKEN('ATTRIBUTE',FND_MESSAGE.GET_STRING('IGS','IGS_AD_APPL'));

345: new_references.person_id,
346: new_references.admission_appl_number
347: ) THEN
348: FND_MESSAGE.SET_NAME('IGS','IGS_GE_PK_UK_NOT_FOUND');
349: FND_MESSAGE.SET_TOKEN('ATTRIBUTE',FND_MESSAGE.GET_STRING('IGS','IGS_AD_APPL'));
350: IGS_GE_MSG_STACK.ADD;
351: App_Exception.Raise_Exception;
352: END IF;
353:

Line 363: FND_MESSAGE.SET_TOKEN('ATTRIBUTE',FND_MESSAGE.GET_STRING('IGS','IGS_AD_APPLICANT_FEE_STAT'));

359: 'SYS_FEE_STATUS',
360: 'N'
361: ) THEN
362: FND_MESSAGE.SET_NAME('IGS','IGS_GE_PK_UK_NOT_FOUND_CLOSED');
363: FND_MESSAGE.SET_TOKEN('ATTRIBUTE',FND_MESSAGE.GET_STRING('IGS','IGS_AD_APPLICANT_FEE_STAT'));
364: IGS_GE_MSG_STACK.ADD;
365: App_Exception.Raise_Exception;
366: END IF;
367:

Line 377: FND_MESSAGE.SET_TOKEN('ATTRIBUTE',FND_MESSAGE.GET_STRING('IGS','IGS_AD_APPLICANT_FEE_TYPE'));

373: 'SYS_FEE_TYPE',
374: 'N'
375: ) THEN
376: FND_MESSAGE.SET_NAME('IGS','IGS_GE_PK_UK_NOT_FOUND_CLOSED');
377: FND_MESSAGE.SET_TOKEN('ATTRIBUTE',FND_MESSAGE.GET_STRING('IGS','IGS_AD_APPLICANT_FEE_TYPE'));
378: IGS_GE_MSG_STACK.ADD;
379: App_Exception.Raise_Exception;
380: END IF;
381:

Line 449: PROCEDURE Get_FK_Igs_Ad_Appl (

445: END IF;
446: END Get_PK_For_Validation;
447:
448:
449: PROCEDURE Get_FK_Igs_Ad_Appl (
450: x_person_id IN NUMBER,
451: x_admission_appl_number IN NUMBER
452: ) AS
453:

Line 486: END Get_FK_Igs_Ad_Appl;

482: Return;
483: END IF;
484: Close cur_rowid;
485:
486: END Get_FK_Igs_Ad_Appl;
487:
488: PROCEDURE Get_FK_Igs_Ad_Code_Classes (
489: x_code_id IN NUMBER
490: ) AS