DBA Data[Home] [Help]

APPS.IGS_AS_CGR_WF_PKG dependencies on FND_USER

Line 32: l_user_name_app fnd_user.user_name%TYPE;

28: itemkey,
29: 'REQUESTER_ID'
30: );
31: l_instructor_id igs_ps_usec_tch_resp.instructor_id%TYPE;
32: l_user_name_app fnd_user.user_name%TYPE;
33: l_user_name_req fnd_user.user_name%TYPE;
34: CURSOR cur_user (lv_requester_id fnd_user.person_party_id%TYPE) IS
35: SELECT user_name
36: FROM fnd_user

Line 33: l_user_name_req fnd_user.user_name%TYPE;

29: 'REQUESTER_ID'
30: );
31: l_instructor_id igs_ps_usec_tch_resp.instructor_id%TYPE;
32: l_user_name_app fnd_user.user_name%TYPE;
33: l_user_name_req fnd_user.user_name%TYPE;
34: CURSOR cur_user (lv_requester_id fnd_user.person_party_id%TYPE) IS
35: SELECT user_name
36: FROM fnd_user
37: WHERE person_party_id = lv_requester_id;

Line 34: CURSOR cur_user (lv_requester_id fnd_user.person_party_id%TYPE) IS

30: );
31: l_instructor_id igs_ps_usec_tch_resp.instructor_id%TYPE;
32: l_user_name_app fnd_user.user_name%TYPE;
33: l_user_name_req fnd_user.user_name%TYPE;
34: CURSOR cur_user (lv_requester_id fnd_user.person_party_id%TYPE) IS
35: SELECT user_name
36: FROM fnd_user
37: WHERE person_party_id = lv_requester_id;
38: CURSOR cur_instruct (lv_uoo_id igs_ps_unit_ofr_opt.uoo_id%TYPE) IS

Line 36: FROM fnd_user

32: l_user_name_app fnd_user.user_name%TYPE;
33: l_user_name_req fnd_user.user_name%TYPE;
34: CURSOR cur_user (lv_requester_id fnd_user.person_party_id%TYPE) IS
35: SELECT user_name
36: FROM fnd_user
37: WHERE person_party_id = lv_requester_id;
38: CURSOR cur_instruct (lv_uoo_id igs_ps_unit_ofr_opt.uoo_id%TYPE) IS
39: SELECT instructor_id
40: FROM igs_ps_usec_tch_resp

Line 43: CURSOR cur_user1 (lv_instructor_id fnd_user.person_party_id%TYPE) IS

39: SELECT instructor_id
40: FROM igs_ps_usec_tch_resp
41: WHERE lead_instructor_flag = 'Y'
42: AND uoo_id = lv_uoo_id;
43: CURSOR cur_user1 (lv_instructor_id fnd_user.person_party_id%TYPE) IS
44: SELECT user_name
45: FROM fnd_user
46: WHERE person_party_id = lv_instructor_id;
47: BEGIN

Line 45: FROM fnd_user

41: WHERE lead_instructor_flag = 'Y'
42: AND uoo_id = lv_uoo_id;
43: CURSOR cur_user1 (lv_instructor_id fnd_user.person_party_id%TYPE) IS
44: SELECT user_name
45: FROM fnd_user
46: WHERE person_party_id = lv_instructor_id;
47: BEGIN
48: SAVEPOINT select_approver;
49: IF (funcmode = 'RUN') THEN