[Home] [Help]
PACKAGE: APPS.IGC_CC_SEC_GROUP_PKG
Source
1 PACKAGE IGC_CC_SEC_GROUP_PKG as
2 /* $Header: IGCCSCGS.pls 120.4.12000000.1 2007/08/20 12:14:41 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_SET_OF_BOOKS_ID NUMBER,
15 P_CC_GROUP_NAME VARCHAR2,
16 P_CC_GROUP_DESC VARCHAR2,
17 P_CONTEXT VARCHAR2,
18 P_ATTRIBUTE1 VARCHAR2,
19 P_ATTRIBUTE2 VARCHAR2,
20 P_ATTRIBUTE3 VARCHAR2,
21 P_ATTRIBUTE4 VARCHAR2,
22 P_ATTRIBUTE5 VARCHAR2,
23 P_ATTRIBUTE6 VARCHAR2,
24 P_ATTRIBUTE7 VARCHAR2,
25 P_ATTRIBUTE8 VARCHAR2,
26 P_ATTRIBUTE9 VARCHAR2,
27 P_ATTRIBUTE10 VARCHAR2,
28 P_ATTRIBUTE11 VARCHAR2,
29 P_ATTRIBUTE12 VARCHAR2,
30 P_ATTRIBUTE13 VARCHAR2,
31 P_ATTRIBUTE14 VARCHAR2,
32 P_ATTRIBUTE15 VARCHAR2,
33 P_LAST_UPDATE_DATE DATE,
34 P_LAST_UPDATED_BY NUMBER,
35 P_CREATION_DATE DATE,
36 P_CREATED_BY NUMBER,
37 P_LAST_UPDATE_LOGIN NUMBER
38 );
39
40 PROCEDURE Update_Row( 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 p_return_status OUT NOCOPY VARCHAR2,
45 p_msg_count OUT NOCOPY NUMBER,
46 p_msg_data OUT NOCOPY VARCHAR2,
47
48 P_ROWID VARCHAR2,
49 P_CC_GROUP_ID NUMBER,
50 P_SET_OF_BOOKS_ID NUMBER,
51 P_CC_GROUP_NAME VARCHAR2,
52 P_CC_GROUP_DESC VARCHAR2,
53 P_CONTEXT VARCHAR2,
54 P_ATTRIBUTE1 VARCHAR2,
55 P_ATTRIBUTE2 VARCHAR2,
56 P_ATTRIBUTE3 VARCHAR2,
57 P_ATTRIBUTE4 VARCHAR2,
58 P_ATTRIBUTE5 VARCHAR2,
59 P_ATTRIBUTE6 VARCHAR2,
60 P_ATTRIBUTE7 VARCHAR2,
61 P_ATTRIBUTE8 VARCHAR2,
62 P_ATTRIBUTE9 VARCHAR2,
63 P_ATTRIBUTE10 VARCHAR2,
64 P_ATTRIBUTE11 VARCHAR2,
65 P_ATTRIBUTE12 VARCHAR2,
66 P_ATTRIBUTE13 VARCHAR2,
67 P_ATTRIBUTE14 VARCHAR2,
68 P_ATTRIBUTE15 VARCHAR2,
69 P_LAST_UPDATE_DATE DATE,
70 P_LAST_UPDATED_BY NUMBER,
71 P_LAST_UPDATE_LOGIN NUMBER
72 );
73
74 PROCEDURE Lock_Row( p_api_version IN NUMBER,
75 p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
76 p_commit IN VARCHAR2 := FND_API.G_FALSE,
77 p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
78 p_return_status OUT NOCOPY VARCHAR2,
79 p_msg_count OUT NOCOPY NUMBER,
80 p_msg_data OUT NOCOPY VARCHAR2,
81
82 P_ROWID VARCHAR2,
83 P_CC_GROUP_ID NUMBER,
84 P_SET_OF_BOOKS_ID NUMBER,
85 P_CC_GROUP_NAME VARCHAR2,
86 P_CC_GROUP_DESC VARCHAR2,
87 P_CONTEXT VARCHAR2,
88 P_ATTRIBUTE1 VARCHAR2,
89 P_ATTRIBUTE2 VARCHAR2,
90 P_ATTRIBUTE3 VARCHAR2,
91 P_ATTRIBUTE4 VARCHAR2,
92 P_ATTRIBUTE5 VARCHAR2,
93 P_ATTRIBUTE6 VARCHAR2,
94 P_ATTRIBUTE7 VARCHAR2,
95 P_ATTRIBUTE8 VARCHAR2,
96 P_ATTRIBUTE9 VARCHAR2,
97 P_ATTRIBUTE10 VARCHAR2,
98 P_ATTRIBUTE11 VARCHAR2,
99 P_ATTRIBUTE12 VARCHAR2,
100 P_ATTRIBUTE13 VARCHAR2,
101 P_ATTRIBUTE14 VARCHAR2,
102 P_ATTRIBUTE15 VARCHAR2,
103 p_row_locked OUT NOCOPY VARCHAR2
104 );
105
106 PROCEDURE Delete_Row( p_api_version IN NUMBER,
107 p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
108 p_commit IN VARCHAR2 := FND_API.G_FALSE,
109 p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
110 p_return_status OUT NOCOPY VARCHAR2,
111 p_msg_count OUT NOCOPY NUMBER,
112 p_msg_data OUT NOCOPY VARCHAR2,
113
114 P_ROWID VARCHAR2);
115
116 PROCEDURE CHECK_UNIQUE(
117 -- p_api_version IN NUMBER,
118 -- p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
119 -- p_commit IN VARCHAR2 := FND_API.G_FALSE,
120 -- p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
121 -- p_return_status OUT NOCOPY VARCHAR2,
122 -- p_msg_count OUT NOCOPY NUMBER,
123 -- p_msg_data OUT NOCOPY VARCHAR2,
124
125 P_ROWID VARCHAR2,
126 P_GROUP_NAME VARCHAR2,
127 P_SOB_ID NUMBER);
128
129 -- END IGC_CC_SEC_GROUP_PKG
130 END IGC_CC_SEC_GROUP_PKG;