[Home] [Help]
47:
48: -- Build the item instance tree containing root nodes and its components.
49: PROCEDURE Build_Config_Tree(p_csi_root_instance_id IN NUMBER,
50: p_master_config_id IN NUMBER,
51: x_config_node_tbl OUT NOCOPY AHL_UMP_PROCESSUNIT_PVT.config_node_tbl_type);
52:
53: -- process material requirement for a UE.
54: PROCEDURE Process_Material_Req (p_unit_effectivity_id IN NUMBER,
55: p_csi_item_instance_id IN NUMBER,
84: -- x_msg_count OUT NUMBER Required
85: -- x_msg_data OUT VARCHAR2 Required
86: --
87: -- Get_Route_Mtl_Req Parameters:
88: -- P_applicable_instances_tbl IN AHL_UMP_PROCESSUNIT_PVT.config_node_tbl_type Required
89: -- The table of records containing list of item instances for which the due
90: -- date calculation process is being performed.
91: --
92: -- Version :
102: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
103: x_return_status OUT NOCOPY VARCHAR2,
104: x_msg_count OUT NOCOPY NUMBER,
105: x_msg_data OUT NOCOPY VARCHAR2,
106: P_applicable_instances_tbl IN AHL_UMP_PROCESSUNIT_PVT.config_node_tbl_type
107: ) IS
108:
109: l_Route_Mtl_Req_Tbl AHL_LTP_MTL_REQ_PVT.Route_Mtl_Req_Tbl_Type;
110:
634: l_name ahl_unit_config_headers.name%TYPE;
635: l_instance_number csi_item_instances.instance_number%TYPE;
636: l_active_end_date DATE;
637:
638: l_config_node_tbl AHL_UMP_PROCESSUNIT_PVT.config_node_tbl_type;
639: l_master_config_id NUMBER;
640: l_config_status_code fnd_lookup_values_vl.lookup_code%TYPE;
641:
642: l_msg_data VARCHAR2(2000);
920: -------------------------------------------------------------
921: -- Build the item instance tree containing root nodes and its components.
922: PROCEDURE Build_Config_Tree(p_csi_root_instance_id IN NUMBER,
923: p_master_config_id IN NUMBER,
924: x_config_node_tbl OUT NOCOPY AHL_UMP_PROCESSUNIT_PVT.config_node_tbl_type)
925:
926: IS
927:
928: CURSOR csi_config_tree_csr ( p_csi_root_instance_id IN NUMBER) IS
938: AND trunc(sysdate) < trunc(nvl(active_end_date, sysdate+1))
939: ORDER BY level;
940:
941: i NUMBER;
942: l_config_node_tbl AHL_UMP_PROCESSUNIT_PVT.config_node_tbl_type := x_config_node_tbl;
943:
944: -- added for perf fix for bug# 6893404.
945: l_buffer_limit number := 1000;
946: