[Home] [Help]
659:
660: -- cursor to check for duplicate skills
661: cursor c_dup_skill_type is
662: select 1
663: from csf_skills_b a, csf_skills_tl b
664: where a.skill_id = b.skill_id
665: and upper (rtrim (ltrim (name))) = upper (rtrim (ltrim (x_name)))
666: and skill_type_id = x_skill_type_id
667: and language = userenv ('lang');
761: , sysdate
762: , g_user_id
763: , g_login_id );
764:
765: insert into csf_skills_tl
766: ( skill_id
767: , name
768: , description
769: , creation_date
786: from fnd_languages l
787: where l.installed_flag in ('I', 'B')
788: and not exists
789: ( select null
790: from csf_skills_tl t
791: where t.skill_id = x_skill_id
792: and t.language = l.language_code );
793:
794: open c_rowid;
820: is
821: select name
822: , description
823: , decode(language, userenv('LANG'), 'Y', 'N') baselang
824: from csf_skills_tl
825: where skill_id = x_skill_id
826: and userenv('LANG') in (language, source_lang)
827: for update of skill_id nowait;
828:
890: IS
891: -- cursor to check for duplicate skills
892: cursor c_dup_skill_type is
893: select 1
894: from csf_skills_b a, csf_skills_tl b
895: where a.skill_id = b.skill_id
896: and upper (rtrim (ltrim (name))) = upper (rtrim (ltrim (x_name)))
897: and skill_type_id = x_skill_type_id
898: and a.skill_id <> x_skill_id
945: then
946: raise no_data_found;
947: end if;
948:
949: update csf_skills_tl
950: set name = x_name
951: , description = x_description
952: , last_update_date = sysdate
953: , last_updated_by = g_user_id
965:
966: PROCEDURE delete_skill ( x_skill_id in number )
967: IS
968: BEGIN
969: delete from csf_skills_tl
970: where skill_id = x_skill_id;
971:
972: if sql%notfound
973: then
984:
985: PROCEDURE add_skill_language
986: IS
987: BEGIN
988: delete from csf_skills_tl t
989: where not exists
990: ( select null
991: from csf_skills_b b
992: where b.skill_id = t.skill_id );
990: ( select null
991: from csf_skills_b b
992: where b.skill_id = t.skill_id );
993:
994: update csf_skills_tl t
995: set ( name
996: , description ) = ( select b.name
997: , b.description
998: from csf_skills_tl b
994: update csf_skills_tl t
995: set ( name
996: , description ) = ( select b.name
997: , b.description
998: from csf_skills_tl b
999: where b.skill_id = t.skill_id
1000: and b.language = t.source_lang )
1001: where ( t.skill_id, t.language ) in
1002: ( select subt.skill_id
1000: and b.language = t.source_lang )
1001: where ( t.skill_id, t.language ) in
1002: ( select subt.skill_id
1003: , subt.language
1004: from csf_skills_tl subb
1005: , csf_skills_tl subt
1006: where subb.skill_id = subt.skill_id
1007: and subb.language = subt.source_lang
1008: and ( subb.name <> subt.name
1001: where ( t.skill_id, t.language ) in
1002: ( select subt.skill_id
1003: , subt.language
1004: from csf_skills_tl subb
1005: , csf_skills_tl subt
1006: where subb.skill_id = subt.skill_id
1007: and subb.language = subt.source_lang
1008: and ( subb.name <> subt.name
1009: or subb.description <> subt.description
1009: or subb.description <> subt.description
1010: or (subb.description is null and subt.description is not null)
1011: or (subb.description is not null and subt.description is null)));
1012:
1013: insert into csf_skills_tl
1014: ( skill_id
1015: , name
1016: , description
1017: , created_by
1030: , b.last_update_date
1031: , b.last_update_login
1032: , l.language_code
1033: , b.source_lang
1034: from csf_skills_tl b
1035: , fnd_languages l
1036: where l.installed_flag in ('I', 'B')
1037: and b.language = userenv('LANG')
1038: and not exists
1036: where l.installed_flag in ('I', 'B')
1037: and b.language = userenv('LANG')
1038: and not exists
1039: ( select null
1040: from csf_skills_tl t
1041: where t.skill_id = b.skill_id
1042: and t.language = l.language_code );
1043: END add_skill_language;
1044:
2529: , p_name in varchar2
2530: , p_description in varchar2)
2531: IS
2532: BEGIN
2533: update csf_skills_tl
2534: set name = p_name,
2535: description = p_description,
2536: last_update_date = sysdate,
2537: last_updated_by = decode(p_owner, 'SEED', 1, 0),