[Home] [Help]
PACKAGE: APPS.CSC_PROFILE_CHECK_RULES_PUB
Source
1 PACKAGE CSC_PROFILE_CHECK_RULES_PUB AUTHID CURRENT_USER as
2 /* $Header: cscppcrs.pls 115.10 2002/11/29 03:42:40 bhroy ship $ */
3 -- Start of Comments
4 -- Package name : CSC_PROFILE_CHECK_RULES_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: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
58 G_MISS_CHK_RULES_REC CHK_RULES_Rec_Type;
59 TYPE CHK_RULES_Tbl_Type IS TABLE OF CHK_RULES_Rec_Type
60 INDEX BY BINARY_INTEGER;
61 G_MISS_CHK_RULES_TBL CHK_RULES_Tbl_Type;
62
63
64 -- *******************************************************
65 -- Start of Comments
66 -- *******************************************************
67 -- API Name: Create_profile_check_rules
68 -- Type : Public
69 -- Pre-Req :
70 -- Parameters:
71 -- IN
72 -- p_api_version_number IN NUMBER Required
73 -- p_init_msg_list IN VARCHAR2 Optional Default = FND_API_G_FALSE
74 -- p_commit IN VARCHAR2 Optional Default = CSC_CORE_UTILS_PVT.G_FALSE
75 -- P_CHK_RULES_Rec IN CHK_RULES_Rec_Type Required
76 --
77 -- OUT :
78 -- x_return_status OUT NOCOPY VARCHAR2
79 -- x_msg_count OUT NOCOPY NUMBER
80 -- x_msg_data OUT NOCOPY VARCHAR2
81 -- Version : Current version 1.0
82 --
83 -- End of Comments
84 --
85
86
87 PROCEDURE Create_profile_check_rules(
88 P_Api_Version_Number IN NUMBER,
89 P_Init_Msg_List IN VARCHAR2,
90 P_Commit IN VARCHAR2,
91 P_CHECK_ID IN NUMBER DEFAULT NULL,
92 P_BLOCK_ID IN NUMBER DEFAULT NULL,
93 P_SEQUENCE IN NUMBER DEFAULT NULL,
94 P_CREATED_BY IN NUMBER DEFAULT NULL,
95 P_CREATION_DATE IN DATE DEFAULT NULL,
96 P_LAST_UPDATED_BY IN NUMBER DEFAULT NULL,
97 P_LAST_UPDATE_DATE IN DATE DEFAULT NULL,
98 P_LAST_UPDATE_LOGIN IN NUMBER DEFAULT NULL,
99 P_LOGICAL_OPERATOR IN VARCHAR2 DEFAULT NULL,
100 P_LEFT_PAREN IN VARCHAR2 DEFAULT NULL,
101 P_COMPARISON_OPERATOR IN VARCHAR2 DEFAULT NULL,
102 P_EXPRESSION IN VARCHAR2 DEFAULT NULL,
103 P_EXPR_TO_BLOCK_ID IN NUMBER DEFAULT NULL,
104 P_RIGHT_PAREN IN VARCHAR2 DEFAULT NULL,
105 P_SEEDED_FLAG IN VARCHAR2 DEFAULT NULL,
106 X_OBJECT_VERSION_NUMBER OUT NOCOPY NUMBER,
107 X_Return_Status OUT NOCOPY VARCHAR2,
108 X_Msg_Count OUT NOCOPY NUMBER,
109 X_Msg_Data OUT NOCOPY VARCHAR2
110 );
111
112 PROCEDURE Create_profile_check_rules(
113 P_Api_Version_Number IN NUMBER,
114 P_Init_Msg_List IN VARCHAR2,
115 P_Commit IN VARCHAR2,
116 P_CHK_RULES_REC IN CHK_RULES_Rec_Type,
117 X_Object_Version_number OUT NOCOPY NUMBER,
118 X_Return_Status OUT NOCOPY VARCHAR2,
119 X_Msg_Count OUT NOCOPY NUMBER,
120 X_Msg_Data OUT NOCOPY VARCHAR2
121 );
122 -- *******************************************************
123 -- Start of Comments
124 -- *******************************************************
125 -- API Name: Update_profile_check_rules
126 -- Type : Public
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_identity_salesforce_id IN NUMBER Optional Default = NULL
134 -- P_CHK_RULES_Rec IN CHK_RULES_Rec_Type Required
135 --
136 -- OUT :
137 -- x_return_status OUT NOCOPY VARCHAR2
138 -- x_msg_count OUT NOCOPY NUMBER
139 -- x_msg_data OUT NOCOPY VARCHAR2
140 -- Version : Current version 1.0
141 --
142 -- End of Comments
143 --
144
145 PROCEDURE Update_profile_check_rules(
146 P_Api_Version_Number IN NUMBER,
147 P_Init_Msg_List IN VARCHAR2,
148 P_Commit IN VARCHAR2,
149 P_CHECK_ID IN NUMBER DEFAULT NULL,
150 P_BLOCK_ID IN NUMBER DEFAULT NULL,
151 P_SEQUENCE IN NUMBER DEFAULT NULL,
152 P_CREATED_BY IN NUMBER DEFAULT NULL,
153 P_CREATION_DATE IN DATE DEFAULT NULL,
154 P_LAST_UPDATED_BY IN NUMBER DEFAULT NULL,
155 P_LAST_UPDATE_DATE IN DATE DEFAULT NULL,
156 P_LAST_UPDATE_LOGIN IN NUMBER DEFAULT NULL,
157 P_LOGICAL_OPERATOR IN VARCHAR2 DEFAULT NULL,
158 P_LEFT_PAREN IN VARCHAR2 DEFAULT NULL,
159 P_COMPARISON_OPERATOR IN VARCHAR2 DEFAULT NULL,
160 P_EXPRESSION IN VARCHAR2 DEFAULT NULL,
161 P_EXPR_TO_BLOCK_ID IN NUMBER DEFAULT NULL,
162 P_RIGHT_PAREN IN VARCHAR2 DEFAULT NULL,
163 P_SEEDED_FLAG IN VARCHAR2 DEFAULT NULL,
164 PX_OBJECT_VERSION_NUMBER IN OUT NOCOPY NUMBER,
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_profile_check_rules(
172 P_Api_Version_Number IN NUMBER,
173 P_Init_Msg_List IN VARCHAR2,
174 P_Commit IN VARCHAR2,
175 P_CHK_RULES_Rec IN CHK_RULES_Rec_Type,
176 PX_Object_Version_Number IN OUT NOCOPY NUMBER,
177 X_Return_Status OUT NOCOPY VARCHAR2,
178 X_Msg_Count OUT NOCOPY NUMBER,
179 X_Msg_Data OUT NOCOPY VARCHAR2
180 );
181
182 -- *******************************************************
183 -- Start of Comments
184 -- *******************************************************
185 -- API Name: Delete_profile_check_rules
186 -- Type : Public
187 -- Pre-Req :
188 -- Parameters:
189 -- IN
190 -- p_api_version_number IN NUMBER Required
191 -- p_init_msg_list IN VARCHAR2 Optional Default = FND_API_G_FALSE
192 -- p_commit IN VARCHAR2 Optional Default = CSC_CORE_UTILS_PVT.G_FALSE
193 -- P_CHK_RULES_Rec IN CHK_RULES_Rec_Type Required
194 --
195 -- OUT :
196 -- x_return_status OUT NOCOPY VARCHAR2
197 -- x_msg_count OUT NOCOPY NUMBER
198 -- x_msg_data OUT NOCOPY VARCHAR2
199 -- Version : Current version 1.0
200 --
201 -- End of Comments
202 --
203 PROCEDURE Delete_profile_check_rules(
204 P_Api_Version_Number IN NUMBER,
205 P_Init_Msg_List IN VARCHAR2,
206 P_Commit IN VARCHAR2,
207 P_CHECK_ID IN NUMBER,
208 P_SEQUENCE IN NUMBER,
209 P_OBJECT_VERSION_NUMBER IN NUMBER,
210 X_Return_Status OUT NOCOPY VARCHAR2,
211 X_Msg_Count OUT NOCOPY NUMBER,
212 X_Msg_Data OUT NOCOPY VARCHAR2
213 );
214
215
216 End CSC_PROFILE_CHECK_RULES_PUB;