APPS.HZ_TRANS_ATTRIBUTES_PKG dependencies on HZ_TRANS_ATTRIBUTES_TL

Line 83: insert into HZ_TRANS_ATTRIBUTES_TL (

79: END IF;
80: END;
81: END LOOP;
82:
83: insert into HZ_TRANS_ATTRIBUTES_TL (
84: LAST_UPDATE_DATE,
85: CREATION_DATE,
86: CREATED_BY,
87: LAST_UPDATED_BY,

Line 109: from HZ_TRANS_ATTRIBUTES_TL T

105: from FND_LANGUAGES L
106: where L.INSTALLED_FLAG in ('I', 'B')
107: and not exists
108: (select NULL
109: from HZ_TRANS_ATTRIBUTES_TL T
110: where T.ATTRIBUTE_ID = X_ATTRIBUTE_ID
111: and T.LANGUAGE = L.LANGUAGE_CODE);
112:
113: end INSERT_ROW;

Line 129: from HZ_TRANS_ATTRIBUTES_TL

125:
126: cursor c1 is select
127: OBJECT_VERSION_NUMBER,
128: decode(LANGUAGE, userenv('LANG'), 'Y', 'N') BASELANG
129: from HZ_TRANS_ATTRIBUTES_TL
130: where ATTRIBUTE_ID = X_ATTRIBUTE_ID
131: and userenv('LANG') in (LANGUAGE, SOURCE_LANG)
132: for update of ATTRIBUTE_ID nowait;
133: begin

Line 182: from HZ_TRANS_ATTRIBUTES_TL

178:
179: cursor c1 is select
180: USER_DEFINED_ATTRIBUTE_NAME,
181: decode(LANGUAGE, userenv('LANG'), 'Y', 'N') BASELANG
182: from HZ_TRANS_ATTRIBUTES_TL
183: where ATTRIBUTE_ID = X_ATTRIBUTE_ID
184: and userenv('LANG') in (LANGUAGE, SOURCE_LANG)
185: for update of ATTRIBUTE_ID nowait;
186: begin

Line 278: update HZ_TRANS_ATTRIBUTES_TL set

274: LAST_UPDATE_LOGIN = X_LAST_UPDATE_LOGIN,
275: OBJECT_VERSION_NUMBER = l_object_version_number
276: where ATTRIBUTE_ID = X_ATTRIBUTE_ID;
277:
278: update HZ_TRANS_ATTRIBUTES_TL set
279: USER_DEFINED_ATTRIBUTE_NAME = X_USER_DEFINED_ATTRIBUTE_NAME,
280: LAST_UPDATE_DATE = X_LAST_UPDATE_DATE,
281: LAST_UPDATED_BY = X_LAST_UPDATED_BY,
282: LAST_UPDATE_LOGIN = X_LAST_UPDATE_LOGIN,

Line 301: delete from HZ_TRANS_ATTRIBUTES_TL

297: procedure DELETE_ROW (
298: X_ATTRIBUTE_ID in NUMBER
299: ) is
300: begin
301: delete from HZ_TRANS_ATTRIBUTES_TL
302: where ATTRIBUTE_ID = X_ATTRIBUTE_ID;
303:
304: if (sql%notfound) then
305: raise no_data_found;

Line 319: delete from HZ_TRANS_ATTRIBUTES_TL T

315:
316: procedure ADD_LANGUAGE
317: is
318: begin
319: delete from HZ_TRANS_ATTRIBUTES_TL T
320: where not exists
321: (select NULL
322: from HZ_TRANS_ATTRIBUTES_B B
323: where B.ATTRIBUTE_ID = T.ATTRIBUTE_ID

Line 326: update HZ_TRANS_ATTRIBUTES_TL T set (

322: from HZ_TRANS_ATTRIBUTES_B B
323: where B.ATTRIBUTE_ID = T.ATTRIBUTE_ID
324: );
325:
326: update HZ_TRANS_ATTRIBUTES_TL T set (
327: USER_DEFINED_ATTRIBUTE_NAME
328: ) = (select
329: B.USER_DEFINED_ATTRIBUTE_NAME
330: from HZ_TRANS_ATTRIBUTES_TL B

Line 330: from HZ_TRANS_ATTRIBUTES_TL B

326: update HZ_TRANS_ATTRIBUTES_TL T set (
327: USER_DEFINED_ATTRIBUTE_NAME
328: ) = (select
329: B.USER_DEFINED_ATTRIBUTE_NAME
330: from HZ_TRANS_ATTRIBUTES_TL B
331: where B.ATTRIBUTE_ID = T.ATTRIBUTE_ID
332: and B.LANGUAGE = T.SOURCE_LANG)
333: where (
334: T.ATTRIBUTE_ID,

Line 339: from HZ_TRANS_ATTRIBUTES_TL SUBB, HZ_TRANS_ATTRIBUTES_TL SUBT

335: T.LANGUAGE
336: ) in (select
337: SUBT.ATTRIBUTE_ID,
338: SUBT.LANGUAGE
339: from HZ_TRANS_ATTRIBUTES_TL SUBB, HZ_TRANS_ATTRIBUTES_TL SUBT
340: where SUBB.ATTRIBUTE_ID = SUBT.ATTRIBUTE_ID
341: and SUBB.LANGUAGE = SUBT.SOURCE_LANG
342: and SUBB.USER_DEFINED_ATTRIBUTE_NAME <> SUBT.USER_DEFINED_ATTRIBUTE_NAME
343: );

Line 345: insert into HZ_TRANS_ATTRIBUTES_TL (

341: and SUBB.LANGUAGE = SUBT.SOURCE_LANG
342: and SUBB.USER_DEFINED_ATTRIBUTE_NAME <> SUBT.USER_DEFINED_ATTRIBUTE_NAME
343: );
344:
345: insert into HZ_TRANS_ATTRIBUTES_TL (
346: LAST_UPDATE_DATE,
347: CREATION_DATE,
348: CREATED_BY,
349: LAST_UPDATED_BY,

Line 365: from HZ_TRANS_ATTRIBUTES_TL B, FND_LANGUAGES L

361: B.USER_DEFINED_ATTRIBUTE_NAME,
362: B.ATTRIBUTE_ID,
363: L.LANGUAGE_CODE,
364: B.SOURCE_LANG
365: from HZ_TRANS_ATTRIBUTES_TL B, FND_LANGUAGES L
366: where L.INSTALLED_FLAG in ('I', 'B')
367: and B.LANGUAGE = userenv('LANG')
368: and not exists
369: (select NULL

Line 370: from HZ_TRANS_ATTRIBUTES_TL T

366: where L.INSTALLED_FLAG in ('I', 'B')
367: and B.LANGUAGE = userenv('LANG')
368: and not exists
369: (select NULL
370: from HZ_TRANS_ATTRIBUTES_TL T
371: where T.ATTRIBUTE_ID = B.ATTRIBUTE_ID
372: and T.LANGUAGE = L.LANGUAGE_CODE);
373: end ADD_LANGUAGE;
374:

Line 445: update HZ_TRANS_ATTRIBUTES_TL set

441: X_OWNER in VARCHAR2) IS
442:
443: begin
444: -- only update rows that have not been altered by user
445: update HZ_TRANS_ATTRIBUTES_TL set
446: USER_DEFINED_ATTRIBUTE_NAME= X_USER_DEFINED_ATTRIBUTE_NAME,
447: source_lang = userenv('LANG'),
448: last_update_date = sysdate,
449: last_updated_by = decode(X_OWNER, 'SEED', 1, 0),