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 466: update FND_RESPONSIBILITY_TL set

462: X_RESPONSIBILITY_KEY,
463: X_START_DATE,
464: X_END_DATE);
465:
466: update FND_RESPONSIBILITY_TL set
467: RESPONSIBILITY_NAME = X_RESPONSIBILITY_NAME,
468: DESCRIPTION = X_DESCRIPTION,
469: LAST_UPDATE_DATE = X_LAST_UPDATE_DATE,
470: LAST_UPDATED_BY = X_LAST_UPDATED_BY,

Line 501: delete from FND_RESPONSIBILITY_TL

497: fnd_function_security_cache.delete_resp(X_RESPONSIBILITY_ID, X_APPLICATION_ID);
498:
499: end if;
500:
501: delete from FND_RESPONSIBILITY_TL
502: where RESPONSIBILITY_ID = X_RESPONSIBILITY_ID
503: and APPLICATION_ID = X_APPLICATION_ID;
504:
505: if (sql%notfound) then

Line 520: delete from FND_RESPONSIBILITY_TL T

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

Line 528: update FND_RESPONSIBILITY_TL T set (

524: where B.RESPONSIBILITY_ID = T.RESPONSIBILITY_ID
525: and B.APPLICATION_ID = T.APPLICATION_ID
526: );
527:
528: update FND_RESPONSIBILITY_TL T set (
529: RESPONSIBILITY_NAME,
530: DESCRIPTION
531: ) = (select
532: B.RESPONSIBILITY_NAME,

Line 534: from FND_RESPONSIBILITY_TL B

530: DESCRIPTION
531: ) = (select
532: B.RESPONSIBILITY_NAME,
533: B.DESCRIPTION
534: from FND_RESPONSIBILITY_TL B
535: where B.RESPONSIBILITY_ID = T.RESPONSIBILITY_ID
536: and B.APPLICATION_ID = T.APPLICATION_ID
537: and B.LANGUAGE = T.SOURCE_LANG)
538: where (

Line 546: from FND_RESPONSIBILITY_TL SUBB, FND_RESPONSIBILITY_TL SUBT

542: ) in (select
543: SUBT.RESPONSIBILITY_ID,
544: SUBT.APPLICATION_ID,
545: SUBT.LANGUAGE
546: from FND_RESPONSIBILITY_TL SUBB, FND_RESPONSIBILITY_TL SUBT
547: where SUBB.RESPONSIBILITY_ID = SUBT.RESPONSIBILITY_ID
548: and SUBB.APPLICATION_ID = SUBT.APPLICATION_ID
549: and SUBB.LANGUAGE = SUBT.SOURCE_LANG
550: and (SUBB.RESPONSIBILITY_NAME <> SUBT.RESPONSIBILITY_NAME

Line 558: FND_RESPONSIBILITY_TL TT(

554: ));
555: */
556:
557: insert /*+ append parallel(TT) */ into
558: FND_RESPONSIBILITY_TL TT(
559: APPLICATION_ID,
560: RESPONSIBILITY_ID,
561: RESPONSIBILITY_NAME,
562: DESCRIPTION,

Line 583: from FND_RESPONSIBILITY_TL B, FND_LANGUAGES L

579: B.LAST_UPDATE_DATE,
580: B.LAST_UPDATE_LOGIN,
581: L.LANGUAGE_CODE,
582: B.SOURCE_LANG
583: from FND_RESPONSIBILITY_TL B, FND_LANGUAGES L
584: where L.INSTALLED_FLAG in ('I', 'B')
585: and B.LANGUAGE = userenv('LANG')
586: )V, FND_RESPONSIBILITY_TL T
587: where T.RESPONSIBILITY_ID(+) = V.RESPONSIBILITY_ID

Line 586: )V, FND_RESPONSIBILITY_TL T

582: B.SOURCE_LANG
583: from FND_RESPONSIBILITY_TL B, FND_LANGUAGES L
584: where L.INSTALLED_FLAG in ('I', 'B')
585: and B.LANGUAGE = userenv('LANG')
586: )V, FND_RESPONSIBILITY_TL T
587: where T.RESPONSIBILITY_ID(+) = V.RESPONSIBILITY_ID
588: and T.APPLICATION_ID(+) = V.APPLICATION_ID
589: and T.LANGUAGE(+) = V.LANGUAGE_CODE
590: and T.APPLICATION_ID is NULL