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_CO_VAL_CCI dependencies on IGS_CO_CAT

Line 45: p_correspondence_cat IN IGS_CO_CAT.correspondence_cat%TYPE,

41: WHERE sca.person_id = p_person_id AND
42: sca.course_cd = p_course_cd;
43: FUNCTION corpl_val_cci (
44: p_course_cd IN IGS_PS_COURSE.course_cd%TYPE,
45: p_correspondence_cat IN IGS_CO_CAT.correspondence_cat%TYPE,
46: p_correspondence_type IN IGS_CO_TYPE.correspondence_type%TYPE,
47: p_message_name OUT NOCOPY varchar2)
48: RETURN
49: BOOLEAN

Line 54: IGS_CO_CAT_ITM.block_when_encumbered_ind%TYPE;

50: AS
51: BEGIN
52: DECLARE
53: v_block_when_encumbered_ind
54: IGS_CO_CAT_ITM.block_when_encumbered_ind%TYPE;
55: CURSOR c_cci IS
56: SELECT cci.block_when_encumbered_ind
57: FROM IGS_CO_CAT_ITM cci
58: WHERE cci.correspondence_cat = p_correspondence_cat AND

Line 57: FROM IGS_CO_CAT_ITM cci

53: v_block_when_encumbered_ind
54: IGS_CO_CAT_ITM.block_when_encumbered_ind%TYPE;
55: CURSOR c_cci IS
56: SELECT cci.block_when_encumbered_ind
57: FROM IGS_CO_CAT_ITM cci
58: WHERE cci.correspondence_cat = p_correspondence_cat AND
59: cci.correspondence_type = p_correspondence_type AND
60: cci.logical_delete_dt IS NULL;
61: CURSOR c_cortjo IS

Line 68: FROM IGS_CO_CAT_ITM cci

64: WHERE cortjo.s_job_name = p_job_name AND
65: cortjo.output_num = p_output_num AND
66: cortjo.correspondence_type IN (
67: SELECT cci.correspondence_type
68: FROM IGS_CO_CAT_ITM cci
69: WHERE cci.correspondence_type =
70: cortjo.correspondence_type AND
71: cci.logical_delete_dt IS NULL);
72: BEGIN

Line 229: cp_correspondence_cat IGS_CO_CAT_ITM.correspondence_cat%TYPE,

225: BEGIN
226: DECLARE
227: v_closed_ind IGS_CO_TYPE.closed_ind%TYPE;
228: CURSOR c_cci(
229: cp_correspondence_cat IGS_CO_CAT_ITM.correspondence_cat%TYPE,
230: cp_correspondence_type IGS_CO_CAT_ITM.correspondence_type%TYPE,
231: cp_create_dt IGS_CO_CAT_ITM.create_dt%TYPE) IS
232: SELECT cci.correspondence_cat
233: FROM IGS_CO_CAT_ITM cci

Line 230: cp_correspondence_type IGS_CO_CAT_ITM.correspondence_type%TYPE,

226: DECLARE
227: v_closed_ind IGS_CO_TYPE.closed_ind%TYPE;
228: CURSOR c_cci(
229: cp_correspondence_cat IGS_CO_CAT_ITM.correspondence_cat%TYPE,
230: cp_correspondence_type IGS_CO_CAT_ITM.correspondence_type%TYPE,
231: cp_create_dt IGS_CO_CAT_ITM.create_dt%TYPE) IS
232: SELECT cci.correspondence_cat
233: FROM IGS_CO_CAT_ITM cci
234: WHERE cci.correspondence_cat = cp_correspondence_cat AND

Line 231: cp_create_dt IGS_CO_CAT_ITM.create_dt%TYPE) IS

227: v_closed_ind IGS_CO_TYPE.closed_ind%TYPE;
228: CURSOR c_cci(
229: cp_correspondence_cat IGS_CO_CAT_ITM.correspondence_cat%TYPE,
230: cp_correspondence_type IGS_CO_CAT_ITM.correspondence_type%TYPE,
231: cp_create_dt IGS_CO_CAT_ITM.create_dt%TYPE) IS
232: SELECT cci.correspondence_cat
233: FROM IGS_CO_CAT_ITM cci
234: WHERE cci.correspondence_cat = cp_correspondence_cat AND
235: cci.correspondence_type = cp_correspondence_type AND

Line 233: FROM IGS_CO_CAT_ITM cci

229: cp_correspondence_cat IGS_CO_CAT_ITM.correspondence_cat%TYPE,
230: cp_correspondence_type IGS_CO_CAT_ITM.correspondence_type%TYPE,
231: cp_create_dt IGS_CO_CAT_ITM.create_dt%TYPE) IS
232: SELECT cci.correspondence_cat
233: FROM IGS_CO_CAT_ITM cci
234: WHERE cci.correspondence_cat = cp_correspondence_cat AND
235: cci.correspondence_type = cp_correspondence_type AND
236: cci.create_dt <> cp_create_dt AND
237: cci.logical_delete_dt IS NULL;