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_ASSOCIATION_TYPES_PKG dependencies on IBC_ASSOCIATION_TYPES_TL

Line 56: INSERT INTO ibc_association_types_tl (

52: ,DECODE(p_last_updated_by,FND_API.G_MISS_NUM,FND_GLOBAL.user_id,NULL,FND_GLOBAL.user_id,p_last_updated_by)
53: ,DECODE(p_last_update_login,FND_API.G_MISS_NUM,FND_GLOBAL.login_id,NULL,FND_GLOBAL.user_id,p_last_update_login)
54: );
55:
56: INSERT INTO ibc_association_types_tl (
57: association_type_code
58: ,association_type_name
59: ,description
60: ,creation_date

Line 82: FROM ibc_association_types_tl t

78: FROM fnd_languages l
79: WHERE l.installed_flag IN ('I', 'B')
80: AND NOT EXISTS
81: (SELECT NULL
82: FROM ibc_association_types_tl t
83: WHERE t.association_type_code = p_association_type_code
84: AND t.LANGUAGE = l.language_code);
85:
86: OPEN c;

Line 115: FROM ibc_association_types_tl

111: CURSOR c1 IS SELECT
112: association_type_name,
113: description,
114: DECODE(LANGUAGE, USERENV('LANG'), 'Y', 'N') baselang
115: FROM ibc_association_types_tl
116: WHERE association_type_code = p_association_type_code
117: AND USERENV('lang') IN (LANGUAGE, source_lang)
118: FOR UPDATE OF association_type_code NOWAIT;
119: BEGIN

Line 186: UPDATE ibc_association_types_tl SET

182: IF (SQL%NOTFOUND) THEN
183: RAISE NO_DATA_FOUND;
184: END IF;
185:
186: UPDATE ibc_association_types_tl SET
187: association_type_name = DECODE(p_association_type_name,FND_API.G_MISS_CHAR,NULL,NULL,association_type_name,p_association_type_name)
188: ,description = DECODE(p_description,FND_API.G_MISS_CHAR,NULL,NULL,description,p_description)
189: ,last_update_date = DECODE(p_last_update_date,FND_API.G_MISS_DATE,SYSDATE,NULL,SYSDATE,p_last_update_date)
190: ,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 205: DELETE FROM ibc_association_types_tl

201: PROCEDURE delete_row (
202: p_association_type_code IN VARCHAR2
203: ) IS
204: BEGIN
205: DELETE FROM ibc_association_types_tl
206: WHERE association_type_code = p_association_type_code;
207:
208: IF (SQL%NOTFOUND) THEN
209: RAISE NO_DATA_FOUND;

Line 223: DELETE FROM ibc_association_types_tl t

219:
220: PROCEDURE add_language
221: IS
222: BEGIN
223: DELETE FROM ibc_association_types_tl t
224: WHERE NOT EXISTS
225: (SELECT NULL
226: FROM ibc_association_types_b b
227: WHERE b.association_type_code = t.association_type_code

Line 230: UPDATE ibc_association_types_tl t SET (

226: FROM ibc_association_types_b b
227: WHERE b.association_type_code = t.association_type_code
228: );
229:
230: UPDATE ibc_association_types_tl t SET (
231: association_type_name,
232: description
233: ) = (SELECT
234: b.association_type_name,

Line 236: FROM ibc_association_types_tl b

232: description
233: ) = (SELECT
234: b.association_type_name,
235: b.description
236: FROM ibc_association_types_tl b
237: WHERE b.association_type_code = t.association_type_code
238: AND b.LANGUAGE = t.source_lang)
239: WHERE (
240: t.association_type_code,

Line 245: FROM ibc_association_types_tl subb, ibc_association_types_tl subt

241: t.LANGUAGE
242: ) IN (SELECT
243: subt.association_type_code,
244: subt.LANGUAGE
245: FROM ibc_association_types_tl subb, ibc_association_types_tl subt
246: WHERE subb.association_type_code = subt.association_type_code
247: AND subb.LANGUAGE = subt.source_lang
248: AND (subb.association_type_name <> subt.association_type_name
249: OR subb.description <> subt.description

Line 254: INSERT INTO ibc_association_types_tl (

250: OR (subb.description IS NULL AND subt.description IS NOT NULL)
251: OR (subb.description IS NOT NULL AND subt.description IS NULL)
252: ));
253:
254: INSERT INTO ibc_association_types_tl (
255: association_type_code,
256: association_type_name,
257: description,
258: created_by,

Line 276: FROM ibc_association_types_tl b, fnd_languages l

272: b.last_update_date,
273: b.last_update_login,
274: l.language_code,
275: b.source_lang
276: FROM ibc_association_types_tl b, fnd_languages l
277: WHERE l.installed_flag IN ('I', 'B')
278: AND b.LANGUAGE = USERENV('LANG')
279: AND NOT EXISTS
280: (SELECT NULL

Line 281: FROM ibc_association_types_tl t

277: WHERE l.installed_flag IN ('I', 'B')
278: AND b.LANGUAGE = USERENV('LANG')
279: AND NOT EXISTS
280: (SELECT NULL
281: FROM ibc_association_types_tl t
282: WHERE t.association_type_code = b.association_type_code
283: AND t.LANGUAGE = l.language_code);
284: END add_language;
285:

Line 411: FROM ibc_association_types_tl

407: l_last_update_date := nvl(TO_DATE(p_last_update_date, 'YYYY/MM/DD'),SYSDATE);
408:
409: -- get updatedby and update_date values if existing in db
410: SELECT LAST_UPDATED_BY, LAST_UPDATE_DATE INTO db_user_id, db_last_update_date
411: FROM ibc_association_types_tl
412: WHERE association_type_code = p_association_type_code
413: AND USERENV('LANG') IN (LANGUAGE, source_lang);
414:
415: IF (FND_LOAD_UTIL.UPLOAD_TEST(l_user_id, l_last_update_date,

Line 419: UPDATE ibc_association_types_tl t SET

415: IF (FND_LOAD_UTIL.UPLOAD_TEST(l_user_id, l_last_update_date,
416: db_user_id, db_last_update_date, p_upload_mode )) THEN
417:
418: -- Only update rows which have not been altered by user
419: UPDATE ibc_association_types_tl t SET
420: association_type_name = p_association_type_name,
421: description = p_description,
422: source_lang = USERENV('LANG'),
423: last_update_date = l_last_update_date,

Line 476: insert into IBC_ASSOCIATION_TYPES_TL (

472: X_LAST_UPDATE_LOGIN,
473: X_SECURITY_GROUP_ID
474: );
475:
476: insert into IBC_ASSOCIATION_TYPES_TL (
477: ASSOCIATION_TYPE_CODE,
478: ASSOCIATION_TYPE_NAME,
479: DESCRIPTION,
480: CREATED_BY,

Line 504: from IBC_ASSOCIATION_TYPES_TL T

500: from FND_LANGUAGES L
501: where L.INSTALLED_FLAG in ('I', 'B')
502: and not exists
503: (select NULL
504: from IBC_ASSOCIATION_TYPES_TL T
505: where T.ASSOCIATION_TYPE_CODE = X_ASSOCIATION_TYPE_CODE
506: and T.LANGUAGE = L.LANGUAGE_CODE);
507:
508: open c;

Line 540: from IBC_ASSOCIATION_TYPES_TL

536: cursor c1 is select
537: ASSOCIATION_TYPE_NAME,
538: DESCRIPTION,
539: decode(LANGUAGE, userenv('LANG'), 'Y', 'N') BASELANG
540: from IBC_ASSOCIATION_TYPES_TL
541: where ASSOCIATION_TYPE_CODE = X_ASSOCIATION_TYPE_CODE
542: and userenv('LANG') in (LANGUAGE, SOURCE_LANG)
543: for update of ASSOCIATION_TYPE_CODE nowait;
544: begin

Line 608: update IBC_ASSOCIATION_TYPES_TL set

604: if (sql%notfound) then
605: raise no_data_found;
606: end if;
607:
608: update IBC_ASSOCIATION_TYPES_TL set
609: ASSOCIATION_TYPE_NAME = X_ASSOCIATION_TYPE_NAME,
610: DESCRIPTION = X_DESCRIPTION,
611: LAST_UPDATE_DATE = X_LAST_UPDATE_DATE,
612: LAST_UPDATED_BY = X_LAST_UPDATED_BY,

Line 628: delete from IBC_ASSOCIATION_TYPES_TL

624: procedure DELETE_ROW (
625: X_ASSOCIATION_TYPE_CODE in VARCHAR2
626: ) is
627: begin
628: delete from IBC_ASSOCIATION_TYPES_TL
629: where ASSOCIATION_TYPE_CODE = X_ASSOCIATION_TYPE_CODE;
630:
631: if (sql%notfound) then
632: raise no_data_found;