APPS.CSF_REQUIRED_SKILLS_PKG dependencies on CSF_SKILL_LEVELS_B

Line 122: From csf_skill_levels_b

118: RETURN boolean
119: IS
120: Cursor c_skill_lvl is
121: Select 1
122: From csf_skill_levels_b
123: Where skill_level_id = p_skill_level_id
124: and (sysdate <= trunc(end_date_active)+1
125: or end_date_active is null);
126: l_dummy_var number;

Line 203: /* Checks if skill level exists in CSF_SKILL_LEVELS_B. */

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. */
204: If not skill_level_exists (p_skill_level_id) then
205: X_return_status := fnd_api.g_ret_sts_error;
206: X_msg_count := 1;
207: X_msg_data := 'Skill level id ('||p_skill_level_id||') '||

Line 208: 'does not exist in CSF_SKILL_LEVELS_B table.';

204: If not skill_level_exists (p_skill_level_id) then
205: X_return_status := fnd_api.g_ret_sts_error;
206: X_msg_count := 1;
207: X_msg_data := 'Skill level id ('||p_skill_level_id||') '||
208: 'does not exist in CSF_SKILL_LEVELS_B table.';
209: return;
210: end if;
211:
212: /* When all checks are ok, insert record

Line 370: l_skill_level_id csf_skill_levels_b.skill_level_id%type;

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
374: -- has to be created.