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_AD_IMP_013 dependencies on IGS_PE_TYPE_INT

Line 87: FROM igs_pe_type_int pty,

83: l_interface_run_id igs_ad_interface_all.interface_run_id%TYPE;
84: -- Cursor to select all the pending records.
85: CURSOR per_type_cur(cp_interface_run_id igs_ad_interface_all.interface_run_id%TYPE) IS
86: SELECT pty.*, i.person_id
87: FROM igs_pe_type_int pty,
88: igs_ad_interface_all i
89: WHERE pty.interface_id = i.interface_id AND
90: pty.status = '2' AND
91: pty.interface_run_id = cp_interface_run_id AND

Line 96: cp_person_type_code igs_pe_type_int.person_type_code%TYPE,

92: i.interface_run_id = cp_interface_run_id;
93:
94: -- Cursor to check for duplicate record
95: CURSOR dup_per_type_cur(cp_person_id igs_ad_interface_all.person_id%TYPE,
96: cp_person_type_code igs_pe_type_int.person_type_code%TYPE,
97: cp_start_date igs_pe_type_int.start_date%TYPE) IS
98: SELECT rowid,type_instance_id, end_date,emplmnt_category_code
99: FROM igs_pe_typ_instances_all
100: WHERE person_id = cp_person_id AND

Line 97: cp_start_date igs_pe_type_int.start_date%TYPE) IS

93:
94: -- Cursor to check for duplicate record
95: CURSOR dup_per_type_cur(cp_person_id igs_ad_interface_all.person_id%TYPE,
96: cp_person_type_code igs_pe_type_int.person_type_code%TYPE,
97: cp_start_date igs_pe_type_int.start_date%TYPE) IS
98: SELECT rowid,type_instance_id, end_date,emplmnt_category_code
99: FROM igs_pe_typ_instances_all
100: WHERE person_id = cp_person_id AND
101: UPPER(person_type_code) = UPPER(cp_person_type_code) AND

Line 117: FROM igs_pe_type_int pty

113: -- Cursor to check whether any Staff/Faculty records are present
114: CURSOR type_exist_cur(cp_person_type_code igs_pe_person_types.person_type_code%TYPE,
115: cp_interface_run_id igs_ad_interface_all.interface_run_id%TYPE) IS
116: SELECT 'X'
117: FROM igs_pe_type_int pty
118: WHERE pty.status = '2' AND
119: pty.person_type_code = cp_person_type_code AND
120: pty.interface_run_id = cp_interface_run_id;
121:

Line 145: cp_person_type_code igs_pe_type_int.person_type_code%TYPE,

141: FROM fnd_user
142: WHERE user_id = cp_user_id;
143:
144: CURSOR date_overlap(cp_person_id igs_ad_interface.person_id%TYPE,
145: cp_person_type_code igs_pe_type_int.person_type_code%TYPE,
146: cp_start_date igs_pe_type_int.start_date%TYPE,
147: cp_end_date igs_pe_type_int.end_date%TYPE,
148: cp_default_date DATE) IS
149: SELECT 'Y'

Line 146: cp_start_date igs_pe_type_int.start_date%TYPE,

142: WHERE user_id = cp_user_id;
143:
144: CURSOR date_overlap(cp_person_id igs_ad_interface.person_id%TYPE,
145: cp_person_type_code igs_pe_type_int.person_type_code%TYPE,
146: cp_start_date igs_pe_type_int.start_date%TYPE,
147: cp_end_date igs_pe_type_int.end_date%TYPE,
148: cp_default_date DATE) IS
149: SELECT 'Y'
150: FROM igs_pe_typ_instances_all

Line 147: cp_end_date igs_pe_type_int.end_date%TYPE,

143:
144: CURSOR date_overlap(cp_person_id igs_ad_interface.person_id%TYPE,
145: cp_person_type_code igs_pe_type_int.person_type_code%TYPE,
146: cp_start_date igs_pe_type_int.start_date%TYPE,
147: cp_end_date igs_pe_type_int.end_date%TYPE,
148: cp_default_date DATE) IS
149: SELECT 'Y'
150: FROM igs_pe_typ_instances_all
151: WHERE person_id = cp_person_id AND

Line 159: cp_start_date igs_pe_type_int.start_date%TYPE,

155: OR ( cp_start_date < start_date AND
156: NVL(end_date,cp_default_date) < NVL(cp_end_date,cp_default_date)));
157:
158: CURSOR emp_cat_status(cp_person_id igs_ad_interface.person_id%TYPE,
159: cp_start_date igs_pe_type_int.start_date%TYPE,
160: cp_end_date igs_pe_type_int.end_date%TYPE,
161: cp_default_date DATE) IS
162: SELECT NULL
163: FROM igs_pe_typ_instances_all typ,igs_pe_person_types sys

Line 160: cp_end_date igs_pe_type_int.end_date%TYPE,

156: NVL(end_date,cp_default_date) < NVL(cp_end_date,cp_default_date)));
157:
158: CURSOR emp_cat_status(cp_person_id igs_ad_interface.person_id%TYPE,
159: cp_start_date igs_pe_type_int.start_date%TYPE,
160: cp_end_date igs_pe_type_int.end_date%TYPE,
161: cp_default_date DATE) IS
162: SELECT NULL
163: FROM igs_pe_typ_instances_all typ,igs_pe_person_types sys
164: WHERE typ.person_id = cp_person_id AND

Line 185: UPDATE igs_pe_type_int

181: p_default_date);
182: FETCH date_overlap INTO l_exists;
183: IF date_overlap%FOUND THEN
184: CLOSE date_overlap;
185: UPDATE igs_pe_type_int
186: SET status = '3',
187: error_code = 'E295'
188: WHERE interface_person_type_id = p_person_type_rec.interface_person_type_id;
189: IF l_enable_log = 'Y' THEN

Line 207: UPDATE igs_pe_type_int

203: FETCH emp_cat_status INTO l_exists;
204: IF emp_cat_status%FOUND THEN
205: CLOSE emp_cat_status;
206:
207: UPDATE igs_pe_type_int
208: SET status = '3',
209: error_code = 'E585'
210: WHERE interface_person_type_id = p_person_type_rec.interface_person_type_id;
211:

Line 252: UPDATE igs_pe_type_int

248: x_org_id => null,
249: x_emplmnt_category_code => p_person_type_rec.emplmnt_category_code
250: );
251:
252: UPDATE igs_pe_type_int
253: SET status = '1'
254: WHERE interface_person_type_id = p_person_type_rec.interface_person_type_id;
255:
256: EXCEPTION

Line 288: UPDATE igs_pe_type_int

284: igs_ad_imp_001.logerrormessage(p_person_type_rec.interface_person_type_id,l_error_code);
285: END IF;
286:
287:
288: UPDATE igs_pe_type_int
289: SET status = '3',
290: error_code = l_error_code
291: WHERE interface_person_type_id = p_person_type_rec.interface_person_type_id;
292:

Line 319: cp_person_type_code igs_pe_type_int.person_type_code%TYPE,

315: FROM fnd_user
316: WHERE user_id = cp_user_id;
317:
318: CURSOR date_overlap(cp_person_id igs_ad_interface.person_id%TYPE,
319: cp_person_type_code igs_pe_type_int.person_type_code%TYPE,
320: cp_start_date igs_pe_type_int.start_date%TYPE,
321: cp_end_date igs_pe_type_int.end_date%TYPE,
322: cp_default_date DATE) IS
323: SELECT 'Y'

Line 320: cp_start_date igs_pe_type_int.start_date%TYPE,

316: WHERE user_id = cp_user_id;
317:
318: CURSOR date_overlap(cp_person_id igs_ad_interface.person_id%TYPE,
319: cp_person_type_code igs_pe_type_int.person_type_code%TYPE,
320: cp_start_date igs_pe_type_int.start_date%TYPE,
321: cp_end_date igs_pe_type_int.end_date%TYPE,
322: cp_default_date DATE) IS
323: SELECT 'Y'
324: FROM igs_pe_typ_instances_all

Line 321: cp_end_date igs_pe_type_int.end_date%TYPE,

317:
318: CURSOR date_overlap(cp_person_id igs_ad_interface.person_id%TYPE,
319: cp_person_type_code igs_pe_type_int.person_type_code%TYPE,
320: cp_start_date igs_pe_type_int.start_date%TYPE,
321: cp_end_date igs_pe_type_int.end_date%TYPE,
322: cp_default_date DATE) IS
323: SELECT 'Y'
324: FROM igs_pe_typ_instances_all
325: WHERE person_id = cp_person_id AND

Line 334: cp_start_date igs_pe_type_int.start_date%TYPE,

330: OR ( cp_start_date < start_date AND
331: NVL(end_date,cp_default_date) < NVL(cp_end_date,cp_default_date)));
332:
333: CURSOR emp_cat_status(cp_person_id igs_ad_interface.person_id%TYPE,
334: cp_start_date igs_pe_type_int.start_date%TYPE,
335: cp_end_date igs_pe_type_int.end_date%TYPE,
336: cp_default_date DATE) IS
337: SELECT null FROM igs_pe_typ_instances_all typ,igs_pe_person_types sys
338: WHERE

Line 335: cp_end_date igs_pe_type_int.end_date%TYPE,

331: NVL(end_date,cp_default_date) < NVL(cp_end_date,cp_default_date)));
332:
333: CURSOR emp_cat_status(cp_person_id igs_ad_interface.person_id%TYPE,
334: cp_start_date igs_pe_type_int.start_date%TYPE,
335: cp_end_date igs_pe_type_int.end_date%TYPE,
336: cp_default_date DATE) IS
337: SELECT null FROM igs_pe_typ_instances_all typ,igs_pe_person_types sys
338: WHERE
339: typ.person_id = cp_person_id AND

Line 363: UPDATE igs_pe_type_int

359: FETCH date_overlap INTO l_exists;
360: IF date_overlap%FOUND THEN
361: CLOSE date_overlap;
362:
363: UPDATE igs_pe_type_int
364: SET status = '3',
365: error_code = 'E295'
366: WHERE interface_person_type_id = p_person_type_rec.interface_person_type_id;
367:

Line 387: UPDATE igs_pe_type_int

383: FETCH emp_cat_status INTO l_exists;
384: IF emp_cat_status%FOUND THEN
385: CLOSE emp_cat_status;
386:
387: UPDATE igs_pe_type_int
388: SET status = '3',
389: error_code = 'E585'
390: WHERE interface_person_type_id = p_person_type_rec.interface_person_type_id;
391:

Line 431: UPDATE igs_pe_type_int

427: );
428:
429: -- END IF;
430:
431: UPDATE igs_pe_type_int
432: SET status = '1',
433: match_ind = '18'
434: WHERE interface_person_type_id = p_person_type_rec.interface_person_type_id;
435:

Line 468: UPDATE igs_pe_type_int

464: IF l_enable_log = 'Y' THEN
465: igs_ad_imp_001.logerrormessage(p_person_type_rec.interface_person_type_id,l_error_code);
466: END IF;
467:
468: UPDATE igs_pe_type_int
469: SET status = '3',
470: error_code = l_error_code
471: WHERE interface_person_type_id = p_person_type_rec.interface_person_type_id;
472:

Line 483: CURSOR system_type_cur(cp_person_type_code igs_pe_type_int.person_type_code%TYPE)

479: )
480: IS
481: l_birth_date igs_pe_person_base_v.birth_date%TYPE;
482:
483: CURSOR system_type_cur(cp_person_type_code igs_pe_type_int.person_type_code%TYPE)
484: IS
485: SELECT system_type
486: FROM igs_pe_person_types
487: WHERE person_type_code = cp_person_type_code

Line 610: UPDATE igs_pe_type_int pti

606: OPEN type_exist_cur(l_staff_person_type_code,l_interface_run_id);
607: FETCH type_exist_cur INTO l_var;
608:
609: IF type_exist_cur%FOUND THEN
610: UPDATE igs_pe_type_int pti
611: SET pti.status = '3',
612: pti.error_code = 'E293'
613: WHERE person_type_code = l_staff_person_type_code AND
614: status = '2' AND

Line 637: UPDATE igs_pe_type_int pti

633: FETCH type_exist_cur INTO l_var;
634:
635: IF type_exist_cur%FOUND THEN
636:
637: UPDATE igs_pe_type_int pti
638: SET pti.status = '3',
639: pti.error_code = 'E293'
640: WHERE person_type_code = l_faculty_person_type_code AND
641: status = '2' AND

Line 663: UPDATE igs_pe_type_int pti

659:
660: -- 1. If the rule is E or I, and the match ind column is not null, update all the records to status 3 as they are invalids.
661:
662: IF ((l_rule='E') OR (l_rule='I')) THEN
663: UPDATE igs_pe_type_int pti
664: SET status = '3',
665: error_code = 'E695'
666: WHERE pti.status = '2' AND
667: pti.interface_run_id = l_interface_run_id AND

Line 674: UPDATE igs_pe_type_int pti

670:
671: -- 2 . If rule is E and the match ind is null, we update the interface table for all duplicate records with status 1 and match ind 19.
672:
673: IF (l_rule = 'E') THEN
674: UPDATE igs_pe_type_int pti
675: SET status = '1',
676: match_ind = '19'
677: WHERE pti.status = '2' AND
678: pti.interface_run_id = l_interface_run_id AND

Line 693: UPDATE igs_pe_type_int pti

689:
690: -- 3. If rule is R and the record status is 18,19,22,23 these records have been processed, but didn't get updated. Update them to 1
691:
692: IF (l_rule='R') THEN
693: UPDATE igs_pe_type_int pti
694: SET status = '1'
695: WHERE pti.status = '2' AND
696: pti.interface_run_id = l_interface_run_id AND
697: pti.match_ind IN ('18','19','22','23');

Line 704: UPDATE igs_pe_type_int pti

700:
701: -- 4. If rule is R and the match ind is not null and is neither 21 nor 25, update it to errored record.
702:
703: IF (l_rule = 'R') THEN
704: UPDATE igs_pe_type_int pti
705: SET status = '3',
706: error_code = 'E695'
707: WHERE pti.status = '2' AND
708: pti.interface_run_id = l_interface_run_id AND

Line 716: UPDATE igs_pe_type_int pti

712:
713: -- 5. If rule = 'R' and there is no discprepency in duplicate records, update them to status 1 and match ind 23.
714:
715: IF (l_rule ='R') THEN
716: UPDATE igs_pe_type_int pti
717: SET status = '1',
718: match_ind = '23'
719: WHERE pti.status = '2' AND
720: pti.interface_run_id = l_interface_run_id AND

Line 740: UPDATE igs_pe_type_int pti

736: -- 6. If rule is R and there are still some records, they are the ones for which there is some discrepency existing. Update them to status 3
737: -- and value from the OSS table.
738:
739: IF (l_rule ='R') THEN
740: UPDATE igs_pe_type_int pti
741: SET status='3',
742: match_ind='20',
743: dup_type_instance_id=(SELECT pi.type_instance_id
744: FROM igs_pe_typ_instances_all pi,

Line 827: UPDATE igs_pe_type_int

823: END IF;
824: ELSE
825: -- Validation failed. Update with proper error code.
826:
827: UPDATE igs_pe_type_int
828: SET status = '3',
829: error_code = l_error_code
830: WHERE interface_person_type_id = per_type_rec.interface_person_type_id;
831: