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.IBC_ATTRIBUTE_TYPES_PKG dependencies on IBC_ATTRIBUTE_TYPES_TL

Line 81: INSERT INTO ibc_attribute_types_tl (

77: ,DECODE(p_display_order,FND_API.G_MISS_NUM,NULL,p_display_order)
78: ,DECODE(p_flex_value_set_id,FND_API.G_MISS_NUM,NULL,p_flex_value_set_id)
79: );
80:
81: INSERT INTO ibc_attribute_types_tl (
82: attribute_type_code
83: ,content_type_code
84: ,attribute_type_name
85: ,description

Line 109: FROM ibc_attribute_types_tl T

105: FROM fnd_languages l
106: WHERE l.installed_flag IN ('I', 'B')
107: AND NOT EXISTS
108: (SELECT NULL
109: FROM ibc_attribute_types_tl T
110: WHERE T.attribute_type_code = p_attribute_type_code
111: AND T.content_type_code = p_content_type_code
112: AND T.LANGUAGE = l.language_code);
113:

Line 157: FROM ibc_attribute_types_tl

153: CURSOR c1 IS SELECT
154: attribute_type_name,
155: description,
156: DECODE(LANGUAGE, USERENV('lang'), 'y', 'n') baselang
157: FROM ibc_attribute_types_tl
158: WHERE attribute_type_code = p_attribute_type_code
159: AND content_type_code = p_content_type_code
160: AND USERENV('lang') IN (LANGUAGE, source_lang)
161: FOR UPDATE OF attribute_type_code NOWAIT;

Line 256: UPDATE ibc_attribute_types_tl SET

252: IF (SQL%NOTFOUND) THEN
253: RAISE NO_DATA_FOUND;
254: END IF;
255:
256: UPDATE ibc_attribute_types_tl SET
257: attribute_type_name = DECODE(p_attribute_type_name,FND_API.G_MISS_CHAR,NULL,NULL,attribute_type_name,p_attribute_type_name)
258: ,description = DECODE(p_description,FND_API.G_MISS_CHAR,NULL,NULL,description,p_description)
259: ,last_update_date = DECODE(p_last_update_date,FND_API.G_MISS_DATE,SYSDATE,NULL,SYSDATE,p_last_update_date)
260: ,last_updated_by = DECODE(p_last_updated_by,FND_API.G_MISS_NUM,FND_GLOBAL.user_id,NULL,FND_GLOBAL.user_id,p_last_updated_by)

Line 277: DELETE FROM ibc_attribute_types_tl

273: p_attribute_type_code IN VARCHAR2,
274: p_content_type_code IN VARCHAR2
275: ) IS
276: BEGIN
277: DELETE FROM ibc_attribute_types_tl
278: WHERE attribute_type_code = p_attribute_type_code
279: AND content_type_code = p_content_type_code;
280:
281: IF (SQL%NOTFOUND) THEN

Line 302: DELETE FROM ibc_attribute_types_tl

298: PROCEDURE delete_rows (
299: p_content_type_code IN VARCHAR2
300: ) IS
301: BEGIN
302: DELETE FROM ibc_attribute_types_tl
303: WHERE attribute_type_code = attribute_type_code
304: AND content_type_code = p_content_type_code;
305:
306: IF (SQL%NOTFOUND) THEN

Line 322: DELETE FROM ibc_attribute_types_tl T

318:
319: PROCEDURE add_language
320: IS
321: BEGIN
322: DELETE FROM ibc_attribute_types_tl T
323: WHERE NOT EXISTS
324: (SELECT NULL
325: FROM ibc_attribute_types_b b
326: WHERE b.attribute_type_code = T.attribute_type_code

Line 330: UPDATE ibc_attribute_types_tl T SET (

326: WHERE b.attribute_type_code = T.attribute_type_code
327: AND b.content_type_code = T.content_type_code
328: );
329:
330: UPDATE ibc_attribute_types_tl T SET (
331: attribute_type_name,
332: description
333: ) = (SELECT
334: b.attribute_type_name,

Line 336: FROM ibc_attribute_types_tl b

332: description
333: ) = (SELECT
334: b.attribute_type_name,
335: b.description
336: FROM ibc_attribute_types_tl b
337: WHERE b.attribute_type_code = T.attribute_type_code
338: AND b.content_type_code = T.content_type_code
339: AND b.LANGUAGE = T.source_lang)
340: WHERE (

Line 348: FROM ibc_attribute_types_tl subb, ibc_attribute_types_tl subt

344: ) IN (SELECT
345: subt.attribute_type_code,
346: subt.content_type_code,
347: subt.LANGUAGE
348: FROM ibc_attribute_types_tl subb, ibc_attribute_types_tl subt
349: WHERE subb.attribute_type_code = subt.attribute_type_code
350: AND subb.content_type_code = subt.content_type_code
351: AND subb.LANGUAGE = subt.source_lang
352: AND (subb.attribute_type_name <> subt.attribute_type_name

Line 358: INSERT INTO ibc_attribute_types_tl (

354: OR (subb.description IS NULL AND subt.description IS NOT NULL)
355: OR (subb.description IS NOT NULL AND subt.description IS NULL)
356: ));
357:
358: INSERT INTO ibc_attribute_types_tl (
359: attribute_type_code,
360: content_type_code,
361: attribute_type_name,
362: description,

Line 382: FROM ibc_attribute_types_tl b, fnd_languages l

378: b.last_update_date,
379: b.last_update_login,
380: l.language_code,
381: b.source_lang
382: FROM ibc_attribute_types_tl b, fnd_languages l
383: WHERE l.installed_flag IN ('I', 'B')
384: AND b.LANGUAGE = USERENV('lang')
385: AND NOT EXISTS
386: (SELECT NULL

Line 387: FROM ibc_attribute_types_tl T

383: WHERE l.installed_flag IN ('I', 'B')
384: AND b.LANGUAGE = USERENV('lang')
385: AND NOT EXISTS
386: (SELECT NULL
387: FROM ibc_attribute_types_tl T
388: WHERE T.attribute_type_code = b.attribute_type_code
389: AND T.content_type_code = b.content_type_code
390: AND T.LANGUAGE = l.language_code);
391: END add_language;

Line 564: FROM IBC_ATTRIBUTE_TYPES_TL

560: l_last_update_date := nvl(TO_DATE(p_last_update_date, 'YYYY/MM/DD'),SYSDATE);
561:
562: -- get updatedby and update_date values if existing in db
563: SELECT LAST_UPDATED_BY, LAST_UPDATE_DATE INTO db_user_id, db_last_update_date
564: FROM IBC_ATTRIBUTE_TYPES_TL
565: WHERE CONTENT_TYPE_CODE = p_CONTENT_TYPE_CODE
566: AND ATTRIBUTE_TYPE_CODE = p_ATTRIBUTE_TYPE_CODE
567: AND USERENV('LANG') IN (LANGUAGE, source_lang);
568:

Line 572: UPDATE IBC_ATTRIBUTE_TYPES_TL

568:
569: IF (FND_LOAD_UTIL.UPLOAD_TEST(l_user_id, l_last_update_date,
570: db_user_id, db_last_update_date, p_upload_mode )) THEN
571: -- Only update rows which have not been altered by user
572: UPDATE IBC_ATTRIBUTE_TYPES_TL
573: SET description = p_DESCRIPTION,
574: ATTRIBUTE_TYPE_NAME = p_ATTRIBUTE_TYPE_NAME,
575: source_lang = USERENV('LANG'),
576: last_update_date = l_last_update_date,

Line 658: INSERT INTO IBC_ATTRIBUTE_TYPES_TL (

654: X_LAST_UPDATED_BY,
655: X_LAST_UPDATE_LOGIN
656: );
657:
658: INSERT INTO IBC_ATTRIBUTE_TYPES_TL (
659: LAST_UPDATE_DATE,
660: LAST_UPDATE_LOGIN,
661: SECURITY_GROUP_ID,
662: CREATED_BY,

Line 688: FROM IBC_ATTRIBUTE_TYPES_TL T

684: FROM FND_LANGUAGES L
685: WHERE L.INSTALLED_FLAG IN ('I', 'B')
686: AND NOT EXISTS
687: (SELECT NULL
688: FROM IBC_ATTRIBUTE_TYPES_TL T
689: WHERE T.CONTENT_TYPE_CODE = X_CONTENT_TYPE_CODE
690: AND T.ATTRIBUTE_TYPE_CODE = X_ATTRIBUTE_TYPE_CODE
691: AND T.LANGUAGE = L.LANGUAGE_CODE);
692:

Line 742: FROM IBC_ATTRIBUTE_TYPES_TL

738: CURSOR c1 IS SELECT
739: ATTRIBUTE_TYPE_NAME,
740: DESCRIPTION,
741: DECODE(LANGUAGE, USERENV('LANG'), 'Y', 'N') BASELANG
742: FROM IBC_ATTRIBUTE_TYPES_TL
743: WHERE CONTENT_TYPE_CODE = X_CONTENT_TYPE_CODE
744: AND ATTRIBUTE_TYPE_CODE = X_ATTRIBUTE_TYPE_CODE
745: AND USERENV('LANG') IN (LANGUAGE, SOURCE_LANG)
746: FOR UPDATE OF CONTENT_TYPE_CODE NOWAIT;

Line 840: UPDATE IBC_ATTRIBUTE_TYPES_TL SET

836: IF (SQL%NOTFOUND) THEN
837: RAISE NO_DATA_FOUND;
838: END IF;
839:
840: UPDATE IBC_ATTRIBUTE_TYPES_TL SET
841: ATTRIBUTE_TYPE_NAME = X_ATTRIBUTE_TYPE_NAME,
842: DESCRIPTION = X_DESCRIPTION,
843: LAST_UPDATE_DATE = X_LAST_UPDATE_DATE,
844: LAST_UPDATED_BY = X_LAST_UPDATED_BY,

Line 861: DELETE FROM IBC_ATTRIBUTE_TYPES_TL

857: X_CONTENT_TYPE_CODE IN VARCHAR2,
858: X_ATTRIBUTE_TYPE_CODE IN VARCHAR2
859: ) IS
860: BEGIN
861: DELETE FROM IBC_ATTRIBUTE_TYPES_TL
862: WHERE CONTENT_TYPE_CODE = X_CONTENT_TYPE_CODE
863: AND ATTRIBUTE_TYPE_CODE = X_ATTRIBUTE_TYPE_CODE;
864:
865: IF (SQL%NOTFOUND) THEN