APPS.CSF_REQUIRED_SKILLS_PKG dependencies on FND_PROFILE

Line 337: where mtl.organization_id = fnd_profile.value('CSF_INVENTORY_ORG')

333: select mtl.inventory_item_id
334: from jtf_tasks_b tb
335: , cs_incidents_all_b sr
336: , mtl_system_items_kfv mtl
337: where mtl.organization_id = fnd_profile.value('CSF_INVENTORY_ORG')
338: and sysdate between nvl(mtl.start_date_active,sysdate) and nvl(mtl.end_date_active,sysdate)
339: and mtl.inventory_item_id = sr.inventory_item_id
340: and sr.incident_id = tb.source_object_id
341: and tb.task_id = l_task_id;

Line 356: if nvl(fnd_profile.value('CSF_SR_ITEM_TO_TASK_REQ'), 'N') = 'Y'

352: -- Check if required skill based on product/inventroy item
353: -- has to be created.
354: l_task_id := jtf_tasks_pub.p_task_user_hooks.task_id;
355: g_called_from_hook := 'T';
356: if nvl(fnd_profile.value('CSF_SR_ITEM_TO_TASK_REQ'), 'N') = 'Y'
357: then
358: -- Takes the Product Skills from the inv table
359: open c_ProdSkill;
360: fetch c_ProdSkill into l_skill_id;

Line 365: l_skill_level_id := fnd_profile.value('CSF_DFLT_SKILL_LEVEL');

361: close c_ProdSkill;
362: if l_skill_id is not null
363: then
364: -- retrieving default values for skill type and level.
365: l_skill_level_id := fnd_profile.value('CSF_DFLT_SKILL_LEVEL');
366:
367: -- when either skill level is null do not proceed.
368: if nvl(l_skill_level_id, null) is not null
369: then