APPS.CSF_REQUIRED_SKILLS_PKG dependencies on CSF_REQUIRED_SKILLS_B

Line 55: from csf_required_skills_b

51: , p_skill_type_id in number)
52: RETURN boolean IS
53: cursor c_reqSkill is
54: select 1
55: from csf_required_skills_b
56: where skill_id = p_skill_id
57: and skill_type_id = p_skill_type_id
58: and has_skill_type = 'TASK'
59: and sysdate >= trunc(start_date_active)

Line 215: select csf_required_skills_b_s1.nextval

211:
212: /* When all checks are ok, insert record
213: into CSF_REQUIRED_SKILLS table. */
214:
215: select csf_required_skills_b_s1.nextval
216: into l_req_skill_id
217: from dual;
218:
219: insert into csf_required_skills_b

Line 219: insert into csf_required_skills_b

215: select csf_required_skills_b_s1.nextval
216: into l_req_skill_id
217: from dual;
218:
219: insert into csf_required_skills_b
220: ( required_skill_id
221: , skill_type_id
222: , skill_id
223: , has_skill_type

Line 296: --When the required skill to be inserted into csf_required_skills_b table already exist for

292:
293: x_return_status := fnd_api.g_ret_sts_success;
294:
295: --Bug Fixed 3884408
296: --When the required skill to be inserted into csf_required_skills_b table already exist for
297: --the given task, Procedure create_row() must return status 'E' to calling function.
298: else
299: if g_called_from_hook = 'T' then
300: X_return_status := fnd_api.g_ret_sts_success;

Line 304: X_msg_data := 'Combination of Skill id ('||p_skill_id||') and Skill type id ('||p_skill_type_id||') to be inserted does exist for Task ('||to_char(p_task_id)|| ') in CSF_REQUIRED_SKILLS_B table';

300: X_return_status := fnd_api.g_ret_sts_success;
301: else
302: X_return_status := fnd_api.g_ret_sts_error;
303: X_msg_count := 1;
304: X_msg_data := 'Combination of Skill id ('||p_skill_id||') and Skill type id ('||p_skill_type_id||') to be inserted does exist for Task ('||to_char(p_task_id)|| ') in CSF_REQUIRED_SKILLS_B table';
305: end if;
306: end if;
307: EXCEPTION
308: when fnd_api.g_exc_error then

Line 461: from csf_required_skills_b

457: Cursor c_skills is
458: Select skill_type_id
459: , skill_id
460: , skill_level_id
461: from csf_required_skills_b
462: where has_skill_type = 'TASK TEMPLATE'
463: and has_skill_id = l_tpl_id;
464:
465: l_api_name constant varchar2(30) := 'create_row_from_tpl';

Line 541: l_skill_type_id csf_required_skills_b.skill_type_id%type;

537: l_parent_task_id number;
538: l_return_status varchar2(50);
539: l_msg_count number;
540: l_msg_data varchar2 (1000);
541: l_skill_type_id csf_required_skills_b.skill_type_id%type;
542: l_skill_id csf_required_skills_b.skill_id%type;
543: l_skill_level_id csf_required_skills_b.skill_level_id%type;
544: l_disabled_flag csf_required_skills_b.disabled_flag%type;
545:

Line 542: l_skill_id csf_required_skills_b.skill_id%type;

538: l_return_status varchar2(50);
539: l_msg_count number;
540: l_msg_data varchar2 (1000);
541: l_skill_type_id csf_required_skills_b.skill_type_id%type;
542: l_skill_id csf_required_skills_b.skill_id%type;
543: l_skill_level_id csf_required_skills_b.skill_level_id%type;
544: l_disabled_flag csf_required_skills_b.disabled_flag%type;
545:
546: BEGIN

Line 543: l_skill_level_id csf_required_skills_b.skill_level_id%type;

539: l_msg_count number;
540: l_msg_data varchar2 (1000);
541: l_skill_type_id csf_required_skills_b.skill_type_id%type;
542: l_skill_id csf_required_skills_b.skill_id%type;
543: l_skill_level_id csf_required_skills_b.skill_level_id%type;
544: l_disabled_flag csf_required_skills_b.disabled_flag%type;
545:
546: BEGIN
547:

Line 544: l_disabled_flag csf_required_skills_b.disabled_flag%type;

540: l_msg_data varchar2 (1000);
541: l_skill_type_id csf_required_skills_b.skill_type_id%type;
542: l_skill_id csf_required_skills_b.skill_id%type;
543: l_skill_level_id csf_required_skills_b.skill_level_id%type;
544: l_disabled_flag csf_required_skills_b.disabled_flag%type;
545:
546: BEGIN
547:
548: l_task_id := jtf_tasks_pub.p_task_user_hooks.task_id;