[Home] [Help]
PACKAGE: APPS.DPP_LOG_PVT
Source
1 PACKAGE DPP_LOG_PVT AUTHID CURRENT_USER AS
2 /* $Header: dppvlogs.pls 120.3.12010000.2 2009/08/17 10:27:31 rvkondur ship $ */
3 TYPE dpp_cst_hdr_rec_type IS RECORD
4 (
5 LOG_MODE VARCHAR2(1),
6 TRANSACTION_HEADER_ID NUMBER,
7 TRANSACTION_NUMBER VARCHAR2(40),
8 REF_DOCUMENT_NUMBER VARCHAR2(40),
9 CONTACT_EMAIL_ADDRESS VARCHAR2(2000),
10 CONTACT_PHONE VARCHAR2(40),
11 TRANSACTION_SOURCE VARCHAR2(40),
12 TRANSACTION_CREATION_DATE DATE,
13 EFFECTIVE_START_DATE DATE,
14 DAYS_COVERED NUMBER,
15 TRANSACTION_STATUS VARCHAR2(20),
16 ORG_ID NUMBER,
17 ORIG_SYS_DOCUMENT_REF VARCHAR2(40),
18 CREATION_DATE DATE,
19 CREATED_BY NUMBER,
20 LAST_UPDATE_DATE DATE,
21 LAST_UPDATED_BY NUMBER,
22 LAST_UPDATE_LOGIN NUMBER,
23 ATTRIBUTE_CATEGORY VARCHAR2(30),
24 ATTRIBUTE1 VARCHAR2(150),
25 ATTRIBUTE2 VARCHAR2(150),
26 ATTRIBUTE3 VARCHAR2(150),
27 ATTRIBUTE4 VARCHAR2(150),
28 ATTRIBUTE5 VARCHAR2(150),
29 ATTRIBUTE6 VARCHAR2(150),
30 ATTRIBUTE7 VARCHAR2(150),
31 ATTRIBUTE8 VARCHAR2(150),
32 ATTRIBUTE9 VARCHAR2(150),
33 ATTRIBUTE10 VARCHAR2(150),
34 ATTRIBUTE11 VARCHAR2(150),
35 ATTRIBUTE12 VARCHAR2(150),
36 ATTRIBUTE13 VARCHAR2(150),
37 ATTRIBUTE14 VARCHAR2(150),
38 ATTRIBUTE15 VARCHAR2(150),
39 ATTRIBUTE16 VARCHAR2(150),
40 ATTRIBUTE17 VARCHAR2(150),
41 ATTRIBUTE18 VARCHAR2(150),
42 ATTRIBUTE19 VARCHAR2(150),
43 ATTRIBUTE20 VARCHAR2(150),
44 ATTRIBUTE21 VARCHAR2(150),
45 ATTRIBUTE22 VARCHAR2(150),
46 ATTRIBUTE23 VARCHAR2(150),
47 ATTRIBUTE24 VARCHAR2(150),
48 ATTRIBUTE25 VARCHAR2(150),
49 ATTRIBUTE26 VARCHAR2(150),
50 ATTRIBUTE27 VARCHAR2(150),
51 ATTRIBUTE28 VARCHAR2(150),
52 ATTRIBUTE29 VARCHAR2(150),
53 ATTRIBUTE30 VARCHAR2(150),
54 VENDOR_ID VARCHAR2(150),
55 VENDOR_CONTACT_ID VARCHAR2(150),
56 VENDOR_SITE_ID VARCHAR2(150),
57 LAST_REFRESHED_BY NUMBER,
58 LAST_REFRESHED_DATE DATE,
59 TRX_CURRENCY VARCHAR2(3),
60 VENDOR_CONTACT_NAME VARCHAR2(50)
61 );
62
63 TYPE dpp_txn_line_rec_type IS RECORD
64 (
65 LOG_MODE VARCHAR2(1),
66 TRANSACTION_HEADER_ID NUMBER,
67 TRANSACTION_LINE_ID NUMBER,
68 SUPPLIER_PART_NUM VARCHAR2(240),
69 LINE_NUMBER NUMBER,
70 PRIOR_PRICE NUMBER,
71 CHANGE_TYPE VARCHAR2(30),
72 CHANGE_VALUE NUMBER,
73 PRICE_CHANGE NUMBER,
74 COVERED_INVENTORY NUMBER,
75 APPROVED_INVENTORY NUMBER,
76 ORG_ID NUMBER,
77 CREATION_DATE DATE,
78 CREATED_BY NUMBER,
79 LAST_UPDATE_DATE DATE,
80 LAST_UPDATED_BY NUMBER,
81 LAST_UPDATE_LOGIN NUMBER,
82 ATTRIBUTE_CATEGORY VARCHAR2(30),
83 ATTRIBUTE1 VARCHAR2(150),
84 ATTRIBUTE2 VARCHAR2(150),
85 ATTRIBUTE3 VARCHAR2(150),
86 ATTRIBUTE4 VARCHAR2(150),
87 ATTRIBUTE5 VARCHAR2(150),
88 ATTRIBUTE6 VARCHAR2(150),
89 ATTRIBUTE7 VARCHAR2(150),
90 ATTRIBUTE8 VARCHAR2(150),
91 ATTRIBUTE9 VARCHAR2(150),
92 ATTRIBUTE10 VARCHAR2(150),
93 ATTRIBUTE11 VARCHAR2(150),
94 ATTRIBUTE12 VARCHAR2(150),
95 ATTRIBUTE13 VARCHAR2(150),
96 ATTRIBUTE14 VARCHAR2(150),
97 ATTRIBUTE15 VARCHAR2(150),
98 ATTRIBUTE16 VARCHAR2(150),
99 ATTRIBUTE17 VARCHAR2(150),
100 ATTRIBUTE18 VARCHAR2(150),
101 ATTRIBUTE19 VARCHAR2(150),
102 ATTRIBUTE20 VARCHAR2(150),
103 ATTRIBUTE21 VARCHAR2(150),
104 ATTRIBUTE22 VARCHAR2(150),
105 ATTRIBUTE23 VARCHAR2(150),
106 ATTRIBUTE24 VARCHAR2(150),
107 ATTRIBUTE25 VARCHAR2(150),
108 ATTRIBUTE26 VARCHAR2(150),
109 ATTRIBUTE27 VARCHAR2(150),
110 ATTRIBUTE28 VARCHAR2(150),
111 ATTRIBUTE29 VARCHAR2(150),
112 ATTRIBUTE30 VARCHAR2(150),
113 INVENTORY_ITEM_ID VARCHAR2(150),
114 SUPPLIER_NEW_PRICE NUMBER,
115 LAST_CALCULATED_BY NUMBER,
116 LAST_CALCULATED_DATE DATE,
117 CLAIM_AMOUNT NUMBER,
118 SUPP_DIST_CLAIM_ID VARCHAR2(150),
119 UPDATE_PURCHASING_DOCS VARCHAR2(1),
120 NOTIFY_PURCHASING_DOCS VARCHAR2(1),
121 UPDATE_INVENTORY_COSTING VARCHAR2(1),
122 UPDATE_ITEM_LIST_PRICE VARCHAR2(1),
123 SUPP_DIST_CLAIM_STATUS VARCHAR2(1),
124 ONHAND_INVENTORY NUMBER,
125 MANUALLY_ADJUSTED VARCHAR2(1),
126 NOTIFY_INBOUND_PRICELIST VARCHAR2(1),
127 NOTIFY_OUTBOUND_PRICELIST VARCHAR2(1),
128 NOTIFY_PROMOTIONS_PRICELIST VARCHAR2(1),
129 SUPPLIER_APPROVED_BY VARCHAR2(100),
130 SUPPLIER_APPROVAL_DATE DATE,
131 CREATE_ON_HAND_CLAIM VARCHAR2(1),
132 CREATE_VEND_CUST_CLAIM VARCHAR2(1)
133 );
134 G_dpp_txn_line_rec dpp_txn_line_rec_type;
135 TYPE dpp_txn_line_tbl_type IS TABLE OF dpp_txn_line_rec_type INDEX BY BINARY_INTEGER;
136
137 TYPE dpp_claim_line_rec_type IS RECORD
138 (
139 LOG_MODE VARCHAR2(1),
140 TRANSACTION_HEADER_ID NUMBER,
141 CUSTOMER_INV_LINE_ID NUMBER,
142 LINE_NUMBER NUMBER,
143 LAST_PRICE NUMBER,
144 SUPPLIER_NEW_PRICE NUMBER,
145 CUSTOMER_NEW_PRICE NUMBER,
146 REPORTED_INVENTORY NUMBER,
147 CALCULATED_INVENTORY NUMBER,
148 CUST_CLAIM_AMT NUMBER,
149 DEBIT_MEMO_NUMBER VARCHAR2(30),
150 CUSTOMER_CLAIM_ID NUMBER,
151 CUSTOMER_CLAIM_CREATED VARCHAR2(1),
152 SUPPLIER_CLAIM_CREATED VARCHAR2(1),
153 CREATION_DATE DATE,
154 CREATED_BY NUMBER,
155 LAST_UPDATE_DATE DATE,
156 LAST_UPDATED_BY NUMBER,
157 LAST_UPDATE_LOGIN NUMBER(15),
158 ATTRIBUTE_CATEGORY VARCHAR2(30),
159 ATTRIBUTE1 VARCHAR2(150),
160 ATTRIBUTE2 VARCHAR2(150),
161 ATTRIBUTE3 VARCHAR2(150),
162 ATTRIBUTE4 VARCHAR2(150),
163 ATTRIBUTE5 VARCHAR2(150),
164 ATTRIBUTE6 VARCHAR2(150),
165 ATTRIBUTE7 VARCHAR2(150),
166 ATTRIBUTE8 VARCHAR2(150),
167 ATTRIBUTE9 VARCHAR2(150),
168 ATTRIBUTE10 VARCHAR2(150),
169 ATTRIBUTE11 VARCHAR2(150),
170 ATTRIBUTE12 VARCHAR2(150),
171 ATTRIBUTE13 VARCHAR2(150),
172 ATTRIBUTE14 VARCHAR2(150),
173 ATTRIBUTE15 VARCHAR2(150),
174 ATTRIBUTE16 VARCHAR2(150),
175 ATTRIBUTE17 VARCHAR2(150),
176 ATTRIBUTE18 VARCHAR2(150),
177 ATTRIBUTE19 VARCHAR2(150),
178 ATTRIBUTE20 VARCHAR2(150),
179 ATTRIBUTE21 VARCHAR2(150),
180 ATTRIBUTE22 VARCHAR2(150),
181 ATTRIBUTE23 VARCHAR2(150),
182 ATTRIBUTE24 VARCHAR2(150),
183 ATTRIBUTE25 VARCHAR2(150),
184 ATTRIBUTE26 VARCHAR2(150),
185 ATTRIBUTE27 VARCHAR2(150),
186 ATTRIBUTE28 VARCHAR2(150),
187 ATTRIBUTE29 VARCHAR2(150),
188 ATTRIBUTE30 VARCHAR2(150),
189 INVENTORY_ITEM_ID VARCHAR2(150),
190 SUPP_CLAIM_AMT NUMBER,
191 SUPP_CUST_CLAIM_ID NUMBER,
192 CUST_ACCOUNT_ID VARCHAR2(150),
193 ORG_ID VARCHAR2(150),
194 TRX_CURRENCY VARCHAR2(15)
195 );
196 G_dpp_claim_line_rec dpp_claim_line_rec_type;
197 TYPE dpp_claim_line_tbl_type IS TABLE OF dpp_claim_line_rec_type INDEX BY BINARY_INTEGER;
198 -- ==============================================================================
199 -- Start of Comments
200 -- ==============================================================================
201 -- API Name : Insert_HeaderLog
202 -- Type : Private
203 -- Pre-Req : None
204 -- Function : Inserts records into Headers Log Table
205 -- Parameters
206 --
207 -- IN
208 -- p_api_version_number IN NUMBER Required
209 -- p_init_msg_list IN VARCHAR2 Optional Default = FND_API_G_FALSE
210 -- p_commit IN VARCHAR2 Optional Default = FND_API.G_FALSE
211 -- p_validation_level IN NUMBER Optional Default = FND_API.G_VALID_LEVEL_NONE
212 -- p_txn_hdr_rec IN OUT dpp_pl_notify_rec_type Required
213 --
214 -- OUT
215 -- x_return_status OUT VARCHAR2
216 -- x_msg_count OUT NUMBER
217 -- x_msg_data OUT VARCHAR2
218 -- Version : Current version 1.0
219 --
220 -- End of Comments
221 -- ==============================================================================
222 PROCEDURE Insert_HeaderLog(
226 ,p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL
223 p_api_version IN NUMBER
224 ,p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE
225 ,p_commit IN VARCHAR2 := FND_API.G_FALSE
227 ,x_return_status OUT NOCOPY VARCHAR2
228 ,x_msg_count OUT NOCOPY NUMBER
229 ,x_msg_data OUT NOCOPY VARCHAR2
230 ,p_txn_hdr_rec IN dpp_cst_hdr_rec_type
231 );
232
233 PROCEDURE Insert_LinesLog(
234 p_api_version IN NUMBER
235 ,p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE
236 ,p_commit IN VARCHAR2 := FND_API.G_FALSE
237 ,p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL
238 ,x_return_status OUT NOCOPY VARCHAR2
239 ,x_msg_count OUT NOCOPY NUMBER
240 ,x_msg_data OUT NOCOPY VARCHAR2
241 ,p_txn_lines_tbl IN dpp_txn_line_tbl_type
242 );
243
244 PROCEDURE Insert_ClaimsLog(
245 p_api_version IN NUMBER
246 ,p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE
247 ,p_commit IN VARCHAR2 := FND_API.G_FALSE
248 ,p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL
249 ,x_return_status OUT NOCOPY VARCHAR2
250 ,x_msg_count OUT NOCOPY NUMBER
251 ,x_msg_data OUT NOCOPY VARCHAR2
252 ,p_claim_lines_tbl IN dpp_claim_line_tbl_type
253 );
254
255 END DPP_LOG_PVT;