DBA Data[Home] [Help]

PACKAGE: APPS.IGC_CC_SEC_GROUP_USERS_PKG

Source


1 PACKAGE IGC_CC_SEC_GROUP_USERS_PKG as
2 /* $Header: IGCCSCUS.pls 120.4.12000000.1 2007/08/20 12:14:48 mbremkum ship $ */
3 
4 PROCEDURE Insert_Row(  p_api_version            IN      NUMBER,
5   		    p_init_msg_list             IN      VARCHAR2 := FND_API.G_FALSE,
6   		    p_commit                    IN      VARCHAR2 := FND_API.G_FALSE,
7   		    p_validation_level          IN      NUMBER   := FND_API.G_VALID_LEVEL_FULL,
8   		    p_return_status             OUT NOCOPY     VARCHAR2,
9   		    p_msg_count                 OUT NOCOPY     NUMBER,
10   		    p_msg_data                  OUT NOCOPY     VARCHAR2,
11 
12 		     P_ROWID 			IN OUT NOCOPY  VARCHAR2,
13 		     P_CC_GROUP_ID			NUMBER,
14 		     P_USER_ID				NUMBER,
15 		     P_CONTEXT				VARCHAR2,
16 		     P_ATTRIBUTE1			VARCHAR2,
17 		     P_ATTRIBUTE2 			VARCHAR2,
18 		     P_ATTRIBUTE3			VARCHAR2,
19 		     P_ATTRIBUTE4			VARCHAR2,
20 		     P_ATTRIBUTE5			VARCHAR2,
21 		     P_ATTRIBUTE6			VARCHAR2,
22 		     P_ATTRIBUTE7			VARCHAR2,
23 		     P_ATTRIBUTE8			VARCHAR2,
24 		     P_ATTRIBUTE9			VARCHAR2,
25 		     P_ATTRIBUTE10 			VARCHAR2,
26 		     P_ATTRIBUTE11 			VARCHAR2,
27 		     P_ATTRIBUTE12 			VARCHAR2,
28 		     P_ATTRIBUTE13 			VARCHAR2,
29 		     P_ATTRIBUTE14 			VARCHAR2,
30 		     P_ATTRIBUTE15 			VARCHAR2,
31 		     P_LAST_UPDATE_DATE			DATE,
32 		     P_LAST_UPDATED_BY			NUMBER,
33 		     P_CREATION_DATE			DATE,
34 		     P_CREATED_BY			NUMBER,
35 		     P_LAST_UPDATE_LOGIN		NUMBER
36 		    );
37 
38 PROCEDURE Update_Row(  p_api_version           IN       NUMBER,
39   		   p_init_msg_list             IN       VARCHAR2 := FND_API.G_FALSE,
40   		   p_commit                    IN       VARCHAR2 := FND_API.G_FALSE,
41   		   p_validation_level          IN       NUMBER   := FND_API.G_VALID_LEVEL_FULL,
42   		   p_return_status             OUT NOCOPY      VARCHAR2,
43   		   p_msg_count                 OUT NOCOPY      NUMBER,
44   		   p_msg_data                  OUT NOCOPY      VARCHAR2,
45 
46 		   P_ROWID			      VARCHAR2,
47 		   P_CC_GROUP_ID	              NUMBER,
48 		   P_USER_ID			      NUMBER,
49 		   P_CONTEXT		              VARCHAR2,
50 		   P_ATTRIBUTE1                       VARCHAR2,
51 		   P_ATTRIBUTE2                       VARCHAR2,
52 		   P_ATTRIBUTE3                       VARCHAR2,
53                    P_ATTRIBUTE4                       VARCHAR2,
54                    P_ATTRIBUTE5                       VARCHAR2,
55                    P_ATTRIBUTE6                       VARCHAR2,
56                    P_ATTRIBUTE7                       VARCHAR2,
57                    P_ATTRIBUTE8                       VARCHAR2,
58                    P_ATTRIBUTE9                       VARCHAR2,
59                    P_ATTRIBUTE10                      VARCHAR2,
60                    P_ATTRIBUTE11                      VARCHAR2,
61                    P_ATTRIBUTE12                      VARCHAR2,
62                    P_ATTRIBUTE13                      VARCHAR2,
63                    P_ATTRIBUTE14                      VARCHAR2,
64                    P_ATTRIBUTE15                      VARCHAR2,
65                    P_LAST_UPDATE_DATE                 DATE,
66 		   P_LAST_UPDATED_BY	              NUMBER,
67 		   P_LAST_UPDATE_LOGIN		      NUMBER
68 		   );
69 
70 PROCEDURE Lock_Row(  p_api_version             IN       NUMBER,
71   		   p_init_msg_list             IN       VARCHAR2 := FND_API.G_FALSE,
72   		   p_commit                    IN       VARCHAR2 := FND_API.G_FALSE,
73   		   p_validation_level          IN       NUMBER   := FND_API.G_VALID_LEVEL_FULL,
74   		   p_return_status             OUT NOCOPY      VARCHAR2,
75   		   p_msg_count                 OUT NOCOPY      NUMBER,
76   		   p_msg_data                  OUT NOCOPY      VARCHAR2,
77 
78 		   P_ROWID			      VARCHAR2,
79                    P_CC_GROUP_ID 	              NUMBER,
80                    P_USER_ID  		              NUMBER,
81                    P_CONTEXT	                      VARCHAR2,
82                    P_ATTRIBUTE1                       VARCHAR2,
83                    P_ATTRIBUTE2                       VARCHAR2,
84                    P_ATTRIBUTE3                       VARCHAR2,
85                    P_ATTRIBUTE4                       VARCHAR2,
86                    P_ATTRIBUTE5                       VARCHAR2,
87                    P_ATTRIBUTE6                       VARCHAR2,
88                    P_ATTRIBUTE7                       VARCHAR2,
89                    P_ATTRIBUTE8                       VARCHAR2,
90                    P_ATTRIBUTE9                       VARCHAR2,
91                    P_ATTRIBUTE10                      VARCHAR2,
92                    P_ATTRIBUTE11                      VARCHAR2,
93                    P_ATTRIBUTE12                      VARCHAR2,
94                    P_ATTRIBUTE13                      VARCHAR2,
95                    P_ATTRIBUTE14                      VARCHAR2,
96                    P_ATTRIBUTE15                      VARCHAR2,
97   		   p_row_locked              OUT NOCOPY      VARCHAR2
98 		  );
99 
100 PROCEDURE Delete_Row(  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   		   p_return_status             OUT NOCOPY      VARCHAR2,
105   		   p_msg_count                 OUT NOCOPY      NUMBER,
106   		   p_msg_data                  OUT NOCOPY      VARCHAR2,
107 
108 		   P_ROWID VARCHAR2) ;
109 
110 -- END IGC_CC_SEC_GROUP_USERS_PKG;
111 END IGC_CC_SEC_GROUP_USERS_PKG;