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