APPS.IGS_PS_AWD_OWN_PKG dependencies on IGS_PS_AWARD

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

116: END BeforeRowInsertUpdateDelete1;
117:
118: PROCEDURE before_insert_update(p_inserting IN BOOLEAN DEFAULT FALSE,
119: p_updating IN BOOLEAN DEFAULT FALSE ) AS
120: CURSOR c_closed_ind (cp_c_award_cd IN IGS_PS_AWARD.AWARD_CD%TYPE,
121: cp_c_course_cd IN IGS_PS_AWARD.COURSE_CD%TYPE,
122: cp_n_version_num IN IGS_PS_AWARD.VERSION_NUMBER%TYPE) IS
123: SELECT CLOSED_IND
124: FROM IGS_PS_AWARD

Line 121: cp_c_course_cd IN IGS_PS_AWARD.COURSE_CD%TYPE,

117:
118: PROCEDURE before_insert_update(p_inserting IN BOOLEAN DEFAULT FALSE,
119: p_updating IN BOOLEAN DEFAULT FALSE ) AS
120: CURSOR c_closed_ind (cp_c_award_cd IN IGS_PS_AWARD.AWARD_CD%TYPE,
121: cp_c_course_cd IN IGS_PS_AWARD.COURSE_CD%TYPE,
122: cp_n_version_num IN IGS_PS_AWARD.VERSION_NUMBER%TYPE) IS
123: SELECT CLOSED_IND
124: FROM IGS_PS_AWARD
125: WHERE AWARD_CD = cp_c_award_cd

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

118: PROCEDURE before_insert_update(p_inserting IN BOOLEAN DEFAULT FALSE,
119: p_updating IN BOOLEAN DEFAULT FALSE ) AS
120: CURSOR c_closed_ind (cp_c_award_cd IN IGS_PS_AWARD.AWARD_CD%TYPE,
121: cp_c_course_cd IN IGS_PS_AWARD.COURSE_CD%TYPE,
122: cp_n_version_num IN IGS_PS_AWARD.VERSION_NUMBER%TYPE) IS
123: SELECT CLOSED_IND
124: FROM IGS_PS_AWARD
125: WHERE AWARD_CD = cp_c_award_cd
126: AND COURSE_CD = cp_c_course_cd

Line 124: FROM IGS_PS_AWARD

120: CURSOR c_closed_ind (cp_c_award_cd IN IGS_PS_AWARD.AWARD_CD%TYPE,
121: cp_c_course_cd IN IGS_PS_AWARD.COURSE_CD%TYPE,
122: cp_n_version_num IN IGS_PS_AWARD.VERSION_NUMBER%TYPE) IS
123: SELECT CLOSED_IND
124: FROM IGS_PS_AWARD
125: WHERE AWARD_CD = cp_c_award_cd
126: AND COURSE_CD = cp_c_course_cd
127: AND VERSION_NUMBER = cp_n_version_num;
128: l_c_closed_ind VARCHAR2(1);

Line 199: IF NOT IGS_PS_AWARD_PKG.Get_PK_For_Validation (

195: (new_references.version_number IS NULL) OR
196: (new_references.award_cd IS NULL))) THEN
197: NULL;
198: ELSE
199: IF NOT IGS_PS_AWARD_PKG.Get_PK_For_Validation (
200: new_references.course_cd,
201: new_references.version_number,
202: new_references.award_cd
203: ) THEN