APPS.ICX_CAT_POPULATE_CTXSTRING_PVT dependencies on ICX_CAT_POPULATE_CTXSTRING_PVT

Line 1: PACKAGE BODY ICX_CAT_POPULATE_CTXSTRING_PVT AS

1: PACKAGE BODY ICX_CAT_POPULATE_CTXSTRING_PVT AS
2: /* $Header: ICXVPCSB.pls 120.7 2006/08/14 23:26:36 rwidjaja noship $*/
3:
4: TYPE g_csr_type IS REF CURSOR;
5:

Line 7: G_PKG_NAME CONSTANT VARCHAR2(30) :='ICX_CAT_POPULATE_CTXSTRING_PVT';

3:
4: TYPE g_csr_type IS REF CURSOR;
5:
6: -- Constants
7: G_PKG_NAME CONSTANT VARCHAR2(30) :='ICX_CAT_POPULATE_CTXSTRING_PVT';
8: g_metadataTblFormed BOOLEAN := FALSE;
9: g_special_metadata_tbl ICX_CAT_BUILD_CTX_SQL_PVT.g_metadata_tbl_type;
10: g_regular_nontl_metadata_tbl ICX_CAT_BUILD_CTX_SQL_PVT.g_metadata_tbl_type;
11: g_regular_tl_metadata_tbl ICX_CAT_BUILD_CTX_SQL_PVT.g_metadata_tbl_type;

Line 1132: exec ICX_CAT_POPULATE_CTXSTRING_PVT.populateCtxString(ICX_CAT_UTIL_PVT.g_PODoc_const, -12, 'UPG', 2500)

1128: ICX_CAT_UTIL_PVT.g_MasterItemCsr_const VARCHAR2(15) := 'MASTER_ITEM';
1129: Values of p_mode:
1130: ICX_CAT_UTIL_PVT.g_upgrade_const VARCHAR2(15) := 'UPGRADE';
1131: ICX_CAT_UTIL_PVT.g_online_const VARCHAR2(15) := 'ONLINE';
1132: exec ICX_CAT_POPULATE_CTXSTRING_PVT.populateCtxString(ICX_CAT_UTIL_PVT.g_PODoc_const, -12, 'UPG', 2500)
1133: PROCEDURE populateCtxString
1134: ( p_doc_source IN VARCHAR2 ,
1135: p_internal_request_id IN NUMBER ,
1136: p_mode IN VARCHAR2 ,

Line 1454: l_err_string := 'ICX_CAT_POPULATE_CTXSTRING_PVT.updateItemsCtxHdrsTlp' ||l_err_loc;

1450: l_err_loc := 3100;
1451: EXIT WHEN l_rowid_tbl.COUNT < ICX_CAT_UTIL_PVT.g_batch_size;
1452: EXCEPTION
1453: WHEN ICX_CAT_UTIL_PVT.g_snap_shot_too_old THEN
1454: l_err_string := 'ICX_CAT_POPULATE_CTXSTRING_PVT.updateItemsCtxHdrsTlp' ||l_err_loc;
1455: ICX_CAT_UTIL_PVT.logAndCommitSnapShotTooOld(g_pkg_name, l_api_name, l_err_string);
1456: l_err_loc := 3200;
1457: CLOSE l_csr_var;
1458: l_err_loc := 3300;

Line 1921: l_err_string := 'ICX_CAT_POPULATE_CTXSTRING_PVT.handleCategoryRename' ||l_err_loc;

1917: l_err_loc := 1700;
1918: EXIT WHEN l_rowid_tbl.COUNT < ICX_CAT_UTIL_PVT.g_batch_size;
1919: EXCEPTION
1920: WHEN ICX_CAT_UTIL_PVT.g_snap_shot_too_old THEN
1921: l_err_string := 'ICX_CAT_POPULATE_CTXSTRING_PVT.handleCategoryRename' ||l_err_loc;
1922: ICX_CAT_UTIL_PVT.logAndCommitSnapShotTooOld(g_pkg_name, l_api_name, l_err_string);
1923: l_err_loc := 1800;
1924: CLOSE l_csr_var;
1925: l_err_loc := 1900;

Line 1965: END ICX_CAT_POPULATE_CTXSTRING_PVT;

1961: ICX_CAT_INTERMEDIA_INDEX_PVT.rebuild_index;
1962: RAISE;
1963: END handleCategoryRename;
1964:
1965: END ICX_CAT_POPULATE_CTXSTRING_PVT;