APPS.IGS_AD_APPL_NOTES_PKG dependencies on IGS_AD_PS_APPL_INST

Line 152: ELSIF NOT Igs_Ad_Ps_Appl_Inst_Pkg.Get_PK_For_Validation (

148: (new_references.admission_appl_number IS NULL) OR
149: (new_references.nominated_course_cd IS NULL) OR
150: (new_references.sequence_number IS NULL))) THEN
151: NULL;
152: ELSIF NOT Igs_Ad_Ps_Appl_Inst_Pkg.Get_PK_For_Validation (
153: new_references.person_id,
154: new_references.admission_appl_number,
155: new_references.nominated_course_cd,
156: new_references.sequence_number

Line 259: PROCEDURE Get_FK_Igs_Ad_Ps_Appl_Inst (

255: close cur_rowid;
256: return(false);
257: END IF;
258: END Get_UK_For_Validation ;
259: PROCEDURE Get_FK_Igs_Ad_Ps_Appl_Inst (
260: x_person_id IN NUMBER,
261: x_admission_appl_number IN NUMBER,
262: x_nominated_course_cd IN VARCHAR2,
263: x_sequence_number IN NUMBER

Line 299: END Get_FK_Igs_Ad_Ps_Appl_Inst;

295: Return;
296: END IF;
297: Close cur_rowid;
298:
299: END Get_FK_Igs_Ad_Ps_Appl_Inst;
300:
301: PROCEDURE Get_FK_Igs_Ad_Note_Types (
302: x_notes_type_id IN NUMBER
303: ) AS

Line 366: CURSOR c_inst_status (cp_person_Id igs_ad_ps_appl_inst.Person_Id%TYPE,

362: (reverse chronological order - newest change first)
363: ***************************************************************/
364:
365:
366: CURSOR c_inst_status (cp_person_Id igs_ad_ps_appl_inst.Person_Id%TYPE,
367: cp_Admission_Appl_Number igs_ad_ps_appl_inst.Admission_Appl_Number%TYPE,
368: cp_Nominated_Course_Cd igs_ad_ps_appl_inst.Nominated_Course_Cd%TYPE,
369: cp_Sequence_Number igs_ad_ps_appl_inst.Sequence_Number%TYPE
370: )

Line 367: cp_Admission_Appl_Number igs_ad_ps_appl_inst.Admission_Appl_Number%TYPE,

363: ***************************************************************/
364:
365:
366: CURSOR c_inst_status (cp_person_Id igs_ad_ps_appl_inst.Person_Id%TYPE,
367: cp_Admission_Appl_Number igs_ad_ps_appl_inst.Admission_Appl_Number%TYPE,
368: cp_Nominated_Course_Cd igs_ad_ps_appl_inst.Nominated_Course_Cd%TYPE,
369: cp_Sequence_Number igs_ad_ps_appl_inst.Sequence_Number%TYPE
370: )
371: IS

Line 368: cp_Nominated_Course_Cd igs_ad_ps_appl_inst.Nominated_Course_Cd%TYPE,

364:
365:
366: CURSOR c_inst_status (cp_person_Id igs_ad_ps_appl_inst.Person_Id%TYPE,
367: cp_Admission_Appl_Number igs_ad_ps_appl_inst.Admission_Appl_Number%TYPE,
368: cp_Nominated_Course_Cd igs_ad_ps_appl_inst.Nominated_Course_Cd%TYPE,
369: cp_Sequence_Number igs_ad_ps_appl_inst.Sequence_Number%TYPE
370: )
371: IS
372: SELECT acaiv.appl_inst_status

Line 369: cp_Sequence_Number igs_ad_ps_appl_inst.Sequence_Number%TYPE

365:
366: CURSOR c_inst_status (cp_person_Id igs_ad_ps_appl_inst.Person_Id%TYPE,
367: cp_Admission_Appl_Number igs_ad_ps_appl_inst.Admission_Appl_Number%TYPE,
368: cp_Nominated_Course_Cd igs_ad_ps_appl_inst.Nominated_Course_Cd%TYPE,
369: cp_Sequence_Number igs_ad_ps_appl_inst.Sequence_Number%TYPE
370: )
371: IS
372: SELECT acaiv.appl_inst_status
373: FROM igs_ad_ps_appl_inst acaiv

Line 373: FROM igs_ad_ps_appl_inst acaiv

369: cp_Sequence_Number igs_ad_ps_appl_inst.Sequence_Number%TYPE
370: )
371: IS
372: SELECT acaiv.appl_inst_status
373: FROM igs_ad_ps_appl_inst acaiv
374: WHERE Person_Id = cp_person_Id AND
375: Admission_Appl_Number = cp_Admission_Appl_Number AND
376: Nominated_Course_Cd = cp_Nominated_Course_Cd AND
377: Sequence_Number = cp_Sequence_Number;

Line 379: lv_appl_inst_status igs_ad_ps_appl_inst.appl_inst_status%TYPE;

375: Admission_Appl_Number = cp_Admission_Appl_Number AND
376: Nominated_Course_Cd = cp_Nominated_Course_Cd AND
377: Sequence_Number = cp_Sequence_Number;
378:
379: lv_appl_inst_status igs_ad_ps_appl_inst.appl_inst_status%TYPE;
380:
381:
382:
383: