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_CONTENT_TYPES_PKG dependencies on IBC_CONTENT_TYPES_TL

Line 67: INSERT INTO IBC_CONTENT_TYPES_TL (

63: ,DECODE(p_OWNER_FND_USER_ID,FND_API.G_MISS_NUM,NULL,p_OWNER_FND_USER_ID)
64: );
65:
66:
67: INSERT INTO IBC_CONTENT_TYPES_TL (
68: CONTENT_TYPE_CODE,
69: CONTENT_TYPE_NAME,
70: DESCRIPTION,
71: CREATION_DATE,

Line 93: FROM IBC_CONTENT_TYPES_TL T

89: FROM FND_LANGUAGES L
90: WHERE L.INSTALLED_FLAG IN ('I', 'B')
91: AND NOT EXISTS
92: (SELECT NULL
93: FROM IBC_CONTENT_TYPES_TL T
94: WHERE T.CONTENT_TYPE_CODE = p_CONTENT_TYPE_CODE
95: AND T.LANGUAGE = L.LANGUAGE_CODE);
96:
97: OPEN c;

Line 130: FROM IBC_CONTENT_TYPES_TL

126: CURSOR c1 IS SELECT
127: CONTENT_TYPE_NAME,
128: DESCRIPTION,
129: DECODE(LANGUAGE, USERENV('LANG'), 'Y', 'N') BASELANG
130: FROM IBC_CONTENT_TYPES_TL
131: WHERE CONTENT_TYPE_CODE = p_CONTENT_TYPE_CODE
132: AND USERENV('LANG') IN (LANGUAGE, SOURCE_LANG)
133: FOR UPDATE OF CONTENT_TYPE_CODE NOWAIT;
134: BEGIN

Line 211: UPDATE IBC_CONTENT_TYPES_TL SET

207: IF (SQL%NOTFOUND) THEN
208: RAISE NO_DATA_FOUND;
209: END IF;
210:
211: UPDATE IBC_CONTENT_TYPES_TL SET
212: content_type_name = p_content_type_name
213: ,description = p_description
214: ,last_update_date = DECODE(p_last_update_date,FND_API.G_MISS_DATE,SYSDATE,NULL,SYSDATE,p_last_update_date)
215: ,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 230: DELETE FROM IBC_CONTENT_TYPES_TL

226: PROCEDURE DELETE_ROW (
227: p_CONTENT_TYPE_CODE IN VARCHAR2
228: ) IS
229: BEGIN
230: DELETE FROM IBC_CONTENT_TYPES_TL
231: WHERE CONTENT_TYPE_CODE = p_CONTENT_TYPE_CODE;
232:
233: IF (SQL%NOTFOUND) THEN
234: RAISE NO_DATA_FOUND;

Line 248: DELETE FROM IBC_CONTENT_TYPES_TL T

244:
245: PROCEDURE ADD_LANGUAGE
246: IS
247: BEGIN
248: DELETE FROM IBC_CONTENT_TYPES_TL T
249: WHERE NOT EXISTS
250: (SELECT NULL
251: FROM IBC_CONTENT_TYPES_B B
252: WHERE B.CONTENT_TYPE_CODE = T.CONTENT_TYPE_CODE

Line 255: UPDATE IBC_CONTENT_TYPES_TL T SET (

251: FROM IBC_CONTENT_TYPES_B B
252: WHERE B.CONTENT_TYPE_CODE = T.CONTENT_TYPE_CODE
253: );
254:
255: UPDATE IBC_CONTENT_TYPES_TL T SET (
256: CONTENT_TYPE_NAME,
257: DESCRIPTION
258: ) = (SELECT
259: B.CONTENT_TYPE_NAME,

Line 261: FROM IBC_CONTENT_TYPES_TL B

257: DESCRIPTION
258: ) = (SELECT
259: B.CONTENT_TYPE_NAME,
260: B.DESCRIPTION
261: FROM IBC_CONTENT_TYPES_TL B
262: WHERE B.CONTENT_TYPE_CODE = T.CONTENT_TYPE_CODE
263: AND B.LANGUAGE = T.SOURCE_LANG)
264: WHERE (
265: T.CONTENT_TYPE_CODE,

Line 270: FROM IBC_CONTENT_TYPES_TL SUBB, IBC_CONTENT_TYPES_TL SUBT

266: T.LANGUAGE
267: ) IN (SELECT
268: SUBT.CONTENT_TYPE_CODE,
269: SUBT.LANGUAGE
270: FROM IBC_CONTENT_TYPES_TL SUBB, IBC_CONTENT_TYPES_TL SUBT
271: WHERE SUBB.CONTENT_TYPE_CODE = SUBT.CONTENT_TYPE_CODE
272: AND SUBB.LANGUAGE = SUBT.SOURCE_LANG
273: AND (SUBB.CONTENT_TYPE_NAME <> SUBT.CONTENT_TYPE_NAME
274: OR SUBB.DESCRIPTION <> SUBT.DESCRIPTION

Line 279: INSERT INTO IBC_CONTENT_TYPES_TL (

275: OR (SUBB.DESCRIPTION IS NULL AND SUBT.DESCRIPTION IS NOT NULL)
276: OR (SUBB.DESCRIPTION IS NOT NULL AND SUBT.DESCRIPTION IS NULL)
277: ));
278:
279: INSERT INTO IBC_CONTENT_TYPES_TL (
280: CONTENT_TYPE_CODE,
281: CONTENT_TYPE_NAME,
282: DESCRIPTION,
283: CREATED_BY,

Line 301: FROM IBC_CONTENT_TYPES_TL B, FND_LANGUAGES L

297: B.LAST_UPDATE_DATE,
298: B.LAST_UPDATE_LOGIN,
299: L.LANGUAGE_CODE,
300: B.SOURCE_LANG
301: FROM IBC_CONTENT_TYPES_TL B, FND_LANGUAGES L
302: WHERE L.INSTALLED_FLAG IN ('I', 'B')
303: AND B.LANGUAGE = USERENV('LANG')
304: AND NOT EXISTS
305: (SELECT NULL

Line 306: FROM IBC_CONTENT_TYPES_TL T

302: WHERE L.INSTALLED_FLAG IN ('I', 'B')
303: AND B.LANGUAGE = USERENV('LANG')
304: AND NOT EXISTS
305: (SELECT NULL
306: FROM IBC_CONTENT_TYPES_TL T
307: WHERE T.CONTENT_TYPE_CODE = B.CONTENT_TYPE_CODE
308: AND T.LANGUAGE = L.LANGUAGE_CODE);
309: END ADD_LANGUAGE;
310:

Line 446: FROM IBC_CONTENT_TYPES_TL

442: l_last_update_date := nvl(TO_DATE(p_last_update_date, 'YYYY/MM/DD'),SYSDATE);
443:
444: -- get updatedby and update_date values if existing in db
445: SELECT LAST_UPDATED_BY, LAST_UPDATE_DATE INTO db_user_id, db_last_update_date
446: FROM IBC_CONTENT_TYPES_TL
447: WHERE CONTENT_TYPE_CODE = p_CONTENT_TYPE_CODE
448: AND USERENV('LANG') IN (LANGUAGE, source_lang);
449:
450: IF (FND_LOAD_UTIL.UPLOAD_TEST(l_user_id, l_last_update_date,

Line 453: UPDATE IBC_CONTENT_TYPES_TL

449:
450: IF (FND_LOAD_UTIL.UPLOAD_TEST(l_user_id, l_last_update_date,
451: db_user_id, db_last_update_date, p_upload_mode )) THEN
452: -- Only update rows which have not been altered by user
453: UPDATE IBC_CONTENT_TYPES_TL
454: SET description = p_DESCRIPTION,
455: CONTENT_TYPE_NAME = p_CONTENT_TYPE_NAME,
456: source_lang = USERENV('LANG'),
457: last_update_date = l_last_update_date,

Line 526: INSERT INTO IBC_CONTENT_TYPES_TL (

522: X_LAST_UPDATE_LOGIN,
523: decode(X_ENCRYPT_FLAG,'Y','T','N',NULL)
524: );
525:
526: INSERT INTO IBC_CONTENT_TYPES_TL (
527: CONTENT_TYPE_CODE,
528: CONTENT_TYPE_NAME,
529: DESCRIPTION,
530: CREATED_BY,

Line 554: FROM IBC_CONTENT_TYPES_TL T

550: FROM FND_LANGUAGES L
551: WHERE L.INSTALLED_FLAG IN ('I', 'B')
552: AND NOT EXISTS
553: (SELECT NULL
554: FROM IBC_CONTENT_TYPES_TL T
555: WHERE T.CONTENT_TYPE_CODE = X_CONTENT_TYPE_CODE
556: AND T.LANGUAGE = L.LANGUAGE_CODE);
557:
558: OPEN c;

Line 598: from IBC_CONTENT_TYPES_TL

594: cursor c1 is select
595: CONTENT_TYPE_NAME,
596: DESCRIPTION,
597: decode(LANGUAGE, userenv('LANG'), 'Y', 'N') BASELANG
598: from IBC_CONTENT_TYPES_TL
599: where CONTENT_TYPE_CODE = X_CONTENT_TYPE_CODE
600: and userenv('LANG') in (LANGUAGE, SOURCE_LANG)
601: for update of CONTENT_TYPE_CODE nowait;
602: begin

Line 683: UPDATE IBC_CONTENT_TYPES_TL SET

679: IF (SQL%NOTFOUND) THEN
680: RAISE NO_DATA_FOUND;
681: END IF;
682:
683: UPDATE IBC_CONTENT_TYPES_TL SET
684: CONTENT_TYPE_NAME = X_CONTENT_TYPE_NAME,
685: DESCRIPTION = X_DESCRIPTION,
686: LAST_UPDATE_DATE = X_LAST_UPDATE_DATE,
687: LAST_UPDATED_BY = X_LAST_UPDATED_BY,

Line 702: DELETE FROM IBC_CONTENT_TYPES_TL

698: PROCEDURE DELETE_ROW (
699: X_CONTENT_TYPE_CODE IN VARCHAR2
700: ) IS
701: BEGIN
702: DELETE FROM IBC_CONTENT_TYPES_TL
703: WHERE CONTENT_TYPE_CODE = X_CONTENT_TYPE_CODE;
704:
705: IF (SQL%NOTFOUND) THEN
706: RAISE NO_DATA_FOUND;

Line 827: UPDATE ibc_content_types_tl

823: UPDATE ibc_content_types_b
824: SET content_type_code=p_new_content_type_code
825: WHERE content_type_code = p_old_content_type_code;
826:
827: UPDATE ibc_content_types_tl
828: SET content_type_code=p_new_content_type_code
829: WHERE content_type_code = p_old_content_type_code;
830:
831: UPDATE ibc_attribute_types_b