APPS.CSF_SKILLS_PKG dependencies on CSF_SKILLS_B

Line 657: from csf_skills_b

653: IS
654: cursor c_rowid
655: is
656: select rowid
657: from csf_skills_b
658: where skill_id = x_skill_id;
659:
660: -- cursor to check for duplicate skills
661: cursor c_dup_skill_type is

Line 663: from csf_skills_b a, csf_skills_tl b

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');

Line 673: select csf_skills_b_s1.nextval

669: l_dummy_var number;
670: BEGIN
671: if x_skill_id is null
672: then
673: select csf_skills_b_s1.nextval
674: into x_skill_id
675: from dual;
676: else
677: -- Checks if record to be inserted already exists.

Line 706: insert into csf_skills_b

702: then
703: x_object_version_number := 1;
704: end if;
705:
706: insert into csf_skills_b
707: ( skill_id
708: , skill_type_id
709: , skill_alias
710: , start_date_active

Line 813: from csf_skills_b

809: IS
810: cursor c_ovn
811: is
812: select object_version_number
813: from csf_skills_b
814: where skill_id = x_skill_id
815: for update of skill_id nowait;
816:
817: l_rec c_ovn%rowtype;

Line 894: from csf_skills_b a, csf_skills_tl b

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

Line 916: update csf_skills_b

912: end if;
913:
914: close c_dup_skill_type;
915:
916: update csf_skills_b
917: set skill_type_id = x_skill_type_id
918: , skill_alias = x_skill_alias
919: , start_date_active = x_start_date_active
920: , end_date_active = x_end_date_active

Line 977: delete from csf_skills_b

973: then
974: raise no_data_found;
975: end if;
976:
977: delete from csf_skills_b
978: where skill_id = x_skill_id;
979:
980: if sql%notfound then
981: raise no_data_found;

Line 991: from csf_skills_b b

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 );
993:
994: update csf_skills_tl t
995: set ( name