1 PACKAGE CSP_RS_CUST_RELATION_PUB AUTHID CURRENT_USER as
2 /* $Header: cspprcrs.pls 115.7 2002/11/26 06:31:21 hhaugeru noship $ */
3 -- Start of Comments
4 -- Package name : CSP_RS_CUST_RELATION_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:RCR_Rec_Type
16 -- -------------------------------------------------------
17 -- Parameters:
18 -- RS_CUST_RELATION_ID
19 -- RESOURCE_TYPE
20 -- RESOURCE_ID
21 -- CUSTOMER_ID
22 -- CREATED_BY
23 -- CREATION_DATE
24 -- LAST_UPDATED_BY
25 -- LAST_UPDATE_DATE
26 -- LAST_UPDATE_LOGIN
27 -- ATTRIBUTE_CATEGORY
28 -- ATTRIBUTE1
29 -- ATTRIBUTE2
30 -- ATTRIBUTE3
31 -- ATTRIBUTE4
32 -- ATTRIBUTE5
33 -- ATTRIBUTE6
34 -- ATTRIBUTE7
35 -- ATTRIBUTE8
36 -- ATTRIBUTE9
37 -- ATTRIBUTE10
38 -- ATTRIBUTE11
39 -- ATTRIBUTE12
40 -- ATTRIBUTE13
41 -- ATTRIBUTE14
42 -- ATTRIBUTE15
43 --
44 -- Required:
45 -- Defaults:
46 -- Note: This is automatic generated record definition, it includes all columns
47 -- defined in the table, developer must manually add or delete some of the attributes.
48 --
49 -- End of Comments
50
51 TYPE RCR_Rec_Type IS RECORD
52 (
53 RS_CUST_RELATION_ID NUMBER := FND_API.G_MISS_NUM,
54 RESOURCE_TYPE VARCHAR2(30) := FND_API.G_MISS_CHAR,
55 RESOURCE_ID NUMBER := FND_API.G_MISS_NUM,
56 CUSTOMER_ID NUMBER := FND_API.G_MISS_NUM,
57 CREATED_BY NUMBER := FND_API.G_MISS_NUM,
58 CREATION_DATE DATE := FND_API.G_MISS_DATE,
59 LAST_UPDATED_BY NUMBER := FND_API.G_MISS_NUM,
60 LAST_UPDATE_DATE DATE := FND_API.G_MISS_DATE,
61 LAST_UPDATE_LOGIN NUMBER := FND_API.G_MISS_NUM,
62 ATTRIBUTE_CATEGORY VARCHAR2(30) := FND_API.G_MISS_CHAR,
63 ATTRIBUTE1 VARCHAR2(150) := FND_API.G_MISS_CHAR,
64 ATTRIBUTE2 VARCHAR2(150) := FND_API.G_MISS_CHAR,
65 ATTRIBUTE3 VARCHAR2(150) := FND_API.G_MISS_CHAR,
66 ATTRIBUTE4 VARCHAR2(150) := FND_API.G_MISS_CHAR,
67 ATTRIBUTE5 VARCHAR2(150) := FND_API.G_MISS_CHAR,
68 ATTRIBUTE6 VARCHAR2(150) := FND_API.G_MISS_CHAR,
69 ATTRIBUTE7 VARCHAR2(150) := FND_API.G_MISS_CHAR,
70 ATTRIBUTE8 VARCHAR2(150) := FND_API.G_MISS_CHAR,
71 ATTRIBUTE9 VARCHAR2(150) := FND_API.G_MISS_CHAR,
72 ATTRIBUTE10 VARCHAR2(150) := FND_API.G_MISS_CHAR,
73 ATTRIBUTE11 VARCHAR2(150) := FND_API.G_MISS_CHAR,
74 ATTRIBUTE12 VARCHAR2(150) := FND_API.G_MISS_CHAR,
75 ATTRIBUTE13 VARCHAR2(150) := FND_API.G_MISS_CHAR,
76 ATTRIBUTE14 VARCHAR2(150) := FND_API.G_MISS_CHAR,
77 ATTRIBUTE15 VARCHAR2(150) := FND_API.G_MISS_CHAR
78 );
79
80 G_MISS_RCR_REC RCR_Rec_Type;
81 TYPE RCR_Tbl_Type IS TABLE OF RCR_Rec_Type
82 INDEX BY BINARY_INTEGER;
83 G_MISS_RCR_TBL RCR_Tbl_Type;
84
85 TYPE RCR_sort_rec_type IS RECORD
86 (
87 -- Please define your own sort by record here.
88 RESOURCE_TYPE NUMBER := NULL
89 );
90
91 -- *******************************************************
92 -- Start of Comments
93 -- *******************************************************
94 -- API Name: Create_rs_cust_relation
95 -- Type : Public
96 -- Pre-Req :
97 -- Parameters:
98 -- IN
99 -- p_api_version_number IN NUMBER Required
100 -- p_init_msg_list IN VARCHAR2 Optional Default = FND_API_G_FALSE
101 -- p_commit IN VARCHAR2 Optional Default = FND_API.G_FALSE
102 -- p_validation_level IN NUMBER Optional Default = FND_API.G_VALID_LEVEL_FULL
103 -- p_check_access_flag IN VARCHAR2 Optional Default = FND_API.G_FALSE
104 -- p_admin_flag IN VARCHAR2 Optional Default = FND_API.G_FALSE
105 -- p_admin_group_id IN NUMBER Required
106 -- P_RCR_Rec IN RCR_Rec_Type Required
107 -- p_profile_tbl IN AS_UTILITY_PUB.PROFILE_TBL_TYPE Required
108 --
109 -- OUT:
110 -- x_return_status OUT NOCOPY VARCHAR2
111 -- x_msg_count OUT NOCOPY NUMBER
112 -- x_msg_data OUT NOCOPY VARCHAR2
113 -- Version : Current version 2.0
114 -- Note: This automatic generated procedure definition, it includes standard IN/OUT parameters
115 -- and basic operation, developer must manually add parameters and business logic as necessary.
116 --
117 -- End of Comments
118 --
119 PROCEDURE Create_rs_cust_relation(
120 P_Api_Version_Number IN NUMBER,
121 P_Init_Msg_List IN VARCHAR2 := FND_API.G_FALSE,
122 P_Commit IN VARCHAR2 := FND_API.G_FALSE,
123 P_RCR_Rec IN RCR_Rec_Type := G_MISS_RCR_REC,
124 --Hint: Add detail tables as parameter lists if it's master-detail relationship.
125 X_RS_CUST_RELATION_ID OUT NOCOPY NUMBER,
126 X_Return_Status OUT NOCOPY VARCHAR2,
127 X_Msg_Count OUT NOCOPY NUMBER,
128 X_Msg_Data OUT NOCOPY VARCHAR2
129 );
130
131 -- *******************************************************
132 -- Start of Comments
133 -- *******************************************************
134 -- API Name: Update_rs_cust_relation
135 -- Type : Public
136 -- Pre-Req :
137 -- Parameters:
138 -- IN
139 -- p_api_version_number IN NUMBER Required
140 -- p_init_msg_list IN VARCHAR2 Optional Default = FND_API_G_FALSE
141 -- p_commit IN VARCHAR2 Optional Default = FND_API.G_FALSE
142 -- p_validation_level IN NUMBER Optional Default = FND_API.G_VALID_LEVEL_FULL
143 -- p_check_access_flag IN VARCHAR2 Optional Default = FND_API.G_FALSE
144 -- p_admin_flag IN VARCHAR2 Optional Default = FND_API.G_FALSE
145 -- p_admin_group_id IN NUMBER Required
146 -- p_identity_salesforce_id IN NUMBER Optional Default = NULL
147 -- P_RCR_Rec IN RCR_Rec_Type Required
148 -- p_profile_tbl IN AS_UTILITY_PUB.PROFILE_TBL_TYPE Required
149 --
150 -- OUT:
151 -- x_return_status OUT NOCOPY VARCHAR2
152 -- x_msg_count OUT NOCOPY NUMBER
153 -- x_msg_data OUT NOCOPY VARCHAR2
154 -- Version : Current version 2.0
155 -- Note: This automatic generated procedure definition, it includes standard IN/OUT parameters
156 -- and basic operation, developer must manually add parameters and business logic as necessary.
157 --
158 -- End of Comments
159 --
160 -- Hint: Add corresponding update detail table procedures if it's master-detail relationship.
161 PROCEDURE Update_rs_cust_relation(
162 P_Api_Version_Number IN NUMBER,
163 P_Init_Msg_List IN VARCHAR2 := FND_API.G_FALSE,
164 P_Commit IN VARCHAR2 := FND_API.G_FALSE,
165 P_Identity_Salesforce_Id IN NUMBER := NULL ,
166 P_RCR_Rec IN RCR_Rec_Type,
167 X_Return_Status OUT NOCOPY VARCHAR2,
168 X_Msg_Count OUT NOCOPY NUMBER,
169 X_Msg_Data OUT NOCOPY VARCHAR2
170 );
171
172 -- *******************************************************
173 -- Start of Comments
174 -- *******************************************************
175 -- API Name: Delete_rs_cust_relation
176 -- Type : Public
177 -- Pre-Req :
178 -- Parameters:
179 -- IN
180 -- p_api_version_number IN NUMBER Required
181 -- p_init_msg_list IN VARCHAR2 Optional Default = FND_API_G_FALSE
182 -- p_commit IN VARCHAR2 Optional Default = FND_API.G_FALSE
183 -- p_validation_level IN NUMBER Optional Default = FND_API.G_VALID_LEVEL_FULL
184 -- p_check_access_flag IN VARCHAR2 Optional Default = FND_API.G_FALSE
185 -- p_admin_flag IN VARCHAR2 Optional Default = FND_API.G_FALSE
186 -- p_admin_group_id IN NUMBER Required
187 -- p_identity_salesforce_id IN NUMBER Optional Default = NULL
188 -- P_RCR_Rec IN RCR_Rec_Type Required
189 -- p_profile_tbl IN AS_UTILITY_PUB.PROFILE_TBL_TYPE Required
190 --
191 -- OUT:
192 -- x_return_status OUT NOCOPY VARCHAR2
193 -- x_msg_count OUT NOCOPY NUMBER
194 -- x_msg_data OUT NOCOPY VARCHAR2
195 -- Version : Current version 2.0
196 -- Note: This automatic generated procedure definition, it includes standard IN/OUT parameters
197 -- and basic operation, developer must manually add parameters and business logic as necessary.
198 --
199 -- End of Comments
200 --
201 -- Hint: Add corresponding delete detail table procedures if it's master-detail relationship.
202 -- The Master delete procedure may not be needed depends on different business requirements.
203 PROCEDURE Delete_rs_cust_relation(
204 P_Api_Version_Number IN NUMBER,
205 P_Init_Msg_List IN VARCHAR2 := FND_API.G_FALSE,
206 P_Commit IN VARCHAR2 := FND_API.G_FALSE,
207 P_Identity_Salesforce_Id IN NUMBER := NULL ,
208 P_RCR_Rec IN RCR_Rec_Type,
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 -- Start of Comments
216 -- *******************************************************
217 -- API Name: Get_rs_cust_relation
218 -- Type : Public
219 -- Pre-Req :
220 -- Parameters:
221 -- IN
222 -- p_api_version_number IN NUMBER Required
223 -- p_init_msg_list IN VARCHAR2 Optional Default = FND_API_G_FALSE
224 -- p_validation_level IN NUMBER Optional Default = FND_API.G_VALID_LEVEL_FULL
225 -- p_check_access_flag IN VARCHAR2 Optional Default = FND_API.G_FALSE
226 -- p_admin_flag IN VARCHAR2 Optional Default = FND_API.G_FALSE
227 -- p_admin_group_id IN NUMBER Required
228 -- p_identity_salesforce_id IN NUMBER Optional Default = NULL
229 -- P_RCR_Rec IN RCR_Rec_Type Required
230 -- p_profile_tbl IN AS_UTILITY_PUB.PROFILE_TBL_TYPE Required
231 -- Hint: Add List of bind variables here
232 -- p_rec_requested IN NUMBER Optional Default = 30
233 -- p_start_rec_ptr IN NUMBER Optional Default = 1
234 --
235 -- Return Total Records Count Flag. This flag controls whether the total record count
236 -- and total record amount is returned.
237 --
238 -- p_return_tot_count IN VARCHAR2 Optional Default = FND_API.G_FALSE
239 -- Hint: User defined record type
240 -- p_order_by_tbl IN AS_UTILITY_PUB.UTIL_ORDER_BY_TBL_TYPE;
241 --
242 -- OUT:
243 -- x_return_status OUT NOCOPY VARCHAR2
244 -- x_msg_count OUT NOCOPY NUMBER
245 -- x_msg_data OUT NOCOPY VARCHAR2
246 -- X_RCR_Tbl OUT NOCOPY RCR_Rec_Type
247 -- x_returned_rec_count OUT NOCOPY NUMBER
248 -- x_next_rec_ptr OUT NOCOPY NUMBER
249 -- x_tot_rec_count OUT NOCOPY NUMBER
250 -- other optional OUT NOCOPY parameters
251 -- x_tot_rec_amount OUT NOCOPY NUMBER
252 -- Version : Current version 2.0
253 -- Note: This automatic generated procedure definition, it includes standard IN/OUT parameters
254 -- and basic operation, developer must manually add parameters and business logic as necessary.
255 --
256 -- End of Comments
257 --
258 PROCEDURE Get_rs_cust_relation(
259 P_Api_Version_Number IN NUMBER,
260 P_Init_Msg_List IN VARCHAR2 := FND_API.G_FALSE,
261 P_identity_salesforce_id IN NUMBER := NULL,
262 P_RCR_Rec IN CSP_rs_cust_relation_PUB.RCR_Rec_Type,
263 -- Hint: Add list of bind variables here
264 p_rec_requested IN NUMBER := G_DEFAULT_NUM_REC_FETCH,
265 p_start_rec_prt IN NUMBER := 1,
266 p_return_tot_count IN NUMBER := FND_API.G_FALSE,
267 -- Hint: user defined record type
268 p_order_by_rec IN CSP_rs_cust_relation_PUB.RCR_sort_rec_type,
269 x_return_status OUT NOCOPY VARCHAR2,
270 x_msg_count OUT NOCOPY NUMBER,
271 x_msg_data OUT NOCOPY VARCHAR2,
272 X_RCR_Tbl OUT NOCOPY CSP_rs_cust_relation_PUB.RCR_Tbl_Type,
273 x_returned_rec_count OUT NOCOPY NUMBER,
274 x_next_rec_ptr OUT NOCOPY NUMBER,
275 x_tot_rec_count OUT NOCOPY NUMBER
276 -- other optional parameters
277 -- x_tot_rec_amount OUT NOCOPY NUMBER
278 );
279
280 End CSP_RS_CUST_RELATION_PUB;