APPS.DOM_DOCUMENT_CATEGORIES_PKG dependencies on DOM_DOCUMENT_CATEGORIES

Line 1: package body DOM_DOCUMENT_CATEGORIES_PKG as

1: package body DOM_DOCUMENT_CATEGORIES_PKG as
2: /* $Header: DOMCATGB.pls 120.0 2006/02/23 02:35 rkhasa noship $ */
3: procedure INSERT_ROW (
4: X_ROWID in out nocopy VARCHAR2,
5: X_CATALOG_ID in NUMBER,

Line 39: cursor C is select ROWID from DOM_DOCUMENT_CATEGORIES

35: X_LAST_UPDATE_DATE in DATE,
36: X_LAST_UPDATED_BY in NUMBER,
37: X_LAST_UPDATE_LOGIN in NUMBER
38: ) is
39: cursor C is select ROWID from DOM_DOCUMENT_CATEGORIES
40: where CATALOG_ID = X_CATALOG_ID
41: and CATEGORY_ID = X_CATEGORY_ID
42: ;
43: begin

Line 44: insert into DOM_DOCUMENT_CATEGORIES (

40: where CATALOG_ID = X_CATALOG_ID
41: and CATEGORY_ID = X_CATEGORY_ID
42: ;
43: begin
44: insert into DOM_DOCUMENT_CATEGORIES (
45: CATALOG_ID,
46: CATEGORY_ID,
47: PARENT_CATEGORY_ID,
48: DOC_CREATION_ALLOWED,

Line 110: insert into DOM_DOCUMENT_CATEGORIES_TL (

106: X_LAST_UPDATED_BY,
107: X_LAST_UPDATE_LOGIN
108: );
109:
110: insert into DOM_DOCUMENT_CATEGORIES_TL (
111: LAST_UPDATE_LOGIN,
112: CATALOG_ID,
113: CATEGORY_ID,
114: NAME,

Line 138: from DOM_DOCUMENT_CATEGORIES_TL T

134: from FND_LANGUAGES L
135: where L.INSTALLED_FLAG in ('I', 'B')
136: and not exists
137: (select NULL
138: from DOM_DOCUMENT_CATEGORIES_TL T
139: where T.CATALOG_ID = X_CATALOG_ID
140: and T.CATEGORY_ID = X_CATEGORY_ID
141: and T.LANGUAGE = L.LANGUAGE_CODE);
142:

Line 208: from DOM_DOCUMENT_CATEGORIES

204: DOC_REV_SUFFIX,
205: DOC_REV_FUNC_ACTION_ID,
206: DOC_NAME_SCHEME,
207: DOC_NAME_FUNC_ACTION_ID
208: from DOM_DOCUMENT_CATEGORIES
209: where CATALOG_ID = X_CATALOG_ID
210: and CATEGORY_ID = X_CATEGORY_ID
211: for update of CATALOG_ID nowait;
212: recinfo c%rowtype;

Line 218: from DOM_DOCUMENT_CATEGORIES_TL

214: cursor c1 is select
215: NAME,
216: DESCRIPTION,
217: decode(LANGUAGE, userenv('LANG'), 'Y', 'N') BASELANG
218: from DOM_DOCUMENT_CATEGORIES_TL
219: where CATALOG_ID = X_CATALOG_ID
220: and CATEGORY_ID = X_CATEGORY_ID
221: and userenv('LANG') in (LANGUAGE, SOURCE_LANG)
222: for update of CATALOG_ID nowait;

Line 337: update DOM_DOCUMENT_CATEGORIES set

333: X_LAST_UPDATED_BY in NUMBER,
334: X_LAST_UPDATE_LOGIN in NUMBER
335: ) is
336: begin
337: update DOM_DOCUMENT_CATEGORIES set
338: PARENT_CATEGORY_ID = X_PARENT_CATEGORY_ID,
339: DOC_CREATION_ALLOWED = X_DOC_CREATION_ALLOWED,
340: INACTIVE_ON = X_INACTIVE_ON,
341: DEFAULT_FOLDER_OPTION = X_DEFAULT_FOLDER_OPTION,

Line 372: update DOM_DOCUMENT_CATEGORIES_TL set

368: if (sql%notfound) then
369: raise no_data_found;
370: end if;
371:
372: update DOM_DOCUMENT_CATEGORIES_TL set
373: NAME = X_NAME,
374: DESCRIPTION = X_DESCRIPTION,
375: LAST_UPDATE_DATE = X_LAST_UPDATE_DATE,
376: LAST_UPDATED_BY = X_LAST_UPDATED_BY,

Line 393: delete from DOM_DOCUMENT_CATEGORIES_TL

389: X_CATALOG_ID in NUMBER,
390: X_CATEGORY_ID in NUMBER
391: ) is
392: begin
393: delete from DOM_DOCUMENT_CATEGORIES_TL
394: where CATALOG_ID = X_CATALOG_ID
395: and CATEGORY_ID = X_CATEGORY_ID;
396:
397: if (sql%notfound) then

Line 401: delete from DOM_DOCUMENT_CATEGORIES

397: if (sql%notfound) then
398: raise no_data_found;
399: end if;
400:
401: delete from DOM_DOCUMENT_CATEGORIES
402: where CATALOG_ID = X_CATALOG_ID
403: and CATEGORY_ID = X_CATEGORY_ID;
404:
405: if (sql%notfound) then

Line 413: delete from DOM_DOCUMENT_CATEGORIES_TL T

409:
410: procedure ADD_LANGUAGE
411: is
412: begin
413: delete from DOM_DOCUMENT_CATEGORIES_TL T
414: where not exists
415: (select NULL
416: from DOM_DOCUMENT_CATEGORIES B
417: where B.CATALOG_ID = T.CATALOG_ID

Line 416: from DOM_DOCUMENT_CATEGORIES B

412: begin
413: delete from DOM_DOCUMENT_CATEGORIES_TL T
414: where not exists
415: (select NULL
416: from DOM_DOCUMENT_CATEGORIES B
417: where B.CATALOG_ID = T.CATALOG_ID
418: and B.CATEGORY_ID = T.CATEGORY_ID
419: );
420:

Line 421: update DOM_DOCUMENT_CATEGORIES_TL T set (

417: where B.CATALOG_ID = T.CATALOG_ID
418: and B.CATEGORY_ID = T.CATEGORY_ID
419: );
420:
421: update DOM_DOCUMENT_CATEGORIES_TL T set (
422: NAME,
423: DESCRIPTION
424: ) = (select
425: B.NAME,

Line 427: from DOM_DOCUMENT_CATEGORIES_TL B

423: DESCRIPTION
424: ) = (select
425: B.NAME,
426: B.DESCRIPTION
427: from DOM_DOCUMENT_CATEGORIES_TL B
428: where B.CATALOG_ID = T.CATALOG_ID
429: and B.CATEGORY_ID = T.CATEGORY_ID
430: and B.LANGUAGE = T.SOURCE_LANG)
431: where (

Line 439: from DOM_DOCUMENT_CATEGORIES_TL SUBB, DOM_DOCUMENT_CATEGORIES_TL SUBT

435: ) in (select
436: SUBT.CATALOG_ID,
437: SUBT.CATEGORY_ID,
438: SUBT.LANGUAGE
439: from DOM_DOCUMENT_CATEGORIES_TL SUBB, DOM_DOCUMENT_CATEGORIES_TL SUBT
440: where SUBB.CATALOG_ID = SUBT.CATALOG_ID
441: and SUBB.CATEGORY_ID = SUBT.CATEGORY_ID
442: and SUBB.LANGUAGE = SUBT.SOURCE_LANG
443: and (SUBB.NAME <> SUBT.NAME

Line 449: insert into DOM_DOCUMENT_CATEGORIES_TL (

445: or (SUBB.DESCRIPTION is null and SUBT.DESCRIPTION is not null)
446: or (SUBB.DESCRIPTION is not null and SUBT.DESCRIPTION is null)
447: ));
448:
449: insert into DOM_DOCUMENT_CATEGORIES_TL (
450: LAST_UPDATE_LOGIN,
451: CATALOG_ID,
452: CATEGORY_ID,
453: NAME,

Line 473: from DOM_DOCUMENT_CATEGORIES_TL B, FND_LANGUAGES L

469: B.LAST_UPDATE_DATE,
470: B.LAST_UPDATED_BY,
471: L.LANGUAGE_CODE,
472: B.SOURCE_LANG
473: from DOM_DOCUMENT_CATEGORIES_TL B, FND_LANGUAGES L
474: where L.INSTALLED_FLAG in ('I', 'B')
475: and B.LANGUAGE = userenv('LANG')
476: and not exists
477: (select NULL

Line 478: from DOM_DOCUMENT_CATEGORIES_TL T

474: where L.INSTALLED_FLAG in ('I', 'B')
475: and B.LANGUAGE = userenv('LANG')
476: and not exists
477: (select NULL
478: from DOM_DOCUMENT_CATEGORIES_TL T
479: where T.CATALOG_ID = B.CATALOG_ID
480: and T.CATEGORY_ID = B.CATEGORY_ID
481: and T.LANGUAGE = L.LANGUAGE_CODE);
482: end ADD_LANGUAGE;

Line 484: end DOM_DOCUMENT_CATEGORIES_PKG;

480: and T.CATEGORY_ID = B.CATEGORY_ID
481: and T.LANGUAGE = L.LANGUAGE_CODE);
482: end ADD_LANGUAGE;
483:
484: end DOM_DOCUMENT_CATEGORIES_PKG;