APPS.HZ_ORIG_SYSTEMS_PKG dependencies on HZ_ORIG_SYSTEMS_TL

Line 157: insert into HZ_ORIG_SYSTEMS_TL (

153: END;
154: END LOOP;
155:
156:
157: insert into HZ_ORIG_SYSTEMS_TL (
158: ORIG_SYSTEM_ID,
159: ORIG_SYSTEM_NAME,
160: DESCRIPTION,
161: CREATED_BY,

Line 183: from HZ_ORIG_SYSTEMS_TL T

179: from FND_LANGUAGES L
180: where L.INSTALLED_FLAG in ('I', 'B')
181: and not exists
182: (select NULL
183: from HZ_ORIG_SYSTEMS_TL T
184: where T.ORIG_SYSTEM_ID = X_ORIG_SYSTEM_ID
185: and T.LANGUAGE = L.LANGUAGE_CODE);
186:
187: end INSERT_ROW;

Line 204: from HZ_ORIG_SYSTEMS_TL

200: cursor c1 is select
201: ORIG_SYSTEM_NAME,
202: DESCRIPTION,
203: decode(LANGUAGE, userenv('LANG'), 'Y', 'N') BASELANG
204: from HZ_ORIG_SYSTEMS_TL
205: where ORIG_SYSTEM_ID = X_ORIG_SYSTEM_ID
206: and userenv('LANG') in (LANGUAGE, SOURCE_LANG)
207: for update of ORIG_SYSTEM_ID nowait;
208: begin

Line 309: update HZ_ORIG_SYSTEMS_TL set

305: if (sql%notfound) then
306: raise no_data_found;
307: end if;
308:
309: update HZ_ORIG_SYSTEMS_TL set
310: ORIG_SYSTEM_NAME = DECODE(X_ORIG_SYSTEM_NAME, FND_API.G_MISS_CHAR, NULL,NULL,ORIG_SYSTEM_NAME, X_ORIG_SYSTEM_NAME),
311: DESCRIPTION = DECODE(X_DESCRIPTION, FND_API.G_MISS_CHAR, NULL,NULL,DESCRIPTION, X_DESCRIPTION),
312: LAST_UPDATE_DATE = HZ_UTILITY_V2PUB.LAST_UPDATE_DATE,
313: LAST_UPDATED_BY = HZ_UTILITY_V2PUB.LAST_UPDATED_BY,

Line 328: delete from HZ_ORIG_SYSTEMS_TL

324: procedure DELETE_ROW (
325: X_ORIG_SYSTEM_ID in NUMBER
326: ) is
327: begin
328: delete from HZ_ORIG_SYSTEMS_TL
329: where ORIG_SYSTEM_ID = X_ORIG_SYSTEM_ID;
330:
331: if (sql%notfound) then
332: raise no_data_found;

Line 346: delete from HZ_ORIG_SYSTEMS_TL T

342:
343: procedure ADD_LANGUAGE
344: is
345: begin
346: delete from HZ_ORIG_SYSTEMS_TL T
347: where not exists
348: (select NULL
349: from HZ_ORIG_SYSTEMS_B B
350: where B.ORIG_SYSTEM_ID = T.ORIG_SYSTEM_ID

Line 353: update HZ_ORIG_SYSTEMS_TL T set (

349: from HZ_ORIG_SYSTEMS_B B
350: where B.ORIG_SYSTEM_ID = T.ORIG_SYSTEM_ID
351: );
352:
353: update HZ_ORIG_SYSTEMS_TL T set (
354: ORIG_SYSTEM_NAME,
355: DESCRIPTION
356: ) = (select
357: B.ORIG_SYSTEM_NAME,

Line 359: from HZ_ORIG_SYSTEMS_TL B

355: DESCRIPTION
356: ) = (select
357: B.ORIG_SYSTEM_NAME,
358: B.DESCRIPTION
359: from HZ_ORIG_SYSTEMS_TL B
360: where B.ORIG_SYSTEM_ID = T.ORIG_SYSTEM_ID
361: and B.LANGUAGE = T.SOURCE_LANG)
362: where (
363: T.ORIG_SYSTEM_ID,

Line 368: from HZ_ORIG_SYSTEMS_TL SUBB, HZ_ORIG_SYSTEMS_TL SUBT

364: T.LANGUAGE
365: ) in (select
366: SUBT.ORIG_SYSTEM_ID,
367: SUBT.LANGUAGE
368: from HZ_ORIG_SYSTEMS_TL SUBB, HZ_ORIG_SYSTEMS_TL SUBT
369: where SUBB.ORIG_SYSTEM_ID = SUBT.ORIG_SYSTEM_ID
370: and SUBB.LANGUAGE = SUBT.SOURCE_LANG
371: and (SUBB.ORIG_SYSTEM_NAME <> SUBT.ORIG_SYSTEM_NAME
372: or SUBB.DESCRIPTION <> SUBT.DESCRIPTION

Line 377: insert into HZ_ORIG_SYSTEMS_TL (

373: or (SUBB.DESCRIPTION is null and SUBT.DESCRIPTION is not null)
374: or (SUBB.DESCRIPTION is not null and SUBT.DESCRIPTION is null)
375: ));
376:
377: insert into HZ_ORIG_SYSTEMS_TL (
378: ORIG_SYSTEM_ID,
379: ORIG_SYSTEM_NAME,
380: DESCRIPTION,
381: CREATED_BY,

Line 399: from HZ_ORIG_SYSTEMS_TL B, FND_LANGUAGES L

395: B.LAST_UPDATE_DATE,
396: B.LAST_UPDATE_LOGIN,
397: L.LANGUAGE_CODE,
398: B.SOURCE_LANG
399: from HZ_ORIG_SYSTEMS_TL B, FND_LANGUAGES L
400: where L.INSTALLED_FLAG in ('I', 'B')
401: and B.LANGUAGE = userenv('LANG')
402: and not exists
403: (select NULL

Line 404: from HZ_ORIG_SYSTEMS_TL T

400: where L.INSTALLED_FLAG in ('I', 'B')
401: and B.LANGUAGE = userenv('LANG')
402: and not exists
403: (select NULL
404: from HZ_ORIG_SYSTEMS_TL T
405: where T.ORIG_SYSTEM_ID = B.ORIG_SYSTEM_ID
406: and T.LANGUAGE = L.LANGUAGE_CODE);
407: end ADD_LANGUAGE;
408: