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_PE_TYP_INSTANCES_PKG dependencies on IGS_PE_TYP_INSTANCES_ALL

Line 4: old_references igs_pe_typ_instances_all%RowType;

1: PACKAGE BODY igs_pe_typ_instances_pkg AS
2: /* $Header: IGSNI46B.pls 120.12 2006/07/12 12:17:22 vskumar ship $ */
3: l_rowid VARCHAR2(25);
4: old_references igs_pe_typ_instances_all%RowType;
5: new_references igs_pe_typ_instances_all%RowType;
6:
7: PROCEDURE Set_Column_Values (
8: p_action IN VARCHAR2,

Line 5: new_references igs_pe_typ_instances_all%RowType;

1: PACKAGE BODY igs_pe_typ_instances_pkg AS
2: /* $Header: IGSNI46B.pls 120.12 2006/07/12 12:17:22 vskumar ship $ */
3: l_rowid VARCHAR2(25);
4: old_references igs_pe_typ_instances_all%RowType;
5: new_references igs_pe_typ_instances_all%RowType;
6:
7: PROCEDURE Set_Column_Values (
8: p_action IN VARCHAR2,
9: x_rowid IN VARCHAR2 ,

Line 47: FROM IGS_PE_TYP_INSTANCES_ALL

43: ***************************************************************/
44:
45: CURSOR cur_old_ref_values IS
46: SELECT *
47: FROM IGS_PE_TYP_INSTANCES_ALL
48: WHERE rowid = x_rowid;
49:
50: BEGIN
51:

Line 109: igs_lookups_view and changed igs_pe_typ_instances to igs_pe_typ_instances_all

105: Change History
106: Who When What
107: pkpatel 25-APR-2003 Bug 2908851
108: Tuned the cursors c_get_others and c_get_active. Removed the unnecessary join with
109: igs_lookups_view and changed igs_pe_typ_instances to igs_pe_typ_instances_all
110: pkpatel 4-MAY-2003 Bug 2989307
111: Removed the existence of active records for person types other than OTHER
112: (reverse chronological order - newest change first)
113: ***************************************************************/

Line 117: FROM igs_pe_typ_instances_all pti,

113: ***************************************************************/
114:
115: CURSOR c_get_others(cp_system_type igs_pe_person_types.system_type%TYPE) IS
116: SELECT pti.rowid
117: FROM igs_pe_typ_instances_all pti,
118: igs_pe_person_types pt
119: WHERE pt.system_type = cp_system_type --'OTHER'
120: AND pti.person_type_code = pt.person_type_code
121: AND pti.person_id = new_references.person_id;

Line 125: FROM igs_pe_typ_instances_all pti,

121: AND pti.person_id = new_references.person_id;
122:
123: CURSOR c_get_active(cp_system_type igs_pe_person_types.system_type%TYPE)IS
124: SELECT pti.type_instance_id
125: FROM igs_pe_typ_instances_all pti,
126: igs_pe_person_types pt
127: WHERE pt.system_type <> cp_system_type --'OTHER'
128: AND pti.person_type_code = pt.person_type_code
129: AND pti.person_id = new_references.person_id;

Line 154: p_person_type_code IN igs_pe_typ_instances_all.person_type_code%TYPE

150: END After_Insert_update;
151:
152: PROCEDURE checkprospectevaluator(
153: p_person_id IN HZ_PARTIES.party_id%TYPE,
154: p_person_type_code IN igs_pe_typ_instances_all.person_type_code%TYPE
155: ) AS
156: /*************************************************************
157: Created By : Nilotpal Shee
158: Date Created By : 05-dec-2001

Line 177: CURSOR c_prospect_evaluator(l_person_type_code igs_pe_typ_instances_all.person_type_code%TYPE) IS

173: -- messages which will be trapped wherever this API is called from and the error handling
174: -- will be done depending on the error message returned
175: (reverse chronological order - newest change first)
176: ***************************************************************/
177: CURSOR c_prospect_evaluator(l_person_type_code igs_pe_typ_instances_all.person_type_code%TYPE) IS
178: SELECT ppt.system_type
179: FROM igs_pe_person_types ppt
180: WHERE ppt.person_type_code = l_person_type_code;
181: l_system_type IGS_PE_PERSON_TYPES.system_type%TYPE;

Line 189: CURSOR pros_eval_cur(cp_person_id igs_pe_typ_instances_all.person_id%TYPE,

185: --less than Sysdate. And vice versa..
186: --Existing check for >= has been changed to > .SInce problem
187: --was found while testing IGSPE006.fmb (SWCR001 )
188: --Bug.No:2203778
189: CURSOR pros_eval_cur(cp_person_id igs_pe_typ_instances_all.person_id%TYPE,
190: cp_system_type igs_pe_person_types.system_type%TYPE)
191: IS
192: SELECT 'X'
193: FROM igs_pe_typ_instances_all pti, igs_pe_person_types ppt

Line 193: FROM igs_pe_typ_instances_all pti, igs_pe_person_types ppt

189: CURSOR pros_eval_cur(cp_person_id igs_pe_typ_instances_all.person_id%TYPE,
190: cp_system_type igs_pe_person_types.system_type%TYPE)
191: IS
192: SELECT 'X'
193: FROM igs_pe_typ_instances_all pti, igs_pe_person_types ppt
194: WHERE pti.person_id = cp_person_id AND
195: pti.person_type_code = ppt.person_type_code AND
196: ppt.system_type = cp_system_type AND
197: (pti.end_date is NULL OR (pti.end_date IS NOT NULL AND trunc(pti.end_date) > trunc(SYSDATE)));

Line 248: cp_person_id igs_pe_typ_instances_all.person_id%TYPE,

244: sykrishn IDOPA2 Commented part which prevents PROSPECT and STUDENT to coexist
245: (reverse chronological order - newest change first)
246: ***************************************************************/
247: CURSOR c_get_applicant(cp_system_type igs_pe_person_types.system_type%TYPE,
248: cp_person_id igs_pe_typ_instances_all.person_id%TYPE,
249: cp_course_cd igs_pe_typ_instances_all.nominated_course_cd%TYPE) IS
250: SELECT pti.rowid,pti.*
251: FROM igs_pe_typ_instances_all pti,
252: igs_pe_person_types pt

Line 249: cp_course_cd igs_pe_typ_instances_all.nominated_course_cd%TYPE) IS

245: (reverse chronological order - newest change first)
246: ***************************************************************/
247: CURSOR c_get_applicant(cp_system_type igs_pe_person_types.system_type%TYPE,
248: cp_person_id igs_pe_typ_instances_all.person_id%TYPE,
249: cp_course_cd igs_pe_typ_instances_all.nominated_course_cd%TYPE) IS
250: SELECT pti.rowid,pti.*
251: FROM igs_pe_typ_instances_all pti,
252: igs_pe_person_types pt
253: WHERE pt.system_type = cp_system_type --'APPLICANT'

Line 251: FROM igs_pe_typ_instances_all pti,

247: CURSOR c_get_applicant(cp_system_type igs_pe_person_types.system_type%TYPE,
248: cp_person_id igs_pe_typ_instances_all.person_id%TYPE,
249: cp_course_cd igs_pe_typ_instances_all.nominated_course_cd%TYPE) IS
250: SELECT pti.rowid,pti.*
251: FROM igs_pe_typ_instances_all pti,
252: igs_pe_person_types pt
253: WHERE pt.system_type = cp_system_type --'APPLICANT'
254: AND pti.person_type_code = pt.person_type_code
255: AND pti.person_id = cp_person_id

Line 495: FROM igs_pe_typ_instances_all

491: ***************************************************************/
492:
493: CURSOR cur_rowid IS
494: SELECT rowid
495: FROM igs_pe_typ_instances_all
496: WHERE type_instance_id = x_type_instance_id
497: FOR UPDATE NOWAIT;
498:
499: lv_rowid cur_rowid%RowType;

Line 534: FROM igs_pe_typ_instances_all

530: ***************************************************************/
531:
532: CURSOR cur_rowid IS
533: SELECT rowid
534: FROM igs_pe_typ_instances_all
535: WHERE person_id = x_person_id
536: AND admission_appl_number = x_admission_appl_number
537: AND nominated_course_cd = x_nominated_course_cd
538: AND sequence_number = x_sequence_number ;

Line 574: FROM igs_pe_typ_instances_all

570: ***************************************************************/
571:
572: CURSOR cur_rowid IS
573: SELECT rowid
574: FROM igs_pe_typ_instances_all
575: WHERE person_type_code = x_person_type_code ;
576:
577: lv_rowid cur_rowid%RowType;
578:

Line 612: FROM igs_pe_typ_instances_all

608: ***************************************************************/
609:
610: CURSOR cur_rowid IS
611: SELECT rowid
612: FROM igs_pe_typ_instances_all
613: WHERE course_cd = x_course_cd
614: AND cc_version_number = x_version_number ;
615:
616: lv_rowid cur_rowid%RowType;

Line 650: FROM igs_pe_typ_instances_all

646: ***************************************************************/
647:
648: CURSOR cur_rowid IS
649: SELECT rowid
650: FROM igs_pe_typ_instances_all
651: WHERE person_id = x_person_id ;
652:
653: lv_rowid cur_rowid%RowType;
654:

Line 1030: SELECT MAX(NVL(end_date,TO_DATE('4712/12/31','YYYY/MM/DD'))) FROM igs_pe_typ_instances_all pti

1026: ---- as the user PERSON TYPE passed. UPDATE CASE
1027: CURSOR get_active_inst_cur(cp_person_id hz_parties.party_id%type,
1028: cp_system_type igs_pe_person_types.system_type%type ,
1029: cp_rowid varchar2) IS
1030: SELECT MAX(NVL(end_date,TO_DATE('4712/12/31','YYYY/MM/DD'))) FROM igs_pe_typ_instances_all pti
1031: WHERE pti.person_id = cp_person_id
1032: AND pti.rowid <> cp_rowid
1033: AND SYSDATE BETWEEN pti.start_date and NVL(pti.end_date, SYSDATE)
1034: AND pti.person_type_code IN

Line 1162: cursor C is select ROWID from IGS_PE_TYP_INSTANCES_ALL

1158:
1159: (reverse chronological order - newest change first)
1160: ***************************************************************/
1161:
1162: cursor C is select ROWID from IGS_PE_TYP_INSTANCES_ALL
1163: where TYPE_INSTANCE_ID= X_TYPE_INSTANCE_ID;
1164: X_LAST_UPDATE_DATE DATE ;
1165: X_LAST_UPDATED_BY NUMBER ;
1166: X_LAST_UPDATE_LOGIN NUMBER ;

Line 1217: insert into IGS_PE_TYP_INSTANCES_ALL (

1213: );
1214: IF (x_mode = 'S') THEN
1215: igs_sc_gen_001.set_ctx('R');
1216: END IF;
1217: insert into IGS_PE_TYP_INSTANCES_ALL (
1218: PERSON_ID
1219: ,COURSE_CD
1220: ,TYPE_INSTANCE_ID
1221: ,PERSON_TYPE_CODE

Line 1341: from IGS_PE_TYP_INSTANCES_ALL

1337: , CREATE_METHOD
1338: , ENDED_BY
1339: , END_METHOD
1340: , EMPLMNT_CATEGORY_CODE
1341: from IGS_PE_TYP_INSTANCES_ALL
1342: where ROWID = X_ROWID
1343: for update nowait;
1344: tlinfo c1%rowtype;
1345: begin

Line 1492: update IGS_PE_TYP_INSTANCES_ALL set

1488: );
1489: IF (x_mode = 'S') THEN
1490: igs_sc_gen_001.set_ctx('R');
1491: END IF;
1492: update IGS_PE_TYP_INSTANCES_ALL set
1493: PERSON_ID = NEW_REFERENCES.PERSON_ID,
1494: COURSE_CD = NEW_REFERENCES.COURSE_CD,
1495: PERSON_TYPE_CODE = NEW_REFERENCES.PERSON_TYPE_CODE,
1496: CC_VERSION_NUMBER = NEW_REFERENCES.CC_VERSION_NUMBER,

Line 1576: cursor c1 is select ROWID from IGS_PE_TYP_INSTANCES_ALL

1572:
1573: (reverse chronological order - newest change first)
1574: ***************************************************************/
1575:
1576: cursor c1 is select ROWID from IGS_PE_TYP_INSTANCES_ALL
1577: where TYPE_INSTANCE_ID= X_TYPE_INSTANCE_ID
1578: ;
1579: begin
1580: open c1;

Line 1652: delete from IGS_PE_TYP_INSTANCES_ALL

1648: );
1649: IF (x_mode = 'S') THEN
1650: igs_sc_gen_001.set_ctx('R');
1651: END IF;
1652: delete from IGS_PE_TYP_INSTANCES_ALL
1653: where ROWID = X_ROWID;
1654: if (sql%notfound) then
1655: fnd_message.set_name ('IGS', 'IGS_SC_POLICY_UPD_DEL_EXCEP');
1656: igs_ge_msg_stack.add;