PACKAGE: APPS.ARRX_OTH

Source

1 PACKAGE ARRX_OTH as
2 /* $Header: ARRXOTHS.pls 120.0 2005/01/26 21:27:40 vcrisost noship $  */
3 
4 procedure oth_rec_app (
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            in   varchar2,
15    p_customer_name_low        in   varchar2,
16    p_customer_name_high       in   varchar2,
17    p_customer_number_low      in   varchar2,
18    p_customer_number_high     in   varchar2,
19    p_receipt_date_low         in   date,
20    p_receipt_date_high        in   date,
21    p_apply_date_low           in   date,
22    p_apply_date_high          in   date,
23    p_remit_batch_low          in   varchar2,
24    p_remit_batch_high         in   varchar2,
25    p_receipt_batch_low        in   varchar2,
26    p_receipt_batch_high       in   varchar2,
27    p_receipt_number_low       in   varchar2,
28    p_receipt_number_high      in   varchar2,
29    p_app_type                 in   varchar2,
30    retcode                    out NOCOPY  number,
31    errbuf                     out NOCOPY  varchar2);
32 
33 procedure before_report;
34 procedure bind(c in integer);
35 procedure after_fetch;
36 
37 type var_t is record (
38         request_id                      number,
39         books_id                        number,
40         chart_of_accounts_id            number,
41         currency_code                   varchar2(15),
42         org_name                        varchar2(50),
43         p_reporting_level               VARCHAR2(30),
44         p_reporting_entity_id           NUMBER,
45         p_sob_id                        NUMBER,
46         p_coa_id			number,
47         p_co_seg_low                    varchar2(30),
48         p_co_seg_high                   varchar2(30),
49         p_gl_date_low                   date,
50         p_gl_date_high                  date,
51         p_currency_code                 varchar2(15),
52         p_customer_name_low             varchar2(50),
53         p_customer_name_high            varchar2(50),
54         p_customer_number_low           varchar2(50),
55         p_customer_number_high          varchar2(50),
56         p_receipt_date_low              date,
57         p_receipt_date_high             date,
58         p_apply_date_low                date,
59         p_apply_date_high               date,
60         p_remit_batch_low               varchar2(20),
61         p_remit_batch_high              varchar2(20),
62         p_receipt_batch_low             varchar2(20),
63         p_receipt_batch_high            varchar2(20),
64         p_receipt_number_low            varchar2(30),
65         p_receipt_number_high           varchar2(30),
66         p_app_type                      varchar2(50),
67         organization_name               varchar2(50),
68         functional_currency_code        varchar2(15),
69         accounting_flexfield            varchar2(4000),
70         code_combination_id             number,
71         bank_account_number             varchar2(30),
72         acctd_amount_applied_from       number,
73         acctd_amount_applied_to         number,
74         activity_name                   varchar2(50),
75         amount_applied                  number,
76         application_ref_num             varchar2(30),
77         application_ref_type            varchar2(80),
78         application_status              varchar2(20),
79         apply_date                      date,
80         batch_id                        number,
81         batch_name                      varchar2(20),
82         batch_source                    varchar2(50),
83         cash_receipt_id                 number,
84         customer_name                   varchar2(50),
85         customer_number                 varchar2(30),
86         debit_balancing                 varchar2(240),
87         format_currency_code            varchar2(15),
88         gl_date                         date,
89         receipt_currency_code           varchar2(15),
90         receipt_date                    date,
91         receipt_number                  varchar2(30),
92         receipt_status                  varchar2(40),
93         receipt_type                    varchar2(30),
94         receipt_amount                  number,
95         remit_batch_name                varchar2(20),
96         ca_sob_type                     varchar2(1),
97         ca_sob_id                       number
98 
99 );
100 
101 var var_t;
102 
103 END ARRX_OTH;