1 PACKAGE AHL_PC_HEADER_PVT AUTHID CURRENT_USER AS
2 /* $Header: AHLVPCHS.pls 115.6 2003/12/10 14:02:12 sjayacha noship $ */
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
115 -- Start of Comments --
116 --
117 -- Procedure name : DELETE_PC_HEADER
118 -- Type : Private
119 -- Function : Deletes an existing Product Classification Header and Nodes.
120 -- Pre-reqs : AHL_PC_NODES_PVT.VALIDATE_NODES
121 --
122 -- Standard IN Parameters :
123 -- p_api_version IN NUMBER Required
124 -- p_init_msg_list IN VARCHAR2 Default FND_API.G_FALSE
125 -- p_commit IN VARCHAR2 Default FND_API.G_FALSE
126 -- p_validation_level IN NUMBER Default FND_API.G_VALID_LEVEL_FULL
127 --
128 -- Standard OUT Parameters :
129 -- x_return_status OUT VARCHAR2 Required
130 -- x_msg_count OUT NUMBER Required
131 -- x_msg_data OUT VARCHAR2 Required
132 --
133 -- DELETE_PC_HEADER Parameters :
134 -- p_x_pc_header_rec IN OUT PC_HEADER_REC Required
135 -- For every PC_HEADER record :
136 -- PC_HEADER_ID Required and existing for DELETE_PC_HEADER
137 -- OPERATION_FLAG Required, D
138 --
139 -- Version :
140 -- Initial Version 1.0
141 --
142 -- End of Comments --
143 PROCEDURE DELETE_PC_HEADER (
144 p_api_version IN NUMBER,
145 p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
146 p_commit IN VARCHAR2 := FND_API.G_FALSE,
147 p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
148 p_x_pc_header_rec IN OUT NOCOPY AHL_PC_HEADER_PUB.PC_HEADER_REC,
149 x_return_status OUT NOCOPY VARCHAR2,
150 x_msg_count OUT NOCOPY NUMBER,
151 x_msg_data OUT NOCOPY VARCHAR2);
152
153 -- Start of Comments --
154 --
155 -- Procedure name : COPY_PC_HEADER
156 -- Type : Private
157 -- Function : Copies an existing Product Classification Header and Nodes.
158 -- Pre-reqs : AHL_PC_NODES_PVT.COPY_NODES
159 --
160 -- Standard IN Parameters :
161 -- p_api_version IN NUMBER Required
162 -- p_init_msg_list IN VARCHAR2 Default FND_API.G_FALSE
163 -- p_commit IN VARCHAR2 Default FND_API.G_FALSE
164 -- p_validation_level IN NUMBER Default FND_API.G_VALID_LEVEL_FULL
165 --
166 -- Standard OUT Parameters :
167 -- x_return_status OUT VARCHAR2 Required
168 -- x_msg_count OUT NUMBER Required
169 -- x_msg_data OUT VARCHAR2 Required
170 --
171 -- COPY_PC_HEADER Parameters :
172 -- p_x_pc_header_rec IN OUT PC_HEADER_REC Required
173 -- For every PC_HEADER record :
174 -- PC_HEADER_ID Required and existing for COPY_PC_HEADER
175 -- NAME Required
176 -- DESCRIPTION
177 -- STATUS Required and present in FND_LOOKUPS
178 -- PRODUCT_TYPE_CODE Required and present in FND_LOOKUPS
179 -- PRIMARY_FLAG Required, Default P
180 -- ASSOCIATION_TYPE_FLAG Required, Default U
181 -- OPERATION_FLAG Required, C
182 --
183 -- Version :
184 -- Initial Version 1.0
185 --
186 -- End of Comments --
187 PROCEDURE COPY_PC_HEADER (
188 p_api_version IN NUMBER,
189 p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
190 p_commit IN VARCHAR2 := FND_API.G_FALSE,
191 p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
192 p_x_pc_header_rec IN OUT NOCOPY AHL_PC_HEADER_PUB.PC_HEADER_REC,
193 x_return_status OUT NOCOPY VARCHAR2,
194 x_msg_count OUT NOCOPY NUMBER,
195 x_msg_data OUT NOCOPY VARCHAR2);
196
197 -- Start of Comments --
198 --
199 -- Procedure name : INITIATE_PC_APPROVAL
200 -- Type : Private
201 -- Function : Initiates an Approval Process for a Product Classification
202 -- Pre-reqs :
203 --
204 -- Standard IN Parameters :
205 -- p_api_version IN NUMBER Required
206 -- p_init_msg_list IN VARCHAR2 Default FND_API.G_FALSE
207 -- p_commit IN VARCHAR2 Default FND_API.G_FALSE
208 -- p_validation_level IN NUMBER Default FND_API.G_VALID_LEVEL_FULL
209 --
210 -- Standard OUT Parameters :
211 -- x_return_status OUT VARCHAR2 Required
212 -- x_msg_count OUT NUMBER Required
213 -- x_msg_data OUT VARCHAR2 Required
214 --
215 -- INITIATE_PC_APPROVAL Parameters :
216 -- p_source_pc_header_id IN NUMBER
217 -- p_object_Version_number IN NUMBER
218 --
219 -- Version :
220 -- Initial Version 1.0
221 --
222 -- End of Comments --
223 PROCEDURE INITIATE_PC_APPROVAL (
224 p_api_version IN NUMBER,
225 p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
226 p_commit IN VARCHAR2 := FND_API.G_FALSE,
227 p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
228 p_default IN VARCHAR2 := FND_API.G_FALSE,
229 x_return_status OUT NOCOPY VARCHAR2,
230 x_msg_count OUT NOCOPY NUMBER,
231 x_msg_data OUT NOCOPY VARCHAR2,
232 p_x_pc_header_rec IN OUT NOCOPY AHL_PC_HEADER_PUB.PC_HEADER_REC
233 );
234
235 END AHL_PC_HEADER_PVT;