1 package ARRX_SALES_TAX_REP AUTHID CURRENT_USER as
2 /* $Header: ARRXSTS.pls 115.1 2002/11/15 03:13:19 anukumar ship $ */
3 -- Intended as a private function
4
5 PROCEDURE INSERT_SALES_TAX_REPORT (
6 chart_of_accounts_id in number,
7 trx_date_low in date,
8 trx_date_high in date,
9 gl_date_low in date,
10 gl_date_high in date,
11 state_low in varchar2,
12 state_high in varchar2,
13 currency_low in varchar2,
14 currency_high in varchar2,
15 exemption_status in varchar2,
16 lp_gltax_where in varchar2,
17 where_gl_flex in varchar2,
18 show_deposit_children in varchar2,
19 detail_level in varchar2,
20 posted_status in varchar2,
21 show_cms_adjs_outside_date in varchar2,
22 request_id in number,
23 user_id in number,
24 mesg out NOCOPY varchar2,
25 success out NOCOPY boolean);
26
27 PROCEDURE FETCH_TRX_ABS_TOTALS (
28 fc_cust_trx_id in number,
29 fc_type_flag in varchar2,
30 fc_inv_line_amount_abs out NOCOPY number,
31 fc_inv_freight_amount_abs out NOCOPY number,
32 fc_inv_tax_amount_abs out NOCOPY number,
33 fc_inv_line_lines_count out NOCOPY number,
34 fc_inv_tax_lines_count out NOCOPY number,
35 fc_inv_freight_lines_count out NOCOPY number);
36
37 FUNCTION LINE_AMOUNT_CALC (
38 c_type_flag IN VARCHAR2,
39 c_line_amount IN NUMBER,
40 c_inv_line_lines_count IN NUMBER,
41 c_inv_line_amount_abs IN NUMBER,
42 c_adj_line_amount IN NUMBER)
43 RETURN NUMBER;
44
45 PROCEDURE WRITE_LOG(
46 fc_which IN NUMBER,
47 fc_text IN VARCHAR2,
48 fc_buffer OUT NOCOPY VARCHAR2);
49
50
51 FUNCTION GET_ITEM_DESCRIPTION(
52 fc_organization_id IN NUMBER,
53 fc_inventory_item_id IN NUMBER)
54 RETURN VARCHAR2;
55
56 FUNCTION GET_ITEM(
57 fc_organization_id IN NUMBER,
58 fc_inventory_item_id IN NUMBER)
59 RETURN VARCHAR2;
60
61 PROCEDURE SUM_ITEM_LINE_AMOUNT(
62 fc_cust_trx_id IN NUMBER,
63 fc_type_flag IN VARCHAR2,
64 fc_adj_line_amount IN NUMBER,
65 fc_adj_tax_amount IN NUMBER,
66 fc_exemption_status IN VARCHAR2,
67 fc_line_total OUT NOCOPY NUMBER,
68 fc_tax_total OUT NOCOPY NUMBER);
69
70 FUNCTION EXEMPTION_AMOUNT_CALC_LINE(
71 fc_precision IN NUMBER,
72 fc_mau IN NUMBER,
73 fc_exempt_percent IN NUMBER,
74 fc_line_amount IN NUMBER,
75 fc_cnt_tax_lines IN NUMBER)
76 RETURN NUMBER;
77
78 FUNCTION TAXABLE_AMOUNT_CALC_LINE(
79 fc_precision IN NUMBER,
80 fc_mau IN NUMBER,
81 fc_exemption_amount IN NUMBER,
82 fc_line_amount IN NUMBER,
83 fc_cnt_tax_lines IN NUMBER)
84 RETURN NUMBER;
85
86 FUNCTION TAX_AMOUNT_CALC (
87 c_type_flag IN VARCHAR2,
88 c_tax_amount IN NUMBER,
89 c_inv_tax_lines_count IN NUMBER,
90 c_inv_tax_amount_abs IN NUMBER,
91 c_adj_line_amount IN NUMBER,
92 c_inv_line_lines_count IN NUMBER,
93 c_adj_tax_amount IN NUMBER)
94 RETURN NUMBER;
95
96 FUNCTION GLTAX_IN_BALANCE (
97 c_trx_id IN NUMBER,
98 c_detail_level IN VARCHAR2)
99 RETURN VARCHAR2;
100
101 FUNCTION TRX_COMMENT_FLAG (
102 fc_type_flag IN VARCHAR2,
103 fc_trx_id IN NUMBER,
104 fc_detail_level IN VARCHAR2,
105 fc_sum_tax_line_amount IN NUMBER,
106 fc_adj_line_amount IN NUMBER,
107 fc_adj_freight_amount IN NUMBER,
108 fc_adj_type IN VARCHAR2,
109 fc_gl_flex IN VARCHAR2 )
110 RETURN VARCHAR2;
111
112 FUNCTION GET_CONVERSION_RATE_TYPE
113 (c_exchange_rate_type IN VARCHAR2)
114 RETURN VARCHAR2;
115
116 PROCEDURE GET_CUSTOMER_INFORMATION(
117 fc_customer_id_in IN NUMBER,
118 fc_site_use_id IN NUMBER,
119 fc_customer_trx_id IN NUMBER,
120 fc_customer_name OUT NOCOPY VARCHAR2,
121 fc_customer_number OUT NOCOPY VARCHAR2,
122 fc_customer_type OUT NOCOPY VARCHAR2,
123 fc_address1 OUT NOCOPY VARCHAR2,
124 fc_address2 OUT NOCOPY VARCHAR2,
125 fc_address3 OUT NOCOPY VARCHAR2,
126 fc_address4 OUT NOCOPY VARCHAR2,
127 fc_city OUT NOCOPY VARCHAR2,
128 fc_zip_code OUT NOCOPY VARCHAR2,
129 fc_state OUT NOCOPY VARCHAR2,
130 fc_province OUT NOCOPY VARCHAR2,
131 fc_county OUT NOCOPY VARCHAR2);
132
133 FUNCTION GET_MIN_TAX_LINE_ID(
134 fc_trx_line_id IN NUMBER)
135 RETURN NUMBER;
136
137 FUNCTION AOL_ROUND(
138 fc_n IN NUMBER,
139 fc_precision IN NUMBER,
140 fc_mac IN NUMBER)
141 RETURN NUMBER;
142
143 FUNCTION CNT_TAX_LINES_FOR_INV_LINE(
144 fc_trx_line_id IN NUMBER)
145 RETURN NUMBER;
146
147 FUNCTION CNT_INV_LINES_FOR_INV_HEADER(
148 f_trx_id IN NUMBER)
149 RETURN NUMBER;
150
151 FUNCTION GET_CUSTOMER_TRX_LINE_ID(
152 fn_trx_id IN NUMBER,
153 fn_cnt_lines IN NUMBER)
154 RETURN NUMBER;
155
156 PROCEDURE GET_PRECISION_AND_MAU(
157 fc_currency IN VARCHAR2,
158 fc_precision OUT NOCOPY NUMBER,
159 fc_mau OUT NOCOPY NUMBER);
160
161 FUNCTION GET_EXEMPTION_AMT(
162 fg_trx_id IN NUMBER,
163 fg_precision IN NUMBER,
164 fg_mau IN NUMBER,
165 fg_type_flag IN VARCHAR2)
166 RETURN NUMBER;
167
168 -- These are the procedures to be called by concurrent request wrappers.
169
170 PROCEDURE SALES_TAX_RPT (
171 chart_of_accounts_id in number,
172 trx_date_low in date,
173 trx_date_high in date,
174 gl_date_low in date,
175 gl_date_high in date,
176 state_low in varchar2,
177 state_high in varchar2,
178 currency_low in varchar2,
179 currency_high in varchar2,
180 exemption_status in varchar2,
181 lp_gltax_where in varchar2,
182 where_gl_flex in varchar2,
183 show_deposit_children in varchar2,
184 detail_level in varchar2,
185 posted_status in varchar2,
186 show_cms_adjs_outside_date in varchar2,
187 request_id in number,
188 user_id in number,
189 retcode out NOCOPY number,
190 errbuf out NOCOPY varchar2);
191
192 end ARRX_SALES_TAX_REP;