[Home] [Help]
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)
210:
211: /* When all checks are ok, insert record
212: into CSF_REQUIRED_SKILLS table. */
213:
214: select csf_required_skills_b_s1.nextval
215: into l_req_skill_id
216: from dual;
217:
218: insert into csf_required_skills_b
214: select csf_required_skills_b_s1.nextval
215: into l_req_skill_id
216: from dual;
217:
218: insert into csf_required_skills_b
219: ( required_skill_id
220: , skill_type_id
221: , skill_id
222: , has_skill_type
291:
292: x_return_status := fnd_api.g_ret_sts_success;
293:
294: --Bug Fixed 3884408
295: --When the required skill to be inserted into csf_required_skills_b table already exist for
296: --the given task, Procedure create_row() must return status 'E' to calling function.
297: else
298: if g_called_from_hook = 'T' then
299: X_return_status := fnd_api.g_ret_sts_success;
299: X_return_status := fnd_api.g_ret_sts_success;
300: else
301: X_return_status := fnd_api.g_ret_sts_error;
302: X_msg_count := 1;
303: 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';
304: end if;
305: end if;
306: EXCEPTION
307: when fnd_api.g_exc_error then
405: Cursor c_skills is
406: Select skill_type_id
407: , skill_id
408: , skill_level_id
409: from csf_required_skills_b
410: where has_skill_type = 'TASK TEMPLATE'
411: and has_skill_id = l_tpl_id;
412:
413: l_api_name constant varchar2(30) := 'create_row_from_tpl';