[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:
657: l_name ahl_unit_config_headers.name%TYPE;
658: l_instance_number csi_item_instances.instance_number%TYPE;
659: l_active_end_date DATE;
660:
661: l_config_node_tbl AHL_UMP_PROCESSUNIT_PVT.config_node_tbl_type;
662: l_master_config_id NUMBER;
663: l_config_status_code fnd_lookup_values_vl.lookup_code%TYPE;
664:
665: l_msg_data VARCHAR2(2000);
943: -------------------------------------------------------------
944: -- Build the item instance tree containing root nodes and its components.
945: PROCEDURE Build_Config_Tree(p_csi_root_instance_id IN NUMBER,
946: p_master_config_id IN NUMBER,
947: x_config_node_tbl OUT NOCOPY AHL_UMP_PROCESSUNIT_PVT.config_node_tbl_type)
948:
949: IS
950:
951: CURSOR csi_config_tree_csr ( p_csi_root_instance_id IN NUMBER) IS
961: AND trunc(sysdate) < trunc(nvl(active_end_date, sysdate+1))
962: ORDER BY level;
963:
964: i NUMBER;
965: l_config_node_tbl AHL_UMP_PROCESSUNIT_PVT.config_node_tbl_type := x_config_node_tbl;
966:
967: -- added for perf fix for bug# 6893404.
968: l_buffer_limit number := 1000;
969: