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