1 PACKAGE AHL_UMP_UF_PUB AS
2 /* $Header: AHLPUMFS.pls 120.0 2005/05/25 23:57:58 appldev noship $ */
3 /*#
4 * This is the public interface to process utilization forecast for Product Classification node, item, unit or item instance. It allows
5 * creation, modification or deletion of utilization forecast.
6 * @rep:scope public
7 * @rep:product AHL
8 * @rep:displayname Utilization Forecast
9 * @rep:lifecycle active
10 * @rep:category BUSINESS_ENTITY AHL_PROD_CLASS
11 */
12 ------------------------
13 -- Declare Procedures --
14 ------------------------
15
16 -- Start of Comments --
17 -- Procedure name : process_utilization_forecast
18 -- Type : Public
19 -- Function : For a given set of utilization forecast header and details, will validate and insert/update
20 -- the utilization forecast information.
21 -- Pre-reqs :
22 -- Parameters :
23 --
24 -- Standard IN Parameters :
25 -- p_api_version IN NUMBER Default 1.0
26 -- p_init_msg_list IN VARCHAR2 Default FND_API.G_TRUE
27 -- p_commit IN VARCHAR2 Default FND_API.G_FALSE
28 -- p_validation_level IN NUMBER Default FND_API.G_VALID_LEVEL_FULL
29 -- Standard OUT Parameters :
30 -- x_return_status OUT VARCHAR2 Required
31 -- x_msg_count OUT NUMBER Required
32 -- x_msg_data OUT VARCHAR2 Required
33 --
34 -- p_module_type IN VARCHAR2 Required.
35 --
36 -- This parameter indicates the front-end form interface. The default value is 'JSP'. If the value
37 -- is JSP, then this API clears out all id columns and validations are done using the values based
38 -- on which the Id's are populated.
39 --
40 -- process_utilization_forecast Parameters:
41 --
42 -- p_x_uf_header_rec IN OUT AHL_UMP_UF_PVT.uf_header_rec_type Required
43 -- Utilization Forecast Header Details
44 -- p_x_uf_detail_tbl IN OUT AHL_UMP_UF_PVT.uf_detail_tbl_type Required
45 -- Utilization Forecast details
46 --
47 --
48 -- Version :
49 -- Initial Version 1.0
50 --
51 -- End of Comments.
52 /*#
53 * Process Utilization Forecast for CMRO product classification nodes and associated units and items. Allows definition and updates
54 * for utilization forecast for install base item instances and inventory items for other applications like Prevetive Maintenance
55 * @param p_api_version Api Version Number
56 * @param p_init_msg_list Initialize the message stack, default value FND_API.G_TRUE
57 * @param p_commit to decide whether to commit the transaction or not, default value FND_API.G_FALSE
58 * @param p_validation_level validation level, default value FND_API.G_VALID_LEVEL_FULL
59 * @param p_module_type whether 'API'or 'JSP', default value NULL
60 * @param p_x_uf_header_rec Utilization Forecast Header Record of type AHL_UMP_UF_PVT.uf_header_rec_type
61 * @param p_x_uf_details_tbl Utilization Forecast Details Table of type AHL_UMP_UF_PVT.uf_details_tbl_type
62 * @param x_return_status return status
63 * @param x_msg_count return message count
64 * @param x_msg_data return message data
65 * @rep:scope public
66 * @rep:lifecycle active
67 * @rep:displayname Process Utilization Forecast
68 */
69 PROCEDURE process_utilization_forecast(
70 p_api_version IN NUMBER := 1.0,
71 p_init_msg_list IN VARCHAR2 := FND_API.G_TRUE,
72 p_commit IN VARCHAR2 := FND_API.G_FALSE,
73 p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
74 p_module_type IN VARCHAR2 := NULL,
75 p_x_uf_header_rec IN OUT NOCOPY AHL_UMP_UF_PVT.uf_header_rec_type,
76 p_x_uf_details_tbl IN OUT NOCOPY AHL_UMP_UF_PVT.uf_details_tbl_type,
77 x_return_status OUT NOCOPY VARCHAR2,
78 x_msg_count OUT NOCOPY NUMBER,
79 x_msg_data OUT NOCOPY VARCHAR2);
80
81 END AHL_UMP_UF_PUB;