APPS.ICX_CAT_POPULATE_REQTMPL_PVT dependencies on ICX_CAT_POPULATE_REQTMPL_PVT

Line 1: PACKAGE BODY ICX_CAT_POPULATE_REQTMPL_PVT AS

1: PACKAGE BODY ICX_CAT_POPULATE_REQTMPL_PVT AS
2: /* $Header: ICXVPPRB.pls 120.10 2006/10/06 02:43:55 rwidjaja noship $*/
3:
4: -- Constants
5: G_PKG_NAME CONSTANT VARCHAR2(30) :='ICX_CAT_POPULATE_REQTMPL_PVT';

Line 5: G_PKG_NAME CONSTANT VARCHAR2(30) :='ICX_CAT_POPULATE_REQTMPL_PVT';

1: PACKAGE BODY ICX_CAT_POPULATE_REQTMPL_PVT AS
2: /* $Header: ICXVPPRB.pls 120.10 2006/10/06 02:43:55 rwidjaja noship $*/
3:
4: -- Constants
5: G_PKG_NAME CONSTANT VARCHAR2(30) :='ICX_CAT_POPULATE_REQTMPL_PVT';
6: g_upgrade_last_run_date DATE;
7: g_key NUMBER;
8: g_start_rowid ROWID;
9: g_end_rowid ROWID;

Line 761: l_err_string := 'ICX_CAT_POPULATE_REQTMPL_PVT.populateReqTemplates' ||l_err_loc

757: l_err_loc := 1400;
758: EXIT WHEN l_inv_item_id_tbl.COUNT < ICX_CAT_UTIL_PVT.g_batch_size;
759: EXCEPTION
760: WHEN ICX_CAT_UTIL_PVT.g_snap_shot_too_old THEN
761: l_err_string := 'ICX_CAT_POPULATE_REQTMPL_PVT.populateReqTemplates' ||l_err_loc
762: ||', Total processeded batches:' ||l_batch_count
763: ||', Cursor will be reopened with TBD TBD:' ;
764: IF (FND_API.To_Boolean(ICX_CAT_UTIL_PVT.g_COMMIT)) THEN
765: ICX_CAT_UTIL_PVT.logAndCommitSnapShotTooOld(g_pkg_name, l_api_name, l_err_string);

Line 882: IF (NOT ICX_CAT_POPULATE_REQTMPL_PVT.g_metadataTblFormed) THEN

878: l_api_name CONSTANT VARCHAR2(30) := 'buildCtxSqlForRTs';
879: l_err_loc PLS_INTEGER;
880: BEGIN
881: l_err_loc := 100;
882: IF (NOT ICX_CAT_POPULATE_REQTMPL_PVT.g_metadataTblFormed) THEN
883: IF (FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
884: FND_LOG.string(FND_LOG.LEVEL_STATEMENT,
885: ICX_CAT_UTIL_PVT.getModuleNameForDebug(g_pkg_name, l_api_name),
886: 'about to call buildmetadatinfo');

Line 894: ICX_CAT_POPULATE_REQTMPL_PVT.g_metadataTblFormed := TRUE;

890: ICX_CAT_BUILD_CTX_SQL_PVT.buildMetadataInfo
891: (0, g_special_metadata_tbl, g_regular_nontl_metadata_tbl, g_regular_tl_metadata_tbl);
892:
893: l_err_loc := 300;
894: ICX_CAT_POPULATE_REQTMPL_PVT.g_metadataTblFormed := TRUE;
895: END IF;
896:
897: l_err_loc := 400;
898: IF (NOT ICX_CAT_POPULATE_REQTMPL_PVT.g_CtxSqlForPODocsFormed) THEN

Line 898: IF (NOT ICX_CAT_POPULATE_REQTMPL_PVT.g_CtxSqlForPODocsFormed) THEN

894: ICX_CAT_POPULATE_REQTMPL_PVT.g_metadataTblFormed := TRUE;
895: END IF;
896:
897: l_err_loc := 400;
898: IF (NOT ICX_CAT_POPULATE_REQTMPL_PVT.g_CtxSqlForPODocsFormed) THEN
899: IF (FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
900: FND_LOG.string(FND_LOG.LEVEL_STATEMENT,
901: ICX_CAT_UTIL_PVT.getModuleNameForDebug(g_pkg_name, l_api_name),
902: 'about to call buildctxsql');

Line 912: ICX_CAT_POPULATE_REQTMPL_PVT.g_CtxSqlForPODocsFormed := TRUE;

908: g_regular_nontl_metadata_tbl, g_regular_tl_metadata_tbl,
909: g_all_ctx_sql_tbl, g_special_ctx_sql_tbl, g_regular_ctx_sql_tbl);
910:
911: l_err_loc := 600;
912: ICX_CAT_POPULATE_REQTMPL_PVT.g_CtxSqlForPODocsFormed := TRUE;
913: END IF;
914:
915: l_err_loc := 700;
916: p_special_ctx_sql_tbl := g_special_ctx_sql_tbl;

Line 929: END ICX_CAT_POPULATE_REQTMPL_PVT;

925: RAISE;
926: END buildCtxSqlForRTs;
927:
928:
929: END ICX_CAT_POPULATE_REQTMPL_PVT;