DBA Data[Home] [Help]

APPS.IEX_STRY_CUWF_PUB dependencies on FND_PROFILE

Line 17: --PG_DEBUG NUMBER(2) := TO_NUMBER(NVL(FND_PROFILE.value('IEX_DEBUG_LEVEL'), '20'));

13: /**Name AddInvalidArgMsg
14: **Appends to a message the api name, parameter name and parameter Value
15: */
16:
17: --PG_DEBUG NUMBER(2) := TO_NUMBER(NVL(FND_PROFILE.value('IEX_DEBUG_LEVEL'), '20'));
18: PG_DEBUG NUMBER;
19:
20: --begin schekuri Bug#4506922 Date:02-Dec-2005
21: wf_yes varchar2(1) ;

Line 292: l_resource_id := nvl(fnd_profile.value('IEX_STRY_DEFAULT_RESOURCE'),0);

288: l_commit := p_commit;
289: if (p_commit is null ) then
290: l_commit := FND_API.G_FALSE;
291: end if;
292: l_resource_id := nvl(fnd_profile.value('IEX_STRY_DEFAULT_RESOURCE'),0);
293:
294: SAVEPOINT START_CUSTOMWF_PUB;
295:
296: -- Standard call to check for call compatibility.

Line 464: l_resource_id := nvl(fnd_profile.value('IEX_STRY_DEFAULT_RESOURCE'),0);

460: select resource_id into l_resource_id
461: from iex_strategy_work_items
462: where work_item_id =p_Custom_WF_rec.workitem_id;
463: EXCEPTION WHEN NO_DATA_FOUND THEN
464: l_resource_id := nvl(fnd_profile.value('IEX_STRY_DEFAULT_RESOURCE'),0);
465: END;
466:
467: set_notification_resources(
468: p_resource_id =>l_resource_id,