APPS.JTF_PREFAB_CA_COMPS_PKG dependencies on JTF_PREFAB_CA_COMPS_TL

Line 79: insert into JTF_PREFAB_CA_COMPS_TL (

75: X_LAST_UPDATED_BY,
76: X_LAST_UPDATE_LOGIN
77: );
78:
79: insert into JTF_PREFAB_CA_COMPS_TL (
80: DESCRIPTION,
81: CREATED_BY,
82: CREATION_DATE,
83: LAST_UPDATED_BY,

Line 106: from JTF_PREFAB_CA_COMPS_TL T

102: from FND_LANGUAGES L
103: where L.INSTALLED_FLAG in ('I', 'B')
104: and not exists
105: (select NULL
106: from JTF_PREFAB_CA_COMPS_TL T
107: where T.CA_COMP_ID = l_ca_comp_id
108: and T.LANGUAGE = L.LANGUAGE_CODE);
109:
110: -- open c;

Line 161: from JTF_PREFAB_CA_COMPS_TL

157:
158: cursor c1 is select
159: DESCRIPTION,
160: decode(LANGUAGE, userenv('LANG'), 'Y', 'N') BASELANG
161: from JTF_PREFAB_CA_COMPS_TL
162: where CA_COMP_ID = X_CA_COMP_ID
163: and userenv('LANG') in (LANGUAGE, SOURCE_LANG)
164: for update of CA_COMP_ID nowait;
165: begin

Line 257: update JTF_PREFAB_CA_COMPS_TL set

253: if (sql%notfound) then
254: raise no_data_found;
255: end if;
256:
257: update JTF_PREFAB_CA_COMPS_TL set
258: DESCRIPTION = X_DESCRIPTION,
259: LAST_UPDATE_DATE = X_LAST_UPDATE_DATE,
260: LAST_UPDATED_BY = X_LAST_UPDATED_BY,
261: LAST_UPDATE_LOGIN = X_LAST_UPDATE_LOGIN,

Line 293: delete from JTF_PREFAB_CA_COMPS_TL

289: procedure DELETE_ROW (
290: X_CA_COMP_ID in NUMBER
291: ) is
292: begin
293: delete from JTF_PREFAB_CA_COMPS_TL
294: where CA_COMP_ID = X_CA_COMP_ID;
295:
296: if (sql%notfound) then
297: raise no_data_found;

Line 311: delete from JTF_PREFAB_CA_COMPS_TL T

307:
308: procedure ADD_LANGUAGE
309: is
310: begin
311: delete from JTF_PREFAB_CA_COMPS_TL T
312: where not exists
313: (select NULL
314: from JTF_PREFAB_CA_COMPS_B B
315: where B.CA_COMP_ID = T.CA_COMP_ID

Line 318: update JTF_PREFAB_CA_COMPS_TL T set (

314: from JTF_PREFAB_CA_COMPS_B B
315: where B.CA_COMP_ID = T.CA_COMP_ID
316: );
317:
318: update JTF_PREFAB_CA_COMPS_TL T set (
319: DESCRIPTION
320: ) = (select
321: B.DESCRIPTION
322: from JTF_PREFAB_CA_COMPS_TL B

Line 322: from JTF_PREFAB_CA_COMPS_TL B

318: update JTF_PREFAB_CA_COMPS_TL T set (
319: DESCRIPTION
320: ) = (select
321: B.DESCRIPTION
322: from JTF_PREFAB_CA_COMPS_TL B
323: where B.CA_COMP_ID = T.CA_COMP_ID
324: and B.LANGUAGE = T.SOURCE_LANG)
325: where (
326: T.CA_COMP_ID,

Line 331: from JTF_PREFAB_CA_COMPS_TL SUBB, JTF_PREFAB_CA_COMPS_TL SUBT

327: T.LANGUAGE
328: ) in (select
329: SUBT.CA_COMP_ID,
330: SUBT.LANGUAGE
331: from JTF_PREFAB_CA_COMPS_TL SUBB, JTF_PREFAB_CA_COMPS_TL SUBT
332: where SUBB.CA_COMP_ID = SUBT.CA_COMP_ID
333: and SUBB.LANGUAGE = SUBT.SOURCE_LANG
334: and (SUBB.DESCRIPTION <> SUBT.DESCRIPTION
335: ));

Line 337: insert into JTF_PREFAB_CA_COMPS_TL (

333: and SUBB.LANGUAGE = SUBT.SOURCE_LANG
334: and (SUBB.DESCRIPTION <> SUBT.DESCRIPTION
335: ));
336:
337: insert into JTF_PREFAB_CA_COMPS_TL (
338: DESCRIPTION,
339: CREATED_BY,
340: CREATION_DATE,
341: LAST_UPDATED_BY,

Line 359: from JTF_PREFAB_CA_COMPS_TL B, FND_LANGUAGES L

355: -- B.SECURITY_GROUP_ID,
356: B.CA_COMP_ID,
357: L.LANGUAGE_CODE,
358: B.SOURCE_LANG
359: from JTF_PREFAB_CA_COMPS_TL B, FND_LANGUAGES L
360: where L.INSTALLED_FLAG in ('I', 'B')
361: and B.LANGUAGE = userenv('LANG')
362: and not exists
363: (select NULL

Line 364: from JTF_PREFAB_CA_COMPS_TL T

360: where L.INSTALLED_FLAG in ('I', 'B')
361: and B.LANGUAGE = userenv('LANG')
362: and not exists
363: (select NULL
364: from JTF_PREFAB_CA_COMPS_TL T
365: where T.CA_COMP_ID = B.CA_COMP_ID
366: and T.LANGUAGE = L.LANGUAGE_CODE);
367: end ADD_LANGUAGE;
368:

Line 599: FROM JTF_PREFAB_CA_COMPS_B b, JTF_PREFAB_CA_COMPS_TL tl

595:
596: begin
597: SELECT tl.CA_COMP_ID, tl.LAST_UPDATED_BY, tl.LAST_UPDATE_DATE
598: INTO l_ca_comp_id, db_luby, db_ludate
599: FROM JTF_PREFAB_CA_COMPS_B b, JTF_PREFAB_CA_COMPS_TL tl
600: WHERE b.CA_COMP_ID = tl.CA_COMP_ID AND
601: b.APPLICATION_ID = X_APPLICATION_ID AND
602: b.COMPONENT_KEY = X_COMPONENT_KEY AND
603: tl.LANGUAGE = userenv('LANG');

Line 608: update JTF_PREFAB_CA_COMPS_TL set

604:
605: if (fnd_load_util.upload_test(f_luby, f_ludate, db_luby,
606: db_ludate, X_CUSTOM_MODE))
607: then
608: update JTF_PREFAB_CA_COMPS_TL set
609: DESCRIPTION = nvl(X_DESCRIPTION, DESCRIPTION),
610: LAST_UPDATE_DATE = f_ludate,
611: LAST_UPDATED_BY = f_luby,
612: LAST_UPDATE_LOGIN = 0,