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_DOC_CATEGORIES_PKG dependencies on FND_DOCUMENT_CATEGORIES

Line 35: cursor C is select ROWID from FND_DOCUMENT_CATEGORIES

31: X_CREATED_BY in NUMBER,
32: X_LAST_UPDATE_DATE in DATE,
33: X_LAST_UPDATED_BY in NUMBER,
34: X_LAST_UPDATE_LOGIN in NUMBER) is
35: cursor C is select ROWID from FND_DOCUMENT_CATEGORIES
36: where CATEGORY_ID = X_CATEGORY_ID;
37: begin
38:
39: insert into FND_DOCUMENT_CATEGORIES (

Line 39: insert into FND_DOCUMENT_CATEGORIES (

35: cursor C is select ROWID from FND_DOCUMENT_CATEGORIES
36: where CATEGORY_ID = X_CATEGORY_ID;
37: begin
38:
39: insert into FND_DOCUMENT_CATEGORIES (
40: CATEGORY_ID,
41: APPLICATION_ID,
42: NAME,
43: START_DATE_ACTIVE,

Line 104: insert into FND_DOCUMENT_CATEGORIES_TL (

100: raise no_data_found;
101: end if;
102: close c;
103:
104: insert into FND_DOCUMENT_CATEGORIES_TL (
105: CATEGORY_ID,
106: LANGUAGE,
107: NAME,
108: USER_NAME,

Line 132: from FND_DOCUMENT_CATEGORIES_TL T

128: from FND_LANGUAGES L
129: where L.INSTALLED_FLAG in ('I', 'B')
130: and not exists
131: (select NULL
132: from FND_DOCUMENT_CATEGORIES_TL T
133: where T.CATEGORY_ID = X_CATEGORY_ID
134: and T.LANGUAGE = L.LANGUAGE_CODE);
135: end INSERT_ROW;
136:

Line 183: from FND_DOCUMENT_CATEGORIES

179: ATTRIBUTE13,
180: ATTRIBUTE14,
181: ATTRIBUTE15,
182: DEFAULT_DATATYPE_ID
183: from FND_DOCUMENT_CATEGORIES
184: where CATEGORY_ID = X_CATEGORY_ID
185: for update of CATEGORY_ID nowait;
186: recinfo c%rowtype;
187:

Line 190: from FND_DOCUMENT_CATEGORIES_TL

186: recinfo c%rowtype;
187:
188: cursor c1 is select
189: USER_NAME
190: from FND_DOCUMENT_CATEGORIES_TL
191: where CATEGORY_ID = X_CATEGORY_ID
192: and LANGUAGE = userenv('LANG')
193: for update of CATEGORY_ID nowait;
194: tlinfo c1%rowtype;

Line 317: update FND_DOCUMENT_CATEGORIES set

313: X_LAST_UPDATE_DATE in DATE,
314: X_LAST_UPDATED_BY in NUMBER,
315: X_LAST_UPDATE_LOGIN in NUMBER) is
316: begin
317: update FND_DOCUMENT_CATEGORIES set
318: CATEGORY_ID = X_CATEGORY_ID,
319: APPLICATION_ID = X_APPLICATION_ID,
320: NAME = X_NAME,
321: START_DATE_ACTIVE = X_START_DATE_ACTIVE,

Line 348: update FND_DOCUMENT_CATEGORIES_TL set

344: if (sql%notfound) then
345: raise no_data_found;
346: end if;
347:
348: update FND_DOCUMENT_CATEGORIES_TL set
349: NAME = X_NAME,
350: USER_NAME = X_USER_NAME,
351: LAST_UPDATE_DATE = X_LAST_UPDATE_DATE,
352: LAST_UPDATED_BY = X_LAST_UPDATED_BY,

Line 365: -- need to mark fnd_document_categories.app_source_version with the

361: end UPDATE_ROW;
362:
363: procedure DELETE_ROW (X_CATEGORY_ID in NUMBER) is
364: begin
365: -- need to mark fnd_document_categories.app_source_version with the
366: -- USER the delete is being sourced from so that trigger logic can call
367: -- the delete stored procedure in the appropriate schema
368: -- (R10/10SC compatibility logic) WIP logic operates off tl table
369: --UPDATE fnd_document_categories_tl

Line 369: --UPDATE fnd_document_categories_tl

365: -- need to mark fnd_document_categories.app_source_version with the
366: -- USER the delete is being sourced from so that trigger logic can call
367: -- the delete stored procedure in the appropriate schema
368: -- (R10/10SC compatibility logic) WIP logic operates off tl table
369: --UPDATE fnd_document_categories_tl
370: -- SET app_source_Version = 'DEL_10SC<<' || USER || '>>'
371: --WHERE category_id = X_category_id;
372:
373: -- now do the delete

Line 374: delete from FND_DOCUMENT_CATEGORIES

370: -- SET app_source_Version = 'DEL_10SC<<' || USER || '>>'
371: --WHERE category_id = X_category_id;
372:
373: -- now do the delete
374: delete from FND_DOCUMENT_CATEGORIES
375: where CATEGORY_ID = X_CATEGORY_ID;
376:
377: if (sql%notfound) then
378: raise no_data_found;

Line 381: delete from FND_DOCUMENT_CATEGORIES_TL

377: if (sql%notfound) then
378: raise no_data_found;
379: end if;
380:
381: delete from FND_DOCUMENT_CATEGORIES_TL
382: where CATEGORY_ID = X_CATEGORY_ID;
383: if (sql%notfound) then
384: raise no_data_found;
385: end if;

Line 402: delete from FND_DOCUMENT_CATEGORIES_TL T

398: /* as a quick workaround to fix the time-consuming table handler issue */
399: /* Eventually we'll need to turn them into a separate fix_language procedure */
400: /*
401:
402: delete from FND_DOCUMENT_CATEGORIES_TL T
403: where not exists
404: (select NULL
405: from FND_DOCUMENT_CATEGORIES B
406: where B.CATEGORY_ID = T.CATEGORY_ID

Line 405: from FND_DOCUMENT_CATEGORIES B

401:
402: delete from FND_DOCUMENT_CATEGORIES_TL T
403: where not exists
404: (select NULL
405: from FND_DOCUMENT_CATEGORIES B
406: where B.CATEGORY_ID = T.CATEGORY_ID
407: );
408:
409: update FND_DOCUMENT_CATEGORIES_TL T set (

Line 409: update FND_DOCUMENT_CATEGORIES_TL T set (

405: from FND_DOCUMENT_CATEGORIES B
406: where B.CATEGORY_ID = T.CATEGORY_ID
407: );
408:
409: update FND_DOCUMENT_CATEGORIES_TL T set (
410: USER_NAME
411: ) = (select
412: B.USER_NAME
413: from FND_DOCUMENT_CATEGORIES_TL B

Line 413: from FND_DOCUMENT_CATEGORIES_TL B

409: update FND_DOCUMENT_CATEGORIES_TL T set (
410: USER_NAME
411: ) = (select
412: B.USER_NAME
413: from FND_DOCUMENT_CATEGORIES_TL B
414: where B.CATEGORY_ID = T.CATEGORY_ID
415: and B.LANGUAGE = T.SOURCE_LANG)
416: where (
417: T.CATEGORY_ID,

Line 422: from FND_DOCUMENT_CATEGORIES_TL SUBB, FND_DOCUMENT_CATEGORIES_TL SUBT

418: T.LANGUAGE
419: ) in (select
420: SUBT.CATEGORY_ID,
421: SUBT.LANGUAGE
422: from FND_DOCUMENT_CATEGORIES_TL SUBB, FND_DOCUMENT_CATEGORIES_TL SUBT
423: where SUBB.CATEGORY_ID = SUBT.CATEGORY_ID
424: and SUBB.LANGUAGE = SUBT.SOURCE_LANG
425: and (SUBB.USER_NAME <> SUBT.USER_NAME
426: ));

Line 429: insert into FND_DOCUMENT_CATEGORIES_TL (

425: and (SUBB.USER_NAME <> SUBT.USER_NAME
426: ));
427: */
428:
429: insert into FND_DOCUMENT_CATEGORIES_TL (
430: CATEGORY_ID,
431: LANGUAGE,
432: NAME,
433: USER_NAME,

Line 451: from FND_DOCUMENT_CATEGORIES_TL M, FND_LANGUAGES B, FND_LANGUAGES L

447: M.LAST_UPDATE_DATE,
448: M.LAST_UPDATED_BY,
449: M.LAST_UPDATE_LOGIN,
450: M.SOURCE_LANG
451: from FND_DOCUMENT_CATEGORIES_TL M, FND_LANGUAGES B, FND_LANGUAGES L
452: where B.INSTALLED_FLAG = 'B'
453: and L.INSTALLED_FLAG in ('I', 'B')
454: and M.LANGUAGE = userenv('LANG')
455: and not exists

Line 457: from FND_DOCUMENT_CATEGORIES_TL T

453: and L.INSTALLED_FLAG in ('I', 'B')
454: and M.LANGUAGE = userenv('LANG')
455: and not exists
456: (select NULL
457: from FND_DOCUMENT_CATEGORIES_TL T
458: where T.CATEGORY_ID = M.CATEGORY_ID
459: and T.LANGUAGE = L.LANGUAGE_CODE);
460: end ADD_LANGUAGE;
461:

Line 468: update fnd_document_categories_tl set

464: X_USER_NAME in VARCHAR2,
465: X_OWNER in VARCHAR2) IS
466: begin
467:
468: update fnd_document_categories_tl set
469: user_name = nvl(X_USER_NAME,user_name),
470: last_update_date = sysdate,
471: last_updated_by = decode(X_OWNER, 'SEED', 1, 0),
472: last_update_login = 0,

Line 502: from fnd_document_categories_tl

498: f_ludate := nvl(to_date(x_last_update_date, 'YYYY/MM/DD'), sysdate);
499:
500: select LAST_UPDATED_BY, LAST_UPDATE_DATE
501: into db_luby, db_ludate
502: from fnd_document_categories_tl
503: where name = X_CATEGORY_NAME
504: and LANGUAGE = userenv('LANG');
505:
506: if (fnd_load_util.upload_test(f_luby, f_ludate, db_luby,

Line 508: update fnd_document_categories_tl set

504: and LANGUAGE = userenv('LANG');
505:
506: if (fnd_load_util.upload_test(f_luby, f_ludate, db_luby,
507: db_ludate, X_CUSTOM_MODE)) then
508: update fnd_document_categories_tl set
509: user_name = nvl(X_USER_NAME,user_name),
510: last_update_date = f_ludate,
511: last_updated_by = f_luby,
512: last_update_login = 0,

Line 567: -- Get category Id from fnd_document_categories.

563: l_application_id := NULL ;
564: end if;
565:
566: begin
567: -- Get category Id from fnd_document_categories.
568: select category_id, application_id
569: into l_category_id, l_application_id
570: from fnd_document_categories
571: where name = X_CATEGORY_NAME ;

Line 570: from fnd_document_categories

566: begin
567: -- Get category Id from fnd_document_categories.
568: select category_id, application_id
569: into l_category_id, l_application_id
570: from fnd_document_categories
571: where name = X_CATEGORY_NAME ;
572:
573: UPDATE_ROW (
574: X_CATEGORY_ID => l_category_id,

Line 605: select fnd_document_categories_s.nextval

601: exception
602: when no_data_found then
603:
604: -- Get category id from a sequence.
605: select fnd_document_categories_s.nextval
606: into l_category_id
607: from dual;
608:
609: INSERT_ROW (

Line 700: -- Get category Id from fnd_document_categories.

696: l_application_id := NULL ;
697: end if;
698:
699: begin
700: -- Get category Id from fnd_document_categories.
701: select category_id, application_id, LAST_UPDATED_BY, LAST_UPDATE_DATE
702: into l_category_id, l_application_id, db_luby, db_ludate
703: from fnd_document_categories
704: where name = X_CATEGORY_NAME ;

Line 703: from fnd_document_categories

699: begin
700: -- Get category Id from fnd_document_categories.
701: select category_id, application_id, LAST_UPDATED_BY, LAST_UPDATE_DATE
702: into l_category_id, l_application_id, db_luby, db_ludate
703: from fnd_document_categories
704: where name = X_CATEGORY_NAME ;
705:
706: if (fnd_load_util.upload_test(f_luby, f_ludate, db_luby,
707: db_ludate, X_CUSTOM_MODE)) then

Line 741: select fnd_document_categories_s.nextval

737: exception
738: when no_data_found then
739:
740: -- Get category id from a sequence.
741: select fnd_document_categories_s.nextval
742: into l_category_id
743: from dual;
744:
745: INSERT_ROW (