eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.HZ_GEOGRAPHY_TYPES_PKG dependencies on HZ_GEOGRAPHY_TYPES_TL

Line 76: insert into HZ_GEOGRAPHY_TYPES_TL (

72: rowid
73: INTO
74: x_rowid;
75:
76: insert into HZ_GEOGRAPHY_TYPES_TL (
77: GEOGRAPHY_TYPE,
78: GEOGRAPHY_TYPE_NAME,
79: CREATED_BY_MODULE,
80: LAST_UPDATED_BY,

Line 122: from HZ_GEOGRAPHY_TYPES_TL T

118: from FND_LANGUAGES L
119: where L.INSTALLED_FLAG in ('I', 'B')
120: and not exists
121: (select NULL
122: from HZ_GEOGRAPHY_TYPES_TL T
123: where T.GEOGRAPHY_TYPE = X_GEOGRAPHY_TYPE
124: and T.LANGUAGE = L.LANGUAGE_CODE);
125:
126: END Insert_Row;

Line 200: update HZ_GEOGRAPHY_TYPES_TL set

196: IF ( SQL%NOTFOUND ) THEN
197: RAISE NO_DATA_FOUND;
198: END IF;
199:
200: update HZ_GEOGRAPHY_TYPES_TL set
201: GEOGRAPHY_TYPE_NAME = decode(X_GEOGRAPHY_TYPE_NAME,
202: NULL, GEOGRAPHY_TYPE_NAME,
203: FND_API.G_MISS_NUM, NULL,
204: X_GEOGRAPHY_TYPE_NAME),

Line 254: from HZ_GEOGRAPHY_TYPES_TL

250:
251: cursor c1 is select
252: GEOGRAPHY_TYPE_NAME,
253: decode(LANGUAGE, userenv('LANG'), 'Y', 'N') BASELANG
254: from HZ_GEOGRAPHY_TYPES_TL
255: where GEOGRAPHY_TYPE = X_GEOGRAPHY_TYPE
256: and userenv('LANG') in (LANGUAGE, SOURCE_LANG)
257: for update of GEOGRAPHY_TYPE nowait;
258: BEGIN

Line 386: delete from HZ_GEOGRAPHY_TYPES_TL

382: x_geography_type IN VARCHAR2
383: ) IS
384: BEGIN
385:
386: delete from HZ_GEOGRAPHY_TYPES_TL
387: where GEOGRAPHY_TYPE = X_GEOGRAPHY_TYPE;
388:
389: if (sql%notfound) then
390: raise no_data_found;

Line 404: delete from HZ_GEOGRAPHY_TYPES_TL T

400:
401: procedure ADD_LANGUAGE
402: is
403: begin
404: delete from HZ_GEOGRAPHY_TYPES_TL T
405: where not exists
406: (select NULL
407: from HZ_GEOGRAPHY_TYPES_B B
408: where B.GEOGRAPHY_TYPE = T.GEOGRAPHY_TYPE

Line 411: update HZ_GEOGRAPHY_TYPES_TL T set (

407: from HZ_GEOGRAPHY_TYPES_B B
408: where B.GEOGRAPHY_TYPE = T.GEOGRAPHY_TYPE
409: );
410:
411: update HZ_GEOGRAPHY_TYPES_TL T set (
412: GEOGRAPHY_TYPE_NAME
413: ) = (select
414: B.GEOGRAPHY_TYPE_NAME
415: from HZ_GEOGRAPHY_TYPES_TL B

Line 415: from HZ_GEOGRAPHY_TYPES_TL B

411: update HZ_GEOGRAPHY_TYPES_TL T set (
412: GEOGRAPHY_TYPE_NAME
413: ) = (select
414: B.GEOGRAPHY_TYPE_NAME
415: from HZ_GEOGRAPHY_TYPES_TL B
416: where B.GEOGRAPHY_TYPE = T.GEOGRAPHY_TYPE
417: and B.LANGUAGE = T.SOURCE_LANG)
418: where (
419: T.GEOGRAPHY_TYPE,

Line 424: from HZ_GEOGRAPHY_TYPES_TL SUBB, HZ_GEOGRAPHY_TYPES_TL SUBT

420: T.LANGUAGE
421: ) in (select
422: SUBT.GEOGRAPHY_TYPE,
423: SUBT.LANGUAGE
424: from HZ_GEOGRAPHY_TYPES_TL SUBB, HZ_GEOGRAPHY_TYPES_TL SUBT
425: where SUBB.GEOGRAPHY_TYPE = SUBT.GEOGRAPHY_TYPE
426: and SUBB.LANGUAGE = SUBT.SOURCE_LANG
427: and (SUBB.GEOGRAPHY_TYPE_NAME <> SUBT.GEOGRAPHY_TYPE_NAME
428: or (SUBB.GEOGRAPHY_TYPE_NAME is null and SUBT.GEOGRAPHY_TYPE_NAME is not null)

Line 432: insert into HZ_GEOGRAPHY_TYPES_TL (

428: or (SUBB.GEOGRAPHY_TYPE_NAME is null and SUBT.GEOGRAPHY_TYPE_NAME is not null)
429: or (SUBB.GEOGRAPHY_TYPE_NAME is not null and SUBT.GEOGRAPHY_TYPE_NAME is null)
430: ));
431:
432: insert into HZ_GEOGRAPHY_TYPES_TL (
433: GEOGRAPHY_TYPE,
434: GEOGRAPHY_TYPE_NAME,
435: LAST_UPDATED_BY,
436: CREATION_DATE,

Line 454: from HZ_GEOGRAPHY_TYPES_TL B, FND_LANGUAGES L

450: B.LAST_UPDATE_LOGIN,
451: L.LANGUAGE_CODE,
452: B.SOURCE_LANG,
453: B.CREATED_BY_MODULE
454: from HZ_GEOGRAPHY_TYPES_TL B, FND_LANGUAGES L
455: where L.INSTALLED_FLAG in ('I', 'B')
456: and B.LANGUAGE = userenv('LANG')
457: and not exists
458: (select NULL

Line 459: from HZ_GEOGRAPHY_TYPES_TL T

455: where L.INSTALLED_FLAG in ('I', 'B')
456: and B.LANGUAGE = userenv('LANG')
457: and not exists
458: (select NULL
459: from HZ_GEOGRAPHY_TYPES_TL T
460: where T.GEOGRAPHY_TYPE = B.GEOGRAPHY_TYPE
461: and T.LANGUAGE = L.LANGUAGE_CODE);
462: end ADD_LANGUAGE;
463:

Line 470: UPDATE HZ_GEOGRAPHY_TYPES_TL

466: x_geography_type_name IN VARCHAR2,
467: x_owner IN VARCHAR2) IS
468:
469: BEGIN
470: UPDATE HZ_GEOGRAPHY_TYPES_TL
471: SET geography_type_name = x_geography_type_name,
472: source_lang = userenv('LANG'),
473: last_update_date = sysdate,
474: last_updated_by = DECODE(x_owner, 'SEED', 1, 0),

Line 548: UPDATE HZ_GEOGRAPHY_TYPES_TL SET

544: WHERE rowid = l_row_id;
545:
546: -- so far hz_geography_types_b table has data. Now update tl table
547:
548: UPDATE HZ_GEOGRAPHY_TYPES_TL SET
549: GEOGRAPHY_TYPE_NAME = decode(X_GEOGRAPHY_TYPE_NAME,
550: NULL, GEOGRAPHY_TYPE_NAME,
551: FND_API.G_MISS_NUM, NULL,
552: X_GEOGRAPHY_TYPE_NAME),

Line 565: -- data exist in hz_geography_types_b table but not in hz_geography_types_tl

561: WHERE GEOGRAPHY_TYPE = X_GEOGRAPHY_TYPE
562: AND USERENV('LANG') in (LANGUAGE, SOURCE_LANG);
563:
564: IF (SQL%NOTFOUND) THEN
565: -- data exist in hz_geography_types_b table but not in hz_geography_types_tl
566: RAISE no_data_found;
567: END IF;
568:
569: EXCEPTION WHEN NO_DATA_FOUND THEN -- insert data

Line 619: INSERT INTO HZ_GEOGRAPHY_TYPES_TL (

615: hz_utility_v2pub.request_id
616: ) ;
617: END IF;
618:
619: INSERT INTO HZ_GEOGRAPHY_TYPES_TL (
620: GEOGRAPHY_TYPE,
621: GEOGRAPHY_TYPE_NAME,
622: CREATED_BY_MODULE,
623: LAST_UPDATED_BY,

Line 660: FROM HZ_GEOGRAPHY_TYPES_TL T

656: USERENV('LANG')
657: FROM FND_LANGUAGES L
658: WHERE L.INSTALLED_FLAG in ('I', 'B')
659: AND NOT EXISTS (SELECT NULL
660: FROM HZ_GEOGRAPHY_TYPES_TL T
661: WHERE T.GEOGRAPHY_TYPE = X_GEOGRAPHY_TYPE
662: AND T.LANGUAGE = L.LANGUAGE_CODE);
663:
664: EXCEPTION WHEN DUP_VAL_ON_INDEX THEN