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 1981: select csf_resource_skills_b_s1.nextval

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

Line 2014: insert into csf_resource_skills_b

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

Line 2094: from csf_resource_skills_b

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

Line 2150: from csf_resource_skills_b

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

Line 2173: update csf_resource_skills_b

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

Line 2214: delete from csf_resource_skills_b

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