APPS.ZPB_DC_OBJECTS_PVT dependencies on FND_USER

Line 1699: FROM fnd_user

1695: EXIT WHEN specific_user_csr%NOTFOUND;
1696:
1697: -- Get the user id by user name
1698: SELECT user_id INTO l_user_id
1699: FROM fnd_user
1700: WHERE user_name = upper(l_user);
1701:
1702: -- Check duplicates
1703: OPEN check_exist_csr;

Line 2169: FROM fnd_user

2165: EXIT WHEN specific_user_csr%NOTFOUND;
2166:
2167: -- Get the user id by user name
2168: SELECT user_id INTO l_user_id
2169: FROM fnd_user
2170: WHERE user_name = upper(l_user);
2171:
2172: -- Check whether the distribution exists already
2173: OPEN check_exist_csr;

Line 2313: SELECT fnd.user_name

2309: l_charDate VARCHAR2(20);
2310: l_rolename VARCHAR2(320);
2311:
2312: CURSOR template_user_csr IS
2313: SELECT fnd.user_name
2314: FROM zpb_dc_objects obj, fnd_user fnd
2315: WHERE obj.template_id = p_template_id
2316: AND obj.object_user_id = fnd.user_id
2317: AND obj.object_type in ('W');

Line 2314: FROM zpb_dc_objects obj, fnd_user fnd

2310: l_rolename VARCHAR2(320);
2311:
2312: CURSOR template_user_csr IS
2313: SELECT fnd.user_name
2314: FROM zpb_dc_objects obj, fnd_user fnd
2315: WHERE obj.template_id = p_template_id
2316: AND obj.object_user_id = fnd.user_id
2317: AND obj.object_type in ('W');
2318: --

Line 2316: AND obj.object_user_id = fnd.user_id

2312: CURSOR template_user_csr IS
2313: SELECT fnd.user_name
2314: FROM zpb_dc_objects obj, fnd_user fnd
2315: WHERE obj.template_id = p_template_id
2316: AND obj.object_user_id = fnd.user_id
2317: AND obj.object_type in ('W');
2318: --
2319: BEGIN
2320:

Line 2571: -- Join the fnd user to get the user names

2567:
2568: END LOOP;
2569: END IF; -- parse and store the ids
2570:
2571: -- Join the fnd user to get the user names
2572: FOR fnd_rec IN
2573: (select column_value , fndu.user_name user_name
2574: from
2575: table( cast(aw_user_list as zpb_num_tbl_type)) aw_users,

Line 2576: fnd_user fndu

2572: FOR fnd_rec IN
2573: (select column_value , fndu.user_name user_name
2574: from
2575: table( cast(aw_user_list as zpb_num_tbl_type)) aw_users,
2576: fnd_user fndu
2577: where fndu.user_id = aw_users.column_value
2578: )
2579: LOOP
2580: l_rolename := zpb_wf_ntf.update_Role_with_Shadows(l_rolename, fnd_rec.user_name);

Line 2680: fnd_user fndu

2676: FOR fnd_rec IN
2677: (select column_value , fndu.user_name user_name
2678: from
2679: table( cast(aw_user_list as zpb_num_tbl_type)) aw_users,
2680: fnd_user fndu
2681: where fndu.user_id = aw_users.column_value
2682: )
2683: LOOP
2684: l_rolename := zpb_wf_ntf.update_Role_with_Shadows(l_rolename, fnd_rec.user_name);

Line 3071: -- Join the fnd user to get the user names

3067:
3068: END LOOP;
3069: END IF; -- parse and store the ids
3070:
3071: -- Join the fnd user to get the user names
3072: FOR fnd_rec IN
3073: (select column_value , fndu.user_name user_name
3074: from
3075: table( cast(aw_user_list as zpb_num_tbl_type)) aw_users,

Line 3076: fnd_user fndu

3072: FOR fnd_rec IN
3073: (select column_value , fndu.user_name user_name
3074: from
3075: table( cast(aw_user_list as zpb_num_tbl_type)) aw_users,
3076: fnd_user fndu
3077: where fndu.user_id = aw_users.column_value
3078: )
3079: LOOP
3080: ZPB_UTIL_PVT.AddUsersToAdHocRole(l_rolename, fnd_rec.user_name);