DBA Data[Home] [Help]

APPS.AHL_UMP_PROCESSUNIT_PVT dependencies on AHL_FMP_PVT

Line 381: -- instead of calling procedure AHL_FMP_PVT.GET_MR_AFFECTED_ITEMS,

377: -- from ahl_unit_effectivities_b.
378: PROCEDURE Assign_Unit_effectivity_IDs;
379:
380: -- Fix for Prev. Maint. performance bug# 5093064.
381: -- instead of calling procedure AHL_FMP_PVT.GET_MR_AFFECTED_ITEMS,
382: -- write PM effectivity logic in this procedure.
383: PROCEDURE Process_PM_MR_Affected_Items(p_commit IN VARCHAR2 := FND_API.G_FALSE,
384: x_msg_count OUT NOCOPY NUMBER,
385: x_msg_data OUT NOCOPY VARCHAR2,

Line 8181: l_appl_activities_tbl AHL_FMP_PVT.applicable_activities_tbl_type;

8177: x_UnSch_programs_tbl OUT NOCOPY PMprogram_tbl_type)
8178:
8179: IS
8180: l_api_version CONSTANT NUMBER := 1.0;
8181: l_appl_activities_tbl AHL_FMP_PVT.applicable_activities_tbl_type;
8182: l_appl_programs_tbl AHL_FMP_PVT.applicable_programs_tbl_type;
8183: l_pm_install_flag VARCHAR2(1);
8184:
8185: l_duplicate_pgm_flag BOOLEAN;

Line 8182: l_appl_programs_tbl AHL_FMP_PVT.applicable_programs_tbl_type;

8178:
8179: IS
8180: l_api_version CONSTANT NUMBER := 1.0;
8181: l_appl_activities_tbl AHL_FMP_PVT.applicable_activities_tbl_type;
8182: l_appl_programs_tbl AHL_FMP_PVT.applicable_programs_tbl_type;
8183: l_pm_install_flag VARCHAR2(1);
8184:
8185: l_duplicate_pgm_flag BOOLEAN;
8186: l_pgm_index NUMBER;

Line 8198: AHL_FMP_PVT.get_pm_applicable_mrs(

8194: AHL_DEBUG_PUB.debug('Start of PopulatePM_Appl_MRs');
8195: END IF;
8196:
8197: -- call api to fetch all applicable mrs for PM installation.
8198: AHL_FMP_PVT.get_pm_applicable_mrs(
8199: p_api_version => l_api_version,
8200: p_init_msg_list => FND_API.G_FALSE,
8201: p_commit => FND_API.G_FALSE,
8202: p_validation_level => FND_API.G_VALID_LEVEL_FULL,

Line 11756: -- Added procedure to replace call to ahl_fmp_pvt.get_mr_affected_items for Prev. Maint

11752:
11753: END validate_for_duedate_reset;
11754:
11755: -----------------------------------------------
11756: -- Added procedure to replace call to ahl_fmp_pvt.get_mr_affected_items for Prev. Maint
11757: -- Called when processing based on MR invoked through concurrent program.
11758: -- Perf fix for bug# 5093064.
11759: PROCEDURE Process_PM_MR_Affected_Items(
11760: p_commit IN VARCHAR2 := FND_API.G_FALSE,

Line 13847: l_mr_item_instances_tbl AHL_FMP_PVT.MR_ITEM_INSTANCE_TBL_TYPE;

13843:
13844: dml_errors EXCEPTION;
13845: PRAGMA EXCEPTION_INIT(dml_errors, -24381);
13846:
13847: l_mr_item_instances_tbl AHL_FMP_PVT.MR_ITEM_INSTANCE_TBL_TYPE;
13848:
13849: BEGIN
13850:
13851: IF G_debug = 'Y' THEN

Line 13862: AHL_FMP_PVT.GET_MR_AFFECTED_ITEMS (

13858: x_return_status := FND_API.G_RET_STS_SUCCESS;
13859:
13860: -- get instances applicable to the MR.
13861: -- this API will insert the applicable MRs into temp table ahl_mr_instances_temp
13862: AHL_FMP_PVT.GET_MR_AFFECTED_ITEMS (
13863: p_api_version => 1.0,
13864: p_init_msg_list => FND_API.G_TRUE,
13865: x_return_status => x_return_status,
13866: x_msg_count => l_msg_count,

Line 14429: l_appl_mrs_tbl AHL_FMP_PVT.applicable_mr_tbl_type;

14425: l_return_status VARCHAR2(1);
14426: l_msg_count NUMBER;
14427: l_msg_data VARCHAR2(2000);
14428:
14429: l_appl_mrs_tbl AHL_FMP_PVT.applicable_mr_tbl_type;
14430:
14431: BEGIN
14432:
14433: IF G_config_node_tbl.COUNT > 0 THEN

Line 14447: AHL_FMP_PVT.GET_MR_APPLICABILITY(p_api_version => 1.0,

14443: EXIT WHEN l_inst_id_tbl.count = 0;
14444:
14445: FOR j IN l_mr_id_tbl.FIRST..l_mr_id_tbl.LAST LOOP
14446: -- call FMP API to get MR effectivities
14447: AHL_FMP_PVT.GET_MR_APPLICABILITY(p_api_version => 1.0,
14448: p_init_msg_list => FND_API.G_FALSE,
14449: p_validation_level => FND_API.G_VALID_LEVEL_FULL,
14450: x_return_status => l_return_status,
14451: x_msg_count => l_msg_count,