APPS.CSF_REQUIRED_SKILLS_PKG dependencies on FND_PROFILE

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

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

Line 357: AND ic.category_set_id = fnd_profile.value('CS_SR_DEFAULT_CATEGORY_SET')

353: WHERE ic.category_id = c.category_id
354: AND t.category_id (+) = c.category_id
355: AND t.language (+) = userenv('LANG')
356: AND ic.category_set_id = cs.category_set_id
357: AND ic.category_set_id = fnd_profile.value('CS_SR_DEFAULT_CATEGORY_SET')
358: AND Sysdate <= NVL(c.disable_date, Sysdate)
359: AND c.category_id = sr.category_id
360: AND sr.incident_id = tb.source_object_id
361: and tb.task_id = l_task_id;

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

373: -- Check if required skill based on product/inventroy item
374: -- has to be created.
375: l_task_id := jtf_tasks_pub.p_task_user_hooks.task_id;
376: g_called_from_hook := 'T';
377: if nvl(fnd_profile.value('CSF_SR_ITEM_TO_TASK_REQ'), 'N') = 'Y'
378: then
379: -- Takes the Product Skills from the inv table
380: open c_ProdSkill;
381: fetch c_ProdSkill into l_skill_id;

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

382: close c_ProdSkill;
383: if l_skill_id is not null
384: then
385: -- retrieving default values for skill type and level.
386: l_skill_level_id := fnd_profile.value('CSF_DFLT_SKILL_LEVEL');
387:
388: -- when either skill level is null do not proceed.
389: if nvl(l_skill_level_id, null) is not null
390: then

Line 408: if nvl(fnd_profile.value('CSF_SR_ITEM_CAT_TO_TASK_REQ'), 'N') = 'Y'

404:
405: end if;
406: end if;
407: end if;
408: if nvl(fnd_profile.value('CSF_SR_ITEM_CAT_TO_TASK_REQ'), 'N') = 'Y'
409: then
410: open c_Prod_cat_skill;
411: fetch c_Prod_cat_Skill into l_skill_id1;
412: close c_Prod_cat_Skill;

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

413:
414: if l_skill_id1 is not null
415: then
416: -- retrieving default values for skill type and level.
417: l_skill_level_id := fnd_profile.value('CSF_DFLT_SKILL_LEVEL');
418:
419: -- when either skill level is null do not proceed.
420: if nvl(l_skill_level_id, null) is not null
421: then

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

556: loop
557: fetch skills_to_create into l_skill_type_id, l_skill_id, l_skill_level_id, l_disabled_flag;
558: EXIT WHEN skills_to_create%NOTFOUND;
559: -- retrieving default values for skill type and level.
560: -- l_skill_level_id := fnd_profile.value('CSF_DFLT_SKILL_LEVEL');
561: create_row
562: ( p_api_version => 1
563: , p_init_msg_list => FND_API.G_FALSE
564: , p_commit => FND_API.G_FALSE