1 PACKAGE CSC_GROUP_CHECKS_PUB AUTHID CURRENT_USER as
2 /* $Header: cscppgcs.pls 115.10 2002/11/29 04:44:38 bhroy ship $ */
3 -- Start of Comments
4 -- Package name : CSC_GROUP_CHECKS_PUB
5 -- Purpose :
6 -- History :
7 -- NOTE :
8 -- End of Comments
9
10 -- Default number of records fetch per call
11 G_DEFAULT_NUM_REC_FETCH NUMBER := 30;
12 -- *******************************************************
13 -- Start of Comments
14 -- -------------------------------------------------------
15 -- Record name:GROUP_CHK_Rec_Type
16 -- -------------------------------------------------------
17 -- Parameters:
18 -- GROUP_ID
19 -- CHECK_ID
20 -- CHECK_SEQUENCE
21 -- END_DATE_ACTIVE
22 -- START_DATE_ACTIVE
23 -- CATEGORY_CODE
24 -- CATEGORY_SEQUENCE
25 -- THRESHOLD_FLAG
26 -- SEEDED_FLAG
27 -- CREATED_BY
28 -- CREATION_DATE
29 -- LAST_UPDATED_BY
30 -- LAST_UPDATE_DATE
31 -- LAST_UPDATE_LOGIN
32 --
33 -- Required:
34 -- Defaults:
35 --
36 -- End of Comments
37
38 TYPE GROUP_CHK_Rec_Type IS RECORD
39 (
40 GROUP_ID NUMBER,
41 CHECK_ID NUMBER,
42 CHECK_SEQUENCE NUMBER,
43 END_DATE_ACTIVE DATE,
44 START_DATE_ACTIVE DATE,
45 CATEGORY_CODE VARCHAR2(30),
46 CATEGORY_SEQUENCE NUMBER,
47 THRESHOLD_FLAG VARCHAR2(3),
48 SEEDED_FLAG VARCHAR2(3),
49 CREATED_BY NUMBER,
50 CREATION_DATE DATE,
51 LAST_UPDATED_BY NUMBER,
52 LAST_UPDATE_DATE DATE,
53 LAST_UPDATE_LOGIN NUMBER
54 );
55
56 G_MISS_GROUP_CHK_REC GROUP_CHK_Rec_Type;
57 TYPE GROUP_CHK_Tbl_Type IS TABLE OF GROUP_CHK_Rec_Type
58 INDEX BY BINARY_INTEGER;
59 G_MISS_GROUP_CHK_TBL GROUP_CHK_Tbl_Type;
60
61 TYPE GROUP_CHK_sort_rec_type IS RECORD
62 (
63 -- Please define your own sort by record here.
64 CHECK_ID NUMBER := NULL
65 );
66
67 -- *******************************************************
68 -- Start of Comments
69 -- *******************************************************
70 -- API Name: Create_group_checks
71 -- Type : Public
72 -- Pre-Req :
73 -- Parameters:
74 -- IN
75 -- p_api_version_number IN NUMBER Required
76 -- p_init_msg_list IN VARCHAR2 Optional Default = FND_API_G_FALSE
77 -- p_commit IN VARCHAR2 Optional Default = CSC_CORE_UTILS_PVT.G_FALSE
78 -- P_GROUP_CHK_Rec IN GROUP_CHK_Rec_Type Required
79 --
80 -- OUT :
81 -- x_return_status OUT NOCOPY VARCHAR2
82 -- x_msg_count OUT NOCOPY NUMBER
83 -- x_msg_data OUT NOCOPY VARCHAR2
84 -- Version : Current version 1.0
85 --
86 -- End of Comments
87 --
88
89 PROCEDURE Create_group_checks(
90 P_Api_Version_Number IN NUMBER,
91 P_Init_Msg_List IN VARCHAR2,
92 P_Commit IN VARCHAR2,
93 p_validation_level IN NUMBER DEFAULT NULL,
94 P_GROUP_ID IN NUMBER DEFAULT NULL,
95 P_CHECK_ID IN NUMBER DEFAULT NULL,
96 P_CHECK_SEQUENCE IN NUMBER DEFAULT NULL,
97 P_END_DATE_ACTIVE IN DATE DEFAULT NULL,
98 P_START_DATE_ACTIVE IN DATE DEFAULT NULL,
99 P_CATEGORY_CODE IN VARCHAR2 DEFAULT NULL,
100 P_CATEGORY_SEQUENCE IN NUMBER DEFAULT NULL,
101 P_THRESHOLD_FLAG IN VARCHAR2 DEFAULT NULL,
102 P_SEEDED_FLAG IN VARCHAR2 DEFAULT NULL,
103 P_CREATED_BY IN NUMBER DEFAULT NULL,
104 P_CREATION_DATE IN DATE DEFAULT NULL,
105 P_LAST_UPDATED_BY IN NUMBER DEFAULT NULL,
106 P_LAST_UPDATE_DATE IN DATE DEFAULT NULL,
107 P_LAST_UPDATE_LOGIN IN NUMBER DEFAULT NULL,
108 X_Return_Status OUT NOCOPY VARCHAR2,
109 X_Msg_Count OUT NOCOPY NUMBER,
110 X_Msg_Data OUT NOCOPY VARCHAR2
111 );
112
113 PROCEDURE Create_group_checks(
114 P_Api_Version_Number IN NUMBER,
115 P_Init_Msg_List IN VARCHAR2,
116 P_Commit IN VARCHAR2,
117 P_GROUP_CHK_Rec IN GROUP_CHK_Rec_Type,
118 X_Return_Status OUT NOCOPY VARCHAR2,
119 X_Msg_Count OUT NOCOPY NUMBER,
120 X_Msg_Data OUT NOCOPY VARCHAR2
121 );
122
123
124 -- *******************************************************
125 -- Start of Comments
126 -- *******************************************************
127 -- API Name: Update_group_checks
128 -- Type : Public
129 -- Pre-Req :
130 -- Parameters:
131 -- IN
132 -- p_api_version_number IN NUMBER Required
133 -- p_init_msg_list IN VARCHAR2 Optional Default = FND_API_G_FALSE
134 -- p_commit IN VARCHAR2 Optional Default = CSC_CORE_UTILS_PVT.G_FALSE
135 -- P_GROUP_CHK_Rec IN GROUP_CHK_Rec_Type Required
136 --
137 -- OUT :
138 -- x_return_status OUT NOCOPY VARCHAR2
139 -- x_msg_count OUT NOCOPY NUMBER
140 -- x_msg_data OUT NOCOPY VARCHAR2
141 -- Version : Current version 1.0
142 --
143 -- End of Comments
144 --
145
146 PROCEDURE Update_group_checks(
147 P_Api_Version_Number IN NUMBER,
148 P_Init_Msg_List IN VARCHAR2,
149 P_Commit IN VARCHAR2,
150 p_validation_level IN NUMBER DEFAULT NULL,
151 P_GROUP_ID IN NUMBER DEFAULT NULL,
152 P_CHECK_ID IN NUMBER DEFAULT NULL,
153 P_CHECK_SEQUENCE IN NUMBER DEFAULT NULL,
154 P_END_DATE_ACTIVE IN DATE DEFAULT NULL,
155 P_START_DATE_ACTIVE IN DATE DEFAULT NULL,
156 P_CATEGORY_CODE IN VARCHAR2 DEFAULT NULL,
157 P_CATEGORY_SEQUENCE IN NUMBER DEFAULT NULL,
158 P_THRESHOLD_FLAG IN VARCHAR2 DEFAULT NULL,
159 P_SEEDED_FLAG IN VARCHAR2 DEFAULT NULL,
160 P_CREATED_BY IN NUMBER DEFAULT NULL,
161 P_CREATION_DATE IN DATE DEFAULT NULL,
162 P_LAST_UPDATED_BY IN NUMBER DEFAULT NULL,
163 P_LAST_UPDATE_DATE IN DATE DEFAULT NULL,
164 P_LAST_UPDATE_LOGIN IN NUMBER DEFAULT NULL,
165 X_Return_Status OUT NOCOPY VARCHAR2,
166 X_Msg_Count OUT NOCOPY NUMBER,
167 X_Msg_Data OUT NOCOPY VARCHAR2
168 );
169
170
171 PROCEDURE Update_group_checks(
172 P_Api_Version_Number IN NUMBER,
173 P_Init_Msg_List IN VARCHAR2,
174 P_Commit IN VARCHAR2,
175 P_GROUP_CHK_Rec IN GROUP_CHK_Rec_Type,
176 X_Return_Status OUT NOCOPY VARCHAR2,
177 X_Msg_Count OUT NOCOPY NUMBER,
178 X_Msg_Data OUT NOCOPY VARCHAR2
179 );
180
181 -- *******************************************************
182 -- Start of Comments
183 -- *******************************************************
184 -- API Name: Delete_group_checks
185 -- Type : Public
186 -- Pre-Req :
187 -- Parameters:
188 -- IN
189 -- p_api_version_number IN NUMBER Required
190 -- p_init_msg_list IN VARCHAR2 Optional Default = FND_API_G_FALSE
191 -- p_commit IN VARCHAR2 Optional Default = CSC_CORE_UTILS_PVT.G_FALSE
192 -- P_GROUP_CHK_Rec IN GROUP_CHK_Rec_Type Required
193 --
194 -- OUT :
195 -- x_return_status OUT NOCOPY VARCHAR2
196 -- x_msg_count OUT NOCOPY NUMBER
197 -- x_msg_data OUT NOCOPY VARCHAR2
198 -- Version : Current version 1.0
199 --
200 -- End of Comments
201 --
202 PROCEDURE Delete_group_checks(
203 P_Api_Version_Number IN NUMBER,
204 P_Init_Msg_List IN VARCHAR2,
205 P_Commit IN VARCHAR2,
206 P_GROUP_ID IN NUMBER,
207 P_CHECK_ID IN NUMBER,
208 P_CHECK_SEQUENCE IN NUMBER,
209 X_Return_Status OUT NOCOPY VARCHAR2,
210 X_Msg_Count OUT NOCOPY NUMBER,
211 X_Msg_Data OUT NOCOPY VARCHAR2
212 );
213
214
215 End CSC_GROUP_CHECKS_PUB;