APPS.IGS_PS_FAC_ASG_TASK_PKG dependencies on IGS_PS_FAC_TASK_TYP

Line 95: ELSIF NOT igs_ps_fac_task_typ_pkg.get_pk_for_validation (

91:
92: IF (((old_references.faculty_task_type = new_references.faculty_task_type)) OR
93: ((new_references.faculty_task_type IS NULL))) THEN
94: NULL;
95: ELSIF NOT igs_ps_fac_task_typ_pkg.get_pk_for_validation (
96: new_references.faculty_task_type
97: ) THEN
98: fnd_message.set_name ('FND', 'FORM_RECORD_DELETED');
99: igs_ge_msg_stack.add;

Line 200: CURSOR c_closed(cp_c_fac_task_type igs_ps_fac_task_typ.faculty_task_type%TYPE) IS

196: || Who When What
197: || (reverse chronological order - newest change first)
198: */
199:
200: CURSOR c_closed(cp_c_fac_task_type igs_ps_fac_task_typ.faculty_task_type%TYPE) IS
201: SELECT 'X'
202: FROM IGS_PS_FAC_TASK_TYP
203: WHERE FACULTY_TASK_TYPE=cp_c_fac_task_type
204: AND CLOSED_IND = 'Y';

Line 202: FROM IGS_PS_FAC_TASK_TYP

198: */
199:
200: CURSOR c_closed(cp_c_fac_task_type igs_ps_fac_task_typ.faculty_task_type%TYPE) IS
201: SELECT 'X'
202: FROM IGS_PS_FAC_TASK_TYP
203: WHERE FACULTY_TASK_TYPE=cp_c_fac_task_type
204: AND CLOSED_IND = 'Y';
205: l_c_var VARCHAR2(1);
206: