APPS.IEC_G_CPN_PERSONALIZE_PKG dependencies on IEC_G_CPN_PERSONALIZE_TL

Line 43: insert into IEC_G_CPN_PERSONALIZE_TL (

39: X_LAST_UPDATED_BY,
40: X_LAST_UPDATE_LOGIN
41: );
42:
43: insert into IEC_G_CPN_PERSONALIZE_TL (
44: CPN_PERSONALIZE_ID,
45: SEARCH_NAME,
46: CREATED_BY,
47: CREATION_DATE,

Line 67: from IEC_G_CPN_PERSONALIZE_TL T

63: from FND_LANGUAGES L
64: where L.INSTALLED_FLAG in ('I', 'B')
65: and not exists
66: (select NULL
67: from IEC_G_CPN_PERSONALIZE_TL T
68: where T.CPN_PERSONALIZE_ID = X_CPN_PERSONALIZE_ID
69: and T.LANGUAGE = L.LANGUAGE_CODE);
70:
71: open c;

Line 145: delete from IEC_G_CPN_PERSONALIZE_TL

141: begin
142: delete from IEC_G_CPN_PERSONALIZE_B
143: where CPN_PERSONALIZE_ID = X_CPN_PERSONALIZE_ID;
144:
145: delete from IEC_G_CPN_PERSONALIZE_TL
146: where CPN_PERSONALIZE_ID = X_CPN_PERSONALIZE_ID;
147:
148: if (sql%notfound) then
149: raise no_data_found;

Line 159: UPDATE IEC_G_CPN_PERSONALIZE_TL SET

155: X_SEARCH_NAME in VARCHAR2,
156: P_OWNER IN VARCHAR2
157: ) is
158: BEGIN
159: UPDATE IEC_G_CPN_PERSONALIZE_TL SET
160: source_lang = userenv('LANG'),
161: SEARCH_NAME = X_SEARCH_NAME,
162: last_update_date = sysdate,
163: last_updated_by = fnd_load_util.owner_id(P_OWNER),

Line 235: delete from IEC_G_CPN_PERSONALIZE_TL T

231:
232: procedure ADD_LANGUAGE
233: is
234: begin
235: delete from IEC_G_CPN_PERSONALIZE_TL T
236: where not exists
237: (select NULL
238: from IEC_G_CPN_PERSONALIZE_B B
239: where B.CPN_PERSONALIZE_ID = T.CPN_PERSONALIZE_ID

Line 242: update IEC_G_CPN_PERSONALIZE_TL T set (

238: from IEC_G_CPN_PERSONALIZE_B B
239: where B.CPN_PERSONALIZE_ID = T.CPN_PERSONALIZE_ID
240: );
241:
242: update IEC_G_CPN_PERSONALIZE_TL T set (
243: SEARCH_NAME
244: ) = (select
245: B.SEARCH_NAME
246: from IEC_G_CPN_PERSONALIZE_TL B

Line 246: from IEC_G_CPN_PERSONALIZE_TL B

242: update IEC_G_CPN_PERSONALIZE_TL T set (
243: SEARCH_NAME
244: ) = (select
245: B.SEARCH_NAME
246: from IEC_G_CPN_PERSONALIZE_TL B
247: where B.CPN_PERSONALIZE_ID = T.CPN_PERSONALIZE_ID
248: and B.LANGUAGE = T.SOURCE_LANG)
249: where (
250: T.CPN_PERSONALIZE_ID,

Line 255: from IEC_G_CPN_PERSONALIZE_TL SUBB, IEC_G_CPN_PERSONALIZE_TL SUBT

251: T.LANGUAGE
252: ) in (select
253: SUBT.CPN_PERSONALIZE_ID,
254: SUBT.LANGUAGE
255: from IEC_G_CPN_PERSONALIZE_TL SUBB, IEC_G_CPN_PERSONALIZE_TL SUBT
256: where SUBB.CPN_PERSONALIZE_ID = SUBT.CPN_PERSONALIZE_ID
257: and SUBB.LANGUAGE = SUBT.SOURCE_LANG
258: and (SUBB.SEARCH_NAME <> SUBT.SEARCH_NAME
259: or (SUBB.SEARCH_NAME is null and SUBT.SEARCH_NAME is not null)

Line 263: insert into IEC_G_CPN_PERSONALIZE_TL (

259: or (SUBB.SEARCH_NAME is null and SUBT.SEARCH_NAME is not null)
260: or (SUBB.SEARCH_NAME is not null and SUBT.SEARCH_NAME is null)
261: ));
262:
263: insert into IEC_G_CPN_PERSONALIZE_TL (
264: CPN_PERSONALIZE_ID,
265: SEARCH_NAME,
266: CREATED_BY,
267: CREATION_DATE,

Line 283: from IEC_G_CPN_PERSONALIZE_TL B, FND_LANGUAGES L

279: B.LAST_UPDATE_DATE,
280: B.LAST_UPDATE_LOGIN,
281: L.LANGUAGE_CODE,
282: B.SOURCE_LANG
283: from IEC_G_CPN_PERSONALIZE_TL B, FND_LANGUAGES L
284: where L.INSTALLED_FLAG in ('I', 'B')
285: and B.LANGUAGE = userenv('LANG')
286: and not exists
287: (select NULL

Line 288: from IEC_G_CPN_PERSONALIZE_TL T

284: where L.INSTALLED_FLAG in ('I', 'B')
285: and B.LANGUAGE = userenv('LANG')
286: and not exists
287: (select NULL
288: from IEC_G_CPN_PERSONALIZE_TL T
289: where T.CPN_PERSONALIZE_ID = B.CPN_PERSONALIZE_ID
290: and T.LANGUAGE = L.LANGUAGE_CODE);
291: end ADD_LANGUAGE;
292: