APPS.IGS_AV_ADV_STANDING_PKG dependencies on IGS_PS_VER

Line 108: cp_course_cd IGS_PS_VER.course_cd%TYPE,

104: SELECT ins.local_institution_ind
105: FROM igs_or_institution ins
106: WHERE ins.institution_cd = cp_ins_cd;
107: CURSOR cur_program_exempt_totals (
108: cp_course_cd IGS_PS_VER.course_cd%TYPE,
109: cp_version_number IGS_PS_VER.version_number%TYPE,
110: cp_local_ind VARCHAR2) IS
111: SELECT DECODE (cp_local_ind, 'N', NVL (cv.external_adv_stnd_limit, -1),
112: NVL (cv.internal_adv_stnd_limit, -1)) adv_stnd_limit

Line 109: cp_version_number IGS_PS_VER.version_number%TYPE,

105: FROM igs_or_institution ins
106: WHERE ins.institution_cd = cp_ins_cd;
107: CURSOR cur_program_exempt_totals (
108: cp_course_cd IGS_PS_VER.course_cd%TYPE,
109: cp_version_number IGS_PS_VER.version_number%TYPE,
110: cp_local_ind VARCHAR2) IS
111: SELECT DECODE (cp_local_ind, 'N', NVL (cv.external_adv_stnd_limit, -1),
112: NVL (cv.internal_adv_stnd_limit, -1)) adv_stnd_limit
113: FROM igs_ps_ver cv

Line 113: FROM igs_ps_ver cv

109: cp_version_number IGS_PS_VER.version_number%TYPE,
110: cp_local_ind VARCHAR2) IS
111: SELECT DECODE (cp_local_ind, 'N', NVL (cv.external_adv_stnd_limit, -1),
112: NVL (cv.internal_adv_stnd_limit, -1)) adv_stnd_limit
113: FROM igs_ps_ver cv
114: WHERE cv.course_cd = cp_course_cd
115: AND cv.version_number = cp_version_number;
116: rec_cur_program_exempt_totals cur_program_exempt_totals%ROWTYPE;
117: rec_local_inst_ind c_local_inst_ind%ROWTYPE;

Line 206: IF NOT IGS_PS_VER_PKG.Get_PK_For_Validation (

202: (new_references.version_number IS NULL))) THEN
203: NULL;
204: ELSE
205: ---
206: IF NOT IGS_PS_VER_PKG.Get_PK_For_Validation (
207: new_references.course_cd,
208: new_references.version_number) THEN
209:
210: FND_Message.Set_Name('FND','FORM_RECORD_DELETED');

Line 288: PROCEDURE GET_FK_IGS_PS_VER (

284: END IF;
285: ---
286: END Get_PK_For_Validation;
287:
288: PROCEDURE GET_FK_IGS_PS_VER (
289: x_course_cd IN VARCHAR2,
290: x_version_number IN NUMBER
291: ) AS
292:

Line 312: END GET_FK_IGS_PS_VER;

308: Close cur_rowid;
309: App_Exception.Raise_Exception;
310: Return;
311: END IF;
312: END GET_FK_IGS_PS_VER;
313:
314: PROCEDURE GET_FK_IGS_PE_PERSON (
315: x_person_id IN NUMBER
316: ) AS