941: SELECT task_template_group_id
942: FROM jtf_task_temp_groups_b
943: WHERE task_template_group_id =
944: (SELECT task_group_id
945: FROM jtf_task_templates_b
946: WHERE task_template_id = p_task_template_id);
947:
948: l_task_template_group_id jtf_task_temp_groups_b.task_template_group_id%TYPE;
949: BEGIN
1038: IS
1039: SELECT source_object_type_code
1040: FROM jtf_task_temp_groups_b
1041: WHERE task_template_group_id = (SELECT task_group_id
1042: FROM jtf_task_templates_b
1043: WHERE task_template_id = p_task_id);
1044: BEGIN
1045: x_return_status := fnd_api.g_ret_sts_success;
1046:
1570: IS
1571: CURSOR c_task_id
1572: IS
1573: SELECT task_template_id task_id
1574: FROM jtf_task_templates_b
1575: WHERE task_template_id = p_task_id;
1576:
1577: CURSOR c_task_number
1578: IS
1576:
1577: CURSOR c_task_number
1578: IS
1579: SELECT task_template_id task_id
1580: FROM jtf_task_templates_b
1581: WHERE task_number = p_task_number;
1582:
1583: l_task_id jtf_tasks_b.task_id%TYPE;
1584: l_task_number jtf_tasks_b.task_number%TYPE;