[Home] [Help]
195: X_return_status := fnd_api.g_ret_sts_error;
196: X_msg_count := 1;
197: X_msg_data := 'Combination of skill id ('||p_skill_id||') '||
198: 'and skill type id ('||p_skill_type_id||') '||
199: 'does not exist in CSF_SKILLS_B table.';
200: return;
201: end if;
202:
203: /* Checks if skill level exists in CSF_SKILL_LEVELS_B. */
364: l_return_status varchar2(50);
365: l_msg_count number;
366: l_msg_data varchar2 (1000);
367:
368: l_skill_id csf_skills_b.skill_id%type;
369: l_skill_id1 csf_skills_b.skill_id%type;
370: l_skill_level_id csf_skill_levels_b.skill_level_id%type;
371:
372: BEGIN
365: l_msg_count number;
366: l_msg_data varchar2 (1000);
367:
368: l_skill_id csf_skills_b.skill_id%type;
369: l_skill_id1 csf_skills_b.skill_id%type;
370: l_skill_level_id csf_skill_levels_b.skill_level_id%type;
371:
372: BEGIN
373: -- Check if required skill based on product/inventroy item