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.3.12000000.2 2007/03/16 23:27:12 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 => 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 => 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 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 489: delete from FND_RESPONSIBILITY

485: X_APPLICATION_ID in NUMBER
486: ) is
487: myList wf_parameter_list_t;
488: begin
489: delete from FND_RESPONSIBILITY
490: where RESPONSIBILITY_ID = X_RESPONSIBILITY_ID
491: and APPLICATION_ID = X_APPLICATION_ID;
492:
493: if (sql%notfound) then

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

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
525: and B.APPLICATION_ID = T.APPLICATION_ID
526: );
527:

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

Line 614: from fnd_responsibility

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

Line 805: from fnd_responsibility

801: from dual;
802:
803: select LAST_UPDATED_BY, LAST_UPDATE_DATE, responsibility_id
804: into db_luby, db_ludate, resp_id
805: from fnd_responsibility
806: where RESPONSIBILITY_KEY = X_RESP_KEY
807: and APPLICATION_ID = app_id;
808:
809: if (fnd_load_util.upload_test(f_luby, f_ludate, db_luby,

Line 811: fnd_responsibility_pkg.UPDATE_ROW (

807: and APPLICATION_ID = app_id;
808:
809: if (fnd_load_util.upload_test(f_luby, f_ludate, db_luby,
810: db_ludate, X_CUSTOM_MODE)) then
811: fnd_responsibility_pkg.UPDATE_ROW (
812: X_RESPONSIBILITY_ID => resp_id,
813: X_APPLICATION_ID => app_id,
814: X_WEB_HOST_NAME => L_WEB_HOST_NAME,
815: X_WEB_AGENT_NAME => L_WEB_AGENT_NAME,

Line 836: select fnd_responsibility_s.nextval

832: exception
833: when NO_DATA_FOUND then
834: -- Get a new resp_id if I don't have one yet
835: if (resp_id is null) then
836: select fnd_responsibility_s.nextval
837: into resp_id
838: from sys.dual;
839: end if;
840:

Line 841: fnd_responsibility_pkg.INSERT_ROW(

837: into resp_id
838: from sys.dual;
839: end if;
840:
841: fnd_responsibility_pkg.INSERT_ROW(
842: X_ROWID => row_id,
843: X_RESPONSIBILITY_ID => resp_id,
844: X_APPLICATION_ID => app_id,
845: X_WEB_HOST_NAME => L_WEB_HOST_NAME,

Line 866: end FND_RESPONSIBILITY_PKG;

862: X_LAST_UPDATE_LOGIN => 0 );
863: end;
864: end LOAD_ROW;
865:
866: end FND_RESPONSIBILITY_PKG;