PACKAGE: APPS.ICX_POR_CTX_DESC

Source

1 PACKAGE ICX_POR_CTX_DESC AUTHID CURRENT_USER AS
2 /* $Header: ICXCGCDS.pls 115.5 2004/03/31 18:44:56 vkartik ship $*/
3 
4 TYPE item_Source_cv_type IS REF CURSOR;
5 TYPE CatCurTyp IS REF CURSOR;
6 BATCH_SIZE       NUMBER:= 5000;
7 
8 --
9 -- Cursor to fetch installed languages
10 --
11     CURSOR installed_languages_cur IS
12         select language_code
13         from fnd_languages
14         where installed_flag in ('B', 'I');
15 
16 PROCEDURE populateCtxDescAll(p_jobno IN INTEGER DEFAULT 0,
17                              p_rebuildAll in VARCHAR2 DEFAULT 'Y',
18                              p_log_type in VARCHAR2 DEFAULT 'CONCURRENT');
19 -- Bug # 3441668 : Overloaded version for concurrent request
20 PROCEDURE populateDescAll(errbuf OUT NOCOPY VARCHAR2,
21                           retcode OUT NOCOPY VARCHAR2,
22                           p_log_type in VARCHAR2 DEFAULT 'CONCURRENT');
23 PROCEDURE populateDescAll(p_log_type in VARCHAR2 DEFAULT 'CONCURRENT');
24 PROCEDURE populateBaseAttributes(pDeleteYN IN VARCHAR2 DEFAULT 'Y',
25   pUpdateYN IN VARCHAR2 DEFAULT 'Y', p_log_type IN VARCHAR2 DEFAULT 'LOADER');
26 PROCEDURE populateCategoryAttribsByJob( pJobNum IN INTEGER DEFAULT 0,
27   pDeleteYN IN VARCHAR2 DEFAULT 'Y',
28   pUpdateYN IN VARCHAR2 DEFAULT 'Y',
29   p_log_type IN VARCHAR2 DEFAULT 'LOADER');
30 PROCEDURE populateCategoryAttributes( pDeleteYN IN VARCHAR2 DEFAULT 'Y',
31   pUpdateYN IN VARCHAR2 DEFAULT 'Y',
32   p_log_type IN VARCHAR2 DEFAULT 'LOADER');
33 PROCEDURE populateCtxDescBaseAtt(pItemSourceCv IN item_source_cv_type,
34                                  pDeleteYN IN VARCHAR2 DEFAULT 'Y',
35                                  pUpdateYN IN VARCHAR2 DEFAULT 'Y',
36                                  pLanguage IN VARCHAR2 DEFAULT NULL,
37                                  pSourceType IN VARCHAR2 DEFAULT 'ROWID',
38                                  p_log_type IN VARCHAR2 DEFAULT 'LOADER');
39 PROCEDURE populateCtxDescCatAtt(pCategoryId IN NUMBER,
40                                  pItemSourceCursor IN NUMBER,
41                                  pDeleteYN IN VARCHAR2 DEFAULT 'Y',
42                                  pUpdateYN IN VARCHAR2 DEFAULT 'Y',
43                                  pLanguage IN VARCHAR2 DEFAULT NULL,
44                                  pSourceType IN VARCHAR2 DEFAULT 'ROWID',
45                                  p_log_type IN VARCHAR2 DEFAULT 'LOADER');
46 PROCEDURE populateCtxDescLang(p_item_id IN NUMBER,
47 			      p_category_id IN NUMBER,
48 			      p_lang IN VARCHAR2 DEFAULT NULL,
49                               p_log_type IN VARCHAR2 DEFAULT 'LOADER');
50 PROCEDURE populateBuyerInfo( pDeleteYN IN VARCHAR2 DEFAULT 'Y',
51   pUpdateYN IN VARCHAR2 DEFAULT 'Y', p_log_type IN VARCHAR2 default 'LOADER');
52 PROCEDURE populateCtxDescBuyerInfo(pItemSourceCv IN item_source_cv_type,
53                             pDeleteYN IN VARCHAR2 DEFAULT 'Y',
54                             pUpdateYN IN VARCHAR2 DEFAULT 'Y',
55                             pLanguage IN VARCHAR2 DEFAULT NULL,
56                             pSourceType IN VARCHAR2 DEFAULT 'ROWID',
57                             p_log_type IN VARCHAR2 DEFAULT 'LOADER');
58 
59 /*
60 ** Rebuild the search indexes by calling either the context index
61 ** rebuild package or the intermedia package.
62 */
63 
64 PROCEDURE rebuild_indexes;
65 
66 
67 END ICX_POR_CTX_DESC;