APPS.JTF_RS_TEAMS_PKG dependencies on JTF_RS_TEAMS_TL

Line 99: insert into JTF_RS_TEAMS_TL (

95: X_LAST_UPDATED_BY,
96: X_LAST_UPDATE_LOGIN
97: );
98:
99: insert into JTF_RS_TEAMS_TL (
100: TEAM_ID,
101: CREATED_BY,
102: CREATION_DATE,
103: LAST_UPDATED_BY,

Line 125: from JTF_RS_TEAMS_TL T

121: from FND_LANGUAGES L
122: where L.INSTALLED_FLAG in ('I', 'B')
123: and not exists
124: (select NULL
125: from JTF_RS_TEAMS_TL T
126: where T.TEAM_ID = X_TEAM_ID
127: and T.LANGUAGE = L.LANGUAGE_CODE);
128:
129: open c;

Line 234: update JTF_RS_TEAMS_TL set

230: if (sql%notfound) then
231: raise no_data_found;
232: end if;
233:
234: update JTF_RS_TEAMS_TL set
235: TEAM_NAME = X_TEAM_NAME,
236: TEAM_DESC = X_TEAM_DESC,
237: LAST_UPDATE_DATE = X_LAST_UPDATE_DATE,
238: LAST_UPDATED_BY = X_LAST_UPDATED_BY,

Line 253: delete from JTF_RS_TEAMS_TL

249: procedure DELETE_ROW (
250: X_TEAM_ID in NUMBER
251: ) is
252: begin
253: delete from JTF_RS_TEAMS_TL
254: where TEAM_ID = X_TEAM_ID;
255:
256: if (sql%notfound) then
257: raise no_data_found;

Line 271: delete from JTF_RS_TEAMS_TL T

267:
268: procedure ADD_LANGUAGE
269: is
270: begin
271: delete from JTF_RS_TEAMS_TL T
272: where not exists
273: (select NULL
274: from JTF_RS_TEAMS_B B
275: where B.TEAM_ID = T.TEAM_ID

Line 278: update JTF_RS_TEAMS_TL T set (

274: from JTF_RS_TEAMS_B B
275: where B.TEAM_ID = T.TEAM_ID
276: );
277:
278: update JTF_RS_TEAMS_TL T set (
279: TEAM_NAME,
280: TEAM_DESC
281: ) = (select
282: B.TEAM_NAME,

Line 284: from JTF_RS_TEAMS_TL B

280: TEAM_DESC
281: ) = (select
282: B.TEAM_NAME,
283: B.TEAM_DESC
284: from JTF_RS_TEAMS_TL B
285: where B.TEAM_ID = T.TEAM_ID
286: and B.LANGUAGE = T.SOURCE_LANG)
287: where (
288: T.TEAM_ID,

Line 293: from JTF_RS_TEAMS_TL SUBB, JTF_RS_TEAMS_TL SUBT

289: T.LANGUAGE
290: ) in (select
291: SUBT.TEAM_ID,
292: SUBT.LANGUAGE
293: from JTF_RS_TEAMS_TL SUBB, JTF_RS_TEAMS_TL SUBT
294: where SUBB.TEAM_ID = SUBT.TEAM_ID
295: and SUBB.LANGUAGE = SUBT.SOURCE_LANG
296: and (SUBB.TEAM_NAME <> SUBT.TEAM_NAME
297: or SUBB.TEAM_DESC <> SUBT.TEAM_DESC

Line 302: insert into JTF_RS_TEAMS_TL (

298: or (SUBB.TEAM_DESC is null and SUBT.TEAM_DESC is not null)
299: or (SUBB.TEAM_DESC is not null and SUBT.TEAM_DESC is null)
300: ));
301:
302: insert into JTF_RS_TEAMS_TL (
303: TEAM_ID,
304: CREATED_BY,
305: CREATION_DATE,
306: LAST_UPDATED_BY,

Line 324: from JTF_RS_TEAMS_TL B, FND_LANGUAGES L

320: B.TEAM_NAME,
321: B.TEAM_DESC,
322: L.LANGUAGE_CODE,
323: B.SOURCE_LANG
324: from JTF_RS_TEAMS_TL B, FND_LANGUAGES L
325: where L.INSTALLED_FLAG in ('I', 'B')
326: and B.LANGUAGE = userenv('LANG')
327: and not exists
328: (select NULL

Line 329: from JTF_RS_TEAMS_TL T

325: where L.INSTALLED_FLAG in ('I', 'B')
326: and B.LANGUAGE = userenv('LANG')
327: and not exists
328: (select NULL
329: from JTF_RS_TEAMS_TL T
330: where T.TEAM_ID = B.TEAM_ID
331: and T.LANGUAGE = L.LANGUAGE_CODE);
332: end ADD_LANGUAGE;
333:

Line 345: Update jtf_rs_teams_tl set

341: x_last_update_login in number)
342: is
343: begin
344:
345: Update jtf_rs_teams_tl set
346: team_name = nvl(x_team_name,team_name),
347: team_desc = nvl(x_team_desc,team_desc),
348: last_update_date = nvl(x_last_update_date,sysdate),
349: last_updated_by = x_last_updated_by,