APPS.CSF_REQUIRED_SKILLS_PKG dependencies on JTF_TASKS_B

Line 32: From jtf_tasks_b

28: RETURN boolean
29: IS
30: Cursor c_task is
31: Select 1
32: From jtf_tasks_b
33: Where task_id = p_task_id;
34: l_dummy_var number;
35: BEGIN
36: /* Check if the task exists. */

Line 189: ') does not exist in JTF_TASKS_B table.';

185: If not task_exists (p_task_id) then
186: X_return_status := fnd_api.g_ret_sts_error;
187: X_msg_count := 1;
188: X_msg_data := 'Task Id ('||to_char(p_task_id)||
189: ') does not exist in JTF_TASKS_B table.';
190: return;
191: end if;
192:
193: /* Checks if skill type and id exist. */

Line 335: from jtf_tasks_b tb

331: l_task_id number ;
332:
333: Cursor c_ProdSkill is
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)

Line 352: jtf_tasks_b tb

348: mtl_categories_kfv c,
349: mtl_category_sets_vl cs,
350: mtl_categories_tl t,
351: cs_incidents_all_b sr,
352: jtf_tasks_b tb
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

Line 521: from jtf_tasks_b a, jtf_task_statuses_b b

517:
518: cursor c_parent_task_id(p_task_id number)
519: is
520: select a.parent_task_id
521: from jtf_tasks_b a, jtf_task_statuses_b b
522: where a.task_id = p_task_id
523: and a.task_status_id = b.task_status_id
524: and nvl(task_split_flag, 'N') = 'D'
525: and nvl(b.cancelled_flag, 'N') <> 'Y';

Line 535: l_task_split_flag jtf_tasks_b.task_split_flag%TYPE;

531: where has_skill_id = p_task_id
532: and skill_type_id <>2;
533:
534: l_api_name constant varchar2(30) := 'create_row_for_child_tasks';
535: l_task_split_flag jtf_tasks_b.task_split_flag%TYPE;
536: l_task_id number ;
537: l_parent_task_id number;
538: l_return_status varchar2(50);
539: l_msg_count number;