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.CN_CREDIT_TYPES_PKG dependencies on CN_CREDIT_TYPES_ALL_TL

Line 97: insert into CN_CREDIT_TYPES_ALL_TL (

93: X_PRECISION,
94: X_EXTENDED_PRECISION
95: );
96:
97: insert into CN_CREDIT_TYPES_ALL_TL (
98: CREDIT_TYPE_ID,
99: ORG_ID,
100: NAME,
101: LAST_UPDATE_DATE,

Line 123: from CN_CREDIT_TYPES_ALL_TL T

119: from FND_LANGUAGES L
120: where L.INSTALLED_FLAG in ('I', 'B')
121: and not exists
122: (select NULL
123: from CN_CREDIT_TYPES_ALL_TL T
124: where T.CREDIT_TYPE_ID = X_CREDIT_TYPE_ID
125: and T.LANGUAGE = L.language_code AND
126: T.ORG_ID = X_ORG_ID
127: );

Line 193: from CN_CREDIT_TYPES_ALL_TL

189:
190: cursor c1 is select
191: NAME,
192: decode(LANGUAGE, userenv('LANG'), 'Y', 'N') BASELANG
193: from CN_CREDIT_TYPES_ALL_TL
194: where CREDIT_TYPE_ID = X_CREDIT_TYPE_ID
195: and userenv('LANG') in (LANGUAGE, SOURCE_LANG) AND
196: NVL(ORG_ID,NVL(TO_NUMBER(DECODE(SUBSTRB(USERENV('CLIENT_INFO'),1,1), ' ', NULL, SUBSTRB(USERENV('CLIENT_INFO'),1,10))),-99)) = NVL(TO_NUMBER(DECODE(SUBSTRB(USERENV('CLIENT_INFO'),1,1), ' ', NULL, SUBSTRB(USERENV('CLIENT_INFO'),1,10))),-99)
197: for update of CREDIT_TYPE_ID nowait;

Line 330: update CN_CREDIT_TYPES_ALL_TL set

326: if (sql%notfound) then
327: raise no_data_found;
328: end if;
329:
330: update CN_CREDIT_TYPES_ALL_TL set
331: NAME = X_NAME,
332: LAST_UPDATE_DATE = X_LAST_UPDATE_DATE,
333: LAST_UPDATED_BY = X_LAST_UPDATED_BY,
334: LAST_UPDATE_LOGIN = X_LAST_UPDATE_LOGIN,

Line 351: delete from CN_CREDIT_TYPES_ALL_TL

347: X_CREDIT_TYPE_ID in NUMBER,
348: X_ORG_ID in NUMBER
349: ) is
350: begin
351: delete from CN_CREDIT_TYPES_ALL_TL
352: where CREDIT_TYPE_ID = X_CREDIT_TYPE_ID AND
353: ORG_ID = X_ORG_ID;
354:
355: if (sql%notfound) then

Line 372: delete from CN_CREDIT_TYPES_ALL_TL T

368:
369: procedure ADD_LANGUAGE
370: is
371: begin
372: delete from CN_CREDIT_TYPES_ALL_TL T
373: where not exists
374: (select NULL
375: from CN_CREDIT_TYPES_ALL_B B
376: where B.CREDIT_TYPE_ID = T.credit_type_id

Line 380: update CN_CREDIT_TYPES_ALL_TL T set (

376: where B.CREDIT_TYPE_ID = T.credit_type_id
377: and B.org_id = T.org_id
378: );
379:
380: update CN_CREDIT_TYPES_ALL_TL T set (
381: NAME
382: ) = (select
383: B.NAME
384: from CN_CREDIT_TYPES_ALL_TL B

Line 384: from CN_CREDIT_TYPES_ALL_TL B

380: update CN_CREDIT_TYPES_ALL_TL T set (
381: NAME
382: ) = (select
383: B.NAME
384: from CN_CREDIT_TYPES_ALL_TL B
385: where B.CREDIT_TYPE_ID = T.CREDIT_TYPE_ID
386: and B.LANGUAGE = T.source_lang
387: and B.org_id = T.org_id)
388: where (

Line 394: from CN_CREDIT_TYPES_ALL_TL SUBB, CN_CREDIT_TYPES_ALL_TL SUBT

390: T.LANGUAGE
391: ) in (select
392: SUBT.CREDIT_TYPE_ID,
393: SUBT.LANGUAGE
394: from CN_CREDIT_TYPES_ALL_TL SUBB, CN_CREDIT_TYPES_ALL_TL SUBT
395: where SUBB.CREDIT_TYPE_ID = SUBT.CREDIT_TYPE_ID
396: and SUBB.LANGUAGE = SUBT.source_lang
397: and SUBB.org_id = SUBT.org_id
398: and (SUBB.NAME <> SUBT.name

Line 403: insert into CN_CREDIT_TYPES_ALL_TL (

399: or (SUBB.NAME is null and SUBT.NAME is not null)
400: or (SUBB.NAME is not null and SUBT.NAME is null)
401: ));
402:
403: insert into CN_CREDIT_TYPES_ALL_TL (
404: ORG_ID,
405: CREDIT_TYPE_ID,
406: NAME,
407: LAST_UPDATE_DATE,

Line 425: from CN_CREDIT_TYPES_ALL_TL B, FND_LANGUAGES L

421: B.CREATION_DATE,
422: B.CREATED_BY,
423: L.LANGUAGE_CODE,
424: B.SOURCE_LANG
425: from CN_CREDIT_TYPES_ALL_TL B, FND_LANGUAGES L
426: where L.INSTALLED_FLAG in ('I', 'B')
427: and B.LANGUAGE = userenv('LANG')
428: and not exists
429: (select NULL

Line 430: from CN_CREDIT_TYPES_ALL_TL T

426: where L.INSTALLED_FLAG in ('I', 'B')
427: and B.LANGUAGE = userenv('LANG')
428: and not exists
429: (select NULL
430: from CN_CREDIT_TYPES_ALL_TL T
431: where T.CREDIT_TYPE_ID = B.CREDIT_TYPE_ID
432: and T.LANGUAGE = L.language_code
433: and T.org_id = B.org_id);
434: end ADD_LANGUAGE;

Line 570: UPDATE cn_credit_types_all_tl SET

566: 0
567: );
568: END IF;
569: -- Load The record to _TL table
570: UPDATE cn_credit_types_all_tl SET
571: name = x_name,
572: last_update_date = sysdate,
573: last_updated_by = user_id,
574: last_update_login = 0,

Line 581: INSERT INTO cn_credit_types_all_tl

577: AND userenv('LANG') IN (LANGUAGE, SOURCE_LANG);
578:
579: IF (SQL%NOTFOUND) THEN
580: -- Insert new record to _TL table
581: INSERT INTO cn_credit_types_all_tl
582: (credit_type_id,
583: org_id,
584: name,
585: creation_date,

Line 607: FROM cn_credit_types_all_tl t

603: FROM fnd_languages l
604: WHERE l.installed_flag IN ('I', 'B')
605: AND NOT EXISTS
606: (SELECT NULL
607: FROM cn_credit_types_all_tl t
608: WHERE t.credit_type_id = x_credit_type_id
609: AND t.language = l.language_code
610: AND org_id = x_org_id);
611: END IF;

Line 638: UPDATE cn_credit_types_all_tl SET

634: ELSE
635: user_id := 0;
636: END IF;
637: -- Update the translation
638: UPDATE cn_credit_types_all_tl SET
639: name = x_name,
640: last_update_date = sysdate,
641: last_updated_by = user_id,
642: last_update_login = 0,