PACKAGE: APPS.ARRX_ADJ

Source

1 PACKAGE ARRX_ADJ as
2 /* $Header: ARRXADJS.pls 120.6 2005/12/14 04:39:58 salladi ship $  */
3 
4 procedure aradj_rep (
5    request_id                 in   number,
6    p_reporting_level          in   number,
7    p_reporting_entity         in   number,
8    p_sob_id                   in   number,
9    p_coa_id		      in   number,
10    p_co_seg_low               in   varchar2,
11    p_co_seg_high              in   varchar2,
12    p_gl_date_low              in   date,
13    p_gl_date_high             in   date,
14    p_currency_code_low        in   varchar2,
15    p_currency_code_high       in   varchar2,
16    p_trx_date_low             in   date,
17    p_trx_date_high            in   date,
18    p_due_date_low             in   date,
19    p_due_date_high            in   date,
20    p_invoice_type_low         in   varchar2,
21    p_invoice_type_high        in   varchar2,
22    p_adj_type_low             in   varchar2,
23    p_adj_type_high            in   varchar2,
24    p_doc_seq_name	      in   varchar2,
25    p_doc_seq_low	      in   number,
26    p_doc_seq_high	      in   number,
27    retcode                    out NOCOPY  number,
28    errbuf                     out NOCOPY  varchar2);
29 
30 procedure aradj_before_report;
31 procedure aradj_bind(c in integer);
32 procedure aradj_after_fetch;
33 
34 -- eliminate reporting details from ar_distributions table
35 function dist_details(
36    adj_id in NUMBER,
37    coa_id in NUMBER,
38    rep_id in NUMBER,
39    ret_type in VARCHAR2)
40 RETURN NUMBER;
41 
42 function dist_ccid(
43    adj_id in NUMBER,
44    coa_id in NUMBER,
45    rep_id in NUMBER)
46 RETURN NUMBER;
47 
48 type var_t is record (
49 			request_id                 		number,
50                         p_reporting_level                       VARCHAR2(30),
51                         p_reporting_entity_id                   NUMBER,
52                         p_sob_id                                NUMBER,
53 			p_coa_id			        number,
54    			p_currency_code_low          		varchar2(15),
55    			p_currency_code_high         		varchar2(15),
56    			p_invoice_type_low           		varchar2(50),
57    			p_invoice_type_high          		varchar2(50),
58    			p_trx_date_low               		date,
59    			p_trx_date_high              		date,
60    			p_due_date_low               		date,
61    			p_due_date_high              		date,
62    			p_co_seg_low                 		varchar2(30),
63    			p_co_seg_high                		varchar2(30),
64    			p_adj_acct_low             		varchar2(240),
65    			p_adj_acct_high				varchar2(240),
66    			p_adj_type_low               		varchar2(30),
67    			p_adj_type_high              		varchar2(30),
68    			p_gl_date_low                		date,
69    			p_gl_date_high				date,
70 			p_doc_seq_name				varchar2(30),
71    			p_doc_seq_low				number,
72    			p_doc_seq_high				number,
73 			organization_name                       varchar2(50),
74 		 	functional_currency_code                varchar2(15),
75  			postable                                varchar2(15),
76  			adj_currency_code                       varchar2(15),
77  			cons                                    varchar2(15),
78  			sortby                                  varchar2(30),
79  			adj_type                                varchar2(30),
80  			trx_number                              varchar2(36),--bug4612433
81  			due_date                                date,
82  			gl_date                                 date,
83  			adj_number                              varchar2(20),
84  			adj_class                               varchar2(30),
85  			adj_type_code                           varchar2(30),
86  			adj_type_meaning                        varchar2(30),
87 			adj_name				varchar2(30),
88 			adj_amount				number,
89  			customer_name                           varchar2(50),
90  			customer_number                         varchar2(30),
91 			customer_id				number,
92  			trx_date                                date,
93  			acctd_adj_amount                        number,
94 			books_id				number,
95 			chart_of_accounts_id			number,
96 			org_name				varchar2(50),
97 			currency_code				varchar2(20),
98 			d_or_i					varchar2(6),
99 			account_code_combination_id		varchar(240),
100 			debit_account				varchar(240),
101 			debit_account_desc			varchar(240),
102   			debit_balancing   			varchar(240),
103    			debit_balancing_desc			varchar(240),
104    			debit_natacct		      		varchar(240),
105    			debit_natacct_desc			varchar(240),
106 			doc_seq_value				number,
107 			doc_seq_name				varchar(30)
108 			);
109 
110 var var_t;
111 
112 
113 
114 END ARRX_ADJ;