1: PACKAGE BODY IGC_CC_ACTIONS_PKG as
2: /* $Header: IGCCACTB.pls 120.3.12000000.1 2007/08/20 12:10:44 mbremkum ship $ */
3:
4: G_PKG_NAME CONSTANT VARCHAR2(30):= 'IGC_CC_ACTIONS_PKG';
5:
1: PACKAGE BODY IGC_CC_ACTIONS_PKG as
2: /* $Header: IGCCACTB.pls 120.3.12000000.1 2007/08/20 12:10:44 mbremkum ship $ */
3:
4: G_PKG_NAME CONSTANT VARCHAR2(30):= 'IGC_CC_ACTIONS_PKG';
5:
6: g_debug_flag VARCHAR2(1) := 'N' ;
7:
8:
20: X_return_status OUT NOCOPY VARCHAR2,
21: X_msg_count OUT NOCOPY NUMBER,
22: X_msg_data OUT NOCOPY VARCHAR2,
23: p_Rowid IN OUT NOCOPY VARCHAR2,
24: p_CC_Header_Id IGC_CC_ACTIONS.CC_Header_Id%TYPE,
25: p_CC_Action_Version_Num IGC_CC_ACTIONS.CC_Action_Version_Num%TYPE,
26: p_CC_Action_Type IGC_CC_ACTIONS.CC_Action_Type %TYPE,
27: p_CC_Action_State IGC_CC_ACTIONS.CC_Action_State%TYPE,
28: p_CC_Action_Ctrl_Status IGC_CC_ACTIONS.CC_Action_Ctrl_Status%TYPE,
21: X_msg_count OUT NOCOPY NUMBER,
22: X_msg_data OUT NOCOPY VARCHAR2,
23: p_Rowid IN OUT NOCOPY VARCHAR2,
24: p_CC_Header_Id IGC_CC_ACTIONS.CC_Header_Id%TYPE,
25: p_CC_Action_Version_Num IGC_CC_ACTIONS.CC_Action_Version_Num%TYPE,
26: p_CC_Action_Type IGC_CC_ACTIONS.CC_Action_Type %TYPE,
27: p_CC_Action_State IGC_CC_ACTIONS.CC_Action_State%TYPE,
28: p_CC_Action_Ctrl_Status IGC_CC_ACTIONS.CC_Action_Ctrl_Status%TYPE,
29: p_CC_Action_Apprvl_Status IGC_CC_ACTIONS.CC_Action_Apprvl_Status%TYPE,
22: X_msg_data OUT NOCOPY VARCHAR2,
23: p_Rowid IN OUT NOCOPY VARCHAR2,
24: p_CC_Header_Id IGC_CC_ACTIONS.CC_Header_Id%TYPE,
25: p_CC_Action_Version_Num IGC_CC_ACTIONS.CC_Action_Version_Num%TYPE,
26: p_CC_Action_Type IGC_CC_ACTIONS.CC_Action_Type %TYPE,
27: p_CC_Action_State IGC_CC_ACTIONS.CC_Action_State%TYPE,
28: p_CC_Action_Ctrl_Status IGC_CC_ACTIONS.CC_Action_Ctrl_Status%TYPE,
29: p_CC_Action_Apprvl_Status IGC_CC_ACTIONS.CC_Action_Apprvl_Status%TYPE,
30: p_CC_Action_Notes IGC_CC_ACTIONS.CC_Action_Notes%TYPE,
23: p_Rowid IN OUT NOCOPY VARCHAR2,
24: p_CC_Header_Id IGC_CC_ACTIONS.CC_Header_Id%TYPE,
25: p_CC_Action_Version_Num IGC_CC_ACTIONS.CC_Action_Version_Num%TYPE,
26: p_CC_Action_Type IGC_CC_ACTIONS.CC_Action_Type %TYPE,
27: p_CC_Action_State IGC_CC_ACTIONS.CC_Action_State%TYPE,
28: p_CC_Action_Ctrl_Status IGC_CC_ACTIONS.CC_Action_Ctrl_Status%TYPE,
29: p_CC_Action_Apprvl_Status IGC_CC_ACTIONS.CC_Action_Apprvl_Status%TYPE,
30: p_CC_Action_Notes IGC_CC_ACTIONS.CC_Action_Notes%TYPE,
31: p_Last_Update_Date IGC_CC_ACTIONS.Last_Update_Date%TYPE,
24: p_CC_Header_Id IGC_CC_ACTIONS.CC_Header_Id%TYPE,
25: p_CC_Action_Version_Num IGC_CC_ACTIONS.CC_Action_Version_Num%TYPE,
26: p_CC_Action_Type IGC_CC_ACTIONS.CC_Action_Type %TYPE,
27: p_CC_Action_State IGC_CC_ACTIONS.CC_Action_State%TYPE,
28: p_CC_Action_Ctrl_Status IGC_CC_ACTIONS.CC_Action_Ctrl_Status%TYPE,
29: p_CC_Action_Apprvl_Status IGC_CC_ACTIONS.CC_Action_Apprvl_Status%TYPE,
30: p_CC_Action_Notes IGC_CC_ACTIONS.CC_Action_Notes%TYPE,
31: p_Last_Update_Date IGC_CC_ACTIONS.Last_Update_Date%TYPE,
32: p_Last_Updated_By IGC_CC_ACTIONS.Last_Updated_By%TYPE,
25: p_CC_Action_Version_Num IGC_CC_ACTIONS.CC_Action_Version_Num%TYPE,
26: p_CC_Action_Type IGC_CC_ACTIONS.CC_Action_Type %TYPE,
27: p_CC_Action_State IGC_CC_ACTIONS.CC_Action_State%TYPE,
28: p_CC_Action_Ctrl_Status IGC_CC_ACTIONS.CC_Action_Ctrl_Status%TYPE,
29: p_CC_Action_Apprvl_Status IGC_CC_ACTIONS.CC_Action_Apprvl_Status%TYPE,
30: p_CC_Action_Notes IGC_CC_ACTIONS.CC_Action_Notes%TYPE,
31: p_Last_Update_Date IGC_CC_ACTIONS.Last_Update_Date%TYPE,
32: p_Last_Updated_By IGC_CC_ACTIONS.Last_Updated_By%TYPE,
33: p_Last_Update_Login IGC_CC_ACTIONS.Last_Update_Login%TYPE,
26: p_CC_Action_Type IGC_CC_ACTIONS.CC_Action_Type %TYPE,
27: p_CC_Action_State IGC_CC_ACTIONS.CC_Action_State%TYPE,
28: p_CC_Action_Ctrl_Status IGC_CC_ACTIONS.CC_Action_Ctrl_Status%TYPE,
29: p_CC_Action_Apprvl_Status IGC_CC_ACTIONS.CC_Action_Apprvl_Status%TYPE,
30: p_CC_Action_Notes IGC_CC_ACTIONS.CC_Action_Notes%TYPE,
31: p_Last_Update_Date IGC_CC_ACTIONS.Last_Update_Date%TYPE,
32: p_Last_Updated_By IGC_CC_ACTIONS.Last_Updated_By%TYPE,
33: p_Last_Update_Login IGC_CC_ACTIONS.Last_Update_Login%TYPE,
34: p_Creation_Date IGC_CC_ACTIONS.Creation_Date%TYPE,
27: p_CC_Action_State IGC_CC_ACTIONS.CC_Action_State%TYPE,
28: p_CC_Action_Ctrl_Status IGC_CC_ACTIONS.CC_Action_Ctrl_Status%TYPE,
29: p_CC_Action_Apprvl_Status IGC_CC_ACTIONS.CC_Action_Apprvl_Status%TYPE,
30: p_CC_Action_Notes IGC_CC_ACTIONS.CC_Action_Notes%TYPE,
31: p_Last_Update_Date IGC_CC_ACTIONS.Last_Update_Date%TYPE,
32: p_Last_Updated_By IGC_CC_ACTIONS.Last_Updated_By%TYPE,
33: p_Last_Update_Login IGC_CC_ACTIONS.Last_Update_Login%TYPE,
34: p_Creation_Date IGC_CC_ACTIONS.Creation_Date%TYPE,
35: p_Created_By IGC_CC_ACTIONS.Created_By%TYPE
28: p_CC_Action_Ctrl_Status IGC_CC_ACTIONS.CC_Action_Ctrl_Status%TYPE,
29: p_CC_Action_Apprvl_Status IGC_CC_ACTIONS.CC_Action_Apprvl_Status%TYPE,
30: p_CC_Action_Notes IGC_CC_ACTIONS.CC_Action_Notes%TYPE,
31: p_Last_Update_Date IGC_CC_ACTIONS.Last_Update_Date%TYPE,
32: p_Last_Updated_By IGC_CC_ACTIONS.Last_Updated_By%TYPE,
33: p_Last_Update_Login IGC_CC_ACTIONS.Last_Update_Login%TYPE,
34: p_Creation_Date IGC_CC_ACTIONS.Creation_Date%TYPE,
35: p_Created_By IGC_CC_ACTIONS.Created_By%TYPE
36: ) IS
29: p_CC_Action_Apprvl_Status IGC_CC_ACTIONS.CC_Action_Apprvl_Status%TYPE,
30: p_CC_Action_Notes IGC_CC_ACTIONS.CC_Action_Notes%TYPE,
31: p_Last_Update_Date IGC_CC_ACTIONS.Last_Update_Date%TYPE,
32: p_Last_Updated_By IGC_CC_ACTIONS.Last_Updated_By%TYPE,
33: p_Last_Update_Login IGC_CC_ACTIONS.Last_Update_Login%TYPE,
34: p_Creation_Date IGC_CC_ACTIONS.Creation_Date%TYPE,
35: p_Created_By IGC_CC_ACTIONS.Created_By%TYPE
36: ) IS
37:
30: p_CC_Action_Notes IGC_CC_ACTIONS.CC_Action_Notes%TYPE,
31: p_Last_Update_Date IGC_CC_ACTIONS.Last_Update_Date%TYPE,
32: p_Last_Updated_By IGC_CC_ACTIONS.Last_Updated_By%TYPE,
33: p_Last_Update_Login IGC_CC_ACTIONS.Last_Update_Login%TYPE,
34: p_Creation_Date IGC_CC_ACTIONS.Creation_Date%TYPE,
35: p_Created_By IGC_CC_ACTIONS.Created_By%TYPE
36: ) IS
37:
38: l_api_name CONSTANT VARCHAR2(30) := 'Insert_Row';
31: p_Last_Update_Date IGC_CC_ACTIONS.Last_Update_Date%TYPE,
32: p_Last_Updated_By IGC_CC_ACTIONS.Last_Updated_By%TYPE,
33: p_Last_Update_Login IGC_CC_ACTIONS.Last_Update_Login%TYPE,
34: p_Creation_Date IGC_CC_ACTIONS.Creation_Date%TYPE,
35: p_Created_By IGC_CC_ACTIONS.Created_By%TYPE
36: ) IS
37:
38: l_api_name CONSTANT VARCHAR2(30) := 'Insert_Row';
39: l_api_version CONSTANT NUMBER := 1.0;
36: ) IS
37:
38: l_api_name CONSTANT VARCHAR2(30) := 'Insert_Row';
39: l_api_version CONSTANT NUMBER := 1.0;
40: l_CC_Action_Num IGC_CC_ACTIONS.CC_Action_Num%TYPE;
41: CURSOR C IS
42: SELECT Rowid
43: FROM IGC_CC_ACTIONS
44: WHERE CC_Header_Id = p_CC_Header_Id;
39: l_api_version CONSTANT NUMBER := 1.0;
40: l_CC_Action_Num IGC_CC_ACTIONS.CC_Action_Num%TYPE;
41: CURSOR C IS
42: SELECT Rowid
43: FROM IGC_CC_ACTIONS
44: WHERE CC_Header_Id = p_CC_Header_Id;
45:
46: CURSOR C1 IS
47: SELECT NVL(MAX(CC_Action_Num),0)
44: WHERE CC_Header_Id = p_CC_Header_Id;
45:
46: CURSOR C1 IS
47: SELECT NVL(MAX(CC_Action_Num),0)
48: FROM IGC_CC_ACTIONS
49: WHERE CC_Header_Id = p_CC_Header_Id;
50:
51: BEGIN
52:
74:
75: X_return_status := FND_API.G_RET_STS_SUCCESS ;
76:
77:
78: INSERT INTO IGC_CC_ACTIONS(
79: CC_Header_Id,
80: CC_Action_Num,
81: CC_Action_Version_Num,
82: CC_Action_Type,
169: X_return_status OUT NOCOPY VARCHAR2,
170: X_msg_count OUT NOCOPY NUMBER,
171: X_msg_data OUT NOCOPY VARCHAR2,
172: p_Rowid IN OUT NOCOPY VARCHAR2,
173: p_CC_Header_Id IGC_CC_ACTIONS.CC_Header_Id%TYPE,
174: p_CC_Action_Num IGC_CC_ACTIONS.CC_Action_Num%TYPE,
175: p_CC_Action_Version_Num IGC_CC_ACTIONS.CC_Action_Version_Num%TYPE,
176: p_CC_Action_Type IGC_CC_ACTIONS.CC_Action_Type %TYPE,
177: p_CC_Action_State IGC_CC_ACTIONS.CC_Action_State%TYPE,
170: X_msg_count OUT NOCOPY NUMBER,
171: X_msg_data OUT NOCOPY VARCHAR2,
172: p_Rowid IN OUT NOCOPY VARCHAR2,
173: p_CC_Header_Id IGC_CC_ACTIONS.CC_Header_Id%TYPE,
174: p_CC_Action_Num IGC_CC_ACTIONS.CC_Action_Num%TYPE,
175: p_CC_Action_Version_Num IGC_CC_ACTIONS.CC_Action_Version_Num%TYPE,
176: p_CC_Action_Type IGC_CC_ACTIONS.CC_Action_Type %TYPE,
177: p_CC_Action_State IGC_CC_ACTIONS.CC_Action_State%TYPE,
178: p_CC_Action_Ctrl_Status IGC_CC_ACTIONS.CC_Action_Ctrl_Status%TYPE,
171: X_msg_data OUT NOCOPY VARCHAR2,
172: p_Rowid IN OUT NOCOPY VARCHAR2,
173: p_CC_Header_Id IGC_CC_ACTIONS.CC_Header_Id%TYPE,
174: p_CC_Action_Num IGC_CC_ACTIONS.CC_Action_Num%TYPE,
175: p_CC_Action_Version_Num IGC_CC_ACTIONS.CC_Action_Version_Num%TYPE,
176: p_CC_Action_Type IGC_CC_ACTIONS.CC_Action_Type %TYPE,
177: p_CC_Action_State IGC_CC_ACTIONS.CC_Action_State%TYPE,
178: p_CC_Action_Ctrl_Status IGC_CC_ACTIONS.CC_Action_Ctrl_Status%TYPE,
179: p_CC_Action_Apprvl_Status IGC_CC_ACTIONS.CC_Action_Apprvl_Status%TYPE,
172: p_Rowid IN OUT NOCOPY VARCHAR2,
173: p_CC_Header_Id IGC_CC_ACTIONS.CC_Header_Id%TYPE,
174: p_CC_Action_Num IGC_CC_ACTIONS.CC_Action_Num%TYPE,
175: p_CC_Action_Version_Num IGC_CC_ACTIONS.CC_Action_Version_Num%TYPE,
176: p_CC_Action_Type IGC_CC_ACTIONS.CC_Action_Type %TYPE,
177: p_CC_Action_State IGC_CC_ACTIONS.CC_Action_State%TYPE,
178: p_CC_Action_Ctrl_Status IGC_CC_ACTIONS.CC_Action_Ctrl_Status%TYPE,
179: p_CC_Action_Apprvl_Status IGC_CC_ACTIONS.CC_Action_Apprvl_Status%TYPE,
180: p_CC_Action_Notes IGC_CC_ACTIONS.CC_Action_Notes%TYPE,
173: p_CC_Header_Id IGC_CC_ACTIONS.CC_Header_Id%TYPE,
174: p_CC_Action_Num IGC_CC_ACTIONS.CC_Action_Num%TYPE,
175: p_CC_Action_Version_Num IGC_CC_ACTIONS.CC_Action_Version_Num%TYPE,
176: p_CC_Action_Type IGC_CC_ACTIONS.CC_Action_Type %TYPE,
177: p_CC_Action_State IGC_CC_ACTIONS.CC_Action_State%TYPE,
178: p_CC_Action_Ctrl_Status IGC_CC_ACTIONS.CC_Action_Ctrl_Status%TYPE,
179: p_CC_Action_Apprvl_Status IGC_CC_ACTIONS.CC_Action_Apprvl_Status%TYPE,
180: p_CC_Action_Notes IGC_CC_ACTIONS.CC_Action_Notes%TYPE,
181: p_Last_Update_Date IGC_CC_ACTIONS.Last_Update_Date%TYPE,
174: p_CC_Action_Num IGC_CC_ACTIONS.CC_Action_Num%TYPE,
175: p_CC_Action_Version_Num IGC_CC_ACTIONS.CC_Action_Version_Num%TYPE,
176: p_CC_Action_Type IGC_CC_ACTIONS.CC_Action_Type %TYPE,
177: p_CC_Action_State IGC_CC_ACTIONS.CC_Action_State%TYPE,
178: p_CC_Action_Ctrl_Status IGC_CC_ACTIONS.CC_Action_Ctrl_Status%TYPE,
179: p_CC_Action_Apprvl_Status IGC_CC_ACTIONS.CC_Action_Apprvl_Status%TYPE,
180: p_CC_Action_Notes IGC_CC_ACTIONS.CC_Action_Notes%TYPE,
181: p_Last_Update_Date IGC_CC_ACTIONS.Last_Update_Date%TYPE,
182: p_Last_Updated_By IGC_CC_ACTIONS.Last_Updated_By%TYPE,
175: p_CC_Action_Version_Num IGC_CC_ACTIONS.CC_Action_Version_Num%TYPE,
176: p_CC_Action_Type IGC_CC_ACTIONS.CC_Action_Type %TYPE,
177: p_CC_Action_State IGC_CC_ACTIONS.CC_Action_State%TYPE,
178: p_CC_Action_Ctrl_Status IGC_CC_ACTIONS.CC_Action_Ctrl_Status%TYPE,
179: p_CC_Action_Apprvl_Status IGC_CC_ACTIONS.CC_Action_Apprvl_Status%TYPE,
180: p_CC_Action_Notes IGC_CC_ACTIONS.CC_Action_Notes%TYPE,
181: p_Last_Update_Date IGC_CC_ACTIONS.Last_Update_Date%TYPE,
182: p_Last_Updated_By IGC_CC_ACTIONS.Last_Updated_By%TYPE,
183: p_Last_Update_Login IGC_CC_ACTIONS.Last_Update_Login%TYPE,
176: p_CC_Action_Type IGC_CC_ACTIONS.CC_Action_Type %TYPE,
177: p_CC_Action_State IGC_CC_ACTIONS.CC_Action_State%TYPE,
178: p_CC_Action_Ctrl_Status IGC_CC_ACTIONS.CC_Action_Ctrl_Status%TYPE,
179: p_CC_Action_Apprvl_Status IGC_CC_ACTIONS.CC_Action_Apprvl_Status%TYPE,
180: p_CC_Action_Notes IGC_CC_ACTIONS.CC_Action_Notes%TYPE,
181: p_Last_Update_Date IGC_CC_ACTIONS.Last_Update_Date%TYPE,
182: p_Last_Updated_By IGC_CC_ACTIONS.Last_Updated_By%TYPE,
183: p_Last_Update_Login IGC_CC_ACTIONS.Last_Update_Login%TYPE,
184: p_Creation_Date IGC_CC_ACTIONS.Creation_Date%TYPE,
177: p_CC_Action_State IGC_CC_ACTIONS.CC_Action_State%TYPE,
178: p_CC_Action_Ctrl_Status IGC_CC_ACTIONS.CC_Action_Ctrl_Status%TYPE,
179: p_CC_Action_Apprvl_Status IGC_CC_ACTIONS.CC_Action_Apprvl_Status%TYPE,
180: p_CC_Action_Notes IGC_CC_ACTIONS.CC_Action_Notes%TYPE,
181: p_Last_Update_Date IGC_CC_ACTIONS.Last_Update_Date%TYPE,
182: p_Last_Updated_By IGC_CC_ACTIONS.Last_Updated_By%TYPE,
183: p_Last_Update_Login IGC_CC_ACTIONS.Last_Update_Login%TYPE,
184: p_Creation_Date IGC_CC_ACTIONS.Creation_Date%TYPE,
185: p_Created_By IGC_CC_ACTIONS.Created_By%TYPE,
178: p_CC_Action_Ctrl_Status IGC_CC_ACTIONS.CC_Action_Ctrl_Status%TYPE,
179: p_CC_Action_Apprvl_Status IGC_CC_ACTIONS.CC_Action_Apprvl_Status%TYPE,
180: p_CC_Action_Notes IGC_CC_ACTIONS.CC_Action_Notes%TYPE,
181: p_Last_Update_Date IGC_CC_ACTIONS.Last_Update_Date%TYPE,
182: p_Last_Updated_By IGC_CC_ACTIONS.Last_Updated_By%TYPE,
183: p_Last_Update_Login IGC_CC_ACTIONS.Last_Update_Login%TYPE,
184: p_Creation_Date IGC_CC_ACTIONS.Creation_Date%TYPE,
185: p_Created_By IGC_CC_ACTIONS.Created_By%TYPE,
186: X_row_locked OUT NOCOPY VARCHAR2
179: p_CC_Action_Apprvl_Status IGC_CC_ACTIONS.CC_Action_Apprvl_Status%TYPE,
180: p_CC_Action_Notes IGC_CC_ACTIONS.CC_Action_Notes%TYPE,
181: p_Last_Update_Date IGC_CC_ACTIONS.Last_Update_Date%TYPE,
182: p_Last_Updated_By IGC_CC_ACTIONS.Last_Updated_By%TYPE,
183: p_Last_Update_Login IGC_CC_ACTIONS.Last_Update_Login%TYPE,
184: p_Creation_Date IGC_CC_ACTIONS.Creation_Date%TYPE,
185: p_Created_By IGC_CC_ACTIONS.Created_By%TYPE,
186: X_row_locked OUT NOCOPY VARCHAR2
187: ) IS
180: p_CC_Action_Notes IGC_CC_ACTIONS.CC_Action_Notes%TYPE,
181: p_Last_Update_Date IGC_CC_ACTIONS.Last_Update_Date%TYPE,
182: p_Last_Updated_By IGC_CC_ACTIONS.Last_Updated_By%TYPE,
183: p_Last_Update_Login IGC_CC_ACTIONS.Last_Update_Login%TYPE,
184: p_Creation_Date IGC_CC_ACTIONS.Creation_Date%TYPE,
185: p_Created_By IGC_CC_ACTIONS.Created_By%TYPE,
186: X_row_locked OUT NOCOPY VARCHAR2
187: ) IS
188:
181: p_Last_Update_Date IGC_CC_ACTIONS.Last_Update_Date%TYPE,
182: p_Last_Updated_By IGC_CC_ACTIONS.Last_Updated_By%TYPE,
183: p_Last_Update_Login IGC_CC_ACTIONS.Last_Update_Login%TYPE,
184: p_Creation_Date IGC_CC_ACTIONS.Creation_Date%TYPE,
185: p_Created_By IGC_CC_ACTIONS.Created_By%TYPE,
186: X_row_locked OUT NOCOPY VARCHAR2
187: ) IS
188:
189: l_api_name CONSTANT VARCHAR2(30) := 'Lock_Row';
191: Counter NUMBER;
192:
193: CURSOR C IS
194: SELECT *
195: FROM IGC_CC_ACTIONS
196: WHERE Rowid = p_Rowid
197: FOR UPDATE of CC_Header_Id NOWAIT;
198: Recinfo C%ROWTYPE;
199:
337: X_return_status OUT NOCOPY VARCHAR2,
338: X_msg_count OUT NOCOPY NUMBER,
339: X_msg_data OUT NOCOPY VARCHAR2,
340: p_Rowid IN OUT NOCOPY VARCHAR2,
341: p_CC_Header_Id IGC_CC_ACTIONS.CC_Header_Id%TYPE,
342: p_CC_Action_Num IGC_CC_ACTIONS.CC_Action_Num%TYPE,
343: p_CC_Action_Version_Num IGC_CC_ACTIONS.CC_Action_Version_Num%TYPE,
344: p_CC_Action_Type IGC_CC_ACTIONS.CC_Action_Type %TYPE,
345: p_CC_Action_State IGC_CC_ACTIONS.CC_Action_State%TYPE,
338: X_msg_count OUT NOCOPY NUMBER,
339: X_msg_data OUT NOCOPY VARCHAR2,
340: p_Rowid IN OUT NOCOPY VARCHAR2,
341: p_CC_Header_Id IGC_CC_ACTIONS.CC_Header_Id%TYPE,
342: p_CC_Action_Num IGC_CC_ACTIONS.CC_Action_Num%TYPE,
343: p_CC_Action_Version_Num IGC_CC_ACTIONS.CC_Action_Version_Num%TYPE,
344: p_CC_Action_Type IGC_CC_ACTIONS.CC_Action_Type %TYPE,
345: p_CC_Action_State IGC_CC_ACTIONS.CC_Action_State%TYPE,
346: p_CC_Action_Ctrl_Status IGC_CC_ACTIONS.CC_Action_Ctrl_Status%TYPE,
339: X_msg_data OUT NOCOPY VARCHAR2,
340: p_Rowid IN OUT NOCOPY VARCHAR2,
341: p_CC_Header_Id IGC_CC_ACTIONS.CC_Header_Id%TYPE,
342: p_CC_Action_Num IGC_CC_ACTIONS.CC_Action_Num%TYPE,
343: p_CC_Action_Version_Num IGC_CC_ACTIONS.CC_Action_Version_Num%TYPE,
344: p_CC_Action_Type IGC_CC_ACTIONS.CC_Action_Type %TYPE,
345: p_CC_Action_State IGC_CC_ACTIONS.CC_Action_State%TYPE,
346: p_CC_Action_Ctrl_Status IGC_CC_ACTIONS.CC_Action_Ctrl_Status%TYPE,
347: p_CC_Action_Apprvl_Status IGC_CC_ACTIONS.CC_Action_Apprvl_Status%TYPE,
340: p_Rowid IN OUT NOCOPY VARCHAR2,
341: p_CC_Header_Id IGC_CC_ACTIONS.CC_Header_Id%TYPE,
342: p_CC_Action_Num IGC_CC_ACTIONS.CC_Action_Num%TYPE,
343: p_CC_Action_Version_Num IGC_CC_ACTIONS.CC_Action_Version_Num%TYPE,
344: p_CC_Action_Type IGC_CC_ACTIONS.CC_Action_Type %TYPE,
345: p_CC_Action_State IGC_CC_ACTIONS.CC_Action_State%TYPE,
346: p_CC_Action_Ctrl_Status IGC_CC_ACTIONS.CC_Action_Ctrl_Status%TYPE,
347: p_CC_Action_Apprvl_Status IGC_CC_ACTIONS.CC_Action_Apprvl_Status%TYPE,
348: p_CC_Action_Notes IGC_CC_ACTIONS.CC_Action_Notes%TYPE,
341: p_CC_Header_Id IGC_CC_ACTIONS.CC_Header_Id%TYPE,
342: p_CC_Action_Num IGC_CC_ACTIONS.CC_Action_Num%TYPE,
343: p_CC_Action_Version_Num IGC_CC_ACTIONS.CC_Action_Version_Num%TYPE,
344: p_CC_Action_Type IGC_CC_ACTIONS.CC_Action_Type %TYPE,
345: p_CC_Action_State IGC_CC_ACTIONS.CC_Action_State%TYPE,
346: p_CC_Action_Ctrl_Status IGC_CC_ACTIONS.CC_Action_Ctrl_Status%TYPE,
347: p_CC_Action_Apprvl_Status IGC_CC_ACTIONS.CC_Action_Apprvl_Status%TYPE,
348: p_CC_Action_Notes IGC_CC_ACTIONS.CC_Action_Notes%TYPE,
349: p_Last_Update_Date IGC_CC_ACTIONS.Last_Update_Date%TYPE,
342: p_CC_Action_Num IGC_CC_ACTIONS.CC_Action_Num%TYPE,
343: p_CC_Action_Version_Num IGC_CC_ACTIONS.CC_Action_Version_Num%TYPE,
344: p_CC_Action_Type IGC_CC_ACTIONS.CC_Action_Type %TYPE,
345: p_CC_Action_State IGC_CC_ACTIONS.CC_Action_State%TYPE,
346: p_CC_Action_Ctrl_Status IGC_CC_ACTIONS.CC_Action_Ctrl_Status%TYPE,
347: p_CC_Action_Apprvl_Status IGC_CC_ACTIONS.CC_Action_Apprvl_Status%TYPE,
348: p_CC_Action_Notes IGC_CC_ACTIONS.CC_Action_Notes%TYPE,
349: p_Last_Update_Date IGC_CC_ACTIONS.Last_Update_Date%TYPE,
350: p_Last_Updated_By IGC_CC_ACTIONS.Last_Updated_By%TYPE,
343: p_CC_Action_Version_Num IGC_CC_ACTIONS.CC_Action_Version_Num%TYPE,
344: p_CC_Action_Type IGC_CC_ACTIONS.CC_Action_Type %TYPE,
345: p_CC_Action_State IGC_CC_ACTIONS.CC_Action_State%TYPE,
346: p_CC_Action_Ctrl_Status IGC_CC_ACTIONS.CC_Action_Ctrl_Status%TYPE,
347: p_CC_Action_Apprvl_Status IGC_CC_ACTIONS.CC_Action_Apprvl_Status%TYPE,
348: p_CC_Action_Notes IGC_CC_ACTIONS.CC_Action_Notes%TYPE,
349: p_Last_Update_Date IGC_CC_ACTIONS.Last_Update_Date%TYPE,
350: p_Last_Updated_By IGC_CC_ACTIONS.Last_Updated_By%TYPE,
351: p_Last_Update_Login IGC_CC_ACTIONS.Last_Update_Login%TYPE,
344: p_CC_Action_Type IGC_CC_ACTIONS.CC_Action_Type %TYPE,
345: p_CC_Action_State IGC_CC_ACTIONS.CC_Action_State%TYPE,
346: p_CC_Action_Ctrl_Status IGC_CC_ACTIONS.CC_Action_Ctrl_Status%TYPE,
347: p_CC_Action_Apprvl_Status IGC_CC_ACTIONS.CC_Action_Apprvl_Status%TYPE,
348: p_CC_Action_Notes IGC_CC_ACTIONS.CC_Action_Notes%TYPE,
349: p_Last_Update_Date IGC_CC_ACTIONS.Last_Update_Date%TYPE,
350: p_Last_Updated_By IGC_CC_ACTIONS.Last_Updated_By%TYPE,
351: p_Last_Update_Login IGC_CC_ACTIONS.Last_Update_Login%TYPE,
352: p_Creation_Date IGC_CC_ACTIONS.Creation_Date%TYPE,
345: p_CC_Action_State IGC_CC_ACTIONS.CC_Action_State%TYPE,
346: p_CC_Action_Ctrl_Status IGC_CC_ACTIONS.CC_Action_Ctrl_Status%TYPE,
347: p_CC_Action_Apprvl_Status IGC_CC_ACTIONS.CC_Action_Apprvl_Status%TYPE,
348: p_CC_Action_Notes IGC_CC_ACTIONS.CC_Action_Notes%TYPE,
349: p_Last_Update_Date IGC_CC_ACTIONS.Last_Update_Date%TYPE,
350: p_Last_Updated_By IGC_CC_ACTIONS.Last_Updated_By%TYPE,
351: p_Last_Update_Login IGC_CC_ACTIONS.Last_Update_Login%TYPE,
352: p_Creation_Date IGC_CC_ACTIONS.Creation_Date%TYPE,
353: p_Created_By IGC_CC_ACTIONS.Created_By%TYPE
346: p_CC_Action_Ctrl_Status IGC_CC_ACTIONS.CC_Action_Ctrl_Status%TYPE,
347: p_CC_Action_Apprvl_Status IGC_CC_ACTIONS.CC_Action_Apprvl_Status%TYPE,
348: p_CC_Action_Notes IGC_CC_ACTIONS.CC_Action_Notes%TYPE,
349: p_Last_Update_Date IGC_CC_ACTIONS.Last_Update_Date%TYPE,
350: p_Last_Updated_By IGC_CC_ACTIONS.Last_Updated_By%TYPE,
351: p_Last_Update_Login IGC_CC_ACTIONS.Last_Update_Login%TYPE,
352: p_Creation_Date IGC_CC_ACTIONS.Creation_Date%TYPE,
353: p_Created_By IGC_CC_ACTIONS.Created_By%TYPE
354: ) IS
347: p_CC_Action_Apprvl_Status IGC_CC_ACTIONS.CC_Action_Apprvl_Status%TYPE,
348: p_CC_Action_Notes IGC_CC_ACTIONS.CC_Action_Notes%TYPE,
349: p_Last_Update_Date IGC_CC_ACTIONS.Last_Update_Date%TYPE,
350: p_Last_Updated_By IGC_CC_ACTIONS.Last_Updated_By%TYPE,
351: p_Last_Update_Login IGC_CC_ACTIONS.Last_Update_Login%TYPE,
352: p_Creation_Date IGC_CC_ACTIONS.Creation_Date%TYPE,
353: p_Created_By IGC_CC_ACTIONS.Created_By%TYPE
354: ) IS
355:
348: p_CC_Action_Notes IGC_CC_ACTIONS.CC_Action_Notes%TYPE,
349: p_Last_Update_Date IGC_CC_ACTIONS.Last_Update_Date%TYPE,
350: p_Last_Updated_By IGC_CC_ACTIONS.Last_Updated_By%TYPE,
351: p_Last_Update_Login IGC_CC_ACTIONS.Last_Update_Login%TYPE,
352: p_Creation_Date IGC_CC_ACTIONS.Creation_Date%TYPE,
353: p_Created_By IGC_CC_ACTIONS.Created_By%TYPE
354: ) IS
355:
356: l_api_name CONSTANT VARCHAR2(30) := 'Update_Row';
349: p_Last_Update_Date IGC_CC_ACTIONS.Last_Update_Date%TYPE,
350: p_Last_Updated_By IGC_CC_ACTIONS.Last_Updated_By%TYPE,
351: p_Last_Update_Login IGC_CC_ACTIONS.Last_Update_Login%TYPE,
352: p_Creation_Date IGC_CC_ACTIONS.Creation_Date%TYPE,
353: p_Created_By IGC_CC_ACTIONS.Created_By%TYPE
354: ) IS
355:
356: l_api_name CONSTANT VARCHAR2(30) := 'Update_Row';
357: l_api_version CONSTANT NUMBER := 1.0;
374: END IF;
375:
376: X_return_status := FND_API.G_RET_STS_SUCCESS ;
377:
378: UPDATE IGC_CC_ACTIONS
379: SET
380:
381: CC_Header_Id = p_CC_Header_Id,
382: CC_Action_Num = p_CC_Action_Num,
475: END IF ;
476:
477: X_return_status := FND_API.G_RET_STS_SUCCESS ;
478:
479: DELETE FROM IGC_CC_ACTIONS
480: WHERE rowid = p_Rowid;
481: if (SQL%NOTFOUND) then
482: Raise NO_DATA_FOUND;
483: end if;
519: p_data => X_msg_data );
520:
521: END Delete_Row;
522:
523: END IGC_CC_ACTIONS_PKG;