[Home] [Help]
PACKAGE: APPS.AHL_UMP_UF_PVT
Source
1 PACKAGE AHL_UMP_UF_PVT AUTHID CURRENT_USER AS
2 /* $Header: AHLVUMFS.pls 120.1 2008/01/18 01:22:23 sikumar ship $ */
3
4 G_OP_CREATE CONSTANT VARCHAR(1) := 'C';
5 G_OP_UPDATE CONSTANT VARCHAR(1) := 'U';
6 G_OP_DELETE CONSTANT VARCHAR(1) := 'D';
7
8 G_UF_TYPE_PC_NODE CONSTANT VARCHAR(1) := 'N';
9 G_UF_TYPE_UNIT CONSTANT VARCHAR(1) := 'U';
10 G_UF_TYPE_PART CONSTANT VARCHAR(1) := 'I';
11 G_UF_TYPE_INSTANCE CONSTANT VARCHAR(1) := 'C';
12
13 G_UF_USE_UNIT_DEFAULT CONSTANT VARCHAR(1) := 'N';
14 G_UF_USE_UNIT_YES CONSTANT VARCHAR(1) := 'Y';
15
16 G_PC_PRIMARY_FLAG CONSTANT VARCHAR2(1) := 'Y';
17 G_PC_ITEM_ASSOCIATION CONSTANT VARCHAR2(1) := 'I';
18 G_PC_UNIT_ASSOCIATION CONSTANT VARCHAR2(1) := 'U';
19 G_DRAFT_STATUS CONSTANT VARCHAR2(30) := 'DRAFT';
20 G_COMPLETE_STATUS CONSTANT VARCHAR2(30) := 'COMPLETE';
21
22 ---------------------------------------------------------------------
23 -- Define Record Types for record structures needed by the APIs --
24 ---------------------------------------------------------------------
25 TYPE uf_header_rec_type IS RECORD (
26 UF_HEADER_ID NUMBER,
27 OBJECT_VERSION_NUMBER NUMBER,
28 CREATED_BY NUMBER,
29 CREATION_DATE DATE,
30 LAST_UPDATED_BY NUMBER,
31 LAST_UPDATE_DATE DATE,
32 LAST_UPDATE_LOGIN NUMBER,
33 UNIT_CONFIG_HEADER_ID NUMBER,
34 UNIT_NAME VARCHAR2(80),
35 PC_NODE_ID NUMBER,
36 INVENTORY_ITEM_ID NUMBER,
37 INVENTORY_ITEM_NAME VARCHAR2(2000),
38 INVENTORY_ORG_CODE VARCHAR2(3),
39 INVENTORY_ORG_ID NUMBER,
40 CSI_ITEM_INSTANCE_ID NUMBER,
41 USE_UNIT_FLAG VARCHAR2(1),
42 FORECAST_TYPE VARCHAR2(1),
43 OPERATION_FLAG VARCHAR2(1),
44 ATTRIBUTE_CATEGORY VARCHAR2(30),
45 ATTRIBUTE1 VARCHAR2(150),
46 ATTRIBUTE2 VARCHAR2(150),
47 ATTRIBUTE3 VARCHAR2(150),
48 ATTRIBUTE4 VARCHAR2(150),
49 ATTRIBUTE5 VARCHAR2(150),
50 ATTRIBUTE6 VARCHAR2(150),
51 ATTRIBUTE7 VARCHAR2(150),
52 ATTRIBUTE8 VARCHAR2(150),
53 ATTRIBUTE9 VARCHAR2(150),
54 ATTRIBUTE10 VARCHAR2(150),
55 ATTRIBUTE11 VARCHAR2(150),
56 ATTRIBUTE12 VARCHAR2(150),
57 ATTRIBUTE13 VARCHAR2(150),
58 ATTRIBUTE14 VARCHAR2(150),
59 ATTRIBUTE15 VARCHAR2(150)
60 );
61
62 TYPE uf_details_rec_type IS RECORD (
63 UF_DETAIL_ID NUMBER,
64 OBJECT_VERSION_NUMBER NUMBER,
65 CREATED_BY NUMBER,
66 CREATION_DATE DATE,
67 LAST_UPDATED_BY NUMBER,
68 LAST_UPDATE_DATE DATE,
69 LAST_UPDATE_LOGIN NUMBER,
70 UF_HEADER_ID NUMBER,
71 UOM_CODE VARCHAR2(3),
72 START_DATE DATE,
73 END_DATE DATE,
74 USAGE_PER_DAY NUMBER,
75 OPERATION_FLAG VARCHAR2(1),
76 ATTRIBUTE_CATEGORY VARCHAR2(30),
77 ATTRIBUTE1 VARCHAR2(150),
78 ATTRIBUTE2 VARCHAR2(150),
79 ATTRIBUTE3 VARCHAR2(150),
80 ATTRIBUTE4 VARCHAR2(150),
81 ATTRIBUTE5 VARCHAR2(150),
82 ATTRIBUTE6 VARCHAR2(150),
83 ATTRIBUTE7 VARCHAR2(150),
84 ATTRIBUTE8 VARCHAR2(150),
85 ATTRIBUTE9 VARCHAR2(150),
86 ATTRIBUTE10 VARCHAR2(150),
87 ATTRIBUTE11 VARCHAR2(150),
88 ATTRIBUTE12 VARCHAR2(150),
89 ATTRIBUTE13 VARCHAR2(150),
90 ATTRIBUTE14 VARCHAR2(150),
91 ATTRIBUTE15 VARCHAR2(150)
92 );
93
94
95 ----------------------------------------------
96 -- Define Table Type for records structures --
97 ----------------------------------------------
98 TYPE uf_details_tbl_type IS TABLE OF uf_details_rec_type INDEX BY BINARY_INTEGER;
99
100 ------------------------
101 -- Declare Procedures --
102 ------------------------
103
104 -- Start of Comments --
105 -- Procedure name : process_utilization_forecast
106 -- Type : Public
107 -- Function : For a given set of utilization forecast header and details, will validate and insert/update
108 -- the utilization forecast information.
109 -- Pre-reqs :
110 -- Parameters :
111 --
112 -- Standard IN Parameters :
113 -- p_api_version IN NUMBER Default 1.0
114 -- p_init_msg_list IN VARCHAR2 Default FND_API.G_TRUE
115 -- p_commit IN VARCHAR2 Default FND_API.G_FALSE
116 -- p_validation_level IN NUMBER Default FND_API.G_VALID_LEVEL_FULL
117 -- Standard OUT Parameters :
118 -- x_return_status OUT VARCHAR2 Required
119 -- x_msg_count OUT NUMBER Required
120 -- x_msg_data OUT VARCHAR2 Required
121 --
122 -- p_module_type IN VARCHAR2 Required.
123 --
124 -- This parameter indicates the front-end form interface. The default value is 'JSP'. If the value
125 -- is JSP, then this API clears out all id columns and validations are done using the values based
126 -- on which the Id's are populated.
127 --
128 -- process_utilization_forecast Parameters:
129 --
130 -- p_x_uf_header_rec IN OUT AHL_UMP_UF_PVT.uf_header_rec_type Required
131 -- Utilization Forecast Header Details
132 -- p_x_uf_detail_tbl IN OUT AHL_UMP_UF_PVT.uf_detail_tbl_type Required
133 -- Utilization Forecast details
134 --
135 --
136 -- Version :
137 -- Initial Version 1.0
138 --
139 -- End of Comments.
140
141 PROCEDURE process_utilization_forecast(
142 p_api_version IN NUMBER := 1.0,
143 p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
144 p_commit IN VARCHAR2 := FND_API.G_FALSE,
145 p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
146 p_module_type IN VARCHAR2 := NULL,
147 p_x_uf_header_rec IN OUT NOCOPY AHL_UMP_UF_PVT.uf_header_rec_type,
148 p_x_uf_details_tbl IN OUT NOCOPY AHL_UMP_UF_PVT.uf_details_tbl_type,
149 x_return_status OUT NOCOPY VARCHAR2,
150 x_msg_count OUT NOCOPY NUMBER,
151 x_msg_data OUT NOCOPY VARCHAR2);
152
153 ----------------------------------------------------------------------
154 -- Procedure to get Utilzation Forecast from Product Classification --
155 ----------------------------------------------------------------------
156 PROCEDURE get_uf_from_pc (
157
158 p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
159 p_pc_node_id IN NUMBER := NULL,
160 p_inventory_item_id IN NUMBER := NULL,
161 p_inventory_org_id IN NUMBER := NULL,
162 p_unit_config_header_id IN NUMBER := NULL ,
163 p_unit_name IN VARCHAR2 := NULL ,
164 p_part_number IN VARCHAR2 := NULL,
165 p_onward_end_date IN DATE := NULL,
166 p_add_unit_item_forecast IN VARCHAR2 := 'N',
167 x_UF_details_tbl OUT NOCOPY AHL_UMP_UF_PVT.uf_details_tbl_type,
168 x_return_status OUT NOCOPY VARCHAR2);
169
170 -------------------------------------------------------------------------
171 -- Procedure to get Utilzation Forecast from Part for an instance when pm is installed --
172 --------------------------------------------------------------------------
173 PROCEDURE get_uf_from_part (
174
175 p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
176 p_csi_item_instance_id IN NUMBER,
177 p_onward_end_date IN DATE := NULL,
178 x_UF_details_tbl OUT NOCOPY AHL_UMP_UF_PVT.uf_details_tbl_type,
179 x_return_status OUT NOCOPY VARCHAR2);
180
181 End AHL_UMP_UF_PVT;