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 202: /* Checks if skill level exists in CSF_SKILL_LEVELS_B. */

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

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

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

Line 349: l_skill_level_id csf_skill_levels_b.skill_level_id%type;

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