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