[Home] [Help]
PACKAGE: APPS.IGC_CC_ACTIONS_PKG
Source
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 /* ================================================================================
6 PROCEDURE Insert_Row
7 ===============================================================================*/
8
9 PROCEDURE Insert_Row(
10
11 p_api_version IN NUMBER,
12 p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
13 p_commit IN VARCHAR2 := FND_API.G_FALSE,
14 p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
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,
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
33 /* ================================================================================
34 PROCEDURE Lock_Row
35 ===============================================================================*/
36
37
38 PROCEDURE Lock_Row (
39
40 p_api_version IN NUMBER,
41 p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
42 p_commit IN VARCHAR2 := FND_API.G_FALSE,
43 p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
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,
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
62 );
63
64
65 /* ================================================================================
66 PROCEDURE Update_Row
67 ===============================================================================*/
68
69 PROCEDURE Update_Row(
70
71 p_api_version IN NUMBER,
72 p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
73 p_commit IN VARCHAR2 := FND_API.G_FALSE,
74 p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
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,
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 );
93
94
95 /* ================================================================================
96 PROCEDURE Delete_Row
97 ===============================================================================*/
98
99 PROCEDURE Delete_Row(
100 p_api_version IN NUMBER,
101 p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
102 p_commit IN VARCHAR2 := FND_API.G_FALSE,
103 p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
104 X_return_status OUT NOCOPY VARCHAR2,
105 X_msg_count OUT NOCOPY NUMBER,
106 X_msg_data OUT NOCOPY VARCHAR2,
107 p_Rowid VARCHAR2
108 );
109
110 END IGC_CC_ACTIONS_PKG;