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_UTILITY_V2PUB

Line 57: hz_utility_v2pub.last_updated_by,

53: x_limited_by_geography_id),
54: DECODE(x_created_by_module,
55: FND_API.G_MISS_CHAR, NULL,
56: x_created_by_module),
57: hz_utility_v2pub.last_updated_by,
58: hz_utility_v2pub.creation_date,
59: hz_utility_v2pub.created_by,
60: hz_utility_v2pub.last_update_date,
61: hz_utility_v2pub.last_update_login,

Line 58: hz_utility_v2pub.creation_date,

54: DECODE(x_created_by_module,
55: FND_API.G_MISS_CHAR, NULL,
56: x_created_by_module),
57: hz_utility_v2pub.last_updated_by,
58: hz_utility_v2pub.creation_date,
59: hz_utility_v2pub.created_by,
60: hz_utility_v2pub.last_update_date,
61: hz_utility_v2pub.last_update_login,
62: DECODE(x_application_id,

Line 59: hz_utility_v2pub.created_by,

55: FND_API.G_MISS_CHAR, NULL,
56: x_created_by_module),
57: hz_utility_v2pub.last_updated_by,
58: hz_utility_v2pub.creation_date,
59: hz_utility_v2pub.created_by,
60: hz_utility_v2pub.last_update_date,
61: hz_utility_v2pub.last_update_login,
62: DECODE(x_application_id,
63: FND_API.G_MISS_NUM, NULL,

Line 60: hz_utility_v2pub.last_update_date,

56: x_created_by_module),
57: hz_utility_v2pub.last_updated_by,
58: hz_utility_v2pub.creation_date,
59: hz_utility_v2pub.created_by,
60: hz_utility_v2pub.last_update_date,
61: hz_utility_v2pub.last_update_login,
62: DECODE(x_application_id,
63: FND_API.G_MISS_NUM, NULL,
64: x_application_id),

Line 61: hz_utility_v2pub.last_update_login,

57: hz_utility_v2pub.last_updated_by,
58: hz_utility_v2pub.creation_date,
59: hz_utility_v2pub.created_by,
60: hz_utility_v2pub.last_update_date,
61: hz_utility_v2pub.last_update_login,
62: DECODE(x_application_id,
63: FND_API.G_MISS_NUM, NULL,
64: x_application_id),
65: hz_utility_v2pub.program_id,

Line 65: hz_utility_v2pub.program_id,

61: hz_utility_v2pub.last_update_login,
62: DECODE(x_application_id,
63: FND_API.G_MISS_NUM, NULL,
64: x_application_id),
65: hz_utility_v2pub.program_id,
66: DECODE(x_program_login_id,
67: FND_API.G_MISS_NUM, NULL,
68: x_program_login_id),
69: hz_utility_v2pub.program_application_id,

Line 69: hz_utility_v2pub.program_application_id,

65: hz_utility_v2pub.program_id,
66: DECODE(x_program_login_id,
67: FND_API.G_MISS_NUM, NULL,
68: x_program_login_id),
69: hz_utility_v2pub.program_application_id,
70: hz_utility_v2pub.request_id
71: ) RETURNING
72: rowid
73: INTO

Line 70: hz_utility_v2pub.request_id

66: DECODE(x_program_login_id,
67: FND_API.G_MISS_NUM, NULL,
68: x_program_login_id),
69: hz_utility_v2pub.program_application_id,
70: hz_utility_v2pub.request_id
71: ) RETURNING
72: rowid
73: INTO
74: x_rowid;

Line 102: hz_utility_v2pub.last_updated_by,

98: x_geography_type_name),
99: DECODE(x_created_by_module,
100: FND_API.G_MISS_CHAR, NULL,
101: x_created_by_module),
102: hz_utility_v2pub.last_updated_by,
103: hz_utility_v2pub.creation_date,
104: hz_utility_v2pub.created_by,
105: hz_utility_v2pub.last_update_date,
106: hz_utility_v2pub.last_update_login,

Line 103: hz_utility_v2pub.creation_date,

99: DECODE(x_created_by_module,
100: FND_API.G_MISS_CHAR, NULL,
101: x_created_by_module),
102: hz_utility_v2pub.last_updated_by,
103: hz_utility_v2pub.creation_date,
104: hz_utility_v2pub.created_by,
105: hz_utility_v2pub.last_update_date,
106: hz_utility_v2pub.last_update_login,
107: DECODE(x_application_id,

Line 104: hz_utility_v2pub.created_by,

100: FND_API.G_MISS_CHAR, NULL,
101: x_created_by_module),
102: hz_utility_v2pub.last_updated_by,
103: hz_utility_v2pub.creation_date,
104: hz_utility_v2pub.created_by,
105: hz_utility_v2pub.last_update_date,
106: hz_utility_v2pub.last_update_login,
107: DECODE(x_application_id,
108: FND_API.G_MISS_NUM, NULL,

Line 105: hz_utility_v2pub.last_update_date,

101: x_created_by_module),
102: hz_utility_v2pub.last_updated_by,
103: hz_utility_v2pub.creation_date,
104: hz_utility_v2pub.created_by,
105: hz_utility_v2pub.last_update_date,
106: hz_utility_v2pub.last_update_login,
107: DECODE(x_application_id,
108: FND_API.G_MISS_NUM, NULL,
109: x_application_id),

Line 106: hz_utility_v2pub.last_update_login,

102: hz_utility_v2pub.last_updated_by,
103: hz_utility_v2pub.creation_date,
104: hz_utility_v2pub.created_by,
105: hz_utility_v2pub.last_update_date,
106: hz_utility_v2pub.last_update_login,
107: DECODE(x_application_id,
108: FND_API.G_MISS_NUM, NULL,
109: x_application_id),
110: hz_utility_v2pub.program_id,

Line 110: hz_utility_v2pub.program_id,

106: hz_utility_v2pub.last_update_login,
107: DECODE(x_application_id,
108: FND_API.G_MISS_NUM, NULL,
109: x_application_id),
110: hz_utility_v2pub.program_id,
111: DECODE(x_program_login_id,
112: FND_API.G_MISS_NUM, NULL,
113: x_program_login_id),
114: hz_utility_v2pub.program_application_id,

Line 114: hz_utility_v2pub.program_application_id,

110: hz_utility_v2pub.program_id,
111: DECODE(x_program_login_id,
112: FND_API.G_MISS_NUM, NULL,
113: x_program_login_id),
114: hz_utility_v2pub.program_application_id,
115: hz_utility_v2pub.request_id,
116: L.LANGUAGE_CODE,
117: userenv('LANG')
118: from FND_LANGUAGES L

Line 115: hz_utility_v2pub.request_id,

111: DECODE(x_program_login_id,
112: FND_API.G_MISS_NUM, NULL,
113: x_program_login_id),
114: hz_utility_v2pub.program_application_id,
115: hz_utility_v2pub.request_id,
116: L.LANGUAGE_CODE,
117: userenv('LANG')
118: from FND_LANGUAGES L
119: where L.INSTALLED_FLAG in ('I', 'B')

Line 176: last_updated_by = hz_utility_v2pub.last_updated_by,

172: DECODE(x_created_by_module,
173: NULL, created_by_module,
174: FND_API.G_MISS_CHAR, NULL,
175: x_created_by_module),
176: last_updated_by = hz_utility_v2pub.last_updated_by,
177: creation_date = creation_date,
178: created_by = created_by,
179: last_update_date = hz_utility_v2pub.last_update_date,
180: last_update_login = hz_utility_v2pub.last_update_login,

Line 179: last_update_date = hz_utility_v2pub.last_update_date,

175: x_created_by_module),
176: last_updated_by = hz_utility_v2pub.last_updated_by,
177: creation_date = creation_date,
178: created_by = created_by,
179: last_update_date = hz_utility_v2pub.last_update_date,
180: last_update_login = hz_utility_v2pub.last_update_login,
181: application_id =
182: DECODE(x_application_id,
183: NULL, application_id,

Line 180: last_update_login = hz_utility_v2pub.last_update_login,

176: last_updated_by = hz_utility_v2pub.last_updated_by,
177: creation_date = creation_date,
178: created_by = created_by,
179: last_update_date = hz_utility_v2pub.last_update_date,
180: last_update_login = hz_utility_v2pub.last_update_login,
181: application_id =
182: DECODE(x_application_id,
183: NULL, application_id,
184: FND_API.G_MISS_NUM, NULL,

Line 186: program_id = hz_utility_v2pub.program_id,

182: DECODE(x_application_id,
183: NULL, application_id,
184: FND_API.G_MISS_NUM, NULL,
185: x_application_id),
186: program_id = hz_utility_v2pub.program_id,
187: program_login_id =
188: DECODE(x_program_login_id,
189: NULL, program_login_id,
190: FND_API.G_MISS_NUM, NULL,

Line 192: program_application_id = hz_utility_v2pub.program_application_id,

188: DECODE(x_program_login_id,
189: NULL, program_login_id,
190: FND_API.G_MISS_NUM, NULL,
191: x_program_login_id),
192: program_application_id = hz_utility_v2pub.program_application_id,
193: request_id = hz_utility_v2pub.request_id
194: WHERE rowid = x_rowid;
195:
196: IF ( SQL%NOTFOUND ) THEN

Line 193: request_id = hz_utility_v2pub.request_id

189: NULL, program_login_id,
190: FND_API.G_MISS_NUM, NULL,
191: x_program_login_id),
192: program_application_id = hz_utility_v2pub.program_application_id,
193: request_id = hz_utility_v2pub.request_id
194: WHERE rowid = x_rowid;
195:
196: IF ( SQL%NOTFOUND ) THEN
197: RAISE NO_DATA_FOUND;

Line 207: hz_utility_v2pub.last_update_date),

203: FND_API.G_MISS_NUM, NULL,
204: X_GEOGRAPHY_TYPE_NAME),
205: LAST_UPDATE_DATE = decode(X_GEOGRAPHY_TYPE_NAME, NULL, LAST_UPDATE_DATE,
206: FND_API.G_MISS_NUM, NULL,
207: hz_utility_v2pub.last_update_date),
208: LAST_UPDATED_BY = decode(X_GEOGRAPHY_TYPE_NAME, NULL, LAST_UPDATED_BY,
209: FND_API.G_MISS_NUM, NULL,
210: hz_utility_v2pub.LAST_UPDATED_BY),
211: LAST_UPDATE_LOGIN = decode(X_GEOGRAPHY_TYPE_NAME, NULL, LAST_UPDATE_LOGIN,

Line 210: hz_utility_v2pub.LAST_UPDATED_BY),

206: FND_API.G_MISS_NUM, NULL,
207: hz_utility_v2pub.last_update_date),
208: LAST_UPDATED_BY = decode(X_GEOGRAPHY_TYPE_NAME, NULL, LAST_UPDATED_BY,
209: FND_API.G_MISS_NUM, NULL,
210: hz_utility_v2pub.LAST_UPDATED_BY),
211: LAST_UPDATE_LOGIN = decode(X_GEOGRAPHY_TYPE_NAME, NULL, LAST_UPDATE_LOGIN,
212: FND_API.G_MISS_NUM, NULL,
213: hz_utility_v2pub.LAST_UPDATE_LOGIN),
214: SOURCE_LANG = userenv('LANG')

Line 213: hz_utility_v2pub.LAST_UPDATE_LOGIN),

209: FND_API.G_MISS_NUM, NULL,
210: hz_utility_v2pub.LAST_UPDATED_BY),
211: LAST_UPDATE_LOGIN = decode(X_GEOGRAPHY_TYPE_NAME, NULL, LAST_UPDATE_LOGIN,
212: FND_API.G_MISS_NUM, NULL,
213: hz_utility_v2pub.LAST_UPDATE_LOGIN),
214: SOURCE_LANG = userenv('LANG')
215: where GEOGRAPHY_TYPE = X_GEOGRAPHY_TYPE
216: and userenv('LANG') in (LANGUAGE, SOURCE_LANG);
217:

Line 511: -- hz_utility_v2pub.last_updated_by which cannot be used for seed data loading

507: WHERE geography_type = x_geography_type;
508:
509: -- data exists in hz_geography_types_b table. Now Update it.
510: -- cannot use update_row package directly because it has last_updated_by as
511: -- hz_utility_v2pub.last_updated_by which cannot be used for seed data loading
512: UPDATE HZ_GEOGRAPHY_TYPES_B
513: SET
514: object_version_number =
515: DECODE(x_object_version_number,

Line 532: last_update_date = hz_utility_v2pub.last_update_date,

528: NULL, limited_by_geography_id,
529: FND_API.G_MISS_NUM, NULL,
530: x_limited_by_geography_id),
531: last_updated_by = l_user_id,
532: last_update_date = hz_utility_v2pub.last_update_date,
533: last_update_login = hz_utility_v2pub.last_update_login,
534: application_id =
535: DECODE(x_application_id,
536: NULL, application_id,

Line 533: last_update_login = hz_utility_v2pub.last_update_login,

529: FND_API.G_MISS_NUM, NULL,
530: x_limited_by_geography_id),
531: last_updated_by = l_user_id,
532: last_update_date = hz_utility_v2pub.last_update_date,
533: last_update_login = hz_utility_v2pub.last_update_login,
534: application_id =
535: DECODE(x_application_id,
536: NULL, application_id,
537: FND_API.G_MISS_NUM, NULL,

Line 554: hz_utility_v2pub.last_update_date),

550: NULL, GEOGRAPHY_TYPE_NAME,
551: FND_API.G_MISS_NUM, NULL,
552: X_GEOGRAPHY_TYPE_NAME),
553: LAST_UPDATE_DATE = decode(X_GEOGRAPHY_TYPE_NAME, NULL, LAST_UPDATE_DATE,
554: hz_utility_v2pub.last_update_date),
555: LAST_UPDATED_BY = decode(X_GEOGRAPHY_TYPE_NAME, NULL, LAST_UPDATED_BY,
556: l_user_id),
557: LAST_UPDATE_LOGIN = decode(X_GEOGRAPHY_TYPE_NAME, NULL, LAST_UPDATE_LOGIN,
558: FND_API.G_MISS_NUM, NULL,

Line 603: hz_utility_v2pub.creation_date,

599: FND_API.G_MISS_NUM, NULL,
600: x_limited_by_geography_id),
601: x_created_by_module,
602: l_user_id,
603: hz_utility_v2pub.creation_date,
604: l_user_id,
605: hz_utility_v2pub.last_update_date,
606: hz_utility_v2pub.last_update_login,
607: DECODE(x_application_id,

Line 605: hz_utility_v2pub.last_update_date,

601: x_created_by_module,
602: l_user_id,
603: hz_utility_v2pub.creation_date,
604: l_user_id,
605: hz_utility_v2pub.last_update_date,
606: hz_utility_v2pub.last_update_login,
607: DECODE(x_application_id,
608: FND_API.G_MISS_NUM, NULL,
609: x_application_id),

Line 606: hz_utility_v2pub.last_update_login,

602: l_user_id,
603: hz_utility_v2pub.creation_date,
604: l_user_id,
605: hz_utility_v2pub.last_update_date,
606: hz_utility_v2pub.last_update_login,
607: DECODE(x_application_id,
608: FND_API.G_MISS_NUM, NULL,
609: x_application_id),
610: hz_utility_v2pub.program_id,

Line 610: hz_utility_v2pub.program_id,

606: hz_utility_v2pub.last_update_login,
607: DECODE(x_application_id,
608: FND_API.G_MISS_NUM, NULL,
609: x_application_id),
610: hz_utility_v2pub.program_id,
611: DECODE(x_program_login_id,
612: FND_API.G_MISS_NUM, NULL,
613: x_program_login_id),
614: hz_utility_v2pub.program_application_id,

Line 614: hz_utility_v2pub.program_application_id,

610: hz_utility_v2pub.program_id,
611: DECODE(x_program_login_id,
612: FND_API.G_MISS_NUM, NULL,
613: x_program_login_id),
614: hz_utility_v2pub.program_application_id,
615: hz_utility_v2pub.request_id
616: ) ;
617: END IF;
618:

Line 615: hz_utility_v2pub.request_id

611: DECODE(x_program_login_id,
612: FND_API.G_MISS_NUM, NULL,
613: x_program_login_id),
614: hz_utility_v2pub.program_application_id,
615: hz_utility_v2pub.request_id
616: ) ;
617: END IF;
618:
619: INSERT INTO HZ_GEOGRAPHY_TYPES_TL (

Line 642: hz_utility_v2pub.creation_date,

638: FND_API.G_MISS_CHAR, NULL,
639: x_geography_type_name),
640: x_created_by_module,
641: l_user_id,
642: hz_utility_v2pub.creation_date,
643: l_user_id,
644: hz_utility_v2pub.last_update_date,
645: hz_utility_v2pub.last_update_login,
646: DECODE(x_application_id,

Line 644: hz_utility_v2pub.last_update_date,

640: x_created_by_module,
641: l_user_id,
642: hz_utility_v2pub.creation_date,
643: l_user_id,
644: hz_utility_v2pub.last_update_date,
645: hz_utility_v2pub.last_update_login,
646: DECODE(x_application_id,
647: FND_API.G_MISS_NUM, NULL,
648: x_application_id),

Line 645: hz_utility_v2pub.last_update_login,

641: l_user_id,
642: hz_utility_v2pub.creation_date,
643: l_user_id,
644: hz_utility_v2pub.last_update_date,
645: hz_utility_v2pub.last_update_login,
646: DECODE(x_application_id,
647: FND_API.G_MISS_NUM, NULL,
648: x_application_id),
649: hz_utility_v2pub.program_id,

Line 649: hz_utility_v2pub.program_id,

645: hz_utility_v2pub.last_update_login,
646: DECODE(x_application_id,
647: FND_API.G_MISS_NUM, NULL,
648: x_application_id),
649: hz_utility_v2pub.program_id,
650: DECODE(x_program_login_id,
651: FND_API.G_MISS_NUM, NULL,
652: x_program_login_id),
653: hz_utility_v2pub.program_application_id,

Line 653: hz_utility_v2pub.program_application_id,

649: hz_utility_v2pub.program_id,
650: DECODE(x_program_login_id,
651: FND_API.G_MISS_NUM, NULL,
652: x_program_login_id),
653: hz_utility_v2pub.program_application_id,
654: hz_utility_v2pub.request_id,
655: L.LANGUAGE_CODE,
656: USERENV('LANG')
657: FROM FND_LANGUAGES L

Line 654: hz_utility_v2pub.request_id,

650: DECODE(x_program_login_id,
651: FND_API.G_MISS_NUM, NULL,
652: x_program_login_id),
653: hz_utility_v2pub.program_application_id,
654: hz_utility_v2pub.request_id,
655: L.LANGUAGE_CODE,
656: USERENV('LANG')
657: FROM FND_LANGUAGES L
658: WHERE L.INSTALLED_FLAG in ('I', 'B')