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_PERSON_TYPES

Line 115: CURSOR c_get_others(cp_system_type igs_pe_person_types.system_type%TYPE) IS

111: Removed the existence of active records for person types other than OTHER
112: (reverse chronological order - newest change first)
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'

Line 118: igs_pe_person_types pt

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;
122:

Line 123: CURSOR c_get_active(cp_system_type igs_pe_person_types.system_type%TYPE)IS

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;
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'

Line 126: igs_pe_person_types pt

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;
130:

Line 179: FROM igs_pe_person_types ppt

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;
182:
183: --This Cursor makes sure that a Person Can have a Person Type

Line 181: l_system_type IGS_PE_PERSON_TYPES.system_type%TYPE;

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;
182:
183: --This Cursor makes sure that a Person Can have a Person Type
184: --Evaluator created from FORM only if the existing Prospect Person Type is End Dated with Sysdate or
185: --less than Sysdate. And vice versa..

Line 190: cp_system_type igs_pe_person_types.system_type%TYPE)

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
194: WHERE pti.person_id = cp_person_id AND

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 247: CURSOR c_get_applicant(cp_system_type igs_pe_person_types.system_type%TYPE,

243: pkpatel 20-sep-2004 Bug 3690856 (removed the cursor c_get_prospect since its not used. Removed igs_lookups_view join in th cursor c_get_applicant. Made cursors parameterized.
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,

Line 252: igs_pe_person_types pt

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
256: AND pti.nominated_course_cd = cp_course_cd

Line 259: CURSOR c_get_sys_typ(cp_person_type_code igs_pe_person_types.person_type_code%TYPE) IS

255: AND pti.person_id = cp_person_id
256: AND pti.nominated_course_cd = cp_course_cd
257: AND pti.end_date IS NULL;
258:
259: CURSOR c_get_sys_typ(cp_person_type_code igs_pe_person_types.person_type_code%TYPE) IS
260: SELECT pt.system_type
261: FROM igs_pe_person_types pt
262: WHERE pt.person_type_code = cp_person_type_code;
263:

Line 261: FROM igs_pe_person_types pt

257: AND pti.end_date IS NULL;
258:
259: CURSOR c_get_sys_typ(cp_person_type_code igs_pe_person_types.person_type_code%TYPE) IS
260: SELECT pt.system_type
261: FROM igs_pe_person_types pt
262: WHERE pt.person_type_code = cp_person_type_code;
263:
264: l_system_type igs_pe_person_types.system_type%TYPE;
265: l_flag varchar2(10) ;

Line 264: l_system_type igs_pe_person_types.system_type%TYPE;

260: SELECT pt.system_type
261: FROM igs_pe_person_types pt
262: WHERE pt.person_type_code = cp_person_type_code;
263:
264: l_system_type igs_pe_person_types.system_type%TYPE;
265: l_flag varchar2(10) ;
266: l_end_method varchar2(30);
267:
268: begin

Line 324: FROM igs_pe_person_types pt

320: ***************************************************************/
321:
322: CURSOR system_type_cur IS
323: SELECT system_type
324: FROM igs_pe_person_types pt
325: WHERE pt.person_type_code = new_references.person_type_code;
326:
327: CURSOR person_type_cur(cp_system_type igs_pe_person_types.system_type%TYPE,cp_closed_ind igs_pe_person_types.closed_ind%TYPE) IS
328: SELECT person_type_code

Line 327: CURSOR person_type_cur(cp_system_type igs_pe_person_types.system_type%TYPE,cp_closed_ind igs_pe_person_types.closed_ind%TYPE) IS

323: SELECT system_type
324: FROM igs_pe_person_types pt
325: WHERE pt.person_type_code = new_references.person_type_code;
326:
327: CURSOR person_type_cur(cp_system_type igs_pe_person_types.system_type%TYPE,cp_closed_ind igs_pe_person_types.closed_ind%TYPE) IS
328: SELECT person_type_code
329: FROM igs_pe_person_types pt
330: WHERE pt.system_type = cp_system_type AND
331: pt.closed_ind = cp_closed_ind;

Line 329: FROM igs_pe_person_types pt

325: WHERE pt.person_type_code = new_references.person_type_code;
326:
327: CURSOR person_type_cur(cp_system_type igs_pe_person_types.system_type%TYPE,cp_closed_ind igs_pe_person_types.closed_ind%TYPE) IS
328: SELECT person_type_code
329: FROM igs_pe_person_types pt
330: WHERE pt.system_type = cp_system_type AND
331: pt.closed_ind = cp_closed_ind;
332:
333: CURSOR meaning_cur(cp_system_type igs_lookup_values.lookup_code%TYPE,cp_lookup_type igs_lookups_view.lookup_type%TYPE) IS

Line 443: ELSIF NOT Igs_Pe_Person_Types_Pkg.Get_PK_For_Validation (

439:
440: IF (((old_references.person_type_code = new_references.person_type_code)) OR
441: ((new_references.person_type_code IS NULL))) THEN
442: NULL;
443: ELSIF NOT Igs_Pe_Person_Types_Pkg.Get_PK_For_Validation (
444: new_references.person_type_code
445: ) THEN
446: Fnd_Message.Set_Name ('FND','FORM_RECORD_DELETED');
447: IGS_GE_MSG_STACK.ADD;

Line 557: PROCEDURE Get_FK_Igs_Pe_Person_Types (

553: Close cur_rowid;
554:
555: END Get_FK_Igs_Ad_Ps_Appl_Inst;
556:
557: PROCEDURE Get_FK_Igs_Pe_Person_Types (
558: x_person_type_code IN VARCHAR2
559: ) AS
560:
561: /*************************************************************

Line 592: END Get_FK_Igs_Pe_Person_Types;

588: Return;
589: END IF;
590: Close cur_rowid;
591:
592: END Get_FK_Igs_Pe_Person_Types;
593:
594: PROCEDURE Get_FK_Igs_Ps_Ver (
595: x_course_cd IN VARCHAR2,
596: x_version_number IN NUMBER

Line 673: p_person_type_code IN IGS_PE_PERSON_TYPES.person_type_code%TYPE,

669: END Get_FK_Igs_Pe_Person;
670:
671: PROCEDURE Check_Mand_Person_Type
672: (
673: p_person_type_code IN IGS_PE_PERSON_TYPES.person_type_code%TYPE,
674: p_person_id IN HZ_PARTIES.party_id%TYPE
675: )
676: IS
677: /*************************************************************

Line 1013: CURSOR person_type_cur(cp_person_type igs_pe_person_types.person_type_code%TYPE) IS

1009: SELECT user_id
1010: FROM fnd_user
1011: WHERE person_party_id = cp_person_id;
1012:
1013: CURSOR person_type_cur(cp_person_type igs_pe_person_types.person_type_code%TYPE) IS
1014: SELECT system_type
1015: FROM igs_pe_person_types pt
1016: WHERE pt.person_type_code = cp_person_type;
1017:

Line 1015: FROM igs_pe_person_types pt

1011: WHERE person_party_id = cp_person_id;
1012:
1013: CURSOR person_type_cur(cp_person_type igs_pe_person_types.person_type_code%TYPE) IS
1014: SELECT system_type
1015: FROM igs_pe_person_types pt
1016: WHERE pt.person_type_code = cp_person_type;
1017:
1018:
1019: l_system_type igs_pe_person_types.system_type%TYPE;

Line 1019: l_system_type igs_pe_person_types.system_type%TYPE;

1015: FROM igs_pe_person_types pt
1016: WHERE pt.person_type_code = cp_person_type;
1017:
1018:
1019: l_system_type igs_pe_person_types.system_type%TYPE;
1020: l_usr_id fnd_user.user_id%type;
1021: l_usr_d_id fnd_user.user_id%type;
1022: l_person_type_w_other varchar2(30) ; -- to hold the person_type value during insert of a person type for the first time.
1023: l_person_id_w_other number; -- to hold the person_id value during insert of a person type for the first time.

Line 1028: cp_system_type igs_pe_person_types.system_type%type ,

1024:
1025: ---- Check if the person has more than ONE ACTIVE assignment for the same System Person Type,
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

Line 1035: (select person_type_code from igs_pe_person_types pt where system_type =cp_system_type) ;

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
1035: (select person_type_code from igs_pe_person_types pt where system_type =cp_system_type) ;
1036: l_max_active_date DATE;
1037: l_person_end_date_other DATE;
1038: l_prog_label CONSTANT VARCHAR2(100) := 'igs.plsql.igs_pe_typ_instances_pkg.after_dml';
1039: l_label VARCHAR2(500);