DBA Data[Home] [Help]

APPS.AHL_UMP_PROCESSUNIT_PVT dependencies on AHL_UMP_PROCESSUNIT_PVT

Line 1: PACKAGE BODY AHL_UMP_PROCESSUNIT_PVT AS

1: PACKAGE BODY AHL_UMP_PROCESSUNIT_PVT AS
2: /* $Header: AHLVUMUB.pls 120.35.12020000.3 2013/04/01 02:58:59 sracha ship $ */
3:
4: G_PKG_NAME CONSTANT VARCHAR2(30) := 'AHL_UMP_ProcessUnit_PVT';
5: G_DEBUG VARCHAR2(1) := AHL_DEBUG_PUB.is_log_enabled;

Line 4: G_PKG_NAME CONSTANT VARCHAR2(30) := 'AHL_UMP_ProcessUnit_PVT';

1: PACKAGE BODY AHL_UMP_PROCESSUNIT_PVT AS
2: /* $Header: AHLVUMUB.pls 120.35.12020000.3 2013/04/01 02:58:59 sracha ship $ */
3:
4: G_PKG_NAME CONSTANT VARCHAR2(30) := 'AHL_UMP_ProcessUnit_PVT';
5: G_DEBUG VARCHAR2(1) := AHL_DEBUG_PUB.is_log_enabled;
6: G_IS_PM_INSTALLED CONSTANT VARCHAR2(1) := AHL_UTIL_PKG.IS_PM_INSTALLED;
7:
8: G_CONCURRENT_FLAG VARCHAR2(1);

Line 161: x_config_node_tbl OUT NOCOPY AHL_UMP_PROCESSUNIT_PVT.config_node_tbl_type);

157:
158: -- Build the item instance tree containing root nodes and its components.
159: PROCEDURE Build_Config_Tree(p_csi_root_instance_id IN NUMBER,
160: p_master_config_id IN NUMBER,
161: x_config_node_tbl OUT NOCOPY AHL_UMP_PROCESSUNIT_PVT.config_node_tbl_type);
162:
163:
164: -- To get the last day of the rolling window from profile values.
165: FUNCTION Get_Rolling_Window_Date RETURN DATE;

Line 599: G_config_node_tbl AHL_UMP_PROCESSUNIT_PVT.config_node_tbl_type;

595:
596: ------------------------------
597: -- Declare global variables --
598: ------------------------------
599: G_config_node_tbl AHL_UMP_PROCESSUNIT_PVT.config_node_tbl_type;
600: -- This variable holds all the item instances that are contained in a configuration.
601: -- For AHL installation, this will hold the top node and all of its components.
602: -- For PM installation, this will contain only one item instance, because each
603: -- component of a configuration is processed as a unit for this case.

Line 673: l_config_node_tbl AHL_UMP_PROCESSUNIT_PVT.config_node_tbl_type;

669: -- This variable holds the Root item instance id.
670: -- For AHL installation, this is the root item instance of the input parameter p_csi_item_instance_id
671: -- For PM installation, this is the item instance input to this procedure(i.e p_csi_item_instance_id).
672:
673: l_config_node_tbl AHL_UMP_PROCESSUNIT_PVT.config_node_tbl_type;
674: l_forecast_details_tbl forecast_details_tbl_type;
675:
676: l_UnSch_programs_tbl PMprogram_tbl_type;
677: -- contains programs and their effectivities.

Line 1377: AHL_UMP_ProcessUnit_PVT.Process_Unit

1373: THEN
1374: IF (p_concurrent_flag = 'Y') THEN
1375: fnd_file.put_line(fnd_file.log, 'Calling Process_Unit for instance: ' || l_ent_cont_tbl(i).coverage_level_id);
1376: END IF;
1377: AHL_UMP_ProcessUnit_PVT.Process_Unit
1378: (
1379: p_commit => l_commit,
1380: x_msg_count => x_msg_count,
1381: x_msg_data => x_msg_data,

Line 1767: x_config_node_tbl OUT NOCOPY AHL_UMP_PROCESSUNIT_PVT.config_node_tbl_type)

1763: -- Validate the input item instance.
1764:
1765: PROCEDURE Build_Config_Tree(p_csi_root_instance_id IN NUMBER,
1766: p_master_config_id IN NUMBER,
1767: x_config_node_tbl OUT NOCOPY AHL_UMP_PROCESSUNIT_PVT.config_node_tbl_type)
1768:
1769: IS
1770:
1771: CURSOR csi_config_tree_csr ( p_csi_root_instance_id IN NUMBER) IS

Line 1785: l_config_node_tbl AHL_UMP_PROCESSUNIT_PVT.config_node_tbl_type := x_config_node_tbl;

1781: AND trunc(sysdate) < trunc(nvl(active_end_date, sysdate+1))
1782: ORDER BY level;
1783:
1784: i NUMBER;
1785: l_config_node_tbl AHL_UMP_PROCESSUNIT_PVT.config_node_tbl_type := x_config_node_tbl;
1786:
1787: -- added for perf fix for bug# 6893404.
1788: l_buffer_limit number := 1000;
1789:

Line 11848: AHL_DEBUG_PUB.debug('Begin private API: AHL_UMP_PROCESSUNIT_PVT.PROCESS_PM_MR_AFFECTED_ITEMS');

11844: BEGIN
11845:
11846: IF l_debug = 'Y' THEN
11847: AHL_DEBUG_PUB.enable_debug;
11848: AHL_DEBUG_PUB.debug('Begin private API: AHL_UMP_PROCESSUNIT_PVT.PROCESS_PM_MR_AFFECTED_ITEMS');
11849: END IF;
11850:
11851: -- Check whether the mr_header_id exists --
11852: OPEN check_mr_exists(p_mr_header_id);

Line 12731: AHL_UMP_PROCESSUNIT_PVT.Process_MRAffected_Units (

12727: -- initialize return status.
12728: retcode := 0;
12729:
12730: -- After commit call UMP BUE api to build UEs.
12731: AHL_UMP_PROCESSUNIT_PVT.Process_MRAffected_Units (
12732: p_commit => FND_API.G_TRUE,
12733: x_msg_count => l_msg_count,
12734: x_msg_data => l_msg_data,
12735: x_return_status => l_return_status, -- ignore status returned by this api.

Line 13452: errbuf := 'AHL_UMP_ProcessUnit_Pvt.Process.Get_Next_BUE_Row:' || SUBSTR(SQLERRM,1,240);

13448:
13449: EXCEPTION
13450: WHEN OTHERS THEN
13451: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
13452: errbuf := 'AHL_UMP_ProcessUnit_Pvt.Process.Get_Next_BUE_Row:' || SUBSTR(SQLERRM,1,240);
13453: x_item_instance_id := NULL;
13454:
13455: END Get_Next_BUE_Row;
13456:

Line 13650: x_errbuf := 'AHL_UMP_ProcessUnit_Pvt.Process.Cleanup_BUE_Worker:line:' || G_DEBUG_LINE_NUM || ':' || SUBSTR(SQLERRM,1,240);

13646:
13647: WHEN OTHERS THEN
13648: ROLLBACK;
13649: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
13650: x_errbuf := 'AHL_UMP_ProcessUnit_Pvt.Process.Cleanup_BUE_Worker:line:' || G_DEBUG_LINE_NUM || ':' || SUBSTR(SQLERRM,1,240);
13651:
13652: END Cleanup_BUE_Worker;
13653:
13654: -- Added for performance bug# 6893404.

Line 16472: END AHL_UMP_ProcessUnit_PVT;

16468:
16469: END Calculate_NR_due_date;
16470: --------------------------
16471:
16472: END AHL_UMP_ProcessUnit_PVT;