[Home] [Help]
PACKAGE: APPS.OZF_PARTNER_CLAIM_GRP
Source
1 PACKAGE OZF_PARTNER_CLAIM_GRP AUTHID CURRENT_USER AS
2 /* $Header: ozfgpcls.pls 115.0 2003/11/11 03:13:34 mchang noship $ */
3 -- Start of Comments
4 -- Package name : OZF_PARTNER_CLAIM_GRP
5 -- Purpose :
6 -- History :
7 -- NOTE :
8 -- End of Comments
9
10 -- Default number of records fetch per call
11
12
13 -- *******************************************************
14 -- Start of Comments
15 -- -------------------------------------------------------
16 -- Record name: CLAIM_REC_TYPE
17 -- -------------------------------------------------------
18 -- CLAIM_ID
19 -- CLAIM_NUMBER
20 -- CLAIM_TYPE_ID
21 -- CLAIM_DATE
22 -- DUE_DATE
23 -- GL_DATE
24 -- OWNER_ID
25 -- AMOUNT
26 -- CURRENCY_CODE
27 -- EXCHANGE_RATE_TYPE
28 -- EXCHANGE_RATE_DATE
29 -- EXCHANGE_RATE
30 -- SET_OF_BOOKS_ID
31 -- SOURCE_OBJECT_ID
32 -- SOURCE_OBJECT_CLASS
33 -- SOURCE_OBJECT_TYPE_ID
34 -- SOURCE_OBJECT_NUMBER
35 -- CUST_ACCOUNT_ID
36 -- CUST_BILLTO_ACCT_SITE_ID
37 -- CUST_SHIPTO_ACCT_SITE_ID
38 -- RELATED_CUST_ACCOUNT_ID
39 -- REASON_CODE_ID
40 -- CUSTOMER_REASON
41 -- STATUS_CODE
42 -- USER_STATUS_ID
43 -- SALES_REP_ID
44 -- COLLECTOR_ID
45 -- CONTACT_ID
46 -- BROKER_ID
47 -- CUSTOMER_REF_DATE
48 -- CUSTOMER_REF_NUMBER
49 -- COMMENTS
50 -- ATTRIBUTE_CATEGORY
51 -- ATTRIBUTE1
52 -- ATTRIBUTE2
53 -- ATTRIBUTE3
54 -- ATTRIBUTE4
55 -- ATTRIBUTE5
56 -- ATTRIBUTE6
57 -- ATTRIBUTE7
58 -- ATTRIBUTE8
59 -- ATTRIBUTE9
60 -- ATTRIBUTE10
61 -- ATTRIBUTE11
62 -- ATTRIBUTE12
63 -- ATTRIBUTE13
64 -- ATTRIBUTE14
65 -- ATTRIBUTE15
66 -- ORG_ID
67 -- Required:
68 -- Defaults:
69 -- Note:
70 --
71 -- End of Comments
72
73 TYPE CLAIM_REC_TYPE IS RECORD
74 (
75 CLAIM_ID NUMBER
76 ,CLAIM_NUMBER VARCHAR2(30)
77 ,CLAIM_TYPE_ID NUMBER
78 ,CLAIM_DATE DATE
79 ,DUE_DATE DATE
80 ,GL_DATE DATE
81 ,OWNER_ID NUMBER
82 ,AMOUNT NUMBER
83 ,CURRENCY_CODE VARCHAR2(15)
84 ,EXCHANGE_RATE_TYPE VARCHAR2(30)
85 ,EXCHANGE_RATE_DATE DATE
86 ,EXCHANGE_RATE NUMBER
87 ,SET_OF_BOOKS_ID NUMBER
88 ,SOURCE_OBJECT_ID NUMBER
89 ,SOURCE_OBJECT_CLASS VARCHAR2(15)
90 ,SOURCE_OBJECT_TYPE_ID NUMBER
91 ,SOURCE_OBJECT_NUMBER VARCHAR2(30)
92 ,CUST_ACCOUNT_ID NUMBER
93 ,CUST_BILLTO_ACCT_SITE_ID NUMBER
94 ,CUST_SHIPTO_ACCT_SITE_ID NUMBER
95 ,PAY_TO_CUST_ACCOUNT_ID NUMBER
96 ,REASON_CODE_ID NUMBER
97 ,CUSTOMER_REASON VARCHAR2(30)
98 ,STATUS_CODE VARCHAR2(30)
99 ,USER_STATUS_ID NUMBER
100 ,SALES_REP_ID NUMBER
101 ,COLLECTOR_ID NUMBER
102 ,CONTACT_ID NUMBER
103 ,BROKER_ID NUMBER
104 ,CUSTOMER_REF_DATE DATE
105 ,CUSTOMER_REF_NUMBER VARCHAR2(30)
106 ,COMMENTS VARCHAR2(2000)
107 ,ATTRIBUTE_CATEGORY VARCHAR2(30)
108 ,ATTRIBUTE1 VARCHAR2(150)
109 ,ATTRIBUTE2 VARCHAR2(150)
110 ,ATTRIBUTE3 VARCHAR2(150)
111 ,ATTRIBUTE4 VARCHAR2(150)
112 ,ATTRIBUTE5 VARCHAR2(150)
113 ,ATTRIBUTE6 VARCHAR2(150)
114 ,ATTRIBUTE7 VARCHAR2(150)
115 ,ATTRIBUTE8 VARCHAR2(150)
116 ,ATTRIBUTE9 VARCHAR2(150)
117 ,ATTRIBUTE10 VARCHAR2(150)
118 ,ATTRIBUTE11 VARCHAR2(150)
119 ,ATTRIBUTE12 VARCHAR2(150)
120 ,ATTRIBUTE13 VARCHAR2(150)
121 ,ATTRIBUTE14 VARCHAR2(150)
122 ,ATTRIBUTE15 VARCHAR2(150)
123 ,ORG_ID NUMBER
124 );
125
126 TYPE CLAIM_TBL_TYPE IS TABLE OF CLAIM_REC_TYPE
127 INDEX BY BINARY_INTEGER;
128
129
130 -- *******************************************************
131 -- Start of Comments
132 -- -------------------------------------------------------
133 -- Record name: PROMOTION_ACTIVITY_REC_TYPE
134 -- -------------------------------------------------------
135 -- OFFER_ID
136 -- ITEM_ID
137 -- AMOUNT
138 --
139 -- Required:
140 -- Defaults:
141 -- Note:
142 --
143 -- End of Comments
144
145
146 TYPE PROMOTION_ACTIVITY_REC_TYPE IS RECORD
147 (
148 OFFER_ID NUMBER
149 ,ITEM_ID NUMBER
150 ,REFERENCE_TYPE VARCHAR2(30)
151 ,REFERENCE_ID NUMBER
152 ,AMOUNT NUMBER
153 );
154
155 TYPE PROMOTION_ACTIVITY_TBL_TYPE IS TABLE OF PROMOTION_ACTIVITY_REC_TYPE
156 INDEX BY BINARY_INTEGER;
157
158
159 -- *******************************************************
160 -- Start of Comments
161 -- *******************************************************
162 -- API Name: Create_Claim
163 -- Type : Public
164 -- Pre-Req :
165 -- Parameters:
166 -- IN
167 -- p_api_version_number IN NUMBER Required
168 -- p_init_msg_list IN VARCHAR2 Optional Default = FND_API_G_FALSE
169 -- p_commit IN VARCHAR2 Optional Default = FND_API.G_FALSE
170 -- p_validation_level IN NUMBER Optional Default = FND_API.G_VALID_LEVEL_FULL
171 -- p_claim_rec IN CLAIM_REC_TYPE Required
172 -- p_promotion_activity_tbl IN PROMOTION_ACTIVITY_TBL_TYPE Required
173 --
174 -- OUT:
175 -- x_return_status OUT VARCHAR2
176 -- x_msg_count OUT NUMBER
177 -- x_msg_data OUT VARCHAR2
178 -- x_claim_id OUT NUMBER
179 -- x_claim_number OUT VARCHAR2
180 -- x_claim_amount OUT NUMBER
181 --
182 -- Version : Current version 1.0
183 --
184 -- Note:
185 --
186 -- End of Comments
187 -- *******************************************************
188 PROCEDURE Create_Claim(
189 p_api_version_number IN NUMBER,
190 p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
191 p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
192 p_commit IN VARCHAR2 := FND_API.G_FALSE,
193
194 x_return_status OUT NOCOPY VARCHAR2,
195 x_msg_count OUT NOCOPY NUMBER,
196 x_msg_data OUT NOCOPY VARCHAR2,
197
198 p_claim_rec IN CLAIM_REC_TYPE,
199 p_promotion_activity_rec IN PROMOTION_ACTIVITY_REC_TYPE,
200 x_claim_id OUT NOCOPY NUMBER,
201 x_claim_number OUT NOCOPY VARCHAR2,
202 x_claim_amount OUT NOCOPY NUMBER
203 );
204
205
206 -- *******************************************************
207 -- Start of Comments
208 -- *******************************************************
209 -- API Name: Update_Claim
210 -- Type : Public
211 -- Pre-Req :
212 -- Parameters:
213 -- IN
214 -- p_api_version_number IN NUMBER Required
215 -- p_init_msg_list IN VARCHAR2 Optional Default = FND_API_G_FALSE
216 -- p_commit IN VARCHAR2 Optional Default = FND_API.G_FALSE
217 -- p_validation_level IN NUMBER Optional Default = FND_API.G_VALID_LEVEL_FULL
218 -- p_claim_id IN NUMBER Required
219 -- p_status_code IN VARCHAR2 Required
220 -- p_note_type IN VARCHAR2 Optional
221 -- p_note_detail IN VARCHAR2 Optional
222 --
223 -- OUT:
224 -- x_return_status OUT VARCHAR2
225 -- x_msg_count OUT NUMBER
226 -- x_msg_data OUT VARCHAR2
227 --
228 -- Version : Current version 1.0
229 --
230 -- Note:
231 --
232 -- End of Comments
233 -- *******************************************************
234 PROCEDURE Update_Claim(
235 p_api_version_number IN NUMBER,
236 p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
237 p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
238 p_commit IN VARCHAR2 := FND_API.G_FALSE,
239
240 x_return_status OUT NOCOPY VARCHAR2,
241 x_msg_count OUT NOCOPY NUMBER,
242 x_msg_data OUT NOCOPY VARCHAR2,
243
244 p_claim_id IN NUMBER,
245 p_status_code IN VARCHAR2,
246 p_comments IN VARCHAR2 := NULL,
247 p_note_type IN VARCHAR2 := NULL,
248 p_note_detail IN VARCHAR2 := NULL
249 );
250
251
252 END OZF_PARTNER_CLAIM_GRP;