eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.IGC_CC_ACTIONS_PKG dependencies on IGC_CC_ACTIONS

Line 1: PACKAGE BODY IGC_CC_ACTIONS_PKG as

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:

Line 4: G_PKG_NAME CONSTANT VARCHAR2(30):= 'IGC_CC_ACTIONS_PKG';

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:

Line 24: p_CC_Header_Id IGC_CC_ACTIONS.CC_Header_Id%TYPE,

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,

Line 25: p_CC_Action_Version_Num IGC_CC_ACTIONS.CC_Action_Version_Num%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,

Line 26: p_CC_Action_Type IGC_CC_ACTIONS.CC_Action_Type %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,

Line 27: p_CC_Action_State IGC_CC_ACTIONS.CC_Action_State%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,

Line 28: p_CC_Action_Ctrl_Status IGC_CC_ACTIONS.CC_Action_Ctrl_Status%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,

Line 29: p_CC_Action_Apprvl_Status IGC_CC_ACTIONS.CC_Action_Apprvl_Status%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,

Line 30: p_CC_Action_Notes IGC_CC_ACTIONS.CC_Action_Notes%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,

Line 31: p_Last_Update_Date IGC_CC_ACTIONS.Last_Update_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

Line 32: p_Last_Updated_By IGC_CC_ACTIONS.Last_Updated_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

Line 33: p_Last_Update_Login IGC_CC_ACTIONS.Last_Update_Login%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
37:

Line 34: p_Creation_Date IGC_CC_ACTIONS.Creation_Date%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:
38: l_api_name CONSTANT VARCHAR2(30) := 'Insert_Row';

Line 35: p_Created_By IGC_CC_ACTIONS.Created_By%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';
39: l_api_version CONSTANT NUMBER := 1.0;

Line 40: l_CC_Action_Num IGC_CC_ACTIONS.CC_Action_Num%TYPE;

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;

Line 43: FROM IGC_CC_ACTIONS

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)

Line 48: 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)
48: FROM IGC_CC_ACTIONS
49: WHERE CC_Header_Id = p_CC_Header_Id;
50:
51: BEGIN
52:

Line 78: INSERT INTO IGC_CC_ACTIONS(

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,

Line 173: p_CC_Header_Id IGC_CC_ACTIONS.CC_Header_Id%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,

Line 174: p_CC_Action_Num IGC_CC_ACTIONS.CC_Action_Num%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,

Line 175: p_CC_Action_Version_Num IGC_CC_ACTIONS.CC_Action_Version_Num%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,

Line 176: p_CC_Action_Type IGC_CC_ACTIONS.CC_Action_Type %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,

Line 177: p_CC_Action_State IGC_CC_ACTIONS.CC_Action_State%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,

Line 178: p_CC_Action_Ctrl_Status IGC_CC_ACTIONS.CC_Action_Ctrl_Status%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,

Line 179: p_CC_Action_Apprvl_Status IGC_CC_ACTIONS.CC_Action_Apprvl_Status%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,

Line 180: p_CC_Action_Notes IGC_CC_ACTIONS.CC_Action_Notes%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,

Line 181: p_Last_Update_Date IGC_CC_ACTIONS.Last_Update_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,

Line 182: p_Last_Updated_By IGC_CC_ACTIONS.Last_Updated_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

Line 183: p_Last_Update_Login IGC_CC_ACTIONS.Last_Update_Login%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
187: ) IS

Line 184: p_Creation_Date IGC_CC_ACTIONS.Creation_Date%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
188:

Line 185: p_Created_By IGC_CC_ACTIONS.Created_By%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:
189: l_api_name CONSTANT VARCHAR2(30) := 'Lock_Row';

Line 195: FROM IGC_CC_ACTIONS

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:

Line 341: p_CC_Header_Id IGC_CC_ACTIONS.CC_Header_Id%TYPE,

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,

Line 342: p_CC_Action_Num IGC_CC_ACTIONS.CC_Action_Num%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,

Line 343: p_CC_Action_Version_Num IGC_CC_ACTIONS.CC_Action_Version_Num%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,

Line 344: p_CC_Action_Type IGC_CC_ACTIONS.CC_Action_Type %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,

Line 345: p_CC_Action_State IGC_CC_ACTIONS.CC_Action_State%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,

Line 346: p_CC_Action_Ctrl_Status IGC_CC_ACTIONS.CC_Action_Ctrl_Status%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,

Line 347: p_CC_Action_Apprvl_Status IGC_CC_ACTIONS.CC_Action_Apprvl_Status%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,

Line 348: p_CC_Action_Notes IGC_CC_ACTIONS.CC_Action_Notes%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,

Line 349: p_Last_Update_Date IGC_CC_ACTIONS.Last_Update_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

Line 350: p_Last_Updated_By IGC_CC_ACTIONS.Last_Updated_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

Line 351: p_Last_Update_Login IGC_CC_ACTIONS.Last_Update_Login%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
355:

Line 352: p_Creation_Date IGC_CC_ACTIONS.Creation_Date%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:
356: l_api_name CONSTANT VARCHAR2(30) := 'Update_Row';

Line 353: p_Created_By IGC_CC_ACTIONS.Created_By%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';
357: l_api_version CONSTANT NUMBER := 1.0;

Line 378: UPDATE IGC_CC_ACTIONS

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,

Line 479: DELETE FROM IGC_CC_ACTIONS

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;

Line 523: END IGC_CC_ACTIONS_PKG;

519: p_data => X_msg_data );
520:
521: END Delete_Row;
522:
523: END IGC_CC_ACTIONS_PKG;