DBA Data[Home] [Help]

APPS.FND_RESPONSIBILITY_PKG dependencies on FND_RESPONSIBILITY_TL

Line 76: insert into FND_RESPONSIBILITY_TL (

72:
73: -- Added for Function Security Cache Invalidation Project
74: fnd_function_security_cache.insert_resp(X_RESPONSIBILITY_ID, X_APPLICATION_ID);
75:
76: insert into FND_RESPONSIBILITY_TL (
77: APPLICATION_ID,
78: RESPONSIBILITY_ID,
79: RESPONSIBILITY_NAME,
80: DESCRIPTION,

Line 104: from FND_RESPONSIBILITY_TL T

100: from FND_LANGUAGES L
101: where L.INSTALLED_FLAG in ('I', 'B')
102: and not exists
103: (select NULL
104: from FND_RESPONSIBILITY_TL T
105: where T.RESPONSIBILITY_ID = X_RESPONSIBILITY_ID
106: and T.APPLICATION_ID = X_APPLICATION_ID
107: and T.LANGUAGE = L.LANGUAGE_CODE);
108:

Line 179: from fnd_responsibility_tl

175:
176: begin
177: select LAST_UPDATED_BY, LAST_UPDATE_DATE
178: into db_luby, db_ludate
179: from fnd_responsibility_tl
180: where (RESPONSIBILITY_ID, APPLICATION_ID)
181: = (select r.responsibility_id, r.application_id
182: from fnd_responsibility r, fnd_application a
183: where r.responsibility_key = X_RESP_KEY

Line 190: update fnd_responsibility_tl set

186: and LANGUAGE = userenv('LANG');
187:
188: if (fnd_load_util.upload_test(f_luby, f_ludate, db_luby,
189: db_ludate, X_CUSTOM_MODE)) then
190: update fnd_responsibility_tl set
191: responsibility_name = nvl(X_RESPONSIBILITY_NAME, responsibility_name),
192: DESCRIPTION = nvl(X_DESCRIPTION, description),
193: LAST_UPDATE_DATE = f_ludate,
194: LAST_UPDATED_BY = f_luby,

Line 350: from FND_RESPONSIBILITY_TL

346:
347: cursor c1 is select
348: RESPONSIBILITY_NAME,
349: DESCRIPTION
350: from FND_RESPONSIBILITY_TL
351: where RESPONSIBILITY_ID = X_RESPONSIBILITY_ID
352: and APPLICATION_ID = X_APPLICATION_ID
353: and LANGUAGE = userenv('LANG')
354: for update of RESPONSIBILITY_ID nowait;

Line 458: update FND_RESPONSIBILITY_TL set

454: X_APPLICATION_ID);
455:
456: end if;
457:
458: update FND_RESPONSIBILITY_TL set
459: RESPONSIBILITY_NAME = X_RESPONSIBILITY_NAME,
460: DESCRIPTION = X_DESCRIPTION,
461: LAST_UPDATE_DATE = X_LAST_UPDATE_DATE,
462: LAST_UPDATED_BY = X_LAST_UPDATED_BY,

Line 506: delete from FND_RESPONSIBILITY_TL

502: fnd_function_security_cache.delete_resp(X_RESPONSIBILITY_ID, X_APPLICATION_ID);
503:
504: end if;
505:
506: delete from FND_RESPONSIBILITY_TL
507: where RESPONSIBILITY_ID = X_RESPONSIBILITY_ID
508: and APPLICATION_ID = X_APPLICATION_ID;
509:
510: if (sql%notfound) then

Line 525: delete from FND_RESPONSIBILITY_TL T

521: /* as a quick workaround to fix the time-consuming table handler issue */
522: /* Eventually we'll need to turn them into a separate fix_language procedure */
523: /*
524:
525: delete from FND_RESPONSIBILITY_TL T
526: where not exists
527: (select NULL
528: from FND_RESPONSIBILITY B
529: where B.RESPONSIBILITY_ID = T.RESPONSIBILITY_ID

Line 533: update FND_RESPONSIBILITY_TL T set (

529: where B.RESPONSIBILITY_ID = T.RESPONSIBILITY_ID
530: and B.APPLICATION_ID = T.APPLICATION_ID
531: );
532:
533: update FND_RESPONSIBILITY_TL T set (
534: RESPONSIBILITY_NAME,
535: DESCRIPTION
536: ) = (select
537: B.RESPONSIBILITY_NAME,

Line 539: from FND_RESPONSIBILITY_TL B

535: DESCRIPTION
536: ) = (select
537: B.RESPONSIBILITY_NAME,
538: B.DESCRIPTION
539: from FND_RESPONSIBILITY_TL B
540: where B.RESPONSIBILITY_ID = T.RESPONSIBILITY_ID
541: and B.APPLICATION_ID = T.APPLICATION_ID
542: and B.LANGUAGE = T.SOURCE_LANG)
543: where (

Line 551: from FND_RESPONSIBILITY_TL SUBB, FND_RESPONSIBILITY_TL SUBT

547: ) in (select
548: SUBT.RESPONSIBILITY_ID,
549: SUBT.APPLICATION_ID,
550: SUBT.LANGUAGE
551: from FND_RESPONSIBILITY_TL SUBB, FND_RESPONSIBILITY_TL SUBT
552: where SUBB.RESPONSIBILITY_ID = SUBT.RESPONSIBILITY_ID
553: and SUBB.APPLICATION_ID = SUBT.APPLICATION_ID
554: and SUBB.LANGUAGE = SUBT.SOURCE_LANG
555: and (SUBB.RESPONSIBILITY_NAME <> SUBT.RESPONSIBILITY_NAME

Line 563: FND_RESPONSIBILITY_TL TT(

559: ));
560: */
561:
562: insert /*+ append parallel(TT) */ into
563: FND_RESPONSIBILITY_TL TT(
564: APPLICATION_ID,
565: RESPONSIBILITY_ID,
566: RESPONSIBILITY_NAME,
567: DESCRIPTION,

Line 588: from FND_RESPONSIBILITY_TL B, FND_LANGUAGES L

584: B.LAST_UPDATE_DATE,
585: B.LAST_UPDATE_LOGIN,
586: L.LANGUAGE_CODE,
587: B.SOURCE_LANG
588: from FND_RESPONSIBILITY_TL B, FND_LANGUAGES L
589: where L.INSTALLED_FLAG in ('I', 'B')
590: and B.LANGUAGE = userenv('LANG')
591: )V, FND_RESPONSIBILITY_TL T
592: where T.RESPONSIBILITY_ID(+) = V.RESPONSIBILITY_ID

Line 591: )V, FND_RESPONSIBILITY_TL T

587: B.SOURCE_LANG
588: from FND_RESPONSIBILITY_TL B, FND_LANGUAGES L
589: where L.INSTALLED_FLAG in ('I', 'B')
590: and B.LANGUAGE = userenv('LANG')
591: )V, FND_RESPONSIBILITY_TL T
592: where T.RESPONSIBILITY_ID(+) = V.RESPONSIBILITY_ID
593: and T.APPLICATION_ID(+) = V.APPLICATION_ID
594: and T.LANGUAGE(+) = V.LANGUAGE_CODE
595: and T.APPLICATION_ID is NULL