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_GR_AWD_CEREMONY_PKG dependencies on IGS_PS_AWARD

Line 194: CURSOR c_closed_ind (cp_c_award_cd IN IGS_PS_AWARD.AWARD_CD%TYPE,

190: END AfterRowInsertUpdate2;
191:
192: PROCEDURE before_insert_update(p_inserting IN BOOLEAN DEFAULT FALSE,
193: p_updating IN BOOLEAN DEFAULT FALSE ) AS
194: CURSOR c_closed_ind (cp_c_award_cd IN IGS_PS_AWARD.AWARD_CD%TYPE,
195: cp_c_course_cd IN IGS_PS_AWARD.COURSE_CD%TYPE,
196: cp_n_version_num IN IGS_PS_AWARD.VERSION_NUMBER%TYPE) IS
197: SELECT CLOSED_IND
198: FROM IGS_PS_AWARD

Line 195: cp_c_course_cd IN IGS_PS_AWARD.COURSE_CD%TYPE,

191:
192: PROCEDURE before_insert_update(p_inserting IN BOOLEAN DEFAULT FALSE,
193: p_updating IN BOOLEAN DEFAULT FALSE ) AS
194: CURSOR c_closed_ind (cp_c_award_cd IN IGS_PS_AWARD.AWARD_CD%TYPE,
195: cp_c_course_cd IN IGS_PS_AWARD.COURSE_CD%TYPE,
196: cp_n_version_num IN IGS_PS_AWARD.VERSION_NUMBER%TYPE) IS
197: SELECT CLOSED_IND
198: FROM IGS_PS_AWARD
199: WHERE AWARD_CD = cp_c_award_cd

Line 196: cp_n_version_num IN IGS_PS_AWARD.VERSION_NUMBER%TYPE) IS

192: PROCEDURE before_insert_update(p_inserting IN BOOLEAN DEFAULT FALSE,
193: p_updating IN BOOLEAN DEFAULT FALSE ) AS
194: CURSOR c_closed_ind (cp_c_award_cd IN IGS_PS_AWARD.AWARD_CD%TYPE,
195: cp_c_course_cd IN IGS_PS_AWARD.COURSE_CD%TYPE,
196: cp_n_version_num IN IGS_PS_AWARD.VERSION_NUMBER%TYPE) IS
197: SELECT CLOSED_IND
198: FROM IGS_PS_AWARD
199: WHERE AWARD_CD = cp_c_award_cd
200: AND COURSE_CD = cp_c_course_cd

Line 198: FROM IGS_PS_AWARD

194: CURSOR c_closed_ind (cp_c_award_cd IN IGS_PS_AWARD.AWARD_CD%TYPE,
195: cp_c_course_cd IN IGS_PS_AWARD.COURSE_CD%TYPE,
196: cp_n_version_num IN IGS_PS_AWARD.VERSION_NUMBER%TYPE) IS
197: SELECT CLOSED_IND
198: FROM IGS_PS_AWARD
199: WHERE AWARD_CD = cp_c_award_cd
200: AND COURSE_CD = cp_c_course_cd
201: AND VERSION_NUMBER = cp_n_version_num;
202: l_c_closed_ind VARCHAR2(1);

Line 255: IF NOT IGS_PS_AWARD_PKG.Get_PK_For_Validation (

251: (new_references.award_crs_version_number IS NULL) OR
252: (new_references.award_cd IS NULL))) THEN
253: NULL;
254: ELSE
255: IF NOT IGS_PS_AWARD_PKG.Get_PK_For_Validation (
256: new_references.award_course_cd,
257: new_references.award_crs_version_number,
258: new_references.award_cd
259: ) THEN