APPS.AHL_MC_TREE_PVT dependencies on AHL_MC_PATH_POSITION_PVT

Line 47: RETURN AHL_MC_PATH_POSITION_PVT.Path_Position_Tbl_Type;

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

Line 171: l_pos_path_tbl AHL_MC_PATH_POSITION_PVT.Path_Position_Tbl_Type;

167: l_pos_ref_code VARCHAR2(30);
168: l_pos_ref_meaning VARCHAR2(80);
169: l_ret_val BOOLEAN;
170: l_active_end_date DATE;
171: l_pos_path_tbl AHL_MC_PATH_POSITION_PVT.Path_Position_Tbl_Type;
172: Nodes_list_for_parent Nodes_for_parent_ref_csr;
173:
174: BEGIN
175:

Line 316: l_tree_node_rec.POSITION_PATH := AHL_MC_PATH_POSITION_PVT.get_encoded_path

312: -- l_tree_node_rec.IS_SUBCONFIG_TOPNODE := 'T';
313: l_tree_node_rec.IS_SUBCONFIG_TOPNODE := 'F';
314:
315: -- Populate position path
316: l_tree_node_rec.POSITION_PATH := AHL_MC_PATH_POSITION_PVT.get_encoded_path
317: (
318: p_parent_pos_path,
319: l_tree_node_rec.MC_ID,
320: l_tree_node_rec.VERSION_NUMBER,

Line 335: l_tree_node_rec.POSITION_PATH := AHL_MC_PATH_POSITION_PVT.get_encoded_path

331: -- Populate position path
332: 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;
333: ELSE
334: -- Populate position path
335: l_tree_node_rec.POSITION_PATH := AHL_MC_PATH_POSITION_PVT.get_encoded_path
336: (
337: p_parent_pos_path,
338: l_tree_node_rec.MC_ID,
339: l_tree_node_rec.VERSION_NUMBER,

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

370: -- Decode the retrieved position path to a position path table, since the input to get_posref_by_path is a position path table
371: l_pos_path_tbl := Decode_Pos_Path(l_tree_node_rec.POSITION_PATH);
372:
373: -- Retrieve the position path specific position reference code, retrieves default position reference if no position path has already been created
374: l_pos_ref_code := AHL_MC_PATH_POSITION_PVT.get_posref_by_path(l_pos_path_tbl, FND_API.G_TRUE);
375:
376: AHL_UTIL_MC_PKG.Convert_To_LookupMeaning
377: (
378: 'AHL_POSITION_REFERENCE',

Line 505: RETURN AHL_MC_PATH_POSITION_PVT.Path_Position_Tbl_Type

501: FUNCTION Decode_Pos_Path
502: (
503: p_encoded_path IN VARCHAR2
504: )
505: RETURN AHL_MC_PATH_POSITION_PVT.Path_Position_Tbl_Type
506: IS
507:
508: G_NODE_SEP VARCHAR2(1) := '/';
509: G_ID_SEP VARCHAR2(1) := ':';

Line 519: l_position_tbl AHL_MC_PATH_POSITION_PVT.Path_Position_Tbl_Type;

515: l_id_start NUMBER := 0;
516: l_id_end NUMBER := 0;
517: l_id_str VARCHAR2(10);
518:
519: l_position_tbl AHL_MC_PATH_POSITION_PVT.Path_Position_Tbl_Type;
520: l_tbl_idx NUMBER := 0;
521:
522: BEGIN
523: