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.12020000.3 2013/02/08 19:04:38 bpulivar ship $*/
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.12020000.3 2013/02/08 19:04:38 bpulivar ship $*/
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 764: l_err_string := 'ICX_CAT_POPULATE_REQTMPL_PVT.populateReqTemplates' ||l_err_loc

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

Line 885: IF (NOT ICX_CAT_POPULATE_REQTMPL_PVT.g_metadataTblFormed) THEN

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

Line 897: ICX_CAT_POPULATE_REQTMPL_PVT.g_metadataTblFormed := TRUE;

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

Line 901: IF (NOT ICX_CAT_POPULATE_REQTMPL_PVT.g_CtxSqlForPODocsFormed) THEN

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

Line 915: ICX_CAT_POPULATE_REQTMPL_PVT.g_CtxSqlForPODocsFormed := TRUE;

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

Line 932: END ICX_CAT_POPULATE_REQTMPL_PVT;

928: RAISE;
929: END buildCtxSqlForRTs;
930:
931:
932: END ICX_CAT_POPULATE_REQTMPL_PVT;