APPS.IGS_AD_IMP_013 dependencies on IGS_PE_PERSON_TYPES

Line 69: l_staff_person_type_code igs_pe_person_types.person_type_code%TYPE;

65: || Who When What
66: */
67:
68: l_rule VARCHAR2(1);
69: l_staff_person_type_code igs_pe_person_types.person_type_code%TYPE;
70: l_faculty_person_type_code igs_pe_person_types.person_type_code%TYPE;
71: l_system_type igs_pe_person_types.system_type%TYPE;
72: l_error_code VARCHAR2(30);
73: l_discp_exists VARCHAR2(1);

Line 70: l_faculty_person_type_code igs_pe_person_types.person_type_code%TYPE;

66: */
67:
68: l_rule VARCHAR2(1);
69: l_staff_person_type_code igs_pe_person_types.person_type_code%TYPE;
70: l_faculty_person_type_code igs_pe_person_types.person_type_code%TYPE;
71: l_system_type igs_pe_person_types.system_type%TYPE;
72: l_error_code VARCHAR2(30);
73: l_discp_exists VARCHAR2(1);
74: l_processed_records NUMBER(5) := 0;

Line 71: l_system_type igs_pe_person_types.system_type%TYPE;

67:
68: l_rule VARCHAR2(1);
69: l_staff_person_type_code igs_pe_person_types.person_type_code%TYPE;
70: l_faculty_person_type_code igs_pe_person_types.person_type_code%TYPE;
71: l_system_type igs_pe_person_types.system_type%TYPE;
72: l_error_code VARCHAR2(30);
73: l_discp_exists VARCHAR2(1);
74: l_processed_records NUMBER(5) := 0;
75: l_var VARCHAR2(1);

Line 108: CURSOR hr_map_cur(cp_system_type igs_pe_person_types.system_type%TYPE) IS

104: dup_per_type_rec dup_per_type_cur%ROWTYPE;
105:
106:
107: -- Cursor to check HR Mapping
108: CURSOR hr_map_cur(cp_system_type igs_pe_person_types.system_type%TYPE) IS
109: SELECT person_type_code
110: FROM igs_pe_per_type_map_v
111: WHERE system_type = cp_system_type;
112:

Line 114: CURSOR type_exist_cur(cp_person_type_code igs_pe_person_types.person_type_code%TYPE,

110: FROM igs_pe_per_type_map_v
111: WHERE system_type = cp_system_type;
112:
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

Line 126: p_system_type IN igs_pe_person_types.system_type%TYPE,

122:
123: -- Private procedure to create person type
124: PROCEDURE create_person_type(
125: p_person_type_rec IN per_type_cur%ROWTYPE,
126: p_system_type IN igs_pe_person_types.system_type%TYPE,
127: p_default_date IN DATE
128: )
129: AS
130: lv_rowid ROWID;

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 301: p_system_type IN igs_pe_person_types.system_type%TYPE,

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:
305: l_ended_by fnd_user.user_id%TYPE;

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 486: FROM igs_pe_person_types

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
488: AND closed_ind = 'N';
489:
490: CURSOR birth_date_cur(cp_person_id igs_pe_person_base_v.person_id%TYPE)