APPS.CSF_SKILLS_PKG dependencies on CSF_RESOURCE_SKILLS_B

Line 1964: from csf_resource_skills_b

1960: IS
1961: cursor c_rowid
1962: is
1963: select rowid
1964: from csf_resource_skills_b
1965: where resource_skill_id = x_resource_skill_id;
1966:
1967: -- cursor to check for duplicate skills assigned to a resource
1968: cursor c_resSkill is

Line 1970: from csf_resource_skills_b

1966:
1967: -- cursor to check for duplicate skills assigned to a resource
1968: cursor c_resSkill is
1969: select 1
1970: from csf_resource_skills_b
1971: where resource_id = x_resource_id
1972: and skill_id = x_skill_id
1973: and resource_type = x_resource_type
1974: and skill_type_id = x_skill_type_id;

Line 1980: select csf_resource_skills_b_s1.nextval

1976: l_dummy_var number;
1977: BEGIN
1978: if x_resource_skill_id is null
1979: then
1980: select csf_resource_skills_b_s1.nextval
1981: into x_resource_skill_id
1982: from dual;
1983: else
1984: -- Checks if record to be inserted already exists.

Line 2013: insert into csf_resource_skills_b

2009: then
2010: x_object_version_number := 1;
2011: end if;
2012:
2013: insert into csf_resource_skills_b
2014: ( resource_skill_id
2015: , skill_type_id
2016: , skill_id
2017: , resource_type

Line 2093: from csf_resource_skills_b

2089: IS
2090: cursor c_ovn
2091: is
2092: select object_version_number
2093: from csf_resource_skills_b
2094: where resource_skill_id = x_resource_skill_id
2095: for update of resource_skill_id nowait;
2096:
2097: l_rec c_ovn%rowtype;

Line 2149: from csf_resource_skills_b

2145: IS
2146: -- cursor to check for duplicate skills assigned to a resource
2147: cursor c_resSkill is
2148: select 1
2149: from csf_resource_skills_b
2150: where resource_id = x_resource_id
2151: and skill_id = x_skill_id
2152: and resource_type = x_resource_type
2153: and skill_type_id = x_skill_type_id

Line 2171: update csf_resource_skills_b

2167: end if;
2168:
2169: close c_resSkill;
2170:
2171: update csf_resource_skills_b
2172: set skill_type_id = x_skill_type_id
2173: , skill_id = x_skill_id
2174: , resource_type = x_resource_type
2175: , resource_id = x_resource_id

Line 2212: delete from csf_resource_skills_b

2208:
2209: PROCEDURE delete_resource_skill ( x_resource_skill_id in number )
2210: IS
2211: BEGIN
2212: delete from csf_resource_skills_b
2213: where resource_skill_id = x_resource_skill_id;
2214:
2215: if sql%notfound then
2216: raise no_data_found;