[Home] [Help]
PACKAGE: APPS.CSC_PROFILE_CHECK_RULES_PVT
Source
1 PACKAGE CSC_PROFILE_CHECK_RULES_PVT AUTHID CURRENT_USER as
2 /* $Header: cscvpcrs.pls 115.9 2002/12/03 17:56:57 jamose ship $ */
3 -- Start of Comments
4 -- Package name : CSC_PROFILE_CHECK_RULES_PVT
5 -- Purpose :
6 -- History :26 Nov 02 jamose made changes for the NOCOPY and FND_API.G_MISS*
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:CHK_RULES_Rec_Type
16 -- -------------------------------------------------------
17 -- Parameters:
18 -- CHECK_ID
19 -- SEQUENCE
20 -- CREATED_BY
21 -- CREATION_DATE
22 -- LAST_UPDATED_BY
23 -- LAST_UPDATE_DATE
24 -- LAST_UPDATE_LOGIN
25 -- LOGICAL_OPERATOR
26 -- LEFT_PAREN
27 -- BLOCK_ID
28 -- COMPARISON_OPERATOR
29 -- EXPRESSION1
30 -- EXPRESSION2
31 -- RIGHT_PAREN
32 -- SEEDED_FLAG
33 --
34 -- Required:
35 -- Defaults:
36 --
37 -- End of Comments
38
39 TYPE CHK_RULES_Rec_Type IS RECORD
40 (
41 CHECK_ID NUMBER,
42 SEQUENCE NUMBER,
43 CREATED_BY NUMBER,
44 CREATION_DATE DATE,
45 LAST_UPDATED_BY NUMBER,
46 LAST_UPDATE_DATE DATE,
47 LAST_UPDATE_LOGIN NUMBER,
48 LOGICAL_OPERATOR VARCHAR2(30),
49 LEFT_PAREN VARCHAR2(30),
50 BLOCK_ID NUMBER,
51 COMPARISON_OPERATOR VARCHAR2(45),
52 EXPRESSION VARCHAR2(240),
53 EXPR_TO_BLOCK_ID NUMBER,
54 RIGHT_PAREN VARCHAR2(30),
55 SEEDED_FLAG VARCHAR2(3));
56
57 G_MISS_CHK_RULES_REC CHK_RULES_Rec_Type;
58 TYPE CHK_RULES_Tbl_Type IS TABLE OF CHK_RULES_Rec_Type
59 INDEX BY BINARY_INTEGER;
60 G_MISS_CHK_RULES_TBL CHK_RULES_Tbl_Type;
61
62 -- *******************************************************
63 -- Start of Comments
64 -- *******************************************************
65 -- API Name: Create_profile_check_rules
66 -- Type : Private
67 -- Pre-Req :
68 -- Parameters:
69 -- IN
70 -- p_api_version_number IN NUMBER Required
71 -- p_init_msg_list IN VARCHAR2 Optional Default = FND_API_G_FALSE
72 -- p_commit IN VARCHAR2 Optional Default = CSC_CORE_UTILS_PVT.G_FALSE
73 -- p_validation_level IN NUMBER Optional Default = CSC_CORE_UTILS_PVT.G_VALID_LEVEL_FULL
74 -- P_CHK_RULES_Rec IN CHK_RULES_Rec_Type Required
75 --
76 -- OUT:
77 -- x_return_status OUT VARCHAR2
78 -- x_msg_count OUT NUMBER
79 -- x_msg_data OUT VARCHAR2
80 -- Version : Current version 1.0
81 --
82 -- End of Comments
83 --
84 PROCEDURE Create_profile_check_rules(
85 P_Api_Version_Number IN NUMBER,
86 P_Init_Msg_List IN VARCHAR2 := CSC_CORE_UTILS_PVT.G_FALSE,
87 P_Commit IN VARCHAR2 := CSC_CORE_UTILS_PVT.G_FALSE,
88 p_validation_level IN NUMBER := CSC_CORE_UTILS_PVT.G_VALID_LEVEL_FULL,
89 P_CHECK_ID IN NUMBER,
90 P_BLOCK_ID IN NUMBER,
91 P_SEQUENCE IN NUMBER,
92 P_CREATED_BY IN NUMBER,
93 P_CREATION_DATE IN DATE,
94 P_LAST_UPDATED_BY IN NUMBER,
95 P_LAST_UPDATE_DATE IN DATE,
96 P_LAST_UPDATE_LOGIN IN NUMBER,
97 P_LOGICAL_OPERATOR IN VARCHAR2,
98 P_LEFT_PAREN IN VARCHAR2,
99 P_COMPARISON_OPERATOR IN VARCHAR2,
100 P_EXPRESSION IN VARCHAR2,
101 P_EXPR_TO_BLOCK_ID IN NUMBER,
102 P_RIGHT_PAREN IN VARCHAR2,
103 P_SEEDED_FLAG IN VARCHAR2,
104 X_OBJECT_VERSION_NUMBER OUT NOCOPY NUMBER,
105 X_Return_Status OUT NOCOPY VARCHAR2,
106 X_Msg_Count OUT NOCOPY NUMBER,
107 X_Msg_Data OUT NOCOPY VARCHAR2
108 );
109
110 PROCEDURE Create_profile_check_rules(
111 P_Api_Version_Number IN NUMBER,
112 P_Init_Msg_List IN VARCHAR2 := CSC_CORE_UTILS_PVT.G_FALSE,
113 P_Commit IN VARCHAR2 := CSC_CORE_UTILS_PVT.G_FALSE,
114 p_validation_level IN NUMBER := CSC_CORE_UTILS_PVT.G_VALID_LEVEL_FULL,
115 P_CHK_RULES_Rec IN CHK_RULES_Rec_Type := G_MISS_CHK_RULES_REC,
116 X_OBJECT_VERSION_NUMBER OUT NOCOPY NUMBER,
117 X_Return_Status OUT NOCOPY VARCHAR2,
118 X_Msg_Count OUT NOCOPY NUMBER,
119 X_Msg_Data OUT NOCOPY VARCHAR2
120 );
121
122 -- *******************************************************
123 -- Start of Comments
124 -- *******************************************************
125 -- API Name: Update_profile_check_rules
126 -- Type : Private
127 -- Pre-Req :
128 -- Parameters:
129 -- IN
130 -- p_api_version_number IN NUMBER Required
131 -- p_init_msg_list IN VARCHAR2 Optional Default = FND_API_G_FALSE
132 -- p_commit IN VARCHAR2 Optional Default = CSC_CORE_UTILS_PVT.G_FALSE
133 -- p_validation_level IN NUMBER Optional Default = CSC_CORE_UTILS_PVT.G_VALID_LEVEL_FULL
134 -- p_identity_salesforce_id IN NUMBER Optional Default = NULL
135 -- P_CHK_RULES_Rec IN CHK_RULES_Rec_Type Required
136 --
137 -- OUT:
138 -- x_return_status OUT VARCHAR2
139 -- x_msg_count OUT NUMBER
140 -- x_msg_data OUT VARCHAR2
141 -- Version : Current version 1.0
142 --
143 -- End of Comments
144 --
145
146 PROCEDURE Update_profile_check_rules(
147 P_Api_Version_Number IN NUMBER,
148 P_Init_Msg_List IN VARCHAR2 := CSC_CORE_UTILS_PVT.G_FALSE,
149 P_Commit IN VARCHAR2 := CSC_CORE_UTILS_PVT.G_FALSE,
150 p_validation_level IN NUMBER := CSC_CORE_UTILS_PVT.G_VALID_LEVEL_FULL,
151 P_CHECK_ID IN NUMBER,
152 P_BLOCK_ID IN NUMBER,
153 P_SEQUENCE IN NUMBER,
154 P_CREATED_BY IN NUMBER,
155 P_CREATION_DATE IN DATE,
156 P_LAST_UPDATED_BY IN NUMBER,
157 P_LAST_UPDATE_DATE IN DATE,
158 P_LAST_UPDATE_LOGIN IN NUMBER,
159 P_LOGICAL_OPERATOR IN VARCHAR2,
160 P_LEFT_PAREN IN VARCHAR2,
161 P_COMPARISON_OPERATOR IN VARCHAR2,
162 P_EXPRESSION IN VARCHAR2,
163 P_EXPR_TO_BLOCK_ID IN NUMBER,
164 P_RIGHT_PAREN IN VARCHAR2,
165 P_SEEDED_FLAG IN VARCHAR2,
166 PX_OBJECT_VERSION_NUMBER IN OUT NOCOPY NUMBER,
167 X_Return_Status OUT NOCOPY VARCHAR2,
168 X_Msg_Count OUT NOCOPY NUMBER,
169 X_Msg_Data OUT NOCOPY VARCHAR2
170 );
171
172 PROCEDURE Update_profile_check_rules(
173 P_Api_Version_Number IN NUMBER,
174 P_Init_Msg_List IN VARCHAR2 := CSC_CORE_UTILS_PVT.G_FALSE,
175 P_Commit IN VARCHAR2 := CSC_CORE_UTILS_PVT.G_FALSE,
176 p_validation_level IN NUMBER := CSC_CORE_UTILS_PVT.G_VALID_LEVEL_FULL,
177 P_CHK_RULES_Rec IN CHK_RULES_Rec_Type := G_MISS_CHK_RULES_REC,
178 --P_CHECK_ID IN NUMBER,
179 --P_BLOCK_ID IN NUMBER,
180 PX_OBJECT_VERSION_NUMBER IN OUT NOCOPY NUMBER,
181 X_Return_Status OUT NOCOPY VARCHAR2,
182 X_Msg_Count OUT NOCOPY NUMBER,
183 X_Msg_Data OUT NOCOPY VARCHAR2
184 );
185
186 -- *******************************************************
187 -- Start of Comments
188 -- *******************************************************
189 -- API Name: Delete_profile_check_rules
190 -- Type : Private
191 -- Pre-Req :
192 -- Parameters:
193 -- IN
194 -- p_api_version_number IN NUMBER Required
195 -- p_init_msg_list IN VARCHAR2 Optional Default = FND_API_G_FALSE
196 -- p_commit IN VARCHAR2 Optional Default = CSC_CORE_UTILS_PVT.G_FALSE
197 -- p_validation_level IN NUMBER Optional Default = CSC_CORE_UTILS_PVT.G_VALID_LEVEL_FULL
198 -- p_identity_salesforce_id IN NUMBER Optional Default = NULL
199 -- P_CHK_RULES_Rec IN CHK_RULES_Rec_Type Required
200 --
201 -- OUT:
202 -- x_return_status OUT VARCHAR2
203 -- x_msg_count OUT NUMBER
204 -- x_msg_data OUT VARCHAR2
205 -- Version : Current version 1.0
206 --
207 -- End of Comments
208 --
209 PROCEDURE Delete_profile_check_rules(
210 P_Api_Version_Number IN NUMBER,
211 P_Init_Msg_List IN VARCHAR2 := CSC_CORE_UTILS_PVT.G_FALSE,
212 P_Commit IN VARCHAR2 := CSC_CORE_UTILS_PVT.G_FALSE,
213 p_validation_level IN NUMBER := CSC_CORE_UTILS_PVT.G_VALID_LEVEL_FULL,
214 p_Check_id IN NUMBER,
215 p_Sequence IN NUMBER,
216 p_OBJECT_VERSION_NUMBER IN NUMBER,
217 X_Return_Status OUT NOCOPY VARCHAR2,
218 X_Msg_Count OUT NOCOPY NUMBER,
219 X_Msg_Data OUT NOCOPY VARCHAR2
220 );
221
222 -- *******************************************************
223 -- Start of Comments
224 -- *******************************************************
225 -- API Name: Validate_profile_check_rules
226
227 PROCEDURE Validate_profile_check_rules(
228 P_Api_Name IN VARCHAR2,
229 P_Init_Msg_List IN VARCHAR2 := CSC_CORE_UTILS_PVT.G_FALSE,
230 P_Validation_level IN NUMBER := CSC_CORE_UTILS_PVT.G_VALID_LEVEL_FULL,
231 P_Validation_mode IN VARCHAR2,
232 P_CHK_RULES_Rec IN CHK_RULES_Rec_Type,
233 --P_BLOCK_ID IN NUMBER,
234 --P_CHECK_ID IN NUMBER,
235 X_Return_Status OUT NOCOPY VARCHAR2,
236 X_Msg_Count OUT NOCOPY NUMBER,
237 X_Msg_Data OUT NOCOPY VARCHAR2
238 );
239 End CSC_PROFILE_CHECK_RULES_PVT;