APPS.AHL_FMP_PVT dependencies on AHL_MC_PATH_POSITION_PVT

Line 813: AHL_MC_PATH_POSITION_PVT.map_position_to_instances

809: EXIT WHEN check_mr_effect%NOTFOUND ;
810:
811: IF l_mr_effect.relationship_id IS NOT NULL
812: THEN
813: AHL_MC_PATH_POSITION_PVT.map_position_to_instances
814: (
815: p_api_version =>p_api_version,
816: p_init_msg_list =>FND_API.G_FALSE,
817: p_commit =>FND_API.G_FALSE,

Line 2399: AHL_MC_PATH_POSITION_PVT.map_instance_to_positions

2395: END IF;
2396:
2397: DELETE FROM ahl_applicable_instances;
2398: -- for input instance.
2399: AHL_MC_PATH_POSITION_PVT.map_instance_to_positions
2400: (
2401: p_api_version => 1.0,
2402: p_init_msg_list => fnd_api.g_false,
2403: p_commit => fnd_api.g_false,

Line 2429: AHL_MC_PATH_POSITION_PVT.map_instance_to_positions

2425: FETCH get_config_tree_csr BULK COLLECT INTO l_subj_id_tbl LIMIT l_buffer_limit;
2426: EXIT WHEN l_subj_id_tbl.COUNT = 0;
2427:
2428: FOR j IN l_subj_id_tbl.FIRST..l_subj_id_tbl.LAST LOOP
2429: AHL_MC_PATH_POSITION_PVT.map_instance_to_positions
2430: (
2431: p_api_version => 1.0,
2432: p_init_msg_list => fnd_api.g_false,
2433: p_commit => fnd_api.g_false,

Line 3261: l_path_tbl AHL_MC_PATH_POSITION_PVT.Path_Position_Tbl_Type;

3257: l_msg_data VARCHAR2(2000);
3258: l_inst_path_pos_id NUMBER;
3259: l_inst_encoded_path AHL_MC_PATH_POSITIONS.ENCODED_PATH_POSITION%TYPE;
3260: l_input_encoded_path AHL_MC_PATH_POSITIONS.ENCODED_PATH_POSITION%TYPE;
3261: l_path_tbl AHL_MC_PATH_POSITION_PVT.Path_Position_Tbl_Type;
3262: l_path_rec AHL_MC_PATH_POSITION_PVT.Path_Position_Rec_Type;
3263: l_unit_csi_id NUMBER;
3264: l_index NUMBER;
3265:

Line 3262: l_path_rec AHL_MC_PATH_POSITION_PVT.Path_Position_Rec_Type;

3258: l_inst_path_pos_id NUMBER;
3259: l_inst_encoded_path AHL_MC_PATH_POSITIONS.ENCODED_PATH_POSITION%TYPE;
3260: l_input_encoded_path AHL_MC_PATH_POSITIONS.ENCODED_PATH_POSITION%TYPE;
3261: l_path_tbl AHL_MC_PATH_POSITION_PVT.Path_Position_Tbl_Type;
3262: l_path_rec AHL_MC_PATH_POSITION_PVT.Path_Position_Rec_Type;
3263: l_unit_csi_id NUMBER;
3264: l_index NUMBER;
3265:
3266: --Fetches lowest level info

Line 3336: -- NOTE: The following lines of code are reproduced from AHL_MC_PATH_POSITION_PVT.Map_Instance_To_Pos_ID

3332: RETURN l_return_value;
3333: END IF;
3334:
3335: -- Get the version specific encoded path position for the instance
3336: -- NOTE: The following lines of code are reproduced from AHL_MC_PATH_POSITION_PVT.Map_Instance_To_Pos_ID
3337: -- However AHL_MC_PATH_POSITION_PVT.Map_Instance_To_Pos_ID itself cannot be used directly
3338: -- since it also updates the db by creating a path position if it does not exist and this is not
3339: -- acceptable if this function is to be called from a Select statement.
3340: --Fetch the position informations for the instance

Line 3337: -- However AHL_MC_PATH_POSITION_PVT.Map_Instance_To_Pos_ID itself cannot be used directly

3333: END IF;
3334:
3335: -- Get the version specific encoded path position for the instance
3336: -- NOTE: The following lines of code are reproduced from AHL_MC_PATH_POSITION_PVT.Map_Instance_To_Pos_ID
3337: -- However AHL_MC_PATH_POSITION_PVT.Map_Instance_To_Pos_ID itself cannot be used directly
3338: -- since it also updates the db by creating a path position if it does not exist and this is not
3339: -- acceptable if this function is to be called from a Select statement.
3340: --Fetch the position informations for the instance
3341: OPEN get_last_uc_rec_csr(p_instance_id);

Line 3375: -- End reproduction from AHL_MC_PATH_POSITION_PVT.Map_Instance_To_Pos_ID

3371: CLOSE get_top_unit_inst_csr;
3372: END IF;
3373: CLOSE get_last_uc_rec_csr;
3374:
3375: -- End reproduction from AHL_MC_PATH_POSITION_PVT.Map_Instance_To_Pos_ID
3376:
3377: IF (fnd_log.level_statement >= fnd_log.g_current_runtime_level) THEN
3378: fnd_log.string(fnd_log.level_statement, l_full_name,
3379: 'l_path_tbl.COUNT = ' || l_path_tbl.COUNT);

Line 4870: AHL_MC_PATH_POSITION_PVT.map_instance_to_positions

4866: END IF;
4867:
4868: DELETE FROM ahl_applicable_instances;
4869: -- for input instance.
4870: AHL_MC_PATH_POSITION_PVT.map_instance_to_positions
4871: (
4872: p_api_version => 1.0,
4873: p_init_msg_list => fnd_api.g_false,
4874: p_commit => fnd_api.g_false,

Line 4900: AHL_MC_PATH_POSITION_PVT.map_instance_to_positions

4896: FETCH get_config_tree_csr BULK COLLECT INTO l_subj_id_tbl LIMIT l_buffer_limit;
4897: EXIT WHEN l_subj_id_tbl.COUNT = 0;
4898:
4899: FOR j IN l_subj_id_tbl.FIRST..l_subj_id_tbl.LAST LOOP
4900: AHL_MC_PATH_POSITION_PVT.map_instance_to_positions
4901: (
4902: p_api_version => 1.0,
4903: p_init_msg_list => fnd_api.g_false,
4904: p_commit => fnd_api.g_false,