[Home] [Help]
PACKAGE: APPS.IGC_CC_HEADERS_PKG
Source
1 PACKAGE IGC_CC_HEADERS_PKG AUTHID CURRENT_USER as
2 /* $Header: IGCCHDRS.pls 120.3.12000000.3 2007/10/08 05:55:23 smannava ship $ */
3
4 /* ================================================================================
5 PROCEDURE Insert_Row Overloaded Procedure for CC_REF_NUM addition
6 ===============================================================================*/
7
8 PROCEDURE Insert_Row(
9 p_api_version IN NUMBER,
10 p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
11 p_commit IN VARCHAR2 := FND_API.G_FALSE,
12 p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
13 X_return_status OUT NOCOPY VARCHAR2,
14 X_msg_count OUT NOCOPY NUMBER,
15 X_msg_data OUT NOCOPY VARCHAR2,
16 p_Rowid IN OUT NOCOPY VARCHAR2,
17 p_CC_Header_Id IGC_CC_HEADERS_ALL.CC_Header_Id%TYPE,
18 p_Org_id IGC_CC_HEADERS_ALL.Org_id%TYPE,
19 p_CC_Type IGC_CC_HEADERS_ALL.CC_Type%TYPE,
20 p_CC_Num IGC_CC_HEADERS_ALL.CC_Num%TYPE,
21 p_CC_Ref_Num IGC_CC_HEADERS_ALL.CC_Ref_Num%TYPE,
22 p_CC_Version_num IGC_CC_HEADERS_ALL.CC_Version_num%TYPE,
23 p_Parent_Header_Id IGC_CC_HEADERS_ALL.Parent_Header_Id%TYPE,
24 p_CC_State IGC_CC_HEADERS_ALL.CC_State%TYPE,
25 p_CC_ctrl_status IGC_CC_HEADERS_ALL.CC_ctrl_status%TYPE,
26 p_CC_Encmbrnc_Status IGC_CC_HEADERS_ALL.CC_Encmbrnc_Status%TYPE,
27 p_CC_Apprvl_Status IGC_CC_HEADERS_ALL.CC_Apprvl_Status%TYPE,
28 p_Vendor_Id IGC_CC_HEADERS_ALL.Vendor_Id%TYPE,
29 p_Vendor_Site_Id IGC_CC_HEADERS_ALL.Vendor_Site_Id%TYPE,
30 p_Vendor_Contact_Id IGC_CC_HEADERS_ALL.Vendor_Contact_Id%TYPE,
31 p_Term_Id IGC_CC_HEADERS_ALL.Term_Id%TYPE,
32 p_Location_Id IGC_CC_HEADERS_ALL.Location_Id%TYPE,
33 p_Set_Of_Books_Id IGC_CC_HEADERS_ALL.Set_Of_Books_Id%TYPE,
34 p_CC_Acct_Date IGC_CC_HEADERS_ALL.CC_Acct_Date%TYPE,
35 p_CC_Desc IGC_CC_HEADERS_ALL.CC_Desc%TYPE,
36 p_CC_Start_Date IGC_CC_HEADERS_ALL.CC_Start_Date%TYPE,
37 p_CC_End_Date IGC_CC_HEADERS_ALL.CC_End_Date%TYPE,
38 p_CC_Owner_User_Id IGC_CC_HEADERS_ALL.CC_Owner_User_Id%TYPE,
39 p_CC_Preparer_User_Id IGC_CC_HEADERS_ALL.CC_Preparer_User_Id%TYPE,
40 p_Currency_Code IGC_CC_HEADERS_ALL.Currency_Code%TYPE,
41 p_Conversion_Type IGC_CC_HEADERS_ALL.Conversion_Type%TYPE,
42 p_Conversion_Date IGC_CC_HEADERS_ALL.Conversion_Date%TYPE,
43 p_Conversion_Rate IGC_CC_HEADERS_ALL.Conversion_Rate%TYPE,
44 p_Last_Update_Date IGC_CC_HEADERS_ALL.Last_Update_Date%TYPE,
45 p_Last_Updated_By IGC_CC_HEADERS_ALL.Last_Updated_By%TYPE,
46 p_Last_Update_Login IGC_CC_HEADERS_ALL.Last_Update_Login%TYPE,
47 p_Created_By IGC_CC_HEADERS_ALL.Created_By%TYPE,
48 p_Creation_Date IGC_CC_HEADERS_ALL.Creation_Date%TYPE,
49 p_CC_Current_User_Id IGC_CC_HEADERS_ALL.CC_Current_User_Id%TYPE,
50 p_Wf_Item_Type IGC_CC_HEADERS_ALL.Wf_Item_Type%TYPE,
51 p_Wf_Item_Key IGC_CC_HEADERS_ALL.Wf_Item_Key%TYPE,
52 p_Attribute1 IGC_CC_HEADERS_ALL.Attribute1%TYPE,
53 p_Attribute2 IGC_CC_HEADERS_ALL.Attribute2%TYPE,
54 p_Attribute3 IGC_CC_HEADERS_ALL.Attribute3%TYPE,
55 p_Attribute4 IGC_CC_HEADERS_ALL.Attribute4%TYPE,
56 p_Attribute5 IGC_CC_HEADERS_ALL.Attribute5%TYPE,
57 p_Attribute6 IGC_CC_HEADERS_ALL.Attribute6%TYPE,
58 p_Attribute7 IGC_CC_HEADERS_ALL.Attribute7%TYPE,
59 p_Attribute8 IGC_CC_HEADERS_ALL.Attribute8%TYPE,
60 p_Attribute9 IGC_CC_HEADERS_ALL.Attribute9%TYPE,
61 p_Attribute10 IGC_CC_HEADERS_ALL.Attribute10%TYPE,
62 p_Attribute11 IGC_CC_HEADERS_ALL.Attribute11%TYPE,
63 p_Attribute12 IGC_CC_HEADERS_ALL.Attribute12%TYPE,
64 p_Attribute13 IGC_CC_HEADERS_ALL.Attribute13%TYPE,
65 p_Attribute14 IGC_CC_HEADERS_ALL.Attribute14%TYPE,
66 p_Attribute15 IGC_CC_HEADERS_ALL.Attribute15%TYPE,
67 p_Context IGC_CC_HEADERS_ALL.Context%TYPE,
68 p_CC_Guarantee_Flag IGC_CC_HEADERS_ALL.CC_Guarantee_Flag%TYPE,
69 G_FLAG IN OUT NOCOPY VARCHAR2
70 );
71
72
73 /* ================================================================================
74 PROCEDURE Insert_Row
75 ===============================================================================*/
76
77
78 PROCEDURE Insert_Row(
79 p_api_version IN NUMBER,
80 p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
81 p_commit IN VARCHAR2 := FND_API.G_FALSE,
82 p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
83 X_return_status OUT NOCOPY VARCHAR2,
84 X_msg_count OUT NOCOPY NUMBER,
85 X_msg_data OUT NOCOPY VARCHAR2,
86 p_Rowid IN OUT NOCOPY VARCHAR2,
87 p_CC_Header_Id IGC_CC_HEADERS_ALL.CC_Header_Id%TYPE,
88 p_Org_id IGC_CC_HEADERS_ALL.Org_id%TYPE,
89 p_CC_Type IGC_CC_HEADERS_ALL.CC_Type%TYPE,
90 p_CC_Num IGC_CC_HEADERS_ALL.CC_Num%TYPE,
91 p_CC_Version_num IGC_CC_HEADERS_ALL.CC_Version_num%TYPE,
92 p_Parent_Header_Id IGC_CC_HEADERS_ALL.Parent_Header_Id%TYPE,
93 p_CC_State IGC_CC_HEADERS_ALL.CC_State%TYPE,
94 p_CC_ctrl_status IGC_CC_HEADERS_ALL.CC_ctrl_status%TYPE,
95 p_CC_Encmbrnc_Status IGC_CC_HEADERS_ALL.CC_Encmbrnc_Status%TYPE,
96 p_CC_Apprvl_Status IGC_CC_HEADERS_ALL.CC_Apprvl_Status%TYPE,
97 p_Vendor_Id IGC_CC_HEADERS_ALL.Vendor_Id%TYPE,
98 p_Vendor_Site_Id IGC_CC_HEADERS_ALL.Vendor_Site_Id%TYPE,
99 p_Vendor_Contact_Id IGC_CC_HEADERS_ALL.Vendor_Contact_Id%TYPE,
100 p_Term_Id IGC_CC_HEADERS_ALL.Term_Id%TYPE,
101 p_Location_Id IGC_CC_HEADERS_ALL.Location_Id%TYPE,
102 p_Set_Of_Books_Id IGC_CC_HEADERS_ALL.Set_Of_Books_Id%TYPE,
103 p_CC_Acct_Date IGC_CC_HEADERS_ALL.CC_Acct_Date%TYPE,
104 p_CC_Desc IGC_CC_HEADERS_ALL.CC_Desc%TYPE,
105 p_CC_Start_Date IGC_CC_HEADERS_ALL.CC_Start_Date%TYPE,
106 p_CC_End_Date IGC_CC_HEADERS_ALL.CC_End_Date%TYPE,
107 p_CC_Owner_User_Id IGC_CC_HEADERS_ALL.CC_Owner_User_Id%TYPE,
108 p_CC_Preparer_User_Id IGC_CC_HEADERS_ALL.CC_Preparer_User_Id%TYPE,
109 p_Currency_Code IGC_CC_HEADERS_ALL.Currency_Code%TYPE,
110 p_Conversion_Type IGC_CC_HEADERS_ALL.Conversion_Type%TYPE,
111 p_Conversion_Date IGC_CC_HEADERS_ALL.Conversion_Date%TYPE,
112 p_Conversion_Rate IGC_CC_HEADERS_ALL.Conversion_Rate%TYPE,
113 p_Last_Update_Date IGC_CC_HEADERS_ALL.Last_Update_Date%TYPE,
114 p_Last_Updated_By IGC_CC_HEADERS_ALL.Last_Updated_By%TYPE,
115 p_Last_Update_Login IGC_CC_HEADERS_ALL.Last_Update_Login%TYPE,
116 p_Created_By IGC_CC_HEADERS_ALL.Created_By%TYPE,
117 p_Creation_Date IGC_CC_HEADERS_ALL.Creation_Date%TYPE,
118 p_CC_Current_User_Id IGC_CC_HEADERS_ALL.CC_Current_User_Id%TYPE,
119 p_Wf_Item_Type IGC_CC_HEADERS_ALL.Wf_Item_Type%TYPE,
120 p_Wf_Item_Key IGC_CC_HEADERS_ALL.Wf_Item_Key%TYPE,
121 p_Attribute1 IGC_CC_HEADERS_ALL.Attribute1%TYPE,
122 p_Attribute2 IGC_CC_HEADERS_ALL.Attribute2%TYPE,
123 p_Attribute3 IGC_CC_HEADERS_ALL.Attribute3%TYPE,
124 p_Attribute4 IGC_CC_HEADERS_ALL.Attribute4%TYPE,
125 p_Attribute5 IGC_CC_HEADERS_ALL.Attribute5%TYPE,
126 p_Attribute6 IGC_CC_HEADERS_ALL.Attribute6%TYPE,
127 p_Attribute7 IGC_CC_HEADERS_ALL.Attribute7%TYPE,
128 p_Attribute8 IGC_CC_HEADERS_ALL.Attribute8%TYPE,
129 p_Attribute9 IGC_CC_HEADERS_ALL.Attribute9%TYPE,
130 p_Attribute10 IGC_CC_HEADERS_ALL.Attribute10%TYPE,
131 p_Attribute11 IGC_CC_HEADERS_ALL.Attribute11%TYPE,
132 p_Attribute12 IGC_CC_HEADERS_ALL.Attribute12%TYPE,
133 p_Attribute13 IGC_CC_HEADERS_ALL.Attribute13%TYPE,
134 p_Attribute14 IGC_CC_HEADERS_ALL.Attribute14%TYPE,
135 p_Attribute15 IGC_CC_HEADERS_ALL.Attribute15%TYPE,
136 p_Context IGC_CC_HEADERS_ALL.Context%TYPE,
137 p_CC_Guarantee_Flag IGC_CC_HEADERS_ALL.CC_Guarantee_Flag%TYPE,
138 G_FLAG IN OUT NOCOPY VARCHAR2
139 );
140 /* =================================================================================
141 PROCEDURE Lock_Row
142 ================================================================================*/
143 PROCEDURE Lock_Row (
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 X_return_status OUT NOCOPY VARCHAR2,
149 X_msg_count OUT NOCOPY NUMBER,
150 X_msg_data OUT NOCOPY VARCHAR2,
151 p_Rowid IN OUT NOCOPY VARCHAR2,
152 p_CC_Header_Id IGC_CC_HEADERS_ALL.CC_Header_Id%TYPE,
153 p_Org_id IGC_CC_HEADERS_ALL.Org_id%TYPE,
154 p_CC_Type IGC_CC_HEADERS_ALL.CC_Type%TYPE,
155 p_CC_Num IGC_CC_HEADERS_ALL.CC_Num%TYPE,
156 p_CC_Version_num IGC_CC_HEADERS_ALL.CC_Version_num%TYPE,
157 p_Parent_Header_Id IGC_CC_HEADERS_ALL.Parent_Header_Id%TYPE,
158 p_CC_State IGC_CC_HEADERS_ALL.CC_State%TYPE,
159 p_CC_ctrl_status IGC_CC_HEADERS_ALL.CC_ctrl_status%TYPE,
160 p_CC_Encmbrnc_Status IGC_CC_HEADERS_ALL.CC_Encmbrnc_Status%TYPE,
161 p_CC_Apprvl_Status IGC_CC_HEADERS_ALL.CC_Apprvl_Status%TYPE,
162 p_Vendor_Id IGC_CC_HEADERS_ALL.Vendor_Id%TYPE,
163 p_Vendor_Site_Id IGC_CC_HEADERS_ALL.Vendor_Site_Id%TYPE,
164 p_Vendor_Contact_Id IGC_CC_HEADERS_ALL.Vendor_Contact_Id%TYPE,
165 p_Term_Id IGC_CC_HEADERS_ALL.Term_Id%TYPE,
166 p_Location_Id IGC_CC_HEADERS_ALL.Location_Id%TYPE,
167 p_Set_Of_Books_Id IGC_CC_HEADERS_ALL.Set_Of_Books_Id%TYPE,
168 p_CC_Acct_Date IGC_CC_HEADERS_ALL.CC_Acct_Date%TYPE,
169 p_CC_Desc IGC_CC_HEADERS_ALL.CC_Desc%TYPE,
170 p_CC_Start_Date IGC_CC_HEADERS_ALL.CC_Start_Date%TYPE,
171 p_CC_End_Date IGC_CC_HEADERS_ALL.CC_End_Date%TYPE,
172 p_CC_Owner_User_Id IGC_CC_HEADERS_ALL.CC_Owner_User_Id%TYPE,
173 p_CC_Preparer_User_Id IGC_CC_HEADERS_ALL.CC_Preparer_User_Id%TYPE,
174 p_Currency_Code IGC_CC_HEADERS_ALL.Currency_Code%TYPE,
175 p_Conversion_Type IGC_CC_HEADERS_ALL.Conversion_Type%TYPE,
176 p_Conversion_Date IGC_CC_HEADERS_ALL.Conversion_Date%TYPE,
177 p_Conversion_Rate IGC_CC_HEADERS_ALL.Conversion_Rate%TYPE,
178 p_Last_Update_Date IGC_CC_HEADERS_ALL.Last_Update_Date%TYPE,
179 p_Last_Updated_By IGC_CC_HEADERS_ALL.Last_Updated_By%TYPE,
180 p_Last_Update_Login IGC_CC_HEADERS_ALL.Last_Update_Login%TYPE,
181 p_Created_By IGC_CC_HEADERS_ALL.Created_By%TYPE,
182 p_Creation_Date IGC_CC_HEADERS_ALL.Creation_Date%TYPE,
186 p_Attribute1 IGC_CC_HEADERS_ALL.Attribute1%TYPE,
183 p_CC_Current_User_Id IGC_CC_HEADERS_ALL.CC_Current_User_Id%TYPE,
184 p_Wf_Item_Type IGC_CC_HEADERS_ALL.Wf_Item_Type%TYPE,
185 p_Wf_Item_Key IGC_CC_HEADERS_ALL.Wf_Item_Key%TYPE,
187 p_Attribute2 IGC_CC_HEADERS_ALL.Attribute2%TYPE,
188 p_Attribute3 IGC_CC_HEADERS_ALL.Attribute3%TYPE,
189 p_Attribute4 IGC_CC_HEADERS_ALL.Attribute4%TYPE,
190 p_Attribute5 IGC_CC_HEADERS_ALL.Attribute5%TYPE,
191 p_Attribute6 IGC_CC_HEADERS_ALL.Attribute6%TYPE,
192 p_Attribute7 IGC_CC_HEADERS_ALL.Attribute7%TYPE,
193 p_Attribute8 IGC_CC_HEADERS_ALL.Attribute8%TYPE,
194 p_Attribute9 IGC_CC_HEADERS_ALL.Attribute9%TYPE,
195 p_Attribute10 IGC_CC_HEADERS_ALL.Attribute10%TYPE,
196 p_Attribute11 IGC_CC_HEADERS_ALL.Attribute11%TYPE,
197 p_Attribute12 IGC_CC_HEADERS_ALL.Attribute12%TYPE,
198 p_Attribute13 IGC_CC_HEADERS_ALL.Attribute13%TYPE,
199 p_Attribute14 IGC_CC_HEADERS_ALL.Attribute14%TYPE,
200 p_Attribute15 IGC_CC_HEADERS_ALL.Attribute15%TYPE,
201 p_Context IGC_CC_HEADERS_ALL.Context%TYPE,
202 p_CC_Guarantee_Flag IGC_CC_HEADERS_ALL.CC_Guarantee_Flag%TYPE,
203 X_row_locked OUT NOCOPY VARCHAR2,
204 G_FLAG IN OUT NOCOPY VARCHAR2
205 );
206
207 /* ================================================================================
208 PROCEDURE Update_Row Overloaded Procedure for CC_REF_NUM addition
209 ===============================================================================*/
210 PROCEDURE Update_Row(
211 p_api_version IN NUMBER,
212 p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
213 p_commit IN VARCHAR2 := FND_API.G_FALSE,
214 p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
215 X_return_status OUT NOCOPY VARCHAR2,
216 X_msg_count OUT NOCOPY NUMBER,
217 X_msg_data OUT NOCOPY VARCHAR2,
218 p_Rowid IN OUT NOCOPY VARCHAR2,
219 p_CC_Header_Id IGC_CC_HEADERS_ALL.CC_Header_Id%TYPE,
220 p_Org_id IGC_CC_HEADERS_ALL.Org_id%TYPE,
221 p_CC_Type IGC_CC_HEADERS_ALL.CC_Type%TYPE,
222 p_CC_Num IGC_CC_HEADERS_ALL.CC_Num%TYPE,
223 p_CC_Ref_Num IGC_CC_HEADERS_ALL.CC_Ref_Num%TYPE,
224 p_CC_Version_num IGC_CC_HEADERS_ALL.CC_Version_num%TYPE,
225 p_Parent_Header_Id IGC_CC_HEADERS_ALL.Parent_Header_Id%TYPE,
226 p_CC_State IGC_CC_HEADERS_ALL.CC_State%TYPE,
227 p_CC_ctrl_status IGC_CC_HEADERS_ALL.CC_ctrl_status%TYPE,
228 p_CC_Encmbrnc_Status IGC_CC_HEADERS_ALL.CC_Encmbrnc_Status%TYPE,
229 p_CC_Apprvl_Status IGC_CC_HEADERS_ALL.CC_Apprvl_Status%TYPE,
230 p_Vendor_Id IGC_CC_HEADERS_ALL.Vendor_Id%TYPE,
231 p_Vendor_Site_Id IGC_CC_HEADERS_ALL.Vendor_Site_Id%TYPE,
232 p_Vendor_Contact_Id IGC_CC_HEADERS_ALL.Vendor_Contact_Id%TYPE,
233 p_Term_Id IGC_CC_HEADERS_ALL.Term_Id%TYPE,
234 p_Location_Id IGC_CC_HEADERS_ALL.Location_Id%TYPE,
235 p_Set_Of_Books_Id IGC_CC_HEADERS_ALL.Set_Of_Books_Id%TYPE,
236 p_CC_Acct_Date IGC_CC_HEADERS_ALL.CC_Acct_Date%TYPE,
237 p_CC_Desc IGC_CC_HEADERS_ALL.CC_Desc%TYPE,
238 p_CC_Start_Date IGC_CC_HEADERS_ALL.CC_Start_Date%TYPE,
239 p_CC_End_Date IGC_CC_HEADERS_ALL.CC_End_Date%TYPE,
240 p_CC_Owner_User_Id IGC_CC_HEADERS_ALL.CC_Owner_User_Id%TYPE,
241 p_CC_Preparer_User_Id IGC_CC_HEADERS_ALL.CC_Preparer_User_Id%TYPE,
242 p_Currency_Code IGC_CC_HEADERS_ALL.Currency_Code%TYPE,
243 p_Conversion_Type IGC_CC_HEADERS_ALL.Conversion_Type%TYPE,
244 p_Conversion_Date IGC_CC_HEADERS_ALL.Conversion_Date%TYPE,
245 p_Conversion_Rate IGC_CC_HEADERS_ALL.Conversion_Rate%TYPE,
246 p_Last_Update_Date IGC_CC_HEADERS_ALL.Last_Update_Date%TYPE,
247 p_Last_Updated_By IGC_CC_HEADERS_ALL.Last_Updated_By%TYPE,
248 p_Last_Update_Login IGC_CC_HEADERS_ALL.Last_Update_Login%TYPE,
249 p_Created_By IGC_CC_HEADERS_ALL.Created_By%TYPE,
250 p_Creation_Date IGC_CC_HEADERS_ALL.Creation_Date%TYPE,
251 p_CC_Current_User_Id IGC_CC_HEADERS_ALL.CC_Current_User_Id%TYPE,
252 p_Wf_Item_Type IGC_CC_HEADERS_ALL.Wf_Item_Type%TYPE,
256 p_Attribute3 IGC_CC_HEADERS_ALL.Attribute3%TYPE,
253 p_Wf_Item_Key IGC_CC_HEADERS_ALL.Wf_Item_Key%TYPE,
254 p_Attribute1 IGC_CC_HEADERS_ALL.Attribute1%TYPE,
255 p_Attribute2 IGC_CC_HEADERS_ALL.Attribute2%TYPE,
257 p_Attribute4 IGC_CC_HEADERS_ALL.Attribute4%TYPE,
258 p_Attribute5 IGC_CC_HEADERS_ALL.Attribute5%TYPE,
259 p_Attribute6 IGC_CC_HEADERS_ALL.Attribute6%TYPE,
260 p_Attribute7 IGC_CC_HEADERS_ALL.Attribute7%TYPE,
261 p_Attribute8 IGC_CC_HEADERS_ALL.Attribute8%TYPE,
262 p_Attribute9 IGC_CC_HEADERS_ALL.Attribute9%TYPE,
263 p_Attribute10 IGC_CC_HEADERS_ALL.Attribute10%TYPE,
264 p_Attribute11 IGC_CC_HEADERS_ALL.Attribute11%TYPE,
265 p_Attribute12 IGC_CC_HEADERS_ALL.Attribute12%TYPE,
266 p_Attribute13 IGC_CC_HEADERS_ALL.Attribute13%TYPE,
267 p_Attribute14 IGC_CC_HEADERS_ALL.Attribute14%TYPE,
268 p_Attribute15 IGC_CC_HEADERS_ALL.Attribute15%TYPE,
269 p_Context IGC_CC_HEADERS_ALL.Context%TYPE,
270 p_CC_Guarantee_Flag IGC_CC_HEADERS_ALL.CC_Guarantee_Flag%TYPE,
271 G_FLAG IN OUT NOCOPY VARCHAR2
272 );
273
274 /* ================================================================================
275 PROCEDURE Update_Row
276 ===============================================================================*/
277 PROCEDURE Update_Row(
278 p_api_version IN NUMBER,
279 p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
280 p_commit IN VARCHAR2 := FND_API.G_FALSE,
281 p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
282 X_return_status OUT NOCOPY VARCHAR2,
283 X_msg_count OUT NOCOPY NUMBER,
284 X_msg_data OUT NOCOPY VARCHAR2,
285 p_Rowid IN OUT NOCOPY VARCHAR2,
286 p_CC_Header_Id IGC_CC_HEADERS_ALL.CC_Header_Id%TYPE,
287 p_Org_id IGC_CC_HEADERS_ALL.Org_id%TYPE,
288 p_CC_Type IGC_CC_HEADERS_ALL.CC_Type%TYPE,
289 p_CC_Num IGC_CC_HEADERS_ALL.CC_Num%TYPE,
290 p_CC_Version_num IGC_CC_HEADERS_ALL.CC_Version_num%TYPE,
291 p_Parent_Header_Id IGC_CC_HEADERS_ALL.Parent_Header_Id%TYPE,
292 p_CC_State IGC_CC_HEADERS_ALL.CC_State%TYPE,
293 p_CC_ctrl_status IGC_CC_HEADERS_ALL.CC_ctrl_status%TYPE,
294 p_CC_Encmbrnc_Status IGC_CC_HEADERS_ALL.CC_Encmbrnc_Status%TYPE,
295 p_CC_Apprvl_Status IGC_CC_HEADERS_ALL.CC_Apprvl_Status%TYPE,
296 p_Vendor_Id IGC_CC_HEADERS_ALL.Vendor_Id%TYPE,
297 p_Vendor_Site_Id IGC_CC_HEADERS_ALL.Vendor_Site_Id%TYPE,
298 p_Vendor_Contact_Id IGC_CC_HEADERS_ALL.Vendor_Contact_Id%TYPE,
299 p_Term_Id IGC_CC_HEADERS_ALL.Term_Id%TYPE,
300 p_Location_Id IGC_CC_HEADERS_ALL.Location_Id%TYPE,
301 p_Set_Of_Books_Id IGC_CC_HEADERS_ALL.Set_Of_Books_Id%TYPE,
302 p_CC_Acct_Date IGC_CC_HEADERS_ALL.CC_Acct_Date%TYPE,
303 p_CC_Desc IGC_CC_HEADERS_ALL.CC_Desc%TYPE,
304 p_CC_Start_Date IGC_CC_HEADERS_ALL.CC_Start_Date%TYPE,
305 p_CC_End_Date IGC_CC_HEADERS_ALL.CC_End_Date%TYPE,
306 p_CC_Owner_User_Id IGC_CC_HEADERS_ALL.CC_Owner_User_Id%TYPE,
307 p_CC_Preparer_User_Id IGC_CC_HEADERS_ALL.CC_Preparer_User_Id%TYPE,
308 p_Currency_Code IGC_CC_HEADERS_ALL.Currency_Code%TYPE,
309 p_Conversion_Type IGC_CC_HEADERS_ALL.Conversion_Type%TYPE,
310 p_Conversion_Date IGC_CC_HEADERS_ALL.Conversion_Date%TYPE,
311 p_Conversion_Rate IGC_CC_HEADERS_ALL.Conversion_Rate%TYPE,
312 p_Last_Update_Date IGC_CC_HEADERS_ALL.Last_Update_Date%TYPE,
313 p_Last_Updated_By IGC_CC_HEADERS_ALL.Last_Updated_By%TYPE,
314 p_Last_Update_Login IGC_CC_HEADERS_ALL.Last_Update_Login%TYPE,
315 p_Created_By IGC_CC_HEADERS_ALL.Created_By%TYPE,
316 p_Creation_Date IGC_CC_HEADERS_ALL.Creation_Date%TYPE,
317 p_CC_Current_User_Id IGC_CC_HEADERS_ALL.CC_Current_User_Id%TYPE,
318 p_Wf_Item_Type IGC_CC_HEADERS_ALL.Wf_Item_Type%TYPE,
319 p_Wf_Item_Key IGC_CC_HEADERS_ALL.Wf_Item_Key%TYPE,
320 p_Attribute1 IGC_CC_HEADERS_ALL.Attribute1%TYPE,
321 p_Attribute2 IGC_CC_HEADERS_ALL.Attribute2%TYPE,
322 p_Attribute3 IGC_CC_HEADERS_ALL.Attribute3%TYPE,
326 p_Attribute7 IGC_CC_HEADERS_ALL.Attribute7%TYPE,
323 p_Attribute4 IGC_CC_HEADERS_ALL.Attribute4%TYPE,
324 p_Attribute5 IGC_CC_HEADERS_ALL.Attribute5%TYPE,
325 p_Attribute6 IGC_CC_HEADERS_ALL.Attribute6%TYPE,
327 p_Attribute8 IGC_CC_HEADERS_ALL.Attribute8%TYPE,
328 p_Attribute9 IGC_CC_HEADERS_ALL.Attribute9%TYPE,
329 p_Attribute10 IGC_CC_HEADERS_ALL.Attribute10%TYPE,
330 p_Attribute11 IGC_CC_HEADERS_ALL.Attribute11%TYPE,
331 p_Attribute12 IGC_CC_HEADERS_ALL.Attribute12%TYPE,
332 p_Attribute13 IGC_CC_HEADERS_ALL.Attribute13%TYPE,
333 p_Attribute14 IGC_CC_HEADERS_ALL.Attribute14%TYPE,
334 p_Attribute15 IGC_CC_HEADERS_ALL.Attribute15%TYPE,
335 p_Context IGC_CC_HEADERS_ALL.Context%TYPE,
336 p_CC_Guarantee_Flag IGC_CC_HEADERS_ALL.CC_Guarantee_Flag%TYPE,
337 G_FLAG IN OUT NOCOPY VARCHAR2
338 );
339
340 /* ==============================================================================
341 PROCEDURE Delete_Row
342 ============================================================================*/
343 PROCEDURE Delete_Row(
344 p_api_version IN NUMBER,
345 p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
346 p_commit IN VARCHAR2 := FND_API.G_FALSE,
347 p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
348 X_return_status OUT NOCOPY VARCHAR2,
349 X_msg_count OUT NOCOPY NUMBER,
350 X_msg_data OUT NOCOPY VARCHAR2,
351 p_Rowid IN OUT NOCOPY VARCHAR2,
352 G_FLAG IN OUT NOCOPY VARCHAR2
353 );
354
355 END IGC_CC_HEADERS_PKG;