APPS.IGS_AD_IMP_013 dependencies on FND_USER

Line 131: l_ended_by fnd_user.user_name%TYPE;

127: p_default_date IN DATE
128: )
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);

Line 139: CURSOR user_name_cur(cp_user_id fnd_user.user_id%TYPE) IS

135: l_app VARCHAR2(50);
136: l_error_code VARCHAR2(30);
137: l_exists VARCHAR2(1);
138:
139: CURSOR user_name_cur(cp_user_id fnd_user.user_id%TYPE) IS
140: SELECT user_name
141: FROM fnd_user
142: WHERE user_id = cp_user_id;
143:

Line 141: FROM fnd_user

137: l_exists VARCHAR2(1);
138:
139: CURSOR user_name_cur(cp_user_id fnd_user.user_id%TYPE) IS
140: SELECT user_name
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,

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

Line 313: CURSOR user_name_cur(cp_user_id fnd_user.user_id%TYPE) IS

309: l_app VARCHAR2(50);
310: l_error_code VARCHAR2(30);
311: l_exists VARCHAR2(1);
312:
313: CURSOR user_name_cur(cp_user_id fnd_user.user_id%TYPE) IS
314: SELECT user_name
315: FROM fnd_user
316: WHERE user_id = cp_user_id;
317:

Line 315: FROM fnd_user

311: l_exists VARCHAR2(1);
312:
313: CURSOR user_name_cur(cp_user_id fnd_user.user_id%TYPE) IS
314: SELECT user_name
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,