APPS.IGS_AS_SU_ATMPT_PAT_PKG dependencies on IGS_EN_SU_ATTEMPT

Line 92: v_version_number IGS_EN_SU_ATTEMPT.version_number%TYPE;

88: ) AS
89: v_message_name VARCHAR2(30);
90: v_error_count NUMBER;
91: v_warning_count NUMBER;
92: v_version_number IGS_EN_SU_ATTEMPT.version_number%TYPE;
93: CURSOR c_sua (cp_person_id IGS_EN_SU_ATTEMPT.person_id%TYPE,
94: cp_course_cd IGS_EN_SU_ATTEMPT.course_cd%TYPE,
95: cp_uoo_id IGS_EN_SU_ATTEMPT.uoo_id%TYPE) IS
96: SELECT version_number

Line 93: CURSOR c_sua (cp_person_id IGS_EN_SU_ATTEMPT.person_id%TYPE,

89: v_message_name VARCHAR2(30);
90: v_error_count NUMBER;
91: v_warning_count NUMBER;
92: v_version_number IGS_EN_SU_ATTEMPT.version_number%TYPE;
93: CURSOR c_sua (cp_person_id IGS_EN_SU_ATTEMPT.person_id%TYPE,
94: cp_course_cd IGS_EN_SU_ATTEMPT.course_cd%TYPE,
95: cp_uoo_id IGS_EN_SU_ATTEMPT.uoo_id%TYPE) IS
96: SELECT version_number
97: FROM IGS_EN_SU_ATTEMPT

Line 94: cp_course_cd IGS_EN_SU_ATTEMPT.course_cd%TYPE,

90: v_error_count NUMBER;
91: v_warning_count NUMBER;
92: v_version_number IGS_EN_SU_ATTEMPT.version_number%TYPE;
93: CURSOR c_sua (cp_person_id IGS_EN_SU_ATTEMPT.person_id%TYPE,
94: cp_course_cd IGS_EN_SU_ATTEMPT.course_cd%TYPE,
95: cp_uoo_id IGS_EN_SU_ATTEMPT.uoo_id%TYPE) IS
96: SELECT version_number
97: FROM IGS_EN_SU_ATTEMPT
98: WHERE person_id = cp_person_id AND

Line 95: cp_uoo_id IGS_EN_SU_ATTEMPT.uoo_id%TYPE) IS

91: v_warning_count NUMBER;
92: v_version_number IGS_EN_SU_ATTEMPT.version_number%TYPE;
93: CURSOR c_sua (cp_person_id IGS_EN_SU_ATTEMPT.person_id%TYPE,
94: cp_course_cd IGS_EN_SU_ATTEMPT.course_cd%TYPE,
95: cp_uoo_id IGS_EN_SU_ATTEMPT.uoo_id%TYPE) IS
96: SELECT version_number
97: FROM IGS_EN_SU_ATTEMPT
98: WHERE person_id = cp_person_id AND
99: course_cd = cp_course_cd AND

Line 97: FROM IGS_EN_SU_ATTEMPT

93: CURSOR c_sua (cp_person_id IGS_EN_SU_ATTEMPT.person_id%TYPE,
94: cp_course_cd IGS_EN_SU_ATTEMPT.course_cd%TYPE,
95: cp_uoo_id IGS_EN_SU_ATTEMPT.uoo_id%TYPE) IS
96: SELECT version_number
97: FROM IGS_EN_SU_ATTEMPT
98: WHERE person_id = cp_person_id AND
99: course_cd = cp_course_cd AND
100: uoo_id = cp_uoo_id;
101: BEGIN

Line 237: ELSIF NOT IGS_EN_SU_ATTEMPT_PKG.Get_PK_For_Validation (

233: ((new_references.person_id IS NULL) OR
234: (new_references.course_cd IS NULL) OR
235: (new_references.uoo_id IS NULL))) THEN
236: NULL;
237: ELSIF NOT IGS_EN_SU_ATTEMPT_PKG.Get_PK_For_Validation (
238: new_references.person_id,
239: new_references.course_cd,
240: new_references.uoo_id
241: )THEN

Line 292: PROCEDURE GET_FK_IGS_EN_SU_ATTEMPT (

288: Close cur_rowid;
289: Return (FALSE);
290: END IF;
291: END Get_PK_For_Validation;
292: PROCEDURE GET_FK_IGS_EN_SU_ATTEMPT (
293: x_person_id IN NUMBER,
294: x_course_cd IN VARCHAR2,
295: x_uoo_id IN NUMBER
296: ) IS

Line 316: END GET_FK_IGS_EN_SU_ATTEMPT;

312:
313: Return;
314: END IF;
315: Close cur_rowid;
316: END GET_FK_IGS_EN_SU_ATTEMPT;
317: PROCEDURE GET_UFK_IGS_AS_UNTAS_PATTERN (
318: x_ass_pattern_id IN NUMBER
319: ) IS
320: CURSOR cur_rowid IS