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_EN_SPA_AWD_AIM_PKG dependencies on IGS_PE_TYP_INSTANCES

Line 166: FROM igs_pe_typ_instances_all pti

162:
163: -- Cursor to fetch active Person Type Instance Record
164: CURSOR cur_typ_id_inst(p_PERSON_ID NUMBER,p_COURSE_CD VARCHAR2,p_PERSON_TYPE_CODE VARCHAR2) IS
165: SELECT pti.*
166: FROM igs_pe_typ_instances_all pti
167: WHERE pti.PERSON_ID = p_PERSON_ID AND
168: pti.COURSE_CD = p_COURSE_CD AND
169: pti.PERSON_TYPE_CODE = p_PERSON_TYPE_CODE AND
170: pti.END_DATE IS NULL;

Line 181: CURSOR cur_pe_typ_inst( p_person_id igs_pe_typ_instances.PERSON_ID%TYPE,

177:
178: -- Cursor used to fetch the Person Type Instance record which is being opened
179: -- irrespective of the system person type is closed or not.
180:
181: CURSOR cur_pe_typ_inst( p_person_id igs_pe_typ_instances.PERSON_ID%TYPE,
182: p_course_cd igs_pe_typ_instances.course_cd%TYPE,
183: p_system_type igs_pe_person_types.SYSTEM_TYPE%TYPE
184: ) IS
185: SELECT pti.rowid row_id ,pti.*

Line 182: p_course_cd igs_pe_typ_instances.course_cd%TYPE,

178: -- Cursor used to fetch the Person Type Instance record which is being opened
179: -- irrespective of the system person type is closed or not.
180:
181: CURSOR cur_pe_typ_inst( p_person_id igs_pe_typ_instances.PERSON_ID%TYPE,
182: p_course_cd igs_pe_typ_instances.course_cd%TYPE,
183: p_system_type igs_pe_person_types.SYSTEM_TYPE%TYPE
184: ) IS
185: SELECT pti.rowid row_id ,pti.*
186: FROM igs_pe_typ_instances_all pti,

Line 186: FROM igs_pe_typ_instances_all pti,

182: p_course_cd igs_pe_typ_instances.course_cd%TYPE,
183: p_system_type igs_pe_person_types.SYSTEM_TYPE%TYPE
184: ) IS
185: SELECT pti.rowid row_id ,pti.*
186: FROM igs_pe_typ_instances_all pti,
187: igs_pe_person_types pty
188: WHERE pti.person_id = p_person_id AND
189: pti.course_cd = p_course_cd AND
190: pti.end_date IS NULL AND

Line 195: CURSOR cur_per_typ_dt( p_person_id igs_pe_typ_instances.PERSON_ID%TYPE,

191: pty.person_type_code = pti.person_type_code AND
192: pty.system_type = p_system_type;
193:
194: --Cursor to fecth Person Type Instance record with end date not null
195: CURSOR cur_per_typ_dt( p_person_id igs_pe_typ_instances.PERSON_ID%TYPE,
196: p_course_cd igs_pe_typ_instances.course_cd%TYPE,
197: p_system_type igs_pe_person_types.SYSTEM_TYPE%TYPE,
198: p_date DATE ) IS
199: SELECT pti.rowid row_id ,pti.*

Line 196: p_course_cd igs_pe_typ_instances.course_cd%TYPE,

192: pty.system_type = p_system_type;
193:
194: --Cursor to fecth Person Type Instance record with end date not null
195: CURSOR cur_per_typ_dt( p_person_id igs_pe_typ_instances.PERSON_ID%TYPE,
196: p_course_cd igs_pe_typ_instances.course_cd%TYPE,
197: p_system_type igs_pe_person_types.SYSTEM_TYPE%TYPE,
198: p_date DATE ) IS
199: SELECT pti.rowid row_id ,pti.*
200: FROM igs_pe_typ_instances_all pti,

Line 200: FROM igs_pe_typ_instances_all pti,

196: p_course_cd igs_pe_typ_instances.course_cd%TYPE,
197: p_system_type igs_pe_person_types.SYSTEM_TYPE%TYPE,
198: p_date DATE ) IS
199: SELECT pti.rowid row_id ,pti.*
200: FROM igs_pe_typ_instances_all pti,
201: igs_pe_person_types pty
202: WHERE pti.person_id = p_person_id AND
203: pti.course_cd = p_course_cd AND
204: pti.end_date = p_date AND

Line 220: l_method igs_pe_typ_instances.CREATE_METHOD%TYPE;

216: cur_pe_typ_inst_rec cur_pe_typ_inst%ROWTYPE;
217: cur_typ_id_inst_rec cur_typ_id_inst%ROWTYPE;
218: cur_per_typ_dt_rec cur_per_typ_dt%ROWTYPE;
219: l_person_type igs_pe_person_types.PERSON_TYPE_CODE%TYPE;
220: l_method igs_pe_typ_instances.CREATE_METHOD%TYPE;
221: l_TYPE_INSTANCE_ID igs_pe_typ_instances.TYPE_INSTANCE_ID%TYPE;
222: l_rowid VARCHAR2(25);
223: l_date DATE;
224:

Line 221: l_TYPE_INSTANCE_ID igs_pe_typ_instances.TYPE_INSTANCE_ID%TYPE;

217: cur_typ_id_inst_rec cur_typ_id_inst%ROWTYPE;
218: cur_per_typ_dt_rec cur_per_typ_dt%ROWTYPE;
219: l_person_type igs_pe_person_types.PERSON_TYPE_CODE%TYPE;
220: l_method igs_pe_typ_instances.CREATE_METHOD%TYPE;
221: l_TYPE_INSTANCE_ID igs_pe_typ_instances.TYPE_INSTANCE_ID%TYPE;
222: l_rowid VARCHAR2(25);
223: l_date DATE;
224:
225:

Line 246: igs_pe_typ_instances_pkg.insert_row(

242:
243: OPEN cur_typ_id_inst(new_references.PERSON_ID,new_references.COURSE_CD,l_person_type);
244: FETCH cur_typ_id_inst INTO cur_typ_id_inst_rec;
245: IF cur_typ_id_inst%NOTFOUND THEN
246: igs_pe_typ_instances_pkg.insert_row(
247: X_ROWID => l_ROWID,
248: X_PERSON_ID => new_references.PERSON_ID,
249: X_COURSE_CD => new_references.COURSE_CD,
250: X_TYPE_INSTANCE_ID => l_TYPE_INSTANCE_ID,

Line 276: igs_pe_typ_instances_pkg.update_row(

272: 'GRADUATE');
273: FETCH cur_pe_typ_inst INTO cur_pe_typ_inst_rec;
274: IF cur_pe_typ_inst%FOUND THEN
275: l_date := cur_pe_typ_inst_rec.START_DATE;
276: igs_pe_typ_instances_pkg.update_row(
277: X_ROWID => cur_pe_typ_inst_rec.ROW_ID,
278: X_PERSON_ID => cur_pe_typ_inst_rec.PERSON_ID,
279: X_COURSE_CD => cur_pe_typ_inst_rec.COURSE_CD,
280: X_TYPE_INSTANCE_ID => cur_pe_typ_inst_rec.TYPE_INSTANCE_ID,

Line 316: igs_pe_typ_instances_pkg.update_row(

312: 'FORMER_STUDENT',
313: l_date);
314: FETCH cur_per_typ_dt INTO cur_per_typ_dt_rec;
315: IF cur_per_typ_dt%FOUND THEN
316: igs_pe_typ_instances_pkg.update_row(
317: X_ROWID => cur_per_typ_dt_rec.ROW_ID,
318: X_PERSON_ID => cur_per_typ_dt_rec.PERSON_ID,
319: X_COURSE_CD => cur_per_typ_dt_rec.COURSE_CD,
320: X_TYPE_INSTANCE_ID => cur_per_typ_dt_rec.TYPE_INSTANCE_ID,

Line 343: igs_pe_typ_instances_pkg.update_row(

339: new_references.COURSE_CD,
340: 'FORMER_STUDENT');
341: FETCH cur_pe_typ_inst INTO cur_pe_typ_inst_rec;
342: IF cur_pe_typ_inst%FOUND THEN
343: igs_pe_typ_instances_pkg.update_row(
344: X_ROWID => cur_pe_typ_inst_rec.ROW_ID,
345: X_PERSON_ID => cur_pe_typ_inst_rec.PERSON_ID,
346: X_COURSE_CD => cur_pe_typ_inst_rec.COURSE_CD,
347: X_TYPE_INSTANCE_ID => cur_pe_typ_inst_rec.TYPE_INSTANCE_ID,

Line 391: igs_pe_typ_instances_pkg.update_row(

387: IF SYSDATE < cur_pe_typ_inst_rec.START_DATE THEN
388: l_date := cur_pe_typ_inst_rec.START_DATE;
389: ELSE l_date := SYSDATE;
390: END IF;
391: igs_pe_typ_instances_pkg.update_row(
392: X_ROWID => cur_pe_typ_inst_rec.ROW_ID,
393: X_PERSON_ID => cur_pe_typ_inst_rec.PERSON_ID,
394: X_COURSE_CD => cur_pe_typ_inst_rec.COURSE_CD,
395: X_TYPE_INSTANCE_ID => cur_pe_typ_inst_rec.TYPE_INSTANCE_ID,

Line 428: igs_pe_typ_instances_pkg.insert_row(

424: IF l_date = SYSDATE THEN
425: OPEN cur_typ_id_inst(new_references.PERSON_ID,new_references.COURSE_CD,l_person_type);
426: FETCH cur_typ_id_inst INTO cur_typ_id_inst_rec;
427: IF cur_typ_id_inst%NOTFOUND THEN
428: igs_pe_typ_instances_pkg.insert_row(
429: X_ROWID => l_ROWID,
430: X_PERSON_ID => new_references.PERSON_ID,
431: X_COURSE_CD => new_references.COURSE_CD,
432: X_TYPE_INSTANCE_ID => l_TYPE_INSTANCE_ID,

Line 458: igs_pe_typ_instances_pkg.update_row(

454: 'FORMER_STUDENT',
455: l_date);
456: FETCH cur_per_typ_dt INTO cur_per_typ_dt_rec;
457: IF cur_per_typ_dt%FOUND THEN
458: igs_pe_typ_instances_pkg.update_row(
459: X_ROWID => cur_per_typ_dt_rec.ROW_ID,
460: X_PERSON_ID => cur_per_typ_dt_rec.PERSON_ID,
461: X_COURSE_CD => cur_per_typ_dt_rec.COURSE_CD,
462: X_TYPE_INSTANCE_ID => cur_per_typ_dt_rec.TYPE_INSTANCE_ID,

Line 508: igs_pe_typ_instances_pkg.update_row(

504: IF cur_pe_typ_inst%FOUND THEN
505: IF SYSDATE < cur_pe_typ_inst_rec.START_DATE THEN
506: l_date := cur_pe_typ_inst_rec.START_DATE;
507: END IF;
508: igs_pe_typ_instances_pkg.update_row(
509: X_ROWID => cur_pe_typ_inst_rec.ROW_ID,
510: X_PERSON_ID => cur_pe_typ_inst_rec.PERSON_ID,
511: X_COURSE_CD => cur_pe_typ_inst_rec.COURSE_CD,
512: X_TYPE_INSTANCE_ID => cur_pe_typ_inst_rec.TYPE_INSTANCE_ID,

Line 544: igs_pe_typ_instances_pkg.insert_row(

540: IF l_date = SYSDATE THEN
541: OPEN cur_typ_id_inst(cur_conf_dt_rec.PERSON_ID,cur_conf_dt_rec.COURSE_CD,l_person_type);
542: FETCH cur_typ_id_inst INTO cur_typ_id_inst_rec;
543: IF cur_typ_id_inst%NOTFOUND THEN
544: igs_pe_typ_instances_pkg.insert_row(
545: X_ROWID => l_ROWID,
546: X_PERSON_ID => cur_conf_dt_rec.PERSON_ID,
547: X_COURSE_CD => cur_conf_dt_rec.COURSE_CD,
548: X_TYPE_INSTANCE_ID => l_TYPE_INSTANCE_ID,

Line 574: igs_pe_typ_instances_pkg.update_row(

570: 'FORMER_STUDENT',
571: l_date);
572: FETCH cur_per_typ_dt INTO cur_per_typ_dt_rec;
573: IF cur_per_typ_dt%FOUND THEN
574: igs_pe_typ_instances_pkg.update_row(
575: X_ROWID => cur_per_typ_dt_rec.ROW_ID,
576: X_PERSON_ID => cur_per_typ_dt_rec.PERSON_ID,
577: X_COURSE_CD => cur_per_typ_dt_rec.COURSE_CD,
578: X_TYPE_INSTANCE_ID => cur_per_typ_dt_rec.TYPE_INSTANCE_ID,