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.FND_RESPONSIBILITY_PKG dependencies on FND_RESPONSIBILITY

Line 1: package body FND_RESPONSIBILITY_PKG as

1: package body FND_RESPONSIBILITY_PKG as
2: /* $Header: AFSCRSPB.pls 120.4.12010000.4 2010/03/23 18:42:34 jvalenti ship $ */
3:
4:
5: procedure INSERT_ROW (

Line 28: cursor C is select ROWID from FND_RESPONSIBILITY

24: X_LAST_UPDATE_DATE in DATE,
25: X_LAST_UPDATED_BY in NUMBER,
26: X_LAST_UPDATE_LOGIN in NUMBER
27: ) is
28: cursor C is select ROWID from FND_RESPONSIBILITY
29: where RESPONSIBILITY_ID = X_RESPONSIBILITY_ID
30: and APPLICATION_ID = X_APPLICATION_ID
31: ;
32: begin

Line 33: insert into FND_RESPONSIBILITY (

29: where RESPONSIBILITY_ID = X_RESPONSIBILITY_ID
30: and APPLICATION_ID = X_APPLICATION_ID
31: ;
32: begin
33: insert into FND_RESPONSIBILITY (
34: WEB_HOST_NAME,
35: WEB_AGENT_NAME,
36: APPLICATION_ID,
37: RESPONSIBILITY_ID,

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 141: fnd_responsibility_pkg.translate_row(

137: appl_id number;
138: resp_id number;
139: begin
140:
141: fnd_responsibility_pkg.translate_row(
142: X_APP_SHORT_NAME => X_APP_SHORT_NAME,
143: X_RESP_KEY => X_RESP_KEY,
144: X_RESPONSIBILITY_NAME => X_RESPONSIBILITY_NAME,
145: X_DESCRIPTION => X_DESCRIPTION,

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 182: from fnd_responsibility r, fnd_application a

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
184: and r.application_id = a.application_id
185: and a.application_short_name = X_APP_SHORT_NAME)
186: and LANGUAGE = userenv('LANG');

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 199: from fnd_responsibility r, fnd_application a

195: LAST_UPDATE_LOGIN = 0,
196: SOURCE_LANG = userenv('LANG')
197: where (RESPONSIBILITY_ID, APPLICATION_ID)
198: = (select r.responsibility_id, r.application_id
199: from fnd_responsibility r, fnd_application a
200: where r.responsibility_key = X_RESP_KEY
201: and r.application_id = a.application_id
202: and a.application_short_name = X_APP_SHORT_NAME)
203: and userenv('LANG') in (LANGUAGE, SOURCE_LANG);

Line 211: from fnd_responsibility

207: from fnd_application
208: where application_short_name = X_APP_SHORT_NAME;
209:
210: select responsibility_id into resp_id
211: from fnd_responsibility
212: where responsibility_key = X_RESP_KEY
213: and application_id = appl_id;
214:
215: fnd_responsibility_pkg.resp_synch(appl_id, resp_id);

Line 215: fnd_responsibility_pkg.resp_synch(appl_id, resp_id);

211: from fnd_responsibility
212: where responsibility_key = X_RESP_KEY
213: and application_id = appl_id;
214:
215: fnd_responsibility_pkg.resp_synch(appl_id, resp_id);
216: end if;
217: exception
218: when no_data_found then
219: null;

Line 245: fnd_responsibility_pkg.load_row(

241: X_WEB_HOST_NAME in VARCHAR2,
242: X_WEB_AGENT_NAME in VARCHAR2 )
243: is
244: begin
245: fnd_responsibility_pkg.load_row(
246: X_APP_SHORT_NAME => X_APP_SHORT_NAME,
247: X_RESP_KEY => upper(X_RESP_KEY),
248: X_RESPONSIBILITY_ID => X_RESPONSIBILITY_ID,
249: X_RESPONSIBILITY_NAME => X_RESPONSIBILITY_NAME,

Line 290: fnd_responsibility_pkg.load_row(

286: X_CUSTOM_MODE in VARCHAR2,
287: X_LAST_UPDATE_DATE in VARCHAR2 )
288: is
289: begin
290: fnd_responsibility_pkg.load_row(
291: X_APP_SHORT_NAME => X_APP_SHORT_NAME,
292: X_RESP_KEY => upper(X_RESP_KEY),
293: X_RESPONSIBILITY_NAME => X_RESPONSIBILITY_NAME,
294: X_OWNER => X_OWNER,

Line 341: from FND_RESPONSIBILITY

337: GROUP_APPLICATION_ID,
338: REQUEST_GROUP_ID,
339: VERSION,
340: RESPONSIBILITY_KEY
341: from FND_RESPONSIBILITY
342: where RESPONSIBILITY_ID = X_RESPONSIBILITY_ID
343: and APPLICATION_ID = X_APPLICATION_ID
344: for update of RESPONSIBILITY_ID nowait;
345: recinfo c%rowtype;

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 431: update FND_RESPONSIBILITY set

427: X_LAST_UPDATED_BY in NUMBER,
428: X_LAST_UPDATE_LOGIN in NUMBER
429: ) is
430: begin
431: update FND_RESPONSIBILITY set
432: WEB_HOST_NAME = X_WEB_HOST_NAME,
433: WEB_AGENT_NAME = X_WEB_AGENT_NAME,
434: DATA_GROUP_APPLICATION_ID = X_DATA_GROUP_APPLICATION_ID,
435: DATA_GROUP_ID = X_DATA_GROUP_ID,

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 494: delete from FND_RESPONSIBILITY

490: X_APPLICATION_ID in NUMBER
491: ) is
492: myList wf_parameter_list_t;
493: begin
494: delete from FND_RESPONSIBILITY
495: where RESPONSIBILITY_ID = X_RESPONSIBILITY_ID
496: and APPLICATION_ID = X_APPLICATION_ID;
497:
498: if (sql%notfound) then

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 528: from FND_RESPONSIBILITY B

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
530: and B.APPLICATION_ID = T.APPLICATION_ID
531: );
532:

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

Line 619: from fnd_responsibility

615: -- fetch info for synch --
616:
617: select start_date, end_date, responsibility_key
618: into my_start, my_end, my_respkey
619: from fnd_responsibility
620: where responsibility_id = p_responsibility_id
621: and application_id = p_application_id;
622:
623: -- Added to maintain "ANY/ALL" diamonds of roles for user/resps.

Line 810: from fnd_responsibility

806: from dual;
807:
808: select LAST_UPDATED_BY, LAST_UPDATE_DATE, responsibility_id
809: into db_luby, db_ludate, resp_id
810: from fnd_responsibility
811: where RESPONSIBILITY_KEY = upper(X_RESP_KEY)
812: and APPLICATION_ID = app_id;
813:
814: if (fnd_load_util.upload_test(f_luby, f_ludate, db_luby,

Line 816: fnd_responsibility_pkg.UPDATE_ROW (

812: and APPLICATION_ID = app_id;
813:
814: if (fnd_load_util.upload_test(f_luby, f_ludate, db_luby,
815: db_ludate, X_CUSTOM_MODE)) then
816: fnd_responsibility_pkg.UPDATE_ROW (
817: X_RESPONSIBILITY_ID => resp_id,
818: X_APPLICATION_ID => app_id,
819: X_WEB_HOST_NAME => L_WEB_HOST_NAME,
820: X_WEB_AGENT_NAME => L_WEB_AGENT_NAME,

Line 841: select fnd_responsibility_s.nextval

837: exception
838: when NO_DATA_FOUND then
839: -- Get a new resp_id if I don't have one yet
840: if (resp_id is null) then
841: select fnd_responsibility_s.nextval
842: into resp_id
843: from sys.dual;
844: end if;
845:

Line 846: fnd_responsibility_pkg.INSERT_ROW(

842: into resp_id
843: from sys.dual;
844: end if;
845:
846: fnd_responsibility_pkg.INSERT_ROW(
847: X_ROWID => row_id,
848: X_RESPONSIBILITY_ID => resp_id,
849: X_APPLICATION_ID => app_id,
850: X_WEB_HOST_NAME => L_WEB_HOST_NAME,

Line 871: end FND_RESPONSIBILITY_PKG;

867: X_LAST_UPDATE_LOGIN => 0 );
868: end;
869: end LOAD_ROW;
870:
871: end FND_RESPONSIBILITY_PKG;