APPS.AHL_FMP_PVT dependencies on AHL_MC_PATH_POSITION_PVT

Line 721: AHL_MC_PATH_POSITION_PVT.map_position_to_instances

717: EXIT WHEN check_mr_effect%NOTFOUND ;
718:
719: IF l_mr_effect.relationship_id IS NOT NULL
720: THEN
721: AHL_MC_PATH_POSITION_PVT.map_position_to_instances
722: (
723: p_api_version =>p_api_version,
724: p_init_msg_list =>FND_API.G_FALSE,
725: p_commit =>FND_API.G_FALSE,

Line 1926: AHL_MC_PATH_POSITION_PVT.map_instance_to_positions

1922: END IF;
1923:
1924: DELETE FROM ahl_applicable_instances;
1925: -- for input instance.
1926: AHL_MC_PATH_POSITION_PVT.map_instance_to_positions
1927: (
1928: p_api_version => 1.0,
1929: p_init_msg_list => fnd_api.g_false,
1930: p_commit => fnd_api.g_false,

Line 1956: AHL_MC_PATH_POSITION_PVT.map_instance_to_positions

1952: FETCH get_config_tree_csr BULK COLLECT INTO l_subj_id_tbl LIMIT l_buffer_limit;
1953: EXIT WHEN l_subj_id_tbl.COUNT = 0;
1954:
1955: FOR j IN l_subj_id_tbl.FIRST..l_subj_id_tbl.LAST LOOP
1956: AHL_MC_PATH_POSITION_PVT.map_instance_to_positions
1957: (
1958: p_api_version => 1.0,
1959: p_init_msg_list => fnd_api.g_false,
1960: p_commit => fnd_api.g_false,

Line 2518: l_path_tbl AHL_MC_PATH_POSITION_PVT.Path_Position_Tbl_Type;

2514: l_msg_data VARCHAR2(2000);
2515: l_inst_path_pos_id NUMBER;
2516: l_inst_encoded_path AHL_MC_PATH_POSITIONS.ENCODED_PATH_POSITION%TYPE;
2517: l_input_encoded_path AHL_MC_PATH_POSITIONS.ENCODED_PATH_POSITION%TYPE;
2518: l_path_tbl AHL_MC_PATH_POSITION_PVT.Path_Position_Tbl_Type;
2519: l_path_rec AHL_MC_PATH_POSITION_PVT.Path_Position_Rec_Type;
2520: l_unit_csi_id NUMBER;
2521: l_index NUMBER;
2522:

Line 2519: l_path_rec AHL_MC_PATH_POSITION_PVT.Path_Position_Rec_Type;

2515: l_inst_path_pos_id NUMBER;
2516: l_inst_encoded_path AHL_MC_PATH_POSITIONS.ENCODED_PATH_POSITION%TYPE;
2517: l_input_encoded_path AHL_MC_PATH_POSITIONS.ENCODED_PATH_POSITION%TYPE;
2518: l_path_tbl AHL_MC_PATH_POSITION_PVT.Path_Position_Tbl_Type;
2519: l_path_rec AHL_MC_PATH_POSITION_PVT.Path_Position_Rec_Type;
2520: l_unit_csi_id NUMBER;
2521: l_index NUMBER;
2522:
2523: --Fetches lowest level info

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

2589: RETURN l_return_value;
2590: END IF;
2591:
2592: -- Get the version specific encoded path position for the instance
2593: -- NOTE: The following lines of code are reproduced from AHL_MC_PATH_POSITION_PVT.Map_Instance_To_Pos_ID
2594: -- However AHL_MC_PATH_POSITION_PVT.Map_Instance_To_Pos_ID itself cannot be used directly
2595: -- since it also updates the db by creating a path position if it does not exist and this is not
2596: -- acceptable if this function is to be called from a Select statement.
2597: --Fetch the position informations for the instance

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

2590: END IF;
2591:
2592: -- Get the version specific encoded path position for the instance
2593: -- NOTE: The following lines of code are reproduced from AHL_MC_PATH_POSITION_PVT.Map_Instance_To_Pos_ID
2594: -- However AHL_MC_PATH_POSITION_PVT.Map_Instance_To_Pos_ID itself cannot be used directly
2595: -- since it also updates the db by creating a path position if it does not exist and this is not
2596: -- acceptable if this function is to be called from a Select statement.
2597: --Fetch the position informations for the instance
2598: OPEN get_last_uc_rec_csr(p_instance_id);

Line 2632: -- End reproduction from AHL_MC_PATH_POSITION_PVT.Map_Instance_To_Pos_ID

2628: CLOSE get_top_unit_inst_csr;
2629: END IF;
2630: CLOSE get_last_uc_rec_csr;
2631:
2632: -- End reproduction from AHL_MC_PATH_POSITION_PVT.Map_Instance_To_Pos_ID
2633:
2634: IF (fnd_log.level_statement >= fnd_log.g_current_runtime_level) THEN
2635: fnd_log.string(fnd_log.level_statement, l_full_name,
2636: 'l_path_tbl.COUNT = ' || l_path_tbl.COUNT);