1: PACKAGE IGC_CC_ACTIONS_PKG AUTHID CURRENT_USER as
2: /* $Header: IGCCACTS.pls 120.3.12000000.1 2007/08/20 12:10:47 mbremkum ship $ */
3:
4:
5: /* ================================================================================
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,
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,
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,
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,
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,
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,
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,
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
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: );
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:
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: /* ================================================================================
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
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,
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,
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,
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,
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,
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,
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,
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,
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,
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
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: );
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:
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:
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,
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,
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,
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,
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,
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,
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,
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,
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
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: );
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:
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:
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: /* ================================================================================
106: X_msg_data OUT NOCOPY VARCHAR2,
107: p_Rowid VARCHAR2
108: );
109:
110: END IGC_CC_ACTIONS_PKG;