APPS.JTF_RS_WF_INTEGRATION_PUB dependencies on FND_USER

Line 92: --xx from fnd_user

88: where vendor_contact_id = c_vendor_contact_id;
89:
90: --xx cursor fnd_wfrole_cur IS
91: --xx select user_name, 'FND_USR', user_id
92: --xx from fnd_user
93: --xx where user_id = p_user_id;
94:
95: BEGIN
96:

Line 277: /* If the resource is not attached to an fnd user */

273: then
274: fnd_msg_pub.Initialize;
275: end if;
276:
277: /* If the resource is not attached to an fnd user */
278: -- if (p_user_id is NULL) then
279:
280: if (p_category not in ('EMPLOYEE','PARTY','PARTNER','SUPPLIER_CONTACT')) then
281:

Line 328: -- end if; /* End of - If the resource is not attached to an fnd user */

324:
325: end if; /* End of - looking for active resource at the time of creation */
326:
327: end if; /* End of - If the resource is not an EMPLOYEE, PARTY, PARTNER or SUPPLIER_CONTACT */
328: -- end if; /* End of - If the resource is not attached to an fnd user */
329:
330: IF p_commit is not NULL and fnd_api.to_boolean(p_commit) THEN
331: COMMIT WORK;
332: END IF;

Line 385: from fnd_user

381: res_wfrole_exists varchar2(1) := 'N';
382:
383: cursor fnd_wfrole_cur(l_user_id number) IS
384: select user_name
385: from fnd_user
386: where user_id = l_user_id;
387:
388: l_fnd_old_user_name wf_local_roles.name%TYPE;
389: l_fnd_new_user_name wf_local_roles.name%TYPE;