APPS.JTF_RS_SKILL_LEVELS_PKG dependencies on JTF_RS_SKILL_LEVELS_B

Line 32: cursor C is select ROWID from JTF_RS_SKILL_LEVELS_B

28: X_LAST_UPDATE_DATE in DATE,
29: X_LAST_UPDATED_BY in NUMBER,
30: X_LAST_UPDATE_LOGIN in NUMBER
31: ) is
32: cursor C is select ROWID from JTF_RS_SKILL_LEVELS_B
33: where SKILL_LEVEL_ID = X_SKILL_LEVEL_ID
34: ;
35: begin
36: insert into JTF_RS_SKILL_LEVELS_B (

Line 36: insert into JTF_RS_SKILL_LEVELS_B (

32: cursor C is select ROWID from JTF_RS_SKILL_LEVELS_B
33: where SKILL_LEVEL_ID = X_SKILL_LEVEL_ID
34: ;
35: begin
36: insert into JTF_RS_SKILL_LEVELS_B (
37: ATTRIBUTE15,
38: ATTRIBUTE_CATEGORY,
39: OBJECT_VERSION_NUMBER,
40: ATTRIBUTE4,

Line 134: from JTF_RS_SKILL_LEVELS_B

130: X_OBJECT_VERSION_NUMBER in NUMBER)
131: is
132: cursor c is select
133: OBJECT_VERSION_NUMBER
134: from JTF_RS_SKILL_LEVELS_B
135: where SKILL_LEVEL_ID = X_SKILL_LEVEL_ID
136: for update of SKILL_LEVEL_ID nowait;
137: recinfo c%rowtype;
138: begin

Line 183: update JTF_RS_SKILL_LEVELS_B set

179: X_LAST_UPDATED_BY in NUMBER,
180: X_LAST_UPDATE_LOGIN in NUMBER
181: ) is
182: begin
183: update JTF_RS_SKILL_LEVELS_B set
184: ATTRIBUTE15 = X_ATTRIBUTE15,
185: ATTRIBUTE_CATEGORY = X_ATTRIBUTE_CATEGORY,
186: OBJECT_VERSION_NUMBER = X_OBJECT_VERSION_NUMBER,
187: ATTRIBUTE4 = X_ATTRIBUTE4,

Line 237: delete from JTF_RS_SKILL_LEVELS_B

233: if (sql%notfound) then
234: raise no_data_found;
235: end if;
236:
237: delete from JTF_RS_SKILL_LEVELS_B
238: where SKILL_LEVEL_ID = X_SKILL_LEVEL_ID;
239:
240: if (sql%notfound) then
241: raise no_data_found;

Line 251: from JTF_RS_SKILL_LEVELS_B B

247: begin
248: delete from JTF_RS_SKILL_LEVELS_TL T
249: where not exists
250: (select NULL
251: from JTF_RS_SKILL_LEVELS_B B
252: where B.SKILL_LEVEL_ID = T.SKILL_LEVEL_ID
253: );
254:
255: update JTF_RS_SKILL_LEVELS_TL T set (