APPS.IGC_CC_ACTIONS_PKG dependencies on IGC_CC_ACTIONS

Line 1: PACKAGE IGC_CC_ACTIONS_PKG as

1: PACKAGE IGC_CC_ACTIONS_PKG as
2: /* $Header: IGCCACTS.pls 120.3.12000000.1 2007/08/20 12:10:47 mbremkum ship $ */
3:
4:
5: /* ================================================================================

Line 19: p_CC_Header_Id IGC_CC_ACTIONS.CC_Header_Id%TYPE,

15: X_return_status OUT NOCOPY VARCHAR2,
16: X_msg_count OUT NOCOPY NUMBER,
17: X_msg_data OUT NOCOPY VARCHAR2,
18: p_Rowid IN OUT NOCOPY VARCHAR2,
19: p_CC_Header_Id IGC_CC_ACTIONS.CC_Header_Id%TYPE,
20: p_CC_Action_Version_Num IGC_CC_ACTIONS.CC_Action_Version_Num%TYPE,
21: p_CC_Action_Type IGC_CC_ACTIONS.CC_Action_Type %TYPE,
22: p_CC_Action_State IGC_CC_ACTIONS.CC_Action_State%TYPE,
23: p_CC_Action_Ctrl_Status IGC_CC_ACTIONS.CC_Action_Ctrl_Status%TYPE,

Line 20: p_CC_Action_Version_Num IGC_CC_ACTIONS.CC_Action_Version_Num%TYPE,

16: X_msg_count OUT NOCOPY NUMBER,
17: X_msg_data OUT NOCOPY VARCHAR2,
18: p_Rowid IN OUT NOCOPY VARCHAR2,
19: p_CC_Header_Id IGC_CC_ACTIONS.CC_Header_Id%TYPE,
20: p_CC_Action_Version_Num IGC_CC_ACTIONS.CC_Action_Version_Num%TYPE,
21: p_CC_Action_Type IGC_CC_ACTIONS.CC_Action_Type %TYPE,
22: p_CC_Action_State IGC_CC_ACTIONS.CC_Action_State%TYPE,
23: p_CC_Action_Ctrl_Status IGC_CC_ACTIONS.CC_Action_Ctrl_Status%TYPE,
24: p_CC_Action_Apprvl_Status IGC_CC_ACTIONS.CC_Action_Apprvl_Status%TYPE,

Line 21: p_CC_Action_Type IGC_CC_ACTIONS.CC_Action_Type %TYPE,

17: X_msg_data OUT NOCOPY VARCHAR2,
18: p_Rowid IN OUT NOCOPY VARCHAR2,
19: p_CC_Header_Id IGC_CC_ACTIONS.CC_Header_Id%TYPE,
20: p_CC_Action_Version_Num IGC_CC_ACTIONS.CC_Action_Version_Num%TYPE,
21: p_CC_Action_Type IGC_CC_ACTIONS.CC_Action_Type %TYPE,
22: p_CC_Action_State IGC_CC_ACTIONS.CC_Action_State%TYPE,
23: p_CC_Action_Ctrl_Status IGC_CC_ACTIONS.CC_Action_Ctrl_Status%TYPE,
24: p_CC_Action_Apprvl_Status IGC_CC_ACTIONS.CC_Action_Apprvl_Status%TYPE,
25: p_CC_Action_Notes IGC_CC_ACTIONS.CC_Action_Notes%TYPE,

Line 22: p_CC_Action_State IGC_CC_ACTIONS.CC_Action_State%TYPE,

18: p_Rowid IN OUT NOCOPY VARCHAR2,
19: p_CC_Header_Id IGC_CC_ACTIONS.CC_Header_Id%TYPE,
20: p_CC_Action_Version_Num IGC_CC_ACTIONS.CC_Action_Version_Num%TYPE,
21: p_CC_Action_Type IGC_CC_ACTIONS.CC_Action_Type %TYPE,
22: p_CC_Action_State IGC_CC_ACTIONS.CC_Action_State%TYPE,
23: p_CC_Action_Ctrl_Status IGC_CC_ACTIONS.CC_Action_Ctrl_Status%TYPE,
24: p_CC_Action_Apprvl_Status IGC_CC_ACTIONS.CC_Action_Apprvl_Status%TYPE,
25: p_CC_Action_Notes IGC_CC_ACTIONS.CC_Action_Notes%TYPE,
26: p_Last_Update_Date IGC_CC_ACTIONS.Last_Update_Date%TYPE,

Line 23: p_CC_Action_Ctrl_Status IGC_CC_ACTIONS.CC_Action_Ctrl_Status%TYPE,

19: p_CC_Header_Id IGC_CC_ACTIONS.CC_Header_Id%TYPE,
20: p_CC_Action_Version_Num IGC_CC_ACTIONS.CC_Action_Version_Num%TYPE,
21: p_CC_Action_Type IGC_CC_ACTIONS.CC_Action_Type %TYPE,
22: p_CC_Action_State IGC_CC_ACTIONS.CC_Action_State%TYPE,
23: p_CC_Action_Ctrl_Status IGC_CC_ACTIONS.CC_Action_Ctrl_Status%TYPE,
24: p_CC_Action_Apprvl_Status IGC_CC_ACTIONS.CC_Action_Apprvl_Status%TYPE,
25: p_CC_Action_Notes IGC_CC_ACTIONS.CC_Action_Notes%TYPE,
26: p_Last_Update_Date IGC_CC_ACTIONS.Last_Update_Date%TYPE,
27: p_Last_Updated_By IGC_CC_ACTIONS.Last_Updated_By%TYPE,

Line 24: p_CC_Action_Apprvl_Status IGC_CC_ACTIONS.CC_Action_Apprvl_Status%TYPE,

20: p_CC_Action_Version_Num IGC_CC_ACTIONS.CC_Action_Version_Num%TYPE,
21: p_CC_Action_Type IGC_CC_ACTIONS.CC_Action_Type %TYPE,
22: p_CC_Action_State IGC_CC_ACTIONS.CC_Action_State%TYPE,
23: p_CC_Action_Ctrl_Status IGC_CC_ACTIONS.CC_Action_Ctrl_Status%TYPE,
24: p_CC_Action_Apprvl_Status IGC_CC_ACTIONS.CC_Action_Apprvl_Status%TYPE,
25: p_CC_Action_Notes IGC_CC_ACTIONS.CC_Action_Notes%TYPE,
26: p_Last_Update_Date IGC_CC_ACTIONS.Last_Update_Date%TYPE,
27: p_Last_Updated_By IGC_CC_ACTIONS.Last_Updated_By%TYPE,
28: p_Last_Update_Login IGC_CC_ACTIONS.Last_Update_Login%TYPE,

Line 25: p_CC_Action_Notes IGC_CC_ACTIONS.CC_Action_Notes%TYPE,

21: p_CC_Action_Type IGC_CC_ACTIONS.CC_Action_Type %TYPE,
22: p_CC_Action_State IGC_CC_ACTIONS.CC_Action_State%TYPE,
23: p_CC_Action_Ctrl_Status IGC_CC_ACTIONS.CC_Action_Ctrl_Status%TYPE,
24: p_CC_Action_Apprvl_Status IGC_CC_ACTIONS.CC_Action_Apprvl_Status%TYPE,
25: p_CC_Action_Notes IGC_CC_ACTIONS.CC_Action_Notes%TYPE,
26: p_Last_Update_Date IGC_CC_ACTIONS.Last_Update_Date%TYPE,
27: p_Last_Updated_By IGC_CC_ACTIONS.Last_Updated_By%TYPE,
28: p_Last_Update_Login IGC_CC_ACTIONS.Last_Update_Login%TYPE,
29: p_Creation_Date IGC_CC_ACTIONS.Creation_Date%TYPE,

Line 26: p_Last_Update_Date IGC_CC_ACTIONS.Last_Update_Date%TYPE,

22: p_CC_Action_State IGC_CC_ACTIONS.CC_Action_State%TYPE,
23: p_CC_Action_Ctrl_Status IGC_CC_ACTIONS.CC_Action_Ctrl_Status%TYPE,
24: p_CC_Action_Apprvl_Status IGC_CC_ACTIONS.CC_Action_Apprvl_Status%TYPE,
25: p_CC_Action_Notes IGC_CC_ACTIONS.CC_Action_Notes%TYPE,
26: p_Last_Update_Date IGC_CC_ACTIONS.Last_Update_Date%TYPE,
27: p_Last_Updated_By IGC_CC_ACTIONS.Last_Updated_By%TYPE,
28: p_Last_Update_Login IGC_CC_ACTIONS.Last_Update_Login%TYPE,
29: p_Creation_Date IGC_CC_ACTIONS.Creation_Date%TYPE,
30: p_Created_By IGC_CC_ACTIONS.Created_By%TYPE

Line 27: p_Last_Updated_By IGC_CC_ACTIONS.Last_Updated_By%TYPE,

23: p_CC_Action_Ctrl_Status IGC_CC_ACTIONS.CC_Action_Ctrl_Status%TYPE,
24: p_CC_Action_Apprvl_Status IGC_CC_ACTIONS.CC_Action_Apprvl_Status%TYPE,
25: p_CC_Action_Notes IGC_CC_ACTIONS.CC_Action_Notes%TYPE,
26: p_Last_Update_Date IGC_CC_ACTIONS.Last_Update_Date%TYPE,
27: p_Last_Updated_By IGC_CC_ACTIONS.Last_Updated_By%TYPE,
28: p_Last_Update_Login IGC_CC_ACTIONS.Last_Update_Login%TYPE,
29: p_Creation_Date IGC_CC_ACTIONS.Creation_Date%TYPE,
30: p_Created_By IGC_CC_ACTIONS.Created_By%TYPE
31: );

Line 28: p_Last_Update_Login IGC_CC_ACTIONS.Last_Update_Login%TYPE,

24: p_CC_Action_Apprvl_Status IGC_CC_ACTIONS.CC_Action_Apprvl_Status%TYPE,
25: p_CC_Action_Notes IGC_CC_ACTIONS.CC_Action_Notes%TYPE,
26: p_Last_Update_Date IGC_CC_ACTIONS.Last_Update_Date%TYPE,
27: p_Last_Updated_By IGC_CC_ACTIONS.Last_Updated_By%TYPE,
28: p_Last_Update_Login IGC_CC_ACTIONS.Last_Update_Login%TYPE,
29: p_Creation_Date IGC_CC_ACTIONS.Creation_Date%TYPE,
30: p_Created_By IGC_CC_ACTIONS.Created_By%TYPE
31: );
32:

Line 29: p_Creation_Date IGC_CC_ACTIONS.Creation_Date%TYPE,

25: p_CC_Action_Notes IGC_CC_ACTIONS.CC_Action_Notes%TYPE,
26: p_Last_Update_Date IGC_CC_ACTIONS.Last_Update_Date%TYPE,
27: p_Last_Updated_By IGC_CC_ACTIONS.Last_Updated_By%TYPE,
28: p_Last_Update_Login IGC_CC_ACTIONS.Last_Update_Login%TYPE,
29: p_Creation_Date IGC_CC_ACTIONS.Creation_Date%TYPE,
30: p_Created_By IGC_CC_ACTIONS.Created_By%TYPE
31: );
32:
33: /* ================================================================================

Line 30: p_Created_By IGC_CC_ACTIONS.Created_By%TYPE

26: p_Last_Update_Date IGC_CC_ACTIONS.Last_Update_Date%TYPE,
27: p_Last_Updated_By IGC_CC_ACTIONS.Last_Updated_By%TYPE,
28: p_Last_Update_Login IGC_CC_ACTIONS.Last_Update_Login%TYPE,
29: p_Creation_Date IGC_CC_ACTIONS.Creation_Date%TYPE,
30: p_Created_By IGC_CC_ACTIONS.Created_By%TYPE
31: );
32:
33: /* ================================================================================
34: PROCEDURE Lock_Row

Line 48: p_CC_Header_Id IGC_CC_ACTIONS.CC_Header_Id%TYPE,

44: X_return_status OUT NOCOPY VARCHAR2,
45: X_msg_count OUT NOCOPY NUMBER,
46: X_msg_data OUT NOCOPY VARCHAR2,
47: p_Rowid IN OUT NOCOPY VARCHAR2,
48: p_CC_Header_Id IGC_CC_ACTIONS.CC_Header_Id%TYPE,
49: p_CC_Action_Num IGC_CC_ACTIONS.CC_Action_Num%TYPE,
50: p_CC_Action_Version_Num IGC_CC_ACTIONS.CC_Action_Version_Num%TYPE,
51: p_CC_Action_Type IGC_CC_ACTIONS.CC_Action_Type %TYPE,
52: p_CC_Action_State IGC_CC_ACTIONS.CC_Action_State%TYPE,

Line 49: p_CC_Action_Num IGC_CC_ACTIONS.CC_Action_Num%TYPE,

45: X_msg_count OUT NOCOPY NUMBER,
46: X_msg_data OUT NOCOPY VARCHAR2,
47: p_Rowid IN OUT NOCOPY VARCHAR2,
48: p_CC_Header_Id IGC_CC_ACTIONS.CC_Header_Id%TYPE,
49: p_CC_Action_Num IGC_CC_ACTIONS.CC_Action_Num%TYPE,
50: p_CC_Action_Version_Num IGC_CC_ACTIONS.CC_Action_Version_Num%TYPE,
51: p_CC_Action_Type IGC_CC_ACTIONS.CC_Action_Type %TYPE,
52: p_CC_Action_State IGC_CC_ACTIONS.CC_Action_State%TYPE,
53: p_CC_Action_Ctrl_Status IGC_CC_ACTIONS.CC_Action_Ctrl_Status%TYPE,

Line 50: p_CC_Action_Version_Num IGC_CC_ACTIONS.CC_Action_Version_Num%TYPE,

46: X_msg_data OUT NOCOPY VARCHAR2,
47: p_Rowid IN OUT NOCOPY VARCHAR2,
48: p_CC_Header_Id IGC_CC_ACTIONS.CC_Header_Id%TYPE,
49: p_CC_Action_Num IGC_CC_ACTIONS.CC_Action_Num%TYPE,
50: p_CC_Action_Version_Num IGC_CC_ACTIONS.CC_Action_Version_Num%TYPE,
51: p_CC_Action_Type IGC_CC_ACTIONS.CC_Action_Type %TYPE,
52: p_CC_Action_State IGC_CC_ACTIONS.CC_Action_State%TYPE,
53: p_CC_Action_Ctrl_Status IGC_CC_ACTIONS.CC_Action_Ctrl_Status%TYPE,
54: p_CC_Action_Apprvl_Status IGC_CC_ACTIONS.CC_Action_Apprvl_Status%TYPE,

Line 51: p_CC_Action_Type IGC_CC_ACTIONS.CC_Action_Type %TYPE,

47: p_Rowid IN OUT NOCOPY VARCHAR2,
48: p_CC_Header_Id IGC_CC_ACTIONS.CC_Header_Id%TYPE,
49: p_CC_Action_Num IGC_CC_ACTIONS.CC_Action_Num%TYPE,
50: p_CC_Action_Version_Num IGC_CC_ACTIONS.CC_Action_Version_Num%TYPE,
51: p_CC_Action_Type IGC_CC_ACTIONS.CC_Action_Type %TYPE,
52: p_CC_Action_State IGC_CC_ACTIONS.CC_Action_State%TYPE,
53: p_CC_Action_Ctrl_Status IGC_CC_ACTIONS.CC_Action_Ctrl_Status%TYPE,
54: p_CC_Action_Apprvl_Status IGC_CC_ACTIONS.CC_Action_Apprvl_Status%TYPE,
55: p_CC_Action_Notes IGC_CC_ACTIONS.CC_Action_Notes%TYPE,

Line 52: p_CC_Action_State IGC_CC_ACTIONS.CC_Action_State%TYPE,

48: p_CC_Header_Id IGC_CC_ACTIONS.CC_Header_Id%TYPE,
49: p_CC_Action_Num IGC_CC_ACTIONS.CC_Action_Num%TYPE,
50: p_CC_Action_Version_Num IGC_CC_ACTIONS.CC_Action_Version_Num%TYPE,
51: p_CC_Action_Type IGC_CC_ACTIONS.CC_Action_Type %TYPE,
52: p_CC_Action_State IGC_CC_ACTIONS.CC_Action_State%TYPE,
53: p_CC_Action_Ctrl_Status IGC_CC_ACTIONS.CC_Action_Ctrl_Status%TYPE,
54: p_CC_Action_Apprvl_Status IGC_CC_ACTIONS.CC_Action_Apprvl_Status%TYPE,
55: p_CC_Action_Notes IGC_CC_ACTIONS.CC_Action_Notes%TYPE,
56: p_Last_Update_Date IGC_CC_ACTIONS.Last_Update_Date%TYPE,

Line 53: p_CC_Action_Ctrl_Status IGC_CC_ACTIONS.CC_Action_Ctrl_Status%TYPE,

49: p_CC_Action_Num IGC_CC_ACTIONS.CC_Action_Num%TYPE,
50: p_CC_Action_Version_Num IGC_CC_ACTIONS.CC_Action_Version_Num%TYPE,
51: p_CC_Action_Type IGC_CC_ACTIONS.CC_Action_Type %TYPE,
52: p_CC_Action_State IGC_CC_ACTIONS.CC_Action_State%TYPE,
53: p_CC_Action_Ctrl_Status IGC_CC_ACTIONS.CC_Action_Ctrl_Status%TYPE,
54: p_CC_Action_Apprvl_Status IGC_CC_ACTIONS.CC_Action_Apprvl_Status%TYPE,
55: p_CC_Action_Notes IGC_CC_ACTIONS.CC_Action_Notes%TYPE,
56: p_Last_Update_Date IGC_CC_ACTIONS.Last_Update_Date%TYPE,
57: p_Last_Updated_By IGC_CC_ACTIONS.Last_Updated_By%TYPE,

Line 54: p_CC_Action_Apprvl_Status IGC_CC_ACTIONS.CC_Action_Apprvl_Status%TYPE,

50: p_CC_Action_Version_Num IGC_CC_ACTIONS.CC_Action_Version_Num%TYPE,
51: p_CC_Action_Type IGC_CC_ACTIONS.CC_Action_Type %TYPE,
52: p_CC_Action_State IGC_CC_ACTIONS.CC_Action_State%TYPE,
53: p_CC_Action_Ctrl_Status IGC_CC_ACTIONS.CC_Action_Ctrl_Status%TYPE,
54: p_CC_Action_Apprvl_Status IGC_CC_ACTIONS.CC_Action_Apprvl_Status%TYPE,
55: p_CC_Action_Notes IGC_CC_ACTIONS.CC_Action_Notes%TYPE,
56: p_Last_Update_Date IGC_CC_ACTIONS.Last_Update_Date%TYPE,
57: p_Last_Updated_By IGC_CC_ACTIONS.Last_Updated_By%TYPE,
58: p_Last_Update_Login IGC_CC_ACTIONS.Last_Update_Login%TYPE,

Line 55: p_CC_Action_Notes IGC_CC_ACTIONS.CC_Action_Notes%TYPE,

51: p_CC_Action_Type IGC_CC_ACTIONS.CC_Action_Type %TYPE,
52: p_CC_Action_State IGC_CC_ACTIONS.CC_Action_State%TYPE,
53: p_CC_Action_Ctrl_Status IGC_CC_ACTIONS.CC_Action_Ctrl_Status%TYPE,
54: p_CC_Action_Apprvl_Status IGC_CC_ACTIONS.CC_Action_Apprvl_Status%TYPE,
55: p_CC_Action_Notes IGC_CC_ACTIONS.CC_Action_Notes%TYPE,
56: p_Last_Update_Date IGC_CC_ACTIONS.Last_Update_Date%TYPE,
57: p_Last_Updated_By IGC_CC_ACTIONS.Last_Updated_By%TYPE,
58: p_Last_Update_Login IGC_CC_ACTIONS.Last_Update_Login%TYPE,
59: p_Creation_Date IGC_CC_ACTIONS.Creation_Date%TYPE,

Line 56: p_Last_Update_Date IGC_CC_ACTIONS.Last_Update_Date%TYPE,

52: p_CC_Action_State IGC_CC_ACTIONS.CC_Action_State%TYPE,
53: p_CC_Action_Ctrl_Status IGC_CC_ACTIONS.CC_Action_Ctrl_Status%TYPE,
54: p_CC_Action_Apprvl_Status IGC_CC_ACTIONS.CC_Action_Apprvl_Status%TYPE,
55: p_CC_Action_Notes IGC_CC_ACTIONS.CC_Action_Notes%TYPE,
56: p_Last_Update_Date IGC_CC_ACTIONS.Last_Update_Date%TYPE,
57: p_Last_Updated_By IGC_CC_ACTIONS.Last_Updated_By%TYPE,
58: p_Last_Update_Login IGC_CC_ACTIONS.Last_Update_Login%TYPE,
59: p_Creation_Date IGC_CC_ACTIONS.Creation_Date%TYPE,
60: p_Created_By IGC_CC_ACTIONS.Created_By%TYPE,

Line 57: p_Last_Updated_By IGC_CC_ACTIONS.Last_Updated_By%TYPE,

53: p_CC_Action_Ctrl_Status IGC_CC_ACTIONS.CC_Action_Ctrl_Status%TYPE,
54: p_CC_Action_Apprvl_Status IGC_CC_ACTIONS.CC_Action_Apprvl_Status%TYPE,
55: p_CC_Action_Notes IGC_CC_ACTIONS.CC_Action_Notes%TYPE,
56: p_Last_Update_Date IGC_CC_ACTIONS.Last_Update_Date%TYPE,
57: p_Last_Updated_By IGC_CC_ACTIONS.Last_Updated_By%TYPE,
58: p_Last_Update_Login IGC_CC_ACTIONS.Last_Update_Login%TYPE,
59: p_Creation_Date IGC_CC_ACTIONS.Creation_Date%TYPE,
60: p_Created_By IGC_CC_ACTIONS.Created_By%TYPE,
61: X_row_locked OUT NOCOPY VARCHAR2

Line 58: p_Last_Update_Login IGC_CC_ACTIONS.Last_Update_Login%TYPE,

54: p_CC_Action_Apprvl_Status IGC_CC_ACTIONS.CC_Action_Apprvl_Status%TYPE,
55: p_CC_Action_Notes IGC_CC_ACTIONS.CC_Action_Notes%TYPE,
56: p_Last_Update_Date IGC_CC_ACTIONS.Last_Update_Date%TYPE,
57: p_Last_Updated_By IGC_CC_ACTIONS.Last_Updated_By%TYPE,
58: p_Last_Update_Login IGC_CC_ACTIONS.Last_Update_Login%TYPE,
59: p_Creation_Date IGC_CC_ACTIONS.Creation_Date%TYPE,
60: p_Created_By IGC_CC_ACTIONS.Created_By%TYPE,
61: X_row_locked OUT NOCOPY VARCHAR2
62: );

Line 59: p_Creation_Date IGC_CC_ACTIONS.Creation_Date%TYPE,

55: p_CC_Action_Notes IGC_CC_ACTIONS.CC_Action_Notes%TYPE,
56: p_Last_Update_Date IGC_CC_ACTIONS.Last_Update_Date%TYPE,
57: p_Last_Updated_By IGC_CC_ACTIONS.Last_Updated_By%TYPE,
58: p_Last_Update_Login IGC_CC_ACTIONS.Last_Update_Login%TYPE,
59: p_Creation_Date IGC_CC_ACTIONS.Creation_Date%TYPE,
60: p_Created_By IGC_CC_ACTIONS.Created_By%TYPE,
61: X_row_locked OUT NOCOPY VARCHAR2
62: );
63:

Line 60: p_Created_By IGC_CC_ACTIONS.Created_By%TYPE,

56: p_Last_Update_Date IGC_CC_ACTIONS.Last_Update_Date%TYPE,
57: p_Last_Updated_By IGC_CC_ACTIONS.Last_Updated_By%TYPE,
58: p_Last_Update_Login IGC_CC_ACTIONS.Last_Update_Login%TYPE,
59: p_Creation_Date IGC_CC_ACTIONS.Creation_Date%TYPE,
60: p_Created_By IGC_CC_ACTIONS.Created_By%TYPE,
61: X_row_locked OUT NOCOPY VARCHAR2
62: );
63:
64:

Line 79: p_CC_Header_Id IGC_CC_ACTIONS.CC_Header_Id%TYPE,

75: X_return_status OUT NOCOPY VARCHAR2,
76: X_msg_count OUT NOCOPY NUMBER,
77: X_msg_data OUT NOCOPY VARCHAR2,
78: p_Rowid IN OUT NOCOPY VARCHAR2,
79: p_CC_Header_Id IGC_CC_ACTIONS.CC_Header_Id%TYPE,
80: p_CC_Action_Num IGC_CC_ACTIONS.CC_Action_Num%TYPE,
81: p_CC_Action_Version_Num IGC_CC_ACTIONS.CC_Action_Version_Num%TYPE,
82: p_CC_Action_Type IGC_CC_ACTIONS.CC_Action_Type %TYPE,
83: p_CC_Action_State IGC_CC_ACTIONS.CC_Action_State%TYPE,

Line 80: p_CC_Action_Num IGC_CC_ACTIONS.CC_Action_Num%TYPE,

76: X_msg_count OUT NOCOPY NUMBER,
77: X_msg_data OUT NOCOPY VARCHAR2,
78: p_Rowid IN OUT NOCOPY VARCHAR2,
79: p_CC_Header_Id IGC_CC_ACTIONS.CC_Header_Id%TYPE,
80: p_CC_Action_Num IGC_CC_ACTIONS.CC_Action_Num%TYPE,
81: p_CC_Action_Version_Num IGC_CC_ACTIONS.CC_Action_Version_Num%TYPE,
82: p_CC_Action_Type IGC_CC_ACTIONS.CC_Action_Type %TYPE,
83: p_CC_Action_State IGC_CC_ACTIONS.CC_Action_State%TYPE,
84: p_CC_Action_Ctrl_Status IGC_CC_ACTIONS.CC_Action_Ctrl_Status%TYPE,

Line 81: p_CC_Action_Version_Num IGC_CC_ACTIONS.CC_Action_Version_Num%TYPE,

77: X_msg_data OUT NOCOPY VARCHAR2,
78: p_Rowid IN OUT NOCOPY VARCHAR2,
79: p_CC_Header_Id IGC_CC_ACTIONS.CC_Header_Id%TYPE,
80: p_CC_Action_Num IGC_CC_ACTIONS.CC_Action_Num%TYPE,
81: p_CC_Action_Version_Num IGC_CC_ACTIONS.CC_Action_Version_Num%TYPE,
82: p_CC_Action_Type IGC_CC_ACTIONS.CC_Action_Type %TYPE,
83: p_CC_Action_State IGC_CC_ACTIONS.CC_Action_State%TYPE,
84: p_CC_Action_Ctrl_Status IGC_CC_ACTIONS.CC_Action_Ctrl_Status%TYPE,
85: p_CC_Action_Apprvl_Status IGC_CC_ACTIONS.CC_Action_Apprvl_Status%TYPE,

Line 82: p_CC_Action_Type IGC_CC_ACTIONS.CC_Action_Type %TYPE,

78: p_Rowid IN OUT NOCOPY VARCHAR2,
79: p_CC_Header_Id IGC_CC_ACTIONS.CC_Header_Id%TYPE,
80: p_CC_Action_Num IGC_CC_ACTIONS.CC_Action_Num%TYPE,
81: p_CC_Action_Version_Num IGC_CC_ACTIONS.CC_Action_Version_Num%TYPE,
82: p_CC_Action_Type IGC_CC_ACTIONS.CC_Action_Type %TYPE,
83: p_CC_Action_State IGC_CC_ACTIONS.CC_Action_State%TYPE,
84: p_CC_Action_Ctrl_Status IGC_CC_ACTIONS.CC_Action_Ctrl_Status%TYPE,
85: p_CC_Action_Apprvl_Status IGC_CC_ACTIONS.CC_Action_Apprvl_Status%TYPE,
86: p_CC_Action_Notes IGC_CC_ACTIONS.CC_Action_Notes%TYPE,

Line 83: p_CC_Action_State IGC_CC_ACTIONS.CC_Action_State%TYPE,

79: p_CC_Header_Id IGC_CC_ACTIONS.CC_Header_Id%TYPE,
80: p_CC_Action_Num IGC_CC_ACTIONS.CC_Action_Num%TYPE,
81: p_CC_Action_Version_Num IGC_CC_ACTIONS.CC_Action_Version_Num%TYPE,
82: p_CC_Action_Type IGC_CC_ACTIONS.CC_Action_Type %TYPE,
83: p_CC_Action_State IGC_CC_ACTIONS.CC_Action_State%TYPE,
84: p_CC_Action_Ctrl_Status IGC_CC_ACTIONS.CC_Action_Ctrl_Status%TYPE,
85: p_CC_Action_Apprvl_Status IGC_CC_ACTIONS.CC_Action_Apprvl_Status%TYPE,
86: p_CC_Action_Notes IGC_CC_ACTIONS.CC_Action_Notes%TYPE,
87: p_Last_Update_Date IGC_CC_ACTIONS.Last_Update_Date%TYPE,

Line 84: p_CC_Action_Ctrl_Status IGC_CC_ACTIONS.CC_Action_Ctrl_Status%TYPE,

80: p_CC_Action_Num IGC_CC_ACTIONS.CC_Action_Num%TYPE,
81: p_CC_Action_Version_Num IGC_CC_ACTIONS.CC_Action_Version_Num%TYPE,
82: p_CC_Action_Type IGC_CC_ACTIONS.CC_Action_Type %TYPE,
83: p_CC_Action_State IGC_CC_ACTIONS.CC_Action_State%TYPE,
84: p_CC_Action_Ctrl_Status IGC_CC_ACTIONS.CC_Action_Ctrl_Status%TYPE,
85: p_CC_Action_Apprvl_Status IGC_CC_ACTIONS.CC_Action_Apprvl_Status%TYPE,
86: p_CC_Action_Notes IGC_CC_ACTIONS.CC_Action_Notes%TYPE,
87: p_Last_Update_Date IGC_CC_ACTIONS.Last_Update_Date%TYPE,
88: p_Last_Updated_By IGC_CC_ACTIONS.Last_Updated_By%TYPE,

Line 85: p_CC_Action_Apprvl_Status IGC_CC_ACTIONS.CC_Action_Apprvl_Status%TYPE,

81: p_CC_Action_Version_Num IGC_CC_ACTIONS.CC_Action_Version_Num%TYPE,
82: p_CC_Action_Type IGC_CC_ACTIONS.CC_Action_Type %TYPE,
83: p_CC_Action_State IGC_CC_ACTIONS.CC_Action_State%TYPE,
84: p_CC_Action_Ctrl_Status IGC_CC_ACTIONS.CC_Action_Ctrl_Status%TYPE,
85: p_CC_Action_Apprvl_Status IGC_CC_ACTIONS.CC_Action_Apprvl_Status%TYPE,
86: p_CC_Action_Notes IGC_CC_ACTIONS.CC_Action_Notes%TYPE,
87: p_Last_Update_Date IGC_CC_ACTIONS.Last_Update_Date%TYPE,
88: p_Last_Updated_By IGC_CC_ACTIONS.Last_Updated_By%TYPE,
89: p_Last_Update_Login IGC_CC_ACTIONS.Last_Update_Login%TYPE,

Line 86: p_CC_Action_Notes IGC_CC_ACTIONS.CC_Action_Notes%TYPE,

82: p_CC_Action_Type IGC_CC_ACTIONS.CC_Action_Type %TYPE,
83: p_CC_Action_State IGC_CC_ACTIONS.CC_Action_State%TYPE,
84: p_CC_Action_Ctrl_Status IGC_CC_ACTIONS.CC_Action_Ctrl_Status%TYPE,
85: p_CC_Action_Apprvl_Status IGC_CC_ACTIONS.CC_Action_Apprvl_Status%TYPE,
86: p_CC_Action_Notes IGC_CC_ACTIONS.CC_Action_Notes%TYPE,
87: p_Last_Update_Date IGC_CC_ACTIONS.Last_Update_Date%TYPE,
88: p_Last_Updated_By IGC_CC_ACTIONS.Last_Updated_By%TYPE,
89: p_Last_Update_Login IGC_CC_ACTIONS.Last_Update_Login%TYPE,
90: p_Creation_Date IGC_CC_ACTIONS.Creation_Date%TYPE,

Line 87: p_Last_Update_Date IGC_CC_ACTIONS.Last_Update_Date%TYPE,

83: p_CC_Action_State IGC_CC_ACTIONS.CC_Action_State%TYPE,
84: p_CC_Action_Ctrl_Status IGC_CC_ACTIONS.CC_Action_Ctrl_Status%TYPE,
85: p_CC_Action_Apprvl_Status IGC_CC_ACTIONS.CC_Action_Apprvl_Status%TYPE,
86: p_CC_Action_Notes IGC_CC_ACTIONS.CC_Action_Notes%TYPE,
87: p_Last_Update_Date IGC_CC_ACTIONS.Last_Update_Date%TYPE,
88: p_Last_Updated_By IGC_CC_ACTIONS.Last_Updated_By%TYPE,
89: p_Last_Update_Login IGC_CC_ACTIONS.Last_Update_Login%TYPE,
90: p_Creation_Date IGC_CC_ACTIONS.Creation_Date%TYPE,
91: p_Created_By IGC_CC_ACTIONS.Created_By%TYPE

Line 88: p_Last_Updated_By IGC_CC_ACTIONS.Last_Updated_By%TYPE,

84: p_CC_Action_Ctrl_Status IGC_CC_ACTIONS.CC_Action_Ctrl_Status%TYPE,
85: p_CC_Action_Apprvl_Status IGC_CC_ACTIONS.CC_Action_Apprvl_Status%TYPE,
86: p_CC_Action_Notes IGC_CC_ACTIONS.CC_Action_Notes%TYPE,
87: p_Last_Update_Date IGC_CC_ACTIONS.Last_Update_Date%TYPE,
88: p_Last_Updated_By IGC_CC_ACTIONS.Last_Updated_By%TYPE,
89: p_Last_Update_Login IGC_CC_ACTIONS.Last_Update_Login%TYPE,
90: p_Creation_Date IGC_CC_ACTIONS.Creation_Date%TYPE,
91: p_Created_By IGC_CC_ACTIONS.Created_By%TYPE
92: );

Line 89: p_Last_Update_Login IGC_CC_ACTIONS.Last_Update_Login%TYPE,

85: p_CC_Action_Apprvl_Status IGC_CC_ACTIONS.CC_Action_Apprvl_Status%TYPE,
86: p_CC_Action_Notes IGC_CC_ACTIONS.CC_Action_Notes%TYPE,
87: p_Last_Update_Date IGC_CC_ACTIONS.Last_Update_Date%TYPE,
88: p_Last_Updated_By IGC_CC_ACTIONS.Last_Updated_By%TYPE,
89: p_Last_Update_Login IGC_CC_ACTIONS.Last_Update_Login%TYPE,
90: p_Creation_Date IGC_CC_ACTIONS.Creation_Date%TYPE,
91: p_Created_By IGC_CC_ACTIONS.Created_By%TYPE
92: );
93:

Line 90: p_Creation_Date IGC_CC_ACTIONS.Creation_Date%TYPE,

86: p_CC_Action_Notes IGC_CC_ACTIONS.CC_Action_Notes%TYPE,
87: p_Last_Update_Date IGC_CC_ACTIONS.Last_Update_Date%TYPE,
88: p_Last_Updated_By IGC_CC_ACTIONS.Last_Updated_By%TYPE,
89: p_Last_Update_Login IGC_CC_ACTIONS.Last_Update_Login%TYPE,
90: p_Creation_Date IGC_CC_ACTIONS.Creation_Date%TYPE,
91: p_Created_By IGC_CC_ACTIONS.Created_By%TYPE
92: );
93:
94:

Line 91: p_Created_By IGC_CC_ACTIONS.Created_By%TYPE

87: p_Last_Update_Date IGC_CC_ACTIONS.Last_Update_Date%TYPE,
88: p_Last_Updated_By IGC_CC_ACTIONS.Last_Updated_By%TYPE,
89: p_Last_Update_Login IGC_CC_ACTIONS.Last_Update_Login%TYPE,
90: p_Creation_Date IGC_CC_ACTIONS.Creation_Date%TYPE,
91: p_Created_By IGC_CC_ACTIONS.Created_By%TYPE
92: );
93:
94:
95: /* ================================================================================

Line 110: END IGC_CC_ACTIONS_PKG;

106: X_msg_data OUT NOCOPY VARCHAR2,
107: p_Rowid VARCHAR2
108: );
109:
110: END IGC_CC_ACTIONS_PKG;