[Home] [Help]
2250: IS
2251: cursor c_rowid
2252: is
2253: select rowid
2254: from csf_required_skills_b
2255: where required_skill_id = x_required_skill_id;
2256:
2257: -- cursor to check for duplicate skills to task
2258: cursor c_reqSkill is
2256:
2257: -- cursor to check for duplicate skills to task
2258: cursor c_reqSkill is
2259: select 1
2260: from csf_required_skills_b
2261: where skill_id = x_skill_id
2262: and skill_type_id = x_skill_type_id
2263: and has_skill_type = x_has_skill_type
2264: and has_skill_id = x_has_skill_id;
2266: l_dummy_var number;
2267: BEGIN
2268: if x_required_skill_id is null
2269: then
2270: select csf_required_skills_b_s1.nextval
2271: into x_required_skill_id
2272: from dual;
2273: else
2274: -- Checks if record to be inserted already exists.
2305: then
2306: x_object_version_number := 1;
2307: end if;
2308:
2309: insert into csf_required_skills_b
2310: ( required_skill_id
2311: , skill_type_id
2312: , skill_id
2313: , has_skill_type
2391: IS
2392: cursor c_ovn
2393: is
2394: select object_version_number
2395: from csf_required_skills_b
2396: where required_skill_id = x_required_skill_id
2397: for update of required_skill_id nowait;
2398:
2399: l_rec c_ovn%rowtype;
2449: , x_attribute_category in varchar2 default null )
2450: IS
2451: l_ovn number;
2452: BEGIN
2453: update csf_required_skills_b
2454: set skill_type_id = x_skill_type_id
2455: , skill_id = x_skill_id
2456: , has_skill_type = x_has_skill_type
2457: , has_skill_id = x_has_skill_id
2493:
2494: PROCEDURE delete_required_skill ( x_required_skill_id in number )
2495: IS
2496: BEGIN
2497: delete from csf_required_skills_b
2498: where required_skill_id = x_required_skill_id;
2499:
2500: if sql%notfound then
2501: raise no_data_found;