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.

[Home] [Help]

APPS.IGS_EN_VAL_PEE dependencies on IGS_PE_PERSENC_EFFCT

Line 15: v_person_id IGS_PE_PERSENC_EFFCT.person_id%TYPE;

11: RETURN BOOLEAN AS
12:
13: BEGIN
14: DECLARE
15: v_person_id IGS_PE_PERSENC_EFFCT.person_id%TYPE;
16: CURSOR c_pee IS
17: SELECT pee.person_id
18: FROM IGS_PE_PERSENC_EFFCT pee
19: WHERE pee.person_id = p_person_id AND

Line 18: FROM IGS_PE_PERSENC_EFFCT pee

14: DECLARE
15: v_person_id IGS_PE_PERSENC_EFFCT.person_id%TYPE;
16: CURSOR c_pee IS
17: SELECT pee.person_id
18: FROM IGS_PE_PERSENC_EFFCT pee
19: WHERE pee.person_id = p_person_id AND
20: pee.s_encmb_effect_type = p_s_encmb_effect_type AND
21: pee.sequence_number <> p_sequence_number AND
22: ( pee.expiry_dt IS NULL OR

Line 31: -- Note:course_cd is not part of the primary key of IGS_PE_PERSENC_EFFCT

27: --RSTR_GE_CP encumbrance effect for the nominated course code, when
28: --attempting to apply credit point restriction effect. Required to
29: --prevent the situation of having a full-time and part-time
30: --restriction applied to the same course.
31: -- Note:course_cd is not part of the primary key of IGS_PE_PERSENC_EFFCT
32: --It is included in the selection criteria as it is possible for course_based
33: --IGS_PE_PERSENC_EFFCT records to exist for more than one records.
34: --(ie the primary key will match. - uniqueness is enforced by a sequence
35: -- number.

Line 33: --IGS_PE_PERSENC_EFFCT records to exist for more than one records.

29: --prevent the situation of having a full-time and part-time
30: --restriction applied to the same course.
31: -- Note:course_cd is not part of the primary key of IGS_PE_PERSENC_EFFCT
32: --It is included in the selection criteria as it is possible for course_based
33: --IGS_PE_PERSENC_EFFCT records to exist for more than one records.
34: --(ie the primary key will match. - uniqueness is enforced by a sequence
35: -- number.
36: --1. Validate the input parameters.
37: IF (p_person_id IS NULL OR

Line 43: --2. Select all IGS_PE_PERSENC_EFFCT's-

39: (p_s_encmb_effect_type NOT IN ('RSTR_LE_CP', 'RSTR_GE_CP'))) THEN
40: p_message_name := null;
41: RETURN TRUE;
42: END IF;
43: --2. Select all IGS_PE_PERSENC_EFFCT's-
44: OPEN c_pee;
45: FETCH c_pee INTO v_person_id;
46: IF (c_pee%NOTFOUND) THEN
47: CLOSE c_pee;

Line 77: v_person_id IGS_PE_PERSENC_EFFCT.person_id%TYPE;

73: RETURN BOOLEAN AS
74:
75: BEGIN
76: DECLARE
77: v_person_id IGS_PE_PERSENC_EFFCT.person_id%TYPE;
78: CURSOR c_pee IS
79: SELECT pee.person_id
80: FROM IGS_PE_PERSENC_EFFCT pee
81: WHERE pee.person_id = p_person_id AND

Line 80: FROM IGS_PE_PERSENC_EFFCT pee

76: DECLARE
77: v_person_id IGS_PE_PERSENC_EFFCT.person_id%TYPE;
78: CURSOR c_pee IS
79: SELECT pee.person_id
80: FROM IGS_PE_PERSENC_EFFCT pee
81: WHERE pee.person_id = p_person_id AND
82: pee.s_encmb_effect_type = p_s_encmb_effect_type AND
83: pee.sequence_number <> p_sequence_number AND
84: ( pee.expiry_dt IS NULL OR

Line 92: -- Note:course_cd is not part of the primary key of IGS_PE_PERSENC_EFFCT

88: -- Validate that here is not an existing RSTR_AT_TY encumbrance
89: --effect for the nominated course code. Required to prevent the
90: --situation of having a full-time and part-time restriction applied
91: --to the same course.
92: -- Note:course_cd is not part of the primary key of IGS_PE_PERSENC_EFFCT
93: -- It is included in the selection criteria as it is possible for course_based
94: -- IGS_PE_PERSENC_EFFCT records to exist for more than one records.
95: -- (ie the primary key will match. - uniqueness is enforced by a sequence
96: -- number.

Line 94: -- IGS_PE_PERSENC_EFFCT records to exist for more than one records.

90: --situation of having a full-time and part-time restriction applied
91: --to the same course.
92: -- Note:course_cd is not part of the primary key of IGS_PE_PERSENC_EFFCT
93: -- It is included in the selection criteria as it is possible for course_based
94: -- IGS_PE_PERSENC_EFFCT records to exist for more than one records.
95: -- (ie the primary key will match. - uniqueness is enforced by a sequence
96: -- number.
97: --1. Validate the input parameters.
98: IF (p_person_id IS NULL OR

Line 104: --2. Select all IGS_PE_PERSENC_EFFCT's-

100: p_course_cd IS NULL) THEN
101: p_message_name := null;
102: RETURN TRUE;
103: END IF;
104: --2. Select all IGS_PE_PERSENC_EFFCT's-
105: OPEN c_pee;
106: FETCH c_pee INTO v_person_id;
107: IF (c_pee%NOTFOUND) THEN
108: CLOSE c_pee;

Line 148: FROM IGS_PE_PERSENC_EFFCT pee

144:
145: v_rec_found BOOLEAN;
146: CURSOR c_pee_no_course IS
147: SELECT person_id
148: FROM IGS_PE_PERSENC_EFFCT pee
149: WHERE pee.person_id = p_person_id AND
150: pee.encumbrance_type = p_encumbrance_type AND
151: pee.pen_start_dt = p_pen_start_dt AND
152: pee.s_encmb_effect_type = p_s_encmb_effect_type AND

Line 156: FROM IGS_PE_PERSENC_EFFCT pee

152: pee.s_encmb_effect_type = p_s_encmb_effect_type AND
153: pee.pee_start_dt = p_pee_start_dt;
154: CURSOR c_pee_course IS
155: SELECT person_id
156: FROM IGS_PE_PERSENC_EFFCT pee
157: WHERE pee.person_id = p_person_id AND
158: pee.encumbrance_type = p_encumbrance_type AND
159: pee.pen_start_dt = p_pen_start_dt AND
160: pee.s_encmb_effect_type = p_s_encmb_effect_type AND

Line 165: -- IGS_PE_PERSENC_EFFCT records for the nominated encumbrance

161: pee.pee_start_dt = p_pee_start_dt AND
162: pee.course_cd = p_course_cd;
163: BEGIN
164: -- This module validates that there are no matching
165: -- IGS_PE_PERSENC_EFFCT records for the nominated encumbrance
166: -- effect type.
167: -- validate the input parameters
168: IF (p_person_id IS NULL OR
169: p_encumbrance_type IS NULL OR

Line 176: -- check if a IGS_PE_PERSENC_EFFCT record

172: p_pee_start_dt IS NULL) THEN
173: p_message_name := null;
174: RETURN TRUE;
175: END IF;
176: -- check if a IGS_PE_PERSENC_EFFCT record
177: -- exists when the course_cd is not specified
178: IF (p_course_cd IS NULL) THEN
179: -- set that no records have yet been found
180: v_rec_found := FALSE;

Line 194: -- check if a IGS_PE_PERSENC_EFFCT record

190: p_message_name := 'IGS_GE_RECORD_ALREADY_EXISTS';
191: RETURN FALSE;
192: END IF;
193: END IF;
194: -- check if a IGS_PE_PERSENC_EFFCT record
195: -- exists when the course_cd is specified
196: IF (p_course_cd IS NOT NULL) THEN
197: -- set that no records have yet been found
198: v_rec_found := FALSE;

Line 242: FROM IGS_PE_PERSENC_EFFCT pee

238:
239: v_rec_found BOOLEAN;
240: CURSOR c_pee_no_course IS
241: SELECT person_id
242: FROM IGS_PE_PERSENC_EFFCT pee
243: WHERE pee.person_id = p_person_id AND
244: pee.encumbrance_type = p_encumbrance_type AND
245: pee.pen_start_dt = p_pen_start_dt AND
246: pee.s_encmb_effect_type = p_s_encmb_effect_type AND

Line 251: FROM IGS_PE_PERSENC_EFFCT pee

247: pee.sequence_number <> p_sequence_number AND
248: pee.expiry_dt IS NULL;
249: CURSOR c_pee_course IS
250: SELECT person_id
251: FROM IGS_PE_PERSENC_EFFCT pee
252: WHERE pee.person_id = p_person_id AND
253: pee.encumbrance_type = p_encumbrance_type AND
254: pee.pen_start_dt = p_pen_start_dt AND
255: pee.s_encmb_effect_type = p_s_encmb_effect_type AND

Line 261: -- IGS_PE_PERSENC_EFFCT records for the nominated encumbrance

257: pee.expiry_dt IS NULL AND
258: pee.course_cd = p_course_cd;
259: BEGIN
260: -- This module validates that there are no other 'open ended'
261: -- IGS_PE_PERSENC_EFFCT records for the nominated encumbrance
262: -- effect type.
263: -- validate the input parameters
264: IF (p_person_id IS NULL OR
265: p_encumbrance_type IS NULL OR

Line 272: -- check if a IGS_PE_PERSENC_EFFCT record

268: p_sequence_number IS NULL) THEN
269: p_message_name := null;
270: RETURN TRUE;
271: END IF;
272: -- check if a IGS_PE_PERSENC_EFFCT record
273: -- exists when the course_cd is not specified
274: IF (p_course_cd IS NULL) THEN
275: -- set that no records have yet been found
276: v_rec_found := FALSE;

Line 290: -- check if a IGS_PE_PERSENC_EFFCT record

286: p_message_name := 'IGS_EN_PERS_ENCUMB_ALREADY_SP';
287: RETURN FALSE;
288: END IF;
289: END IF;
290: -- check if a IGS_PE_PERSENC_EFFCT record
291: -- exists when the course_cd is specified
292: IF (p_course_cd IS NOT NULL) THEN
293: -- set that no records have yet been found
294: v_rec_found := FALSE;

Line 330: -- for a IGS_PE_PERSENC_EFFCT if the course_cd is set ensure

326: p_message_name OUT NOCOPY VARCHAR2)
327: RETURN BOOLEAN AS
328:
329: BEGIN -- enrp_val_pee_crs
330: -- for a IGS_PE_PERSENC_EFFCT if the course_cd is set ensure
331: -- that the person is enrolled in a course
332: DECLARE
333: v_check VARCHAR2(1);
334: CURSOR c_person_exist IS

Line 422: -- For a IGS_PE_PERSENC_EFFCT based on a s_encmb_effect_type which has

418: p_message_name OUT NOCOPY VARCHAR2)
419: RETURN BOOLEAN AS
420:
421: BEGIN -- enrp_val_pee_enrol
422: -- For a IGS_PE_PERSENC_EFFCT based on a s_encmb_effect_type which has
423: -- the to_course_ind set, ensure that the person is enrolled in a course.
424: -- If not, this type of effect cannot be created.
425: DECLARE
426: v_check VARCHAR2(1);