DBA Data[Home] [Help]

APPS.CSF_REQUIRED_SKILLS_PKG dependencies on CSF_SKILLS_B

Line 198: 'does not exist in CSF_SKILLS_B table.';

194: X_return_status := fnd_api.g_ret_sts_error;
195: X_msg_count := 1;
196: X_msg_data := 'Combination of skill id ('||p_skill_id||') '||
197: 'and skill type id ('||p_skill_type_id||') '||
198: 'does not exist in CSF_SKILLS_B table.';
199: return;
200: end if;
201:
202: /* Checks if skill level exists in CSF_SKILL_LEVELS_B. */

Line 348: l_skill_id csf_skills_b.skill_id%type;

344: l_return_status varchar2(50);
345: l_msg_count number;
346: l_msg_data varchar2 (1000);
347:
348: l_skill_id csf_skills_b.skill_id%type;
349: l_skill_level_id csf_skill_levels_b.skill_level_id%type;
350:
351: BEGIN
352: -- Check if required skill based on product/inventroy item