[Home] [Help]
PACKAGE: APPS.ARRX_RC_UNAPP
Source
1 PACKAGE ARRX_RC_UNAPP AS
2 /* $Header: ARRXUNAS.pls 120.1 2005/10/30 04:45:57 appldev noship $ */
3
4 /*=======================================================================+
5 | Package Global Constants
6 +=======================================================================*/
7
8 type var_t is record(
9 request_id NUMBER,
10 p_reporting_level VARCHAR2(30),
11 p_reporting_entity_id NUMBER,
12 p_sob_id NUMBER,
13 p_coa_id NUMBER,
14 p_co_seg_low VARCHAR2(25),
15 p_co_seg_high VARCHAR2(25),
16 p_gl_date_from DATE,
17 p_gl_date_to DATE,
18 p_entered_currency VARCHAR2(15),
19 p_batch_name_low VARCHAR2(20),
20 p_batch_name_high VARCHAR2(20),
21 p_batch_src_low VARCHAR2(50),
22 p_batch_src_high VARCHAR2(50),
23 p_customer_name_low VARCHAR2(50),
24 p_customer_name_high VARCHAR2(50),
25 p_customer_number_low VARCHAR2(30),
26 p_customer_number_high VARCHAR2(30),
27 p_receipt_number_low VARCHAR2(30),
28 p_receipt_number_high VARCHAR2(30),
29 organization_name VARCHAR2(50),
30 functional_currency_code VARCHAR2(15),
31 cr_status VARCHAR2(40),
32 crh_status VARCHAR2(40),
33 batch_id NUMBER,
34 batch_name VARCHAR2(20),
35 cash_receipt_id NUMBER,
36 receipt_number VARCHAR2(30),
37 receipt_currency_code VARCHAR2(15),
38 exchange_rate NUMBER,
39 exchange_date DATE,
40 exchange_type VARCHAR2(30),
41 doc_sequence_name VARCHAR2(30),
42 doc_sequence_value NUMBER,
43 deposit_date DATE,
44 receipt_date DATE,
45 receipt_status VARCHAR2(40),
46 bank_name VARCHAR2(60),
47 bank_name_alt VARCHAR2(320),
48 bank_branch_name VARCHAR2(60),
49 bank_branch_name_alt VARCHAR2(320),
50 bank_number VARCHAR2(30),
51 bank_branch_number VARCHAR2(25),
52 bank_account_name VARCHAR2(80),
53 bank_account_name_alt VARCHAR2(320),
54 bank_account_currency VARCHAR2(15),
55 receipt_method VARCHAR2(30),
56 cash_receipt_history_id NUMBER,
57 gl_date DATE,
58 receipt_amount NUMBER,
59 receipt_history_status VARCHAR2(40),
60 acctd_receipt_amount NUMBER,
61 factor_discount_amount NUMBER,
62 acctd_factor_discount_amount NUMBER,
63 unapp_amount NUMBER,
64 on_acc_amount NUMBER,
65 claim_amount NUMBER,
66 prepay_amount NUMBER,
67 total_unresolved_amount NUMBER,
68 format_currency_code VARCHAR2(15),
69 account_code_combination_id NUMBER,
70 debit_balancing VARCHAR2(240),
71 customer_id NUMBER,
72 customer_name VARCHAR2(50),
73 customer_name_alt VARCHAR2(320),
74 customer_number VARCHAR2(30),
75 batch_source VARCHAR2(30),
76 ca_sob_type VARCHAR2(1),
77 ca_sob_id NUMBER
78 );
79 var var_t;
80
81 /*========================================================================+
82 | PUBLIC PROCEDURE AR_UNAPP_REG |
83 | |
84 | DESCRIPTION |
85 | |
86 | This procedure is the inner procedure for the RXi report. It uses |
87 | the appropriate fa_rx_util_pkg routines to bild the report |
88 | |
89 | PSEUDO CODE/LOGIC |
90 | |
91 | PARAMETERS |
92 | |
93 | request_id IN Request id for the concurrent program |
94 | and the other input parameters of the report |
95 | |
96 | KNOWN ISSUES |
97 | |
98 | NOTES |
99 | |
100 | |
101 | MODIFICATION HISTORY |
102 | Date Author Description of Changes |
103 | 04-OCT-2004 rkader Created |
104 | |
105 *=======================================================================*/
106
107 PROCEDURE ar_unapp_reg(
108 request_id IN NUMBER,
109 p_reporting_level IN VARCHAR2,
110 p_reporting_entity_id IN NUMBER,
111 p_sob_id IN NUMBER,
112 p_coa_id IN NUMBER,
113 p_co_seg_low IN VARCHAR2,
114 p_co_seg_high IN VARCHAR2,
115 p_gl_date_from IN DATE,
116 p_gl_date_to IN DATE,
117 p_entered_currency IN VARCHAR2,
118 p_batch_name_low IN VARCHAR2,
119 p_batch_name_high IN VARCHAR2,
120 p_batch_src_low IN VARCHAR2,
121 p_batch_src_high IN VARCHAR2,
122 p_customer_name_low IN VARCHAR2,
123 p_customer_name_high IN VARCHAR2,
124 p_customer_number_low IN VARCHAR2,
125 p_customer_number_high IN VARCHAR2,
126 p_receipt_number_low IN VARCHAR2,
127 p_receipt_number_high IN VARCHAR2,
128 retcode OUT NOCOPY NUMBER,
129 errbuf OUT NOCOPY NUMBER);
130
131 /*=======================================================================+
132 | Define the Report Triggers |
133 +=======================================================================*/
134
135 PROCEDURE before_report;
136
137 PROCEDURE bind(c IN INTEGER);
138
139 PROCEDURE after_fetch;
140
141 END ARRX_RC_UNAPP;