1 PACKAGE AHL_UMP_FORECAST_REQ_PVT AUTHID CURRENT_USER AS
2 /* $Header: AHLVURQS.pls 120.1.12020000.2 2012/12/11 03:23:06 prakkum ship $ */
3
4 ------------------------
5 -- Declare Procedures --
6 ------------------------
7
8 -- Start of Comments --
9 -- Procedure name : Process_Mrl_Req_Forecast
10 -- Type : Private
11 -- Function : Private API to collect the material requirements for unit effectivities of a given set
12 -- of item instances.
13 -- Insert these material requirements into AHL_SCHEDULE_MATERIALS for ASCP/DP to pick up
14 -- and plan the forecasted material requirements.
15 -- If a unit effectivity does not have due date, the material forecast is not done.
16 -- Pre-reqs :
17 -- Parameters :
18 --
19 -- Standard IN Parameters :
20 -- p_api_version IN NUMBER Required
21 -- p_init_msg_list IN VARCHAR2 Default FND_API.G_FALSE
22 -- p_validation_level IN NUMBER Default FND_API.G_VALID_LEVEL_FULL
23 --
24 -- Standard OUT Parameters :
25 -- x_return_status OUT VARCHAR2 Required
26 -- x_msg_count OUT NUMBER Required
27 -- x_msg_data OUT VARCHAR2 Required
28 --
29 -- Get_Route_Mtl_Req Parameters:
30 -- P_applicable_instances_tbl IN AHL_UMP_PROCESSUNIT_PVT.config_node_tbl_type Required
31 -- The table of records containing list of item instances for which the due
32 -- date calculation process is being performed.
33 --
34 -- Version :
35 -- Initial Version 1.0
36 -- Create By : Sunil Kumar
37 -- End of Comments.
38
39 PROCEDURE Process_Mrl_Req_Forecast
40 (
41 p_api_version IN NUMBER,
42 p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
43 p_commit IN VARCHAR2 := FND_API.G_FALSE,
44 p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
45 x_return_status OUT NOCOPY VARCHAR2,
46 x_msg_count OUT NOCOPY NUMBER,
47 x_msg_data OUT NOCOPY VARCHAR2,
48 P_applicable_instances_tbl IN
49 AHL_UMP_PROCESSUNIT_PVT.config_node_tbl_type
50 );
51
52
53 -- Called from concurrent program. This will create/update the material
54 -- forecast stream.
55 PROCEDURE Build_Mat_Forecast_Stream (
56 errbuf OUT NOCOPY VARCHAR2,
57 retcode OUT NOCOPY NUMBER,
58 p_unit_config_hdr_id IN NUMBER,
59 p_item_instance_id IN NUMBER
60 );
61
62
63 End AHL_UMP_FORECAST_REQ_PVT;