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_TRANSFORMATIONS_PKG dependencies on HZ_UTILITY_V2PUB

Line 51: hz_utility_v2pub.created_by,

47: VALUES (
48: x_transformation_id,
49: DECODE(x_procedure_name,FND_API.G_MISS_CHAR, NULL,x_procedure_name),
50: l_object_version_number,
51: hz_utility_v2pub.created_by,
52: hz_utility_v2pub.creation_date,
53: hz_utility_v2pub.last_updated_by,
54: hz_utility_v2pub.last_update_login,
55: hz_utility_v2pub.last_update_date

Line 52: hz_utility_v2pub.creation_date,

48: x_transformation_id,
49: DECODE(x_procedure_name,FND_API.G_MISS_CHAR, NULL,x_procedure_name),
50: l_object_version_number,
51: hz_utility_v2pub.created_by,
52: hz_utility_v2pub.creation_date,
53: hz_utility_v2pub.last_updated_by,
54: hz_utility_v2pub.last_update_login,
55: hz_utility_v2pub.last_update_date
56: );

Line 53: hz_utility_v2pub.last_updated_by,

49: DECODE(x_procedure_name,FND_API.G_MISS_CHAR, NULL,x_procedure_name),
50: l_object_version_number,
51: hz_utility_v2pub.created_by,
52: hz_utility_v2pub.creation_date,
53: hz_utility_v2pub.last_updated_by,
54: hz_utility_v2pub.last_update_login,
55: hz_utility_v2pub.last_update_date
56: );
57: l_success := 'Y';

Line 54: hz_utility_v2pub.last_update_login,

50: l_object_version_number,
51: hz_utility_v2pub.created_by,
52: hz_utility_v2pub.creation_date,
53: hz_utility_v2pub.last_updated_by,
54: hz_utility_v2pub.last_update_login,
55: hz_utility_v2pub.last_update_date
56: );
57: l_success := 'Y';
58: EXCEPTION WHEN DUP_VAL_ON_INDEX THEN

Line 55: hz_utility_v2pub.last_update_date

51: hz_utility_v2pub.created_by,
52: hz_utility_v2pub.creation_date,
53: hz_utility_v2pub.last_updated_by,
54: hz_utility_v2pub.last_update_login,
55: hz_utility_v2pub.last_update_date
56: );
57: l_success := 'Y';
58: EXCEPTION WHEN DUP_VAL_ON_INDEX THEN
59: IF INSTRB( SQLERRM, 'HZ_TRANSFORMATIONS_B_U1' ) <> 0 THEN

Line 102: hz_utility_v2pub.created_by,

98: x_description,
99: l.language_code,
100: userenv('LANG'),
101: l_object_version_number,
102: hz_utility_v2pub.created_by,
103: hz_utility_v2pub.creation_date,
104: hz_utility_v2pub.last_updated_by,
105: hz_utility_v2pub.last_update_login,
106: hz_utility_v2pub.last_update_date

Line 103: hz_utility_v2pub.creation_date,

99: l.language_code,
100: userenv('LANG'),
101: l_object_version_number,
102: hz_utility_v2pub.created_by,
103: hz_utility_v2pub.creation_date,
104: hz_utility_v2pub.last_updated_by,
105: hz_utility_v2pub.last_update_login,
106: hz_utility_v2pub.last_update_date
107: FROM FND_LANGUAGES L

Line 104: hz_utility_v2pub.last_updated_by,

100: userenv('LANG'),
101: l_object_version_number,
102: hz_utility_v2pub.created_by,
103: hz_utility_v2pub.creation_date,
104: hz_utility_v2pub.last_updated_by,
105: hz_utility_v2pub.last_update_login,
106: hz_utility_v2pub.last_update_date
107: FROM FND_LANGUAGES L
108: WHERE L.INSTALLED_FLAG in ('I', 'B')

Line 105: hz_utility_v2pub.last_update_login,

101: l_object_version_number,
102: hz_utility_v2pub.created_by,
103: hz_utility_v2pub.creation_date,
104: hz_utility_v2pub.last_updated_by,
105: hz_utility_v2pub.last_update_login,
106: hz_utility_v2pub.last_update_date
107: FROM FND_LANGUAGES L
108: WHERE L.INSTALLED_FLAG in ('I', 'B')
109: AND NOT EXISTS (select NULL from HZ_TRANSFORMATIONS_TL T

Line 106: hz_utility_v2pub.last_update_date

102: hz_utility_v2pub.created_by,
103: hz_utility_v2pub.creation_date,
104: hz_utility_v2pub.last_updated_by,
105: hz_utility_v2pub.last_update_login,
106: hz_utility_v2pub.last_update_date
107: FROM FND_LANGUAGES L
108: WHERE L.INSTALLED_FLAG in ('I', 'B')
109: AND NOT EXISTS (select NULL from HZ_TRANSFORMATIONS_TL T
110: where T.TRANSFORMATION_ID = X_TRANSFORMATION_ID

Line 138: last_updated_by = hz_utility_v2pub.last_updated_by,

134: end if;
135: UPDATE HZ_TRANSFORMATIONS_B set
136: procedure_name = decode(x_procedure_name,null,procedure_name,fnd_api.g_miss_char,NULL,x_procedure_name),
137: object_version_number = p_object_version_number,
138: last_updated_by = hz_utility_v2pub.last_updated_by,
139: last_update_login = hz_utility_v2pub.last_update_login,
140: last_update_date = hz_utility_v2pub.last_update_date
141: where transformation_id = x_transformation_id;
142:

Line 139: last_update_login = hz_utility_v2pub.last_update_login,

135: UPDATE HZ_TRANSFORMATIONS_B set
136: procedure_name = decode(x_procedure_name,null,procedure_name,fnd_api.g_miss_char,NULL,x_procedure_name),
137: object_version_number = p_object_version_number,
138: last_updated_by = hz_utility_v2pub.last_updated_by,
139: last_update_login = hz_utility_v2pub.last_update_login,
140: last_update_date = hz_utility_v2pub.last_update_date
141: where transformation_id = x_transformation_id;
142:
143: if (sql%notfound) then

Line 140: last_update_date = hz_utility_v2pub.last_update_date

136: procedure_name = decode(x_procedure_name,null,procedure_name,fnd_api.g_miss_char,NULL,x_procedure_name),
137: object_version_number = p_object_version_number,
138: last_updated_by = hz_utility_v2pub.last_updated_by,
139: last_update_login = hz_utility_v2pub.last_update_login,
140: last_update_date = hz_utility_v2pub.last_update_date
141: where transformation_id = x_transformation_id;
142:
143: if (sql%notfound) then
144: raise no_data_found;

Line 151: last_updated_by = hz_utility_v2pub.last_updated_by,

147: update HZ_TRANSFORMATIONS_TL set
148: transformation_name = decode(x_transformation_name,null,transformation_name,fnd_api.g_miss_char,NULL,x_transformation_name),
149: description = decode(x_description,null,description,fnd_api.g_miss_char,NULL,x_description),
150: object_version_number = p_object_version_number,
151: last_updated_by = hz_utility_v2pub.last_updated_by,
152: last_update_login = hz_utility_v2pub.last_update_login,
153: last_update_date = hz_utility_v2pub.last_update_date,
154: source_lang = userenv('LANG')
155: where transformation_id = x_transformation_id

Line 152: last_update_login = hz_utility_v2pub.last_update_login,

148: transformation_name = decode(x_transformation_name,null,transformation_name,fnd_api.g_miss_char,NULL,x_transformation_name),
149: description = decode(x_description,null,description,fnd_api.g_miss_char,NULL,x_description),
150: object_version_number = p_object_version_number,
151: last_updated_by = hz_utility_v2pub.last_updated_by,
152: last_update_login = hz_utility_v2pub.last_update_login,
153: last_update_date = hz_utility_v2pub.last_update_date,
154: source_lang = userenv('LANG')
155: where transformation_id = x_transformation_id
156: and userenv('LANG') in (LANGUAGE, SOURCE_LANG);

Line 153: last_update_date = hz_utility_v2pub.last_update_date,

149: description = decode(x_description,null,description,fnd_api.g_miss_char,NULL,x_description),
150: object_version_number = p_object_version_number,
151: last_updated_by = hz_utility_v2pub.last_updated_by,
152: last_update_login = hz_utility_v2pub.last_update_login,
153: last_update_date = hz_utility_v2pub.last_update_date,
154: source_lang = userenv('LANG')
155: where transformation_id = x_transformation_id
156: and userenv('LANG') in (LANGUAGE, SOURCE_LANG);
157: x_object_version_number := p_object_version_number ;