[Home] [Help]
PACKAGE: APPS.CN_ADJ_DISP_PUB
Source
1 PACKAGE cn_adj_disp_pub AS
2 -- $Header: cnpadjs.pls 120.0 2005/09/16 02:29:35 chanthon noship $
3
4 TYPE adj_rec_type IS RECORD
5 (
6 invoice_number VARCHAR2(20),
7 invoice_date DATE,
8 order_number NUMBER,
9 order_date DATE,
10 creation_date DATE,
11 processed_date DATE,
12 trx_type_disp VARCHAR2(80),
13 adjust_status_disp VARCHAR2(80),
14 adjusted_by VARCHAR2(100),
15 adjust_date DATE,
16 calc_status_disp VARCHAR2(80),
17 currency_code VARCHAR2(3),
18 sales_credit NUMBER,
19 commission NUMBER,
20 attribute1 VARCHAR2(240),
21 attribute2 VARCHAR2(240),
22 attribute3 VARCHAR2(240),
23 attribute4 VARCHAR2(240),
24 attribute5 VARCHAR2(240),
25 attribute6 VARCHAR2(240),
26 attribute7 VARCHAR2(240),
27 attribute8 VARCHAR2(240),
28 attribute9 VARCHAR2(240),
29 attribute10 VARCHAR2(240),
30 attribute11 VARCHAR2(240),
31 attribute12 VARCHAR2(240),
32 attribute13 VARCHAR2(240),
33 attribute14 VARCHAR2(240),
34 attribute15 VARCHAR2(240),
35 attribute16 VARCHAR2(240),
36 attribute17 VARCHAR2(240),
37 attribute18 VARCHAR2(240),
38 attribute19 VARCHAR2(240),
39 attribute20 VARCHAR2(240),
40 attribute21 VARCHAR2(240),
41 attribute22 VARCHAR2(240),
42 attribute23 VARCHAR2(240),
43 attribute24 VARCHAR2(240),
44 attribute25 VARCHAR2(240),
45 attribute26 VARCHAR2(240),
46 attribute27 VARCHAR2(240),
47 attribute28 VARCHAR2(240),
48 attribute29 VARCHAR2(240),
49 attribute30 VARCHAR2(240),
50 attribute31 VARCHAR2(240),
51 attribute32 VARCHAR2(240),
52 attribute33 VARCHAR2(240),
53 attribute34 VARCHAR2(240),
54 attribute35 VARCHAR2(240),
55 attribute36 VARCHAR2(240),
56 attribute37 VARCHAR2(240),
57 attribute38 VARCHAR2(240),
58 attribute39 VARCHAR2(240),
59 attribute40 VARCHAR2(240),
60 attribute41 VARCHAR2(240),
61 attribute42 VARCHAR2(240),
62 attribute43 VARCHAR2(240),
63 attribute44 VARCHAR2(240),
64 attribute45 VARCHAR2(240),
65 attribute46 VARCHAR2(240),
66 attribute47 VARCHAR2(240),
67 attribute48 VARCHAR2(240),
68 attribute49 VARCHAR2(240),
69 attribute50 VARCHAR2(240),
70 attribute51 VARCHAR2(240),
71 attribute52 VARCHAR2(240),
72 attribute53 VARCHAR2(240),
73 attribute54 VARCHAR2(240),
74 attribute55 VARCHAR2(240),
75 attribute56 VARCHAR2(240),
76 attribute57 VARCHAR2(240),
77 attribute58 VARCHAR2(240),
78 attribute59 VARCHAR2(240),
79 attribute60 VARCHAR2(240),
80 attribute61 VARCHAR2(240),
81 attribute62 VARCHAR2(240),
82 attribute63 VARCHAR2(240),
83 attribute64 VARCHAR2(240),
84 attribute65 VARCHAR2(240),
85 attribute66 VARCHAR2(240),
86 attribute67 VARCHAR2(240),
87 attribute68 VARCHAR2(240),
88 attribute69 VARCHAR2(240),
89 attribute70 VARCHAR2(240),
90 attribute71 VARCHAR2(240),
91 attribute72 VARCHAR2(240),
92 attribute73 VARCHAR2(240),
93 attribute74 VARCHAR2(240),
94 attribute75 VARCHAR2(240),
95 attribute76 VARCHAR2(240),
96 attribute77 VARCHAR2(240),
97 attribute78 VARCHAR2(240),
98 attribute79 VARCHAR2(240),
99 attribute80 VARCHAR2(240),
100 attribute81 VARCHAR2(240),
101 attribute82 VARCHAR2(240),
102 attribute83 VARCHAR2(240),
103 attribute84 VARCHAR2(240),
104 attribute85 VARCHAR2(240),
105 attribute86 VARCHAR2(240),
106 attribute87 VARCHAR2(240),
107 attribute88 VARCHAR2(240),
108 attribute89 VARCHAR2(240),
109 attribute90 VARCHAR2(240),
110 attribute91 VARCHAR2(240),
111 attribute92 VARCHAR2(240),
112 attribute93 VARCHAR2(240),
113 attribute94 VARCHAR2(240),
114 attribute95 VARCHAR2(240),
115 attribute96 VARCHAR2(240),
116 attribute97 VARCHAR2(240),
117 attribute98 VARCHAR2(240),
118 attribute99 VARCHAR2(240),
119 attribute100 VARCHAR2(240),
120 customer_id NUMBER(15),
121 customer_name VARCHAR2(50),
122 customer_number VARCHAR2(30),
123 bill_to_address_id NUMBER,
124 ship_to_address_id NUMBER,
125 bill_to_contact_id NUMBER,
126 ship_to_contact_id NUMBER,
127 rollup_date DATE,
128 comments VARCHAR2(1800),
129 reason_code VARCHAR2(30),
130 reason VARCHAR2(80),
131 quota_id NUMBER(15),
132 quota_name VARCHAR2(80),
133 revenue_class_id NUMBER(15),
134 revenue_class_name VARCHAR2(30)
135 );
136
137 TYPE adj_tbl_type IS TABLE OF adj_rec_type
138 INDEX BY BINARY_INTEGER;
139
140
141 -- API name : Get_adj
142 -- Type : Public.
143 -- Pre-reqs :
144 -- Usage :
145 --
146 -- Desc : Get the transaction details
147 -- Parameters :
148 -- IN : p_salesrep_id Id of salesrep. Should not be null : NUMBER
149 -- IN : p_pr_date_from Processed date from. : DATE
150 -- IN : p_pr_date_to Processed date to. : DATE
151 -- IN : p_invoice_num Invoice number : VARCHAR2
152 -- IN : p_order_num Order number : NUMBER
153 -- IN : p_calc_status Calculation Status : VARCHAR2
154 -- IN : p_adjust_status Adjustment Status : VARCHAR2
155 -- IN : p_adjust_date Adjustment Date : DATE
156 -- IN : p_trx_type Transaction Type : VARCHAR2
157 -- IN : p_date_pattern Default date, Cant seem to pass an aribtrary
158 -- number as a date from the front end. This date
159 -- pattern is taken as the null(all) date.
160 -- Pass a dummy date like 11/11/1111 and hope no one
161 -- made etransactions on that date :) : DATE
162 -- IN : p_start_record For page scrolling, the first record : NUMBER
163 -- IN : p_increment_count The number of records per page : NUMBER
164
165 -- IN : p_curr_code Currency code to convert to
166 -- OUT : x_adj_tbl The output table : adj_tbl_type
167 -- OUT : x_adj_count Total records in the query : NUMBER
168 -- OUT : x_total_transaction_amount : NUMBER
169 -- OUT : x_total_commission_amount : NUMBER
170 -- OUT : x_conv_status Currency conversion status
171 -- Version : Current version 1.0
172 -- Initial version 1.0
173 -- Notes : This API is used to get the transaction detail information. The data come
174 -- from CN_COMMISSION_LINES and CN_COMMISSION_HEADERS. This API will not
175 -- get the transaction information from CN_COMM_LINES_API.
176 -- End of comments
177
178 PROCEDURE get_adj
179 (
180 p_api_version IN NUMBER,
181 p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
182 p_validation_level IN VARCHAR2 := FND_API.G_VALID_LEVEL_FULL,
183 x_return_status OUT NOCOPY VARCHAR2,
184 x_msg_count OUT NOCOPY NUMBER,
185 x_msg_data OUT NOCOPY VARCHAR2,
186 x_loading_status OUT NOCOPY VARCHAR2,
187 p_salesrep_id IN NUMBER ,
188 p_pr_date_from IN DATE ,
189 p_pr_date_to IN DATE ,
190 p_invoice_num IN VARCHAR2,
191 p_order_num IN NUMBER,
192 p_calc_status IN VARCHAR2,
193 p_adjust_status IN VARCHAR2,
194 p_adjust_date IN DATE,
195 p_trx_type IN VARCHAR2,
196 p_date_pattern IN DATE,
197 p_start_record IN NUMBER := 1,
198 p_increment_count IN NUMBER,
199 p_curr_code IN VARCHAR2,
200 x_adj_tbl OUT NOCOPY adj_tbl_type,
201 x_adj_count OUT NOCOPY NUMBER,
202 x_total_sales_credit OUT NOCOPY NUMBER,
203 x_total_commission OUT NOCOPY NUMBER,
204 x_conv_status OUT NOCOPY VARCHAR2
205 );
206
207 END cn_adj_disp_pub ;
208