APPS.HZ_TRANSFORMATIONS_PKG dependencies on HZ_TRANSFORMATIONS_TL

Line 82: INSERT INTO HZ_TRANSFORMATIONS_TL (

78: END IF;
79: END;
80: END LOOP;
81:
82: INSERT INTO HZ_TRANSFORMATIONS_TL (
83: transformation_id,
84: transformation_name,
85: description,
86: language,

Line 109: AND NOT EXISTS (select NULL from HZ_TRANSFORMATIONS_TL T

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
111: and T.LANGUAGE = L.LANGUAGE_CODE
112: );
113:

Line 147: update HZ_TRANSFORMATIONS_TL set

143: if (sql%notfound) then
144: raise no_data_found;
145: end if;
146:
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,

Line 178: delete from HZ_TRANSFORMATIONS_TL

174: if (sql%notfound) then
175: raise no_data_found;
176: end if;
177:
178: delete from HZ_TRANSFORMATIONS_TL
179: where transformation_id = x_transformation_id ;
180:
181: if (sql%notfound) then
182: raise no_data_found;

Line 192: from HZ_TRANSFORMATIONS_TL

188: x_object_version_number in NUMBER
189: )
190: IS
191: cursor c is select object_version_number
192: from HZ_TRANSFORMATIONS_TL
193: where transformation_id = x_transformation_id
194: and language = userenv('lang');
195: cursor c1 is select object_version_number
196: from HZ_TRANSFORMATIONS_B

Line 201: from HZ_TRANSFORMATIONS_TL

197: where transformation_id = x_transformation_id
198: for update of transformation_id nowait;
199:
200: cursor c2 is select object_version_number
201: from HZ_TRANSFORMATIONS_TL
202: where transformation_id = x_transformation_id
203: for update of transformation_id nowait;
204:
205: recinfo c%rowtype;

Line 243: delete from HZ_TRANSFORMATIONS_TL T

239:
240: procedure Add_Language
241: IS
242: BEGIN
243: delete from HZ_TRANSFORMATIONS_TL T
244: where not exists
245: (select NULL
246: from HZ_TRANSFORMATIONS_B B
247: where B.transformation_id = T.transformation_id

Line 250: update HZ_TRANSFORMATIONS_TL T set (

246: from HZ_TRANSFORMATIONS_B B
247: where B.transformation_id = T.transformation_id
248: );
249:
250: update HZ_TRANSFORMATIONS_TL T set (
251: transformation_name,
252: description,
253: object_version_number
254: ) = (select B.transformation_name,B.description,

Line 256: from HZ_TRANSFORMATIONS_TL B

252: description,
253: object_version_number
254: ) = (select B.transformation_name,B.description,
255: NVL(T.object_version_number, 1) + 1
256: from HZ_TRANSFORMATIONS_TL B
257: where B.transformation_id = T.transformation_id
258: and B.language = T.source_lang
259: )
260: where (T.transformation_id,T.language) in (select SUBT.transformation_id,SUBT.language

Line 261: from HZ_TRANSFORMATIONS_TL SUBB, HZ_TRANSFORMATIONS_TL SUBT

257: where B.transformation_id = T.transformation_id
258: and B.language = T.source_lang
259: )
260: where (T.transformation_id,T.language) in (select SUBT.transformation_id,SUBT.language
261: from HZ_TRANSFORMATIONS_TL SUBB, HZ_TRANSFORMATIONS_TL SUBT
262: where SUBB.transformation_id = SUBT.transformation_id
263: and SUBB.language = SUBT.source_lang
264: and (SUBB.transformation_name <> SUBT.transformation_name
265: or SUBB.description <> SUBT.description

Line 271: insert into HZ_TRANSFORMATIONS_TL (

267: or (SUBB.description is not null and SUBT.description is null)
268: )
269: );
270:
271: insert into HZ_TRANSFORMATIONS_TL (
272: LAST_UPDATE_DATE,
273: CREATION_DATE,
274: CREATED_BY,
275: DESCRIPTION,

Line 295: from HZ_TRANSFORMATIONS_TL B, FND_LANGUAGES L

291: B.LAST_UPDATE_LOGIN,
292: L.LANGUAGE_CODE,
293: B.SOURCE_LANG,
294: 1
295: from HZ_TRANSFORMATIONS_TL B, FND_LANGUAGES L
296: where L.INSTALLED_FLAG in ('I', 'B')
297: and B.LANGUAGE = userenv('LANG')
298: and L.LANGUAGE_CODE <> B.LANGUAGE
299: and not exists

Line 301: from HZ_TRANSFORMATIONS_TL T

297: and B.LANGUAGE = userenv('LANG')
298: and L.LANGUAGE_CODE <> B.LANGUAGE
299: and not exists
300: (select NULL
301: from HZ_TRANSFORMATIONS_TL T
302: where T.TRANSFORMATION_ID = B.TRANSFORMATION_ID
303: and T.language = L.language_code );
304: END ;
305:

Line 391: UPDATE HZ_TRANSFORMATIONS_TL set

387: x_owner in VARCHAR2)
388: IS
389: BEGIN
390:
391: UPDATE HZ_TRANSFORMATIONS_TL set
392: transformation_name = x_transformation_name,
393: description = x_description,
394: source_lang = userenv('LANG'),
395: last_update_date = sysdate,