APPS.IGS_EN_WLST_GEN_PROC dependencies on FND_USER

Line 305: SELECT fnd.USER_ID from fnd_user fnd ,

301: -------------------------------------------------------------------
302: IS
303:
304: CURSOR c_userid IS
305: SELECT fnd.USER_ID from fnd_user fnd ,
306: igs_ps_usec_tch_resp ustr
307: WHERE
308: ustr.uoo_id = p_uoo_id AND
309: ustr.LEAD_INSTRUCTOR_FLAG='Y' AND

Line 313: CURSOR c_resp (cp_user_id fnd_user.user_id%type) IS

309: ustr.LEAD_INSTRUCTOR_FLAG='Y' AND
310: ustr.instructor_id = fnd.person_party_id ;
311:
312:
313: CURSOR c_resp (cp_user_id fnd_user.user_id%type) IS
314: SELECT rg.responsibility_id,
315: rg.responsibility_application_id
316: FROM fnd_user_resp_groups rg, fnd_responsibility r
317: WHERE rg.user_id = cp_user_id

Line 316: FROM fnd_user_resp_groups rg, fnd_responsibility r

312:
313: CURSOR c_resp (cp_user_id fnd_user.user_id%type) IS
314: SELECT rg.responsibility_id,
315: rg.responsibility_application_id
316: FROM fnd_user_resp_groups rg, fnd_responsibility r
317: WHERE rg.user_id = cp_user_id
318: AND SYSDATE BETWEEN rg.start_date AND NVL(rg.end_date,(SYSDATE+1))
319: AND r.responsibility_id = rg.responsibility_id
320: AND r.responsibility_key = 'IGS_SS_FACULTY';

Line 327: l_USER_ID fnd_user.USER_ID%TYPE ;

323: l_key NUMBER;
324: l_param_list wf_parameter_list_t:=wf_parameter_list_t();
325: l_wf_installed fnd_lookups.lookup_code%TYPE;
326: v_USER_ID c_userid%ROWTYPE ;
327: l_USER_ID fnd_user.USER_ID%TYPE ;
328: l_RESP_ID fnd_user_resp_groups.responsibility_id%TYPE ;
329: l_RESP_APPL_ID fnd_user_resp_groups.responsibility_application_id%TYPE ;
330:
331: BEGIN

Line 328: l_RESP_ID fnd_user_resp_groups.responsibility_id%TYPE ;

324: l_param_list wf_parameter_list_t:=wf_parameter_list_t();
325: l_wf_installed fnd_lookups.lookup_code%TYPE;
326: v_USER_ID c_userid%ROWTYPE ;
327: l_USER_ID fnd_user.USER_ID%TYPE ;
328: l_RESP_ID fnd_user_resp_groups.responsibility_id%TYPE ;
329: l_RESP_APPL_ID fnd_user_resp_groups.responsibility_application_id%TYPE ;
330:
331: BEGIN
332: -- get the profile value that is set for checking if workflow is installed

Line 329: l_RESP_APPL_ID fnd_user_resp_groups.responsibility_application_id%TYPE ;

325: l_wf_installed fnd_lookups.lookup_code%TYPE;
326: v_USER_ID c_userid%ROWTYPE ;
327: l_USER_ID fnd_user.USER_ID%TYPE ;
328: l_RESP_ID fnd_user_resp_groups.responsibility_id%TYPE ;
329: l_RESP_APPL_ID fnd_user_resp_groups.responsibility_application_id%TYPE ;
330:
331: BEGIN
332: -- get the profile value that is set for checking if workflow is installed
333: fnd_profile.get('IGS_WF_ENABLE',l_wf_installed);

Line 472: FROM fnd_user

468:
469: -- Cursor to select user name of the student based on the person_id
470: CURSOR c_student(cp_person_id hz_parties.party_id%TYPE) IS
471: SELECT user_name
472: FROM fnd_user
473: WHERE person_party_id = cp_person_id;
474:
475: -- Record type for PL/SQL table
476: TYPE t_stud_wait_rec IS RECORD

Line 492: l_student_user_name fnd_user.user_name%TYPE;

488: stud_waitlist_table t_stud_waitlist;
489:
490: l_person_number_wlst hz_parties.party_number%TYPE;
491: l_person_number_sua hz_parties.party_number%TYPE;
492: l_student_user_name fnd_user.user_name%TYPE;
493:
494: waitlist_pos NUMBER;
495: counter NUMBER;
496: