APPS.ZPB_WF_NTF dependencies on FND_USER

Line 289: FND_USER C

285: CURSOR c_baControllers is
286: select C.USER_NAME
287: from FND_RESPONSIBILITY A,
288: ZPB_ACCOUNT_STATES B,
289: FND_USER C
290: where B.BUSINESS_AREA_ID = l_business_area_id AND
291: A.RESPONSIBILITY_ID = B.RESP_ID AND
292: A.RESPONSIBILITY_KEY = 'ZPB_SUPER_CONTROLLER_RESP' AND
293: C.USER_ID = B.USER_ID ;

Line 301: FND_USER C

297: CURSOR c_bpadmin is
298: select C.USER_NAME
299: from FND_RESPONSIBILITY A,
300: ZPB_ACCOUNT_STATES B,
301: FND_USER C
302: where A.RESPONSIBILITY_ID = B.RESP_ID AND
303: A.RESPONSIBILITY_KEY = 'ZPB_CONTROLLER_RESP' AND
304: C.USER_ID = B.USER_ID ;
305:

Line 312: FND_USER C

308: -- B4951035 - ACID was hard coded to 8891.
309: CURSOR c_bpowner is
310: select C.USER_NAME
311: from zpb_analysis_cycles A,
312: FND_USER C
313: where analysis_cycle_id = ACID AND
314: C.USER_ID = A.OWNER_ID ;
315:
316: v_bpowner c_bpowner%ROWTYPE;

Line 719: from zpb_all_cycles_v v, zpb_process_details_v pro, fnd_user u

715:
716: CURSOR c_eventACID is
717: select distinct v.analysis_cycle_id thisACID, v.name thisACName,
718: u.user_name thisUser
719: from zpb_all_cycles_v v, zpb_process_details_v pro, fnd_user u
720: where v.analysis_cycle_id in (select pa.analysis_cycle_id from zpb_ac_param_values pa
721: where pa.param_id = 20 and pa.value in(select d.value from ZPB_PROCESS_DETAILS_V d
722: where d.name = 'CREATE_EVENT_IDENTIFIER' and d.task_id = TaskID))
723: and v.last_updated_by = u.user_id;

Line 1114: from fnd_user

1110: BEGIN
1111:
1112:
1113: select user_name into fndUser
1114: from fnd_user
1115: where user_id = userID;
1116:
1117: return fndUser;
1118:

Line 1138: from fnd_user

1134:
1135: BEGIN
1136:
1137: select user_id into userID
1138: from fnd_user
1139: where user_name = fndUser;
1140:
1141: return userID;
1142:

Line 1298: -- FND user names list so build Ad Hoc role

1294: ZPB_UTIL_PVT.AddUsersToAdHocRole(rolename, l_UserList);
1295: l_type := 'ALREADY_SET';
1296:
1297: elsif instr(UserList, ',') > 0 then
1298: -- FND user names list so build Ad Hoc role
1299: rolename := zpb_wf_ntf.MakeRoleName(InstanceID, TaskID);
1300: zpb_wf_ntf.SetRole(rolename, relative+7);
1301: ZPB_UTIL_PVT.AddUsersToAdHocRole(rolename, UserList);
1302: l_type := 'ALREADY_SET';

Line 1356: which may be a vaild fnd_user.user_name.

1352:
1353: This procedure assumes application context is set!
1354:
1355: p_userID is any user ID which corresponds to a valid wf_roles.name
1356: which may be a vaild fnd_user.user_name.
1357: p_subject - the notification subject up to 150 chars
1358: p_message - the notification message up to 2000 chars
1359:
1360: May be called from any procedure if context is set.