[Home] [Help]
PACKAGE: APPS.ARRX_TX
Source
1 PACKAGE ARRX_TX as
2 /* $Header: ARRXTXS.pls 120.6 2005/12/15 07:19:22 srivasud ship $ */
3
4 procedure artx_rep (
5 completed_flag in varchar2,
6 posted_flag in varchar2,
7 start_gl_date in date,
8 end_gl_date in date,
9 start_transaction_date in date,
10 end_transaction_date in date,
11 start_transaction_type in varchar2,
12 end_transaction_type in varchar2,
13 start_transaction_class in varchar2,
14 end_transaction_class in varchar2,
15 start_balancing_segment in varchar2,
16 end_balancing_segment in varchar2,
17 start_bill_to_customer_name in varchar2,
18 end_bill_to_customer_name in varchar2,
19 start_currency in varchar2,
20 end_currency in varchar2,
21 payment_method in varchar2,
22 doc_sequence_name in varchar2,
23 doc_sequence_number_from in number,
24 doc_sequence_number_to in number,
25 start_bill_to_customer_number in varchar2,
26 end_bill_to_customer_number in varchar2,
27 reporting_level IN VARCHAR2,
28 reporting_entity_id IN NUMBER,
29 start_account in varchar2,
30 end_account in varchar2,
31 batch_source_name in VARCHAR2,
32 transaction_class in varchar2,
33 request_id in number,
34 retcode out NOCOPY number,
35 errbuf out NOCOPY varchar2);
36
37 procedure before_report;
38 procedure bind(c in integer);
39 procedure after_fetch;
40
41 procedure artx_rep_check (
42 completed_flag in varchar2,
43 posted_flag in varchar2,
44 start_gl_date in date,
45 end_gl_date in date,
46 start_transaction_date in date,
47 end_transaction_date in date,
48 start_transaction_type in varchar2,
49 end_transaction_type in varchar2,
50 start_transaction_class in varchar2,
51 end_transaction_class in varchar2,
52 start_balancing_segment in varchar2,
53 end_balancing_segment in varchar2,
54 start_bill_to_customer_name in varchar2,
55 end_bill_to_customer_name in varchar2,
56 start_currency in varchar2,
57 end_currency in varchar2,
58 payment_method in varchar2,
59 start_update_date in date,
60 end_update_date in date,
61 last_updated_by in number,
62 request_id in number,
63 retcode out NOCOPY number,
64 errbuf out NOCOPY varchar2);
65
66 procedure check_before_report;
67 procedure check_bind(c in integer);
68 procedure check_after_fetch;
69
70 procedure artx_rep_forecast(
71 completed_flag in varchar2,
72 posted_flag in varchar2,
73 start_gl_date in date,
74 end_gl_date in date,
75 start_transaction_date in date,
76 end_transaction_date in date,
77 start_transaction_type in varchar2,
78 end_transaction_type in varchar2,
79 start_transaction_class in varchar2,
80 end_transaction_class in varchar2,
81 start_balancing_segment in varchar2,
82 end_balancing_segment in varchar2,
83 start_bill_to_customer_name in varchar2,
84 end_bill_to_customer_name in varchar2,
85 start_currency in varchar2,
86 end_currency in varchar2,
87 payment_method in varchar2,
88 start_due_date in date,
89 end_due_date in date,
90 request_id in number,
91 retcode out NOCOPY number,
92 errbuf out NOCOPY varchar2);
93
94 procedure forecast_before_report;
95 procedure forecast_bind(c in integer);
96
97 procedure artx_sales_rep (
98 completed_flag in varchar2,
99 posted_flag in varchar2,
100 transaction_type in varchar2,
101 line_invoice in varchar2,
102 start_invoice_num in varchar2,
103 end_invoice_num in varchar2,
104 doc_sequence_name in varchar2,
105 start_doc_sequence_value in number,
106 end_doc_sequence_value in number,
107 start_gl_date in date,
108 end_gl_date in date,
109 start_company_segment in varchar2,
110 end_company_segment in varchar2,
111 start_rec_nat_acct in varchar2,
112 end_rec_nat_acct in varchar2,
113 start_account in varchar2,
114 end_account in varchar2,
115 start_currency in varchar2,
116 end_currency in varchar2,
117 start_amount in number,
118 end_amount in number,
119 start_customer_name in varchar2,
120 end_customer_name in varchar2,
121 start_customer_number in varchar2,
122 end_customer_number in varchar2,
123 request_id in number,
124 retcode out NOCOPY number,
125 errbuf out NOCOPY varchar2);
126
127 procedure sales_before_report;
128 procedure sales_bind(c in integer);
129 procedure sales_after_fetch;
130
131
132 function GET_CONS_BILL_NUMBER(P_CUSTOMER_TRX_ID in number) RETURN VARCHAR2;
133 function LAST_UPDATED_BY(P_CUSTOMER_TRX_ID in number) return number;
134 function LAST_UPDATE_DATE(P_CUSTOMER_TRX_ID in number) return date;
135 function WHERE_LAST_UPDATE(P_CUSTOMER_TRX_ID in number, P_LAST_UPDATED_BY in number, P_START_UPDATE_DATE in date, P_END_UPDATE_DATE in date) return varchar2;
136
137 type var_t is record (
138 request_id number,
139 organization_name varchar2(30),
140 functional_currency_code varchar2(15),
141 customer_trx_id number,
142 trx_number varchar2(20),
143 cons_bill_number varchar2(30),
144 rec_cust_trx_line_gl_dist_id number,
145 rec_account varchar2(2000), /*4653230*/
146 rec_account_desc varchar2(240),
147 rec_balance varchar2(2000), /*4653230*/
148 rec_balance_desc varchar2(240),
149 rec_natacct varchar2(2000), /*4653230*/
150 rec_natacct_desc varchar2(240),
151 rec_postable_flag varchar2(10),
152 trx_last_updated_by number,
153 trx_last_update_date date,
154 customer_trx_line_id number,
155 link_to_cust_trx_line_id number,
156 inventory_item varchar2(240),
157 cust_trx_line_gl_dist_id number,
158 account varchar2(240),
159 account_desc varchar2(240),
160 balance varchar2(240),
161 balance_desc varchar2(240),
162 natacct varchar2(240),
163 natacct_desc varchar2(240),
164 trx_payment_schedule_id number,
165 completed_flag varchar2(1),
166 posted_flag varchar2(1),
167 start_gl_date date,
168 end_gl_date date,
169 start_transaction_date date,
170 end_transaction_date date,
171 start_transaction_type varchar2(20),
172 end_transaction_type varchar2(20),
173 start_transaction_class varchar2(20),
174 end_transaction_class varchar2(20),
175 start_balancing_segment varchar2(25),
176 end_balancing_segment varchar2(25),
177 start_bill_to_customer_name varchar2(50),
178 end_bill_to_customer_name varchar2(50),
179 start_currency varchar2(15),
180 end_currency varchar2(15),
181 payment_method varchar2(30),
182 doc_sequence_name varchar2(30),
183 doc_sequence_number_from number,
184 doc_sequence_number_to number,
185 start_update_date date,
186 end_update_date date,
187 last_updated_by number,
188 start_due_date date,
189 end_due_date date,
190 ccid number,
191 ccid2 number,
192 books_id number,
193 chart_of_accounts_id number,
194 bill_flag varchar2(1),
195 so_id_flex_code varchar2(240),
196 so_organization_id number,
197 ctid number := -1,
198 user_id number,
199 update_date date,
200 item_description varchar2(240),
201 line_invoice varchar2(7),
202 start_invoice_num varchar2(20),
203 end_invoice_num varchar2(20),
204 start_rec_nat_acct varchar2(240),
205 end_rec_nat_acct varchar2(240),
206 start_account varchar2(2000), /*4653230*/
207 end_account varchar2(2000), /*4653230*/
208 start_amount number,
209 end_amount number,
210 start_bill_to_customer_number varchar2(30),
211 end_bill_to_customer_number varchar2(30),
212 trx_date date,
213 trx_currency varchar2(15),
214 exchange_rate number,
215 exchange_date date,
216 exchange_type varchar2(30),
217 receivables_gl_date date,
218 trx_due_date date,
219 tax_header_level_flag varchar2(1),
220 doc_sequence_value number,
221 trx_amount number,
222 trx_acctd_amount number,
223 ship_to_customer_id number(15),
224 ship_to_site_use_id number(15),
225 bill_to_customer_id number(15),
226 bill_to_site_use_id number(15),
227 cust_trx_type_id number(15),
228 term_id number(15),
229 doc_sequence_id number(15),
230 receipt_method_id number(15),
231 org_id number(15),
232 ca_sob_type varchar2(1),
233 ca_sob_id number,
234 batch_id number,
235 batch_source_id number,
236 batch_source_name Varchar2(50),
237 reporting_level varchar2(50),
238 reporting_entity_id number,
239 transaction_class varchar2(50)
240 );
241 var var_t;
242
243 END ARRX_TX;