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_TYP_INSTANCES_ALL

Line 99: FROM igs_pe_typ_instances_all

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
102: TRUNC(start_date) = TRUNC(cp_start_date);
103:

Line 133: l_type_instance_id igs_pe_typ_instances_all.type_instance_id%TYPE;

129: AS
130: lv_rowid ROWID;
131: l_ended_by fnd_user.user_name%TYPE;
132: l_end_method VARCHAR2(30);
133: l_type_instance_id igs_pe_typ_instances_all.type_instance_id%TYPE;
134: l_message_name VARCHAR2(30);
135: l_app VARCHAR2(50);
136: l_error_code VARCHAR2(30);
137: l_exists VARCHAR2(1);

Line 150: FROM igs_pe_typ_instances_all

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
152: person_type_code = cp_person_type_code AND
153: ( NVL(cp_end_date,cp_default_date) BETWEEN start_date AND NVL(end_date,cp_default_date)
154: OR cp_start_date BETWEEN start_date AND NVL(end_date,cp_default_date)

Line 163: FROM igs_pe_typ_instances_all typ,igs_pe_person_types sys

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
165: sys.person_type_code = typ.person_type_code AND
166: sys.system_type IN ('FACULTY','STAFF') AND
167: ( NVL(cp_end_date,cp_default_date) BETWEEN typ.start_date AND NVL(typ.end_date,cp_default_date)

Line 297: p_type_instance_id IN igs_pe_typ_instances_all.type_instance_id%TYPE,

293: END create_person_type;
294:
295: -- Private procedure to update person type
296: PROCEDURE update_person_type(p_person_type_rec IN per_type_cur%ROWTYPE,
297: p_type_instance_id IN igs_pe_typ_instances_all.type_instance_id%TYPE,
298: p_rowid IN ROWID,
299: p_end_date IN igs_pe_typ_instances_all.end_date%TYPE,
300: p_emplmnt_category_code IN igs_pe_typ_instances_all.emplmnt_category_code%TYPE,
301: p_system_type IN igs_pe_person_types.system_type%TYPE,

Line 299: p_end_date IN igs_pe_typ_instances_all.end_date%TYPE,

295: -- Private procedure to update person type
296: PROCEDURE update_person_type(p_person_type_rec IN per_type_cur%ROWTYPE,
297: p_type_instance_id IN igs_pe_typ_instances_all.type_instance_id%TYPE,
298: p_rowid IN ROWID,
299: p_end_date IN igs_pe_typ_instances_all.end_date%TYPE,
300: p_emplmnt_category_code IN igs_pe_typ_instances_all.emplmnt_category_code%TYPE,
301: p_system_type IN igs_pe_person_types.system_type%TYPE,
302: p_default_date IN DATE)
303: AS

Line 300: p_emplmnt_category_code IN igs_pe_typ_instances_all.emplmnt_category_code%TYPE,

296: PROCEDURE update_person_type(p_person_type_rec IN per_type_cur%ROWTYPE,
297: p_type_instance_id IN igs_pe_typ_instances_all.type_instance_id%TYPE,
298: p_rowid IN ROWID,
299: p_end_date IN igs_pe_typ_instances_all.end_date%TYPE,
300: p_emplmnt_category_code IN igs_pe_typ_instances_all.emplmnt_category_code%TYPE,
301: p_system_type IN igs_pe_person_types.system_type%TYPE,
302: p_default_date IN DATE)
303: AS
304:

Line 307: l_type_instance_id igs_pe_typ_instances_all.type_instance_id%TYPE;

303: AS
304:
305: l_ended_by fnd_user.user_id%TYPE;
306: l_end_method VARCHAR2(30);
307: l_type_instance_id igs_pe_typ_instances_all.type_instance_id%TYPE;
308: l_message_name VARCHAR2(30);
309: l_app VARCHAR2(50);
310: l_error_code VARCHAR2(30);
311: l_exists VARCHAR2(1);

Line 324: FROM igs_pe_typ_instances_all

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
326: person_type_code = cp_person_type_code AND
327: start_date <> cp_start_date AND
328: ( NVL(cp_end_date,cp_default_date) BETWEEN start_date AND NVL(end_date,cp_default_date)

Line 337: SELECT null FROM igs_pe_typ_instances_all typ,igs_pe_person_types sys

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
340: sys.person_type_code = typ.person_type_code AND
341: sys.system_type in ('FACULTY','STAFF') AND

Line 681: FROM igs_pe_typ_instances_all pi,

677: WHERE pti.status = '2' AND
678: pti.interface_run_id = l_interface_run_id AND
679: pti.match_ind IS NULL AND
680: EXISTS (SELECT 1
681: FROM igs_pe_typ_instances_all pi,
682: igs_ad_interface_all ai
683: WHERE pti.interface_id = ai.interface_id AND
684: ai.interface_run_id = l_interface_run_id AND
685: ai.person_id = pi.person_id AND

Line 724: FROM igs_pe_typ_instances_all pi,

720: pti.interface_run_id = l_interface_run_id AND
721: pti.match_ind IS NULL AND
722: EXISTS
723: (SELECT 1
724: FROM igs_pe_typ_instances_all pi,
725: igs_ad_interface_all ai
726: WHERE pti.interface_id = ai.interface_id AND
727: ai.interface_run_id = l_interface_run_id AND
728: ai.person_id = pi.person_id AND

Line 744: FROM igs_pe_typ_instances_all pi,

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,
745: igs_ad_interface_all ai
746: WHERE pti.interface_id = ai.interface_id AND
747: ai.interface_run_id = l_interface_run_id AND
748: ai.person_id = pi.person_id AND

Line 756: FROM igs_pe_typ_instances_all pi,

752: pti.interface_run_id = l_interface_run_id AND
753: pti.match_ind IS NULL AND
754: EXISTS
755: (SELECT 1
756: FROM igs_pe_typ_instances_all pi,
757: igs_ad_interface_all ai
758: WHERE pti.interface_id=ai.interface_id AND
759: ai.interface_run_id = l_interface_run_id AND
760: ai.person_id = pi.person_id AND