APPS.AHL_MC_TREE_PVT dependencies on AHL_MC_PATH_POSITION_PVT

Line 48: RETURN AHL_MC_PATH_POSITION_PVT.Path_Position_Tbl_Type;

44: FUNCTION Decode_Pos_Path
45: (
46: p_encoded_path IN VARCHAR2
47: )
48: RETURN AHL_MC_PATH_POSITION_PVT.Path_Position_Tbl_Type;
49:
50: PROCEDURE Get_nodes_for_parent(
51: -- p_end_date IN DATE,
52: p_relationship_id IN NUMBER,

Line 174: l_pos_path_tbl AHL_MC_PATH_POSITION_PVT.Path_Position_Tbl_Type;

170: l_pos_ref_code VARCHAR2(30);
171: l_pos_ref_meaning VARCHAR2(80);
172: l_ret_val BOOLEAN;
173: l_active_end_date DATE;
174: l_pos_path_tbl AHL_MC_PATH_POSITION_PVT.Path_Position_Tbl_Type;
175:
176: -- SATHAPLI::Bug 8363349, 16-Apr-2009, MC tree perf issue
177: -- Nodes_list_for_parent Nodes_for_parent_ref_csr;
178: l_Nodes_for_parent_tbl Nodes_for_parent_tbl;

Line 356: l_tree_node_rec.POSITION_PATH := AHL_MC_PATH_POSITION_PVT.get_encoded_path

352: -- l_tree_node_rec.IS_SUBCONFIG_TOPNODE := 'T';
353: l_tree_node_rec.IS_SUBCONFIG_TOPNODE := 'F';
354:
355: -- Populate position path
356: l_tree_node_rec.POSITION_PATH := AHL_MC_PATH_POSITION_PVT.get_encoded_path
357: (
358: p_parent_pos_path,
359: l_tree_node_rec.MC_ID,
360: l_tree_node_rec.VERSION_NUMBER,

Line 375: l_tree_node_rec.POSITION_PATH := AHL_MC_PATH_POSITION_PVT.get_encoded_path

371: -- Populate position path
372: l_tree_node_rec.POSITION_PATH := to_char(l_tree_node_rec.MC_ID)||':'||to_char(l_tree_node_rec.VERSION_NUMBER)||':'||l_tree_node_rec.POSITION_KEY;
373: ELSE
374: -- Populate position path
375: l_tree_node_rec.POSITION_PATH := AHL_MC_PATH_POSITION_PVT.get_encoded_path
376: (
377: p_parent_pos_path,
378: l_tree_node_rec.MC_ID,
379: l_tree_node_rec.VERSION_NUMBER,

Line 414: l_pos_ref_code := AHL_MC_PATH_POSITION_PVT.get_posref_by_path(l_pos_path_tbl, FND_API.G_TRUE);

410: -- Decode the retrieved position path to a position path table, since the input to get_posref_by_path is a position path table
411: l_pos_path_tbl := Decode_Pos_Path(l_tree_node_rec.POSITION_PATH);
412:
413: -- Retrieve the position path specific position reference code, retrieves default position reference if no position path has already been created
414: l_pos_ref_code := AHL_MC_PATH_POSITION_PVT.get_posref_by_path(l_pos_path_tbl, FND_API.G_TRUE);
415:
416: AHL_UTIL_MC_PKG.Convert_To_LookupMeaning
417: (
418: 'AHL_POSITION_REFERENCE',

Line 556: RETURN AHL_MC_PATH_POSITION_PVT.Path_Position_Tbl_Type

552: FUNCTION Decode_Pos_Path
553: (
554: p_encoded_path IN VARCHAR2
555: )
556: RETURN AHL_MC_PATH_POSITION_PVT.Path_Position_Tbl_Type
557: IS
558:
559: G_NODE_SEP VARCHAR2(1) := '/';
560: G_ID_SEP VARCHAR2(1) := ':';

Line 570: l_position_tbl AHL_MC_PATH_POSITION_PVT.Path_Position_Tbl_Type;

566: l_id_start NUMBER := 0;
567: l_id_end NUMBER := 0;
568: l_id_str VARCHAR2(10);
569:
570: l_position_tbl AHL_MC_PATH_POSITION_PVT.Path_Position_Tbl_Type;
571: l_tbl_idx NUMBER := 0;
572:
573: BEGIN
574: