APPS.WIP_OSP_SHP_I_WF dependencies on FND_PROFILE

Line 196: if(fnd_profile.value('WIP_OSP_INITIATE_REQAPPR') = WIP_CONSTANTS.NO) then

192: , avalue => l_req_import);
193: /* End of Fix for bug 8919025 (FP 8850950)*/
194:
195: /*ER 4276433*/
196: if(fnd_profile.value('WIP_OSP_INITIATE_REQAPPR') = WIP_CONSTANTS.NO) then
197: l_init_reqappr := 'N';
198: else
199: l_init_reqappr := 'Y';
200: end if;

Line 236: l_user_id := fnd_profile.value('USER_ID');

232: if NOT wip_common_wf_pkg.OSPEnabled then
233: return;
234: end if;
235: /* Commented out for bug fix 6501679
236: l_user_id := fnd_profile.value('USER_ID');
237: l_resp_id := fnd_profile.value('RESP_ID');
238: l_resp_appl_id := fnd_profile.value('RESP_APPL_ID');
239: l_security_group_id := fnd_profile.value('SECURITY_GROUP_ID');
240: */

Line 237: l_resp_id := fnd_profile.value('RESP_ID');

233: return;
234: end if;
235: /* Commented out for bug fix 6501679
236: l_user_id := fnd_profile.value('USER_ID');
237: l_resp_id := fnd_profile.value('RESP_ID');
238: l_resp_appl_id := fnd_profile.value('RESP_APPL_ID');
239: l_security_group_id := fnd_profile.value('SECURITY_GROUP_ID');
240: */
241:

Line 238: l_resp_appl_id := fnd_profile.value('RESP_APPL_ID');

234: end if;
235: /* Commented out for bug fix 6501679
236: l_user_id := fnd_profile.value('USER_ID');
237: l_resp_id := fnd_profile.value('RESP_ID');
238: l_resp_appl_id := fnd_profile.value('RESP_APPL_ID');
239: l_security_group_id := fnd_profile.value('SECURITY_GROUP_ID');
240: */
241:
242: -- Added for bugfix 6501679 . Used fnd_global package to get the

Line 239: l_security_group_id := fnd_profile.value('SECURITY_GROUP_ID');

235: /* Commented out for bug fix 6501679
236: l_user_id := fnd_profile.value('USER_ID');
237: l_resp_id := fnd_profile.value('RESP_ID');
238: l_resp_appl_id := fnd_profile.value('RESP_APPL_ID');
239: l_security_group_id := fnd_profile.value('SECURITY_GROUP_ID');
240: */
241:
242: -- Added for bugfix 6501679 . Used fnd_global package to get the
243: -- user information.

Line 1688: IF(fnd_profile.value('WIP_OSP_INITIATE_REQAPPR') = WIP_CONSTANTS.NO) then

1684: itemkey,
1685: 'REQ_GROUP_BY');
1686:
1687: /*ER 4276433*/
1688: IF(fnd_profile.value('WIP_OSP_INITIATE_REQAPPR') = WIP_CONSTANTS.NO) then
1689: l_init_reqappr := 'N';
1690: ELSE
1691: l_init_reqappr := 'Y';
1692: END IF;

Line 1778: IF(fnd_profile.value('REQIMP_AUTORELEASE') = 'Y') THEN

1774: (l_parent_id, 10, 3600, phase, status, devphase,
1775: devstatus, message);
1776:
1777: --PO: Release During ReqImport is launched inside REQIMPORT, we need to wait for it to finish before we continue in the workflow
1778: IF(fnd_profile.value('REQIMP_AUTORELEASE') = 'Y') THEN
1779: BEGIN
1780: select request_id
1781: into l_child_id
1782: from fnd_concurrent_requests