1 PACKAGE AHL_PC_HEADER_PVT AUTHID CURRENT_USER AS
2 /* $Header: AHLVPCHS.pls 120.1.12020000.2 2012/12/07 01:41:27 sareepar ship $ */
3
4 G_PKG_NAME CONSTANT VARCHAR2(30) := 'AHL_PC_HEADER_PVT';
5
6 G_USER_ID CONSTANT NUMBER := FND_GLOBAL.LOGIN_ID;
7
8 G_DML_CREATE CONSTANT VARCHAR2(1) := 'C';
9 G_DML_UPDATE CONSTANT VARCHAR2(1) := 'U';
10 G_DML_DELETE CONSTANT VARCHAR2(1) := 'D';
11 G_DML_COPY CONSTANT VARCHAR2(1) := 'X';
12 G_DML_LINK CONSTANT VARCHAR2(1) := 'L';
13
14 G_UNIT CONSTANT VARCHAR2(1) := 'U';
15 G_PART CONSTANT VARCHAR2(1) := 'I';
16 G_NODE CONSTANT VARCHAR2(1) := 'N';
17
18 -- For COPY_PC_HEADER...
19 TYPE PC_NODE_ID_REC IS RECORD
20 (
21 NODE_ID NUMBER,
22 NEW_NODE_ID NUMBER
23 );
24
25 TYPE PC_NODE_ID_TBL IS TABLE OF PC_NODE_ID_REC INDEX BY BINARY_INTEGER;
26
27 -- Start of Comments --
28 --
29 -- Procedure name : CREATE_PC_HEADER
30 -- Type : Private
31 -- Function : Creates a new Product Classification Header.
32 -- Pre-reqs :
33 --
34 -- Standard IN Parameters :
35 -- p_api_version IN NUMBER Required
36 -- p_init_msg_list IN VARCHAR2 Default FND_API.G_FALSE
37 -- p_commit IN VARCHAR2 Default FND_API.G_FALSE
38 -- p_validation_level IN NUMBER Default FND_API.G_VALID_LEVEL_FULL
39 --
40 -- Standard OUT Parameters :
41 -- x_return_status OUT VARCHAR2 Required
42 -- x_msg_count OUT NUMBER Required
43 -- x_msg_data OUT VARCHAR2 Required
44 --
45 -- CREATE_PC_HEADER Parameters :
46 -- p_x_pc_header_rec IN OUT PC_HEADER_REC Required
47 -- For every PC_HEADER record :
48 -- PC_HEADER_ID NULL for CREATE_PC_HEADER
49 -- NAME Required
50 -- DESCRIPTION
51 -- STATUS Required and present in FND_LOOKUPS
52 -- PRODUCT_TYPE_CODE Required and present in FND_LOOKUPS
53 -- PRIMARY_FLAG Required, Default P
54 -- ASSOCIATION_TYPE_FLAG Required, Default U
55 -- OPERATION_FLAG Required, I
56 --
57 -- Version :
58 -- Initial Version 1.0
59 --
60 -- End of Comments --
61 PROCEDURE CREATE_PC_HEADER (
62 p_api_version IN NUMBER,
63 p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
64 p_commit IN VARCHAR2 := FND_API.G_FALSE,
65 p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
66 p_x_pc_header_rec IN OUT NOCOPY AHL_PC_HEADER_PUB.PC_HEADER_REC,
67 x_return_status OUT NOCOPY VARCHAR2,
68 x_msg_count OUT NOCOPY NUMBER,
69 x_msg_data OUT NOCOPY VARCHAR2);
70
71 -- Start of Comments --
72 --
73 -- Procedure name : UPDATE_PC_HEADER
74 -- Type : Private
75 -- Function : Updates an existing Product Classification Header.
76 -- Pre-reqs :
77 --
78 -- Standard IN Parameters :
79 -- p_api_version IN NUMBER Required
80 -- p_init_msg_list IN VARCHAR2 Default FND_API.G_FALSE
81 -- p_commit IN VARCHAR2 Default FND_API.G_FALSE
82 -- p_validation_level IN NUMBER Default FND_API.G_VALID_LEVEL_FULL
83 --
84 -- Standard OUT Parameters :
85 -- x_return_status OUT VARCHAR2 Required
86 -- x_msg_count OUT NUMBER Required
87 -- x_msg_data OUT VARCHAR2 Required
88 --
89 -- UPDATE_PC_HEADER Parameters :
90 -- p_x_pc_header_rec IN OUT PC_HEADER_REC Required
91 -- For every PC_HEADER record :
92 -- PC_HEADER_ID Required and existing for UPDATE_PC_HEADER
93 -- NAME Required
94 -- DESCRIPTION
95 -- STATUS Required and present in FND_LOOKUPS
96 -- PRODUCT_TYPE_CODE Required and present in FND_LOOKUPS
97 -- PRIMARY_FLAG Required, Default P
98 -- ASSOCIATION_TYPE_FLAG Required, Default U
99 -- OPERATION_FLAG Required, U
100 --
101 -- Version :
102 -- Initial Version 1.0
103 --
104 -- End of Comments --
105 PROCEDURE UPDATE_PC_HEADER (
106 p_api_version IN NUMBER,
107 p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
108 p_commit IN VARCHAR2 := FND_API.G_FALSE,
109 p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
110 p_x_pc_header_rec IN OUT NOCOPY AHL_PC_HEADER_PUB.PC_HEADER_REC,
111 x_return_status OUT NOCOPY VARCHAR2,
112 x_msg_count OUT NOCOPY NUMBER,
113 x_msg_data OUT NOCOPY VARCHAR2,
114 x_warning_msg_data OUT NOCOPY AHL_PC_HEADER_PUB.Warn_Tbl_Type);
115
116 -- Start of Comments --
117 --
118 -- Procedure name : DELETE_PC_HEADER
119 -- Type : Private
120 -- Function : Deletes an existing Product Classification Header and Nodes.
121 -- Pre-reqs : AHL_PC_NODES_PVT.VALIDATE_NODES
122 --
123 -- Standard IN Parameters :
124 -- p_api_version IN NUMBER Required
125 -- p_init_msg_list IN VARCHAR2 Default FND_API.G_FALSE
126 -- p_commit IN VARCHAR2 Default FND_API.G_FALSE
127 -- p_validation_level IN NUMBER Default FND_API.G_VALID_LEVEL_FULL
128 --
129 -- Standard OUT Parameters :
130 -- x_return_status OUT VARCHAR2 Required
131 -- x_msg_count OUT NUMBER Required
132 -- x_msg_data OUT VARCHAR2 Required
133 --
134 -- DELETE_PC_HEADER Parameters :
135 -- p_x_pc_header_rec IN OUT PC_HEADER_REC Required
136 -- For every PC_HEADER record :
137 -- PC_HEADER_ID Required and existing for DELETE_PC_HEADER
138 -- OPERATION_FLAG Required, D
139 --
140 -- Version :
141 -- Initial Version 1.0
142 --
143 -- End of Comments --
144 PROCEDURE DELETE_PC_HEADER (
145 p_api_version IN NUMBER,
146 p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
147 p_commit IN VARCHAR2 := FND_API.G_FALSE,
148 p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
149 p_x_pc_header_rec IN OUT NOCOPY AHL_PC_HEADER_PUB.PC_HEADER_REC,
150 x_return_status OUT NOCOPY VARCHAR2,
151 x_msg_count OUT NOCOPY NUMBER,
152 x_msg_data OUT NOCOPY VARCHAR2);
153
154 -- Start of Comments --
155 --
156 -- Procedure name : COPY_PC_HEADER
157 -- Type : Private
158 -- Function : Copies an existing Product Classification Header and Nodes.
159 -- Pre-reqs : AHL_PC_NODES_PVT.COPY_NODES
160 --
161 -- Standard IN Parameters :
162 -- p_api_version IN NUMBER Required
163 -- p_init_msg_list IN VARCHAR2 Default FND_API.G_FALSE
164 -- p_commit IN VARCHAR2 Default FND_API.G_FALSE
165 -- p_validation_level IN NUMBER Default FND_API.G_VALID_LEVEL_FULL
166 --
167 -- Standard OUT Parameters :
168 -- x_return_status OUT VARCHAR2 Required
169 -- x_msg_count OUT NUMBER Required
170 -- x_msg_data OUT VARCHAR2 Required
171 --
172 -- COPY_PC_HEADER Parameters :
173 -- p_x_pc_header_rec IN OUT PC_HEADER_REC Required
174 -- For every PC_HEADER record :
175 -- PC_HEADER_ID Required and existing for COPY_PC_HEADER
176 -- NAME Required
177 -- DESCRIPTION
178 -- STATUS Required and present in FND_LOOKUPS
179 -- PRODUCT_TYPE_CODE Required and present in FND_LOOKUPS
180 -- PRIMARY_FLAG Required, Default P
181 -- ASSOCIATION_TYPE_FLAG Required, Default U
182 -- OPERATION_FLAG Required, C
183 --
184 -- Version :
185 -- Initial Version 1.0
186 --
187 -- End of Comments --
188 PROCEDURE COPY_PC_HEADER (
189 p_api_version IN NUMBER,
190 p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
191 p_commit IN VARCHAR2 := FND_API.G_FALSE,
192 p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
193 p_x_pc_header_rec IN OUT NOCOPY AHL_PC_HEADER_PUB.PC_HEADER_REC,
194 x_return_status OUT NOCOPY VARCHAR2,
195 x_msg_count OUT NOCOPY NUMBER,
196 x_msg_data OUT NOCOPY VARCHAR2);
197
198 -- Start of Comments --
199 --
200 -- Procedure name : INITIATE_PC_APPROVAL
201 -- Type : Private
202 -- Function : Initiates an Approval Process for a Product Classification
203 -- Pre-reqs :
204 --
205 -- Standard IN Parameters :
206 -- p_api_version IN NUMBER Required
207 -- p_init_msg_list IN VARCHAR2 Default FND_API.G_FALSE
208 -- p_commit IN VARCHAR2 Default FND_API.G_FALSE
209 -- p_validation_level IN NUMBER Default FND_API.G_VALID_LEVEL_FULL
210 --
211 -- Standard OUT Parameters :
212 -- x_return_status OUT VARCHAR2 Required
213 -- x_msg_count OUT NUMBER Required
214 -- x_msg_data OUT VARCHAR2 Required
215 --
216 -- INITIATE_PC_APPROVAL Parameters :
217 -- p_source_pc_header_id IN NUMBER
218 -- p_object_Version_number IN NUMBER
219 --
220 -- Version :
221 -- Initial Version 1.0
222 --
223 -- End of Comments --
224 PROCEDURE INITIATE_PC_APPROVAL (
225 p_api_version IN NUMBER,
226 p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
227 p_commit IN VARCHAR2 := FND_API.G_FALSE,
228 p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
229 p_default IN VARCHAR2 := FND_API.G_FALSE,
230 x_return_status OUT NOCOPY VARCHAR2,
231 x_msg_count OUT NOCOPY NUMBER,
232 x_msg_data OUT NOCOPY VARCHAR2,
233 p_x_pc_header_rec IN OUT NOCOPY AHL_PC_HEADER_PUB.PC_HEADER_REC,
234 x_warning_msg_data OUT NOCOPY AHL_PC_HEADER_PUB.Warn_Tbl_Type
235 );
236
237 END AHL_PC_HEADER_PVT;