APPS.JTF_RS_SKILL_LEVELS_PKG dependencies on JTF_RS_SKILL_LEVELS_TL

Line 88: insert into JTF_RS_SKILL_LEVELS_TL (

84: X_LAST_UPDATED_BY,
85: X_LAST_UPDATE_LOGIN
86: );
87:
88: insert into JTF_RS_SKILL_LEVELS_TL (
89: CREATION_DATE,
90: LAST_UPDATED_BY,
91: LAST_UPDATE_DATE,
92: LAST_UPDATE_LOGIN,

Line 114: from JTF_RS_SKILL_LEVELS_TL T

110: from FND_LANGUAGES L
111: where L.INSTALLED_FLAG in ('I', 'B')
112: and not exists
113: (select NULL
114: from JTF_RS_SKILL_LEVELS_TL T
115: where T.SKILL_LEVEL_ID = X_SKILL_LEVEL_ID
116: and T.LANGUAGE = L.LANGUAGE_CODE);
117:
118: open c;

Line 211: update JTF_RS_SKILL_LEVELS_TL set

207: if (sql%notfound) then
208: raise no_data_found;
209: end if;
210:
211: update JTF_RS_SKILL_LEVELS_TL set
212: LEVEL_NAME = X_LEVEL_NAME,
213: LEVEL_DESC = X_LEVEL_DESC,
214: LAST_UPDATE_DATE = X_LAST_UPDATE_DATE,
215: LAST_UPDATED_BY = X_LAST_UPDATED_BY,

Line 230: delete from JTF_RS_SKILL_LEVELS_TL

226: procedure DELETE_ROW (
227: X_SKILL_LEVEL_ID in NUMBER
228: ) is
229: begin
230: delete from JTF_RS_SKILL_LEVELS_TL
231: where SKILL_LEVEL_ID = X_SKILL_LEVEL_ID;
232:
233: if (sql%notfound) then
234: raise no_data_found;

Line 248: delete from JTF_RS_SKILL_LEVELS_TL T

244:
245: procedure ADD_LANGUAGE
246: is
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

Line 255: update JTF_RS_SKILL_LEVELS_TL T set (

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 (
256: LEVEL_NAME,
257: LEVEL_DESC
258: ) = (select
259: B.LEVEL_NAME,

Line 261: from JTF_RS_SKILL_LEVELS_TL B

257: LEVEL_DESC
258: ) = (select
259: B.LEVEL_NAME,
260: B.LEVEL_DESC
261: from JTF_RS_SKILL_LEVELS_TL B
262: where B.SKILL_LEVEL_ID = T.SKILL_LEVEL_ID
263: and B.LANGUAGE = T.SOURCE_LANG)
264: where (
265: T.SKILL_LEVEL_ID,

Line 270: from JTF_RS_SKILL_LEVELS_TL SUBB, JTF_RS_SKILL_LEVELS_TL SUBT

266: T.LANGUAGE
267: ) in (select
268: SUBT.SKILL_LEVEL_ID,
269: SUBT.LANGUAGE
270: from JTF_RS_SKILL_LEVELS_TL SUBB, JTF_RS_SKILL_LEVELS_TL SUBT
271: where SUBB.SKILL_LEVEL_ID = SUBT.SKILL_LEVEL_ID
272: and SUBB.LANGUAGE = SUBT.SOURCE_LANG
273: and (SUBB.LEVEL_NAME <> SUBT.LEVEL_NAME
274: or SUBB.LEVEL_DESC <> SUBT.LEVEL_DESC

Line 279: insert into JTF_RS_SKILL_LEVELS_TL (

275: or (SUBB.LEVEL_DESC is null and SUBT.LEVEL_DESC is not null)
276: or (SUBB.LEVEL_DESC is not null and SUBT.LEVEL_DESC is null)
277: ));
278:
279: insert into JTF_RS_SKILL_LEVELS_TL (
280: CREATION_DATE,
281: LAST_UPDATED_BY,
282: LAST_UPDATE_DATE,
283: LAST_UPDATE_LOGIN,

Line 301: from JTF_RS_SKILL_LEVELS_TL B, FND_LANGUAGES L

297: B.CREATED_BY,
298: B.SKILL_LEVEL_ID,
299: L.LANGUAGE_CODE,
300: B.SOURCE_LANG
301: from JTF_RS_SKILL_LEVELS_TL B, FND_LANGUAGES L
302: where L.INSTALLED_FLAG in ('I', 'B')
303: and B.LANGUAGE = userenv('LANG')
304: and not exists
305: (select NULL

Line 306: from JTF_RS_SKILL_LEVELS_TL T

302: where L.INSTALLED_FLAG in ('I', 'B')
303: and B.LANGUAGE = userenv('LANG')
304: and not exists
305: (select NULL
306: from JTF_RS_SKILL_LEVELS_TL T
307: where T.SKILL_LEVEL_ID = B.SKILL_LEVEL_ID
308: and T.LANGUAGE = L.LANGUAGE_CODE);
309: end ADD_LANGUAGE;
310:

Line 321: update jtf_rs_skill_levels_tl set

317: x_last_update_login in number)
318: is
319: begin
320:
321: update jtf_rs_skill_levels_tl set
322: level_name = nvl(x_level_name,level_name),
323: level_desc = nvl(x_level_desc,level_desc),
324: last_update_date = nvl(x_last_update_date,sysdate),
325: last_updated_by = x_last_updated_by,