[Home] [Help]
PACKAGE: APPS.AR_REVENUE_MANAGEMENT_PVT
Source
1 PACKAGE ar_revenue_management_pvt AS
2 /* $Header: ARXRVMGS.pls 120.23 2006/05/02 13:02:31 mraymond noship $ */
3
4 /*=======================================================================+
5 | Declare PUBLIC Data Types and Variables
6 +=======================================================================*/
7
8 TYPE binary_int_table IS TABLE OF BINARY_INTEGER
9 INDEX BY BINARY_INTEGER;
10
11 TYPE number_table IS TABLE OF NUMBER
12 INDEX BY BINARY_INTEGER;
13
14 TYPE varchar_table IS TABLE OF VARCHAR2(240)
15 INDEX BY BINARY_INTEGER;
16
17 TYPE date_table IS TABLE OF DATE
18 INDEX BY BINARY_INTEGER;
19
20 TYPE desc_flexfield IS RECORD (
21 attribute1 VARCHAR2(150) DEFAULT NULL,
22 attribute2 VARCHAR2(150) DEFAULT NULL,
23 attribute3 VARCHAR2(150) DEFAULT NULL,
24 attribute4 VARCHAR2(150) DEFAULT NULL,
25 attribute5 VARCHAR2(150) DEFAULT NULL,
26 attribute6 VARCHAR2(150) DEFAULT NULL,
27 attribute7 VARCHAR2(150) DEFAULT NULL,
28 attribute8 VARCHAR2(150) DEFAULT NULL,
29 attribute9 VARCHAR2(150) DEFAULT NULL,
30 attribute10 VARCHAR2(150) DEFAULT NULL,
31 attribute11 VARCHAR2(150) DEFAULT NULL,
32 attribute12 VARCHAR2(150) DEFAULT NULL,
33 attribute13 VARCHAR2(150) DEFAULT NULL,
34 attribute14 VARCHAR2(150) DEFAULT NULL,
35 attribute15 VARCHAR2(150) DEFAULT NULL,
36 attribute_category VARCHAR2(30) DEFAULT NULL);
37 --
38 -- Constants
39 --
40
41 c_max_bulk_fetch_size CONSTANT NUMBER := 1000;
42
43 c_revenue_deferral_event CONSTANT wf_events.name%TYPE :=
44 'oracle.apps.ar.transaction.Invoice.noncollectible';
45
46 c_rule_object_name CONSTANT VARCHAR2(30) :=
47 'AR_REVENUE_DEFERRAL_REASONS';
48
49 c_receipt_application_mode CONSTANT NUMBER := 1;
50 c_receipt_reversal_mode CONSTANT NUMBER := 2;
51
52 c_manual_override_mode CONSTANT NUMBER := 1;
53 c_acceptance_obtained_mode CONSTANT NUMBER := 2;
54 c_update_reason_mode CONSTANT NUMBER := 3;
55
56 c_earn_revenue CONSTANT VARCHAR2(30) := 'EARN';
57 c_unearn_revenue CONSTANT VARCHAR2(30) := 'UNEARN';
58
59 not_analyzed CONSTANT NUMBER := 2;
60 collect CONSTANT NUMBER := 1;
61 defer CONSTANT NUMBER := 0;
62
63 credit CONSTANT NUMBER := 1;
64 payment_term CONSTANT NUMBER := 2;
65
66 c_recognizable CONSTANT NUMBER := 0;
67 c_cash_based CONSTANT NUMBER := 1;
68 c_contingency_based CONSTANT NUMBER := 2;
69 c_combination CONSTANT NUMBER := 3;
70
71 c_not_recognized CONSTANT NUMBER := 0;
72 c_partially_recognized CONSTANT NUMBER := 1;
73 c_fully_recognized CONSTANT NUMBER := 2;
74
75 c_acceptance_allowed CONSTANT NUMBER := 1;
76 c_transaction_not_monitored CONSTANT NUMBER := 2;
77 c_acceptance_not_required CONSTANT NUMBER := 3;
78
79 c_revenue_management_source CONSTANT NUMBER := 1;
80
81 c_yes CONSTANT NUMBER := 0;
82 c_no CONSTANT NUMBER := 1;
83
84 -- seeded contingencies
85 c_pre_billing_acceptance CONSTANT NUMBER := 1;
86 c_explicit_acceptance CONSTANT NUMBER := 2;
87 c_customer_credit CONSTANT NUMBER := 3;
88 c_doubtful_collectibility CONSTANT NUMBER := 4;
89 c_extended_payment_term CONSTANT NUMBER := 5;
90 c_delivery CONSTANT NUMBER := 6;
91 c_cancellation CONSTANT NUMBER := 7;
92 c_fiscal_funcing CONSTANT NUMBER := 8;
93 c_refund CONSTANT NUMBER := 9;
94 c_forfeiture CONSTANT NUMBER := 10;
95 c_installation CONSTANT NUMBER := 11;
96 c_okl_collectibility CONSTANT NUMBER := 12;
97 c_impaird_loans CONSTANT NUMBER := 13;
98
99 FUNCTION revenue_management_enabled
100 RETURN BOOLEAN;
101
102 FUNCTION cash_based (p_customer_trx_id IN NUMBER)
103 RETURN NUMBER;
104
105 FUNCTION acceptance_allowed (
106 p_customer_trx_id IN NUMBER,
107 p_customer_trx_line_id IN NUMBER)
108 RETURN NUMBER;
109
110 FUNCTION creditworthy (
111 p_customer_account_id IN NUMBER,
112 p_customer_site_use_id IN NUMBER)
113 RETURN NUMBER;
114
115 FUNCTION line_collectible (
116 p_customer_trx_id NUMBER,
117 p_customer_trx_line_id NUMBER DEFAULT NULL)
118 RETURN NUMBER;
119
120 FUNCTION txn_collectible (p_customer_trx_id IN NUMBER)
121 RETURN BOOLEAN;
122
123 FUNCTION line_collectibility (
124 p_request_id NUMBER,
125 p_source VARCHAR2 DEFAULT NULL,
126 x_error_count OUT NOCOPY NUMBER,
127 p_customer_trx_line_id ra_customer_trx_lines.customer_trx_line_id%TYPE DEFAULT NULL)
128 RETURN number_table;
129
130 FUNCTION line_collectibility(
131 p_customer_trx_id NUMBER,
132 p_customer_trx_line_id NUMBER)
133 RETURN NUMBER;
134
135 PROCEDURE delete_failed_rows (p_request_id IN NUMBER);
136
137 PROCEDURE delete_rejected_rows (p_request_id IN NUMBER);
138
139 PROCEDURE periodic_sweeper (
140 errbuf OUT NOCOPY VARCHAR2,
141 retcode OUT NOCOPY VARCHAR2,
142 p_org_id IN NUMBER);
143
144 PROCEDURE receipt_analyzer (
145 p_mode IN VARCHAR2 DEFAULT NULL,
146 p_customer_trx_id IN NUMBER DEFAULT NULL,
147 p_acctd_amount_applied IN NUMBER DEFAULT NULL,
148 p_exchange_rate IN NUMBER DEFAULT NULL,
149 p_invoice_currency_code IN VARCHAR2 DEFAULT NULL,
150 p_tax_applied IN NUMBER DEFAULT NULL,
151 p_charges_applied IN NUMBER DEFAULT NULL,
152 p_freight_applied IN NUMBER DEFAULT NULL,
153 p_line_applied IN NUMBER DEFAULT NULL,
154 p_receivable_application_id IN NUMBER DEFAULT NULL,
155 p_gl_date IN DATE DEFAULT NULL);
156
157 PROCEDURE receipt_analyzer (p_request_id IN NUMBER);
158
159 PROCEDURE revenue_synchronizer (
160 p_mode IN NUMBER DEFAULT c_manual_override_mode,
161 p_customer_trx_id IN NUMBER,
162 p_customer_trx_line_id IN NUMBER,
163 p_gl_date IN DATE DEFAULT NULL,
164 p_comments IN VARCHAR2 DEFAULT NULL,
165 p_ram_desc_flexfield IN desc_flexfield,
166 x_scenario OUT NOCOPY NUMBER,
167 x_first_adjustment_number OUT NOCOPY NUMBER,
168 x_last_adjustment_number OUT NOCOPY NUMBER,
169 x_return_status OUT NOCOPY VARCHAR2,
170 x_msg_count OUT NOCOPY NUMBER,
171 x_msg_data OUT NOCOPY VARCHAR2);
172
173 PROCEDURE process_event (
174 p_cust_trx_line_id IN NUMBER,
175 p_event_date IN DATE,
176 p_event_code IN VARCHAR2);
177
178 PROCEDURE update_line_conts (
179 p_customer_trx_line_id NUMBER,
180 p_contingency_id NUMBER,
181 p_expiration_date DATE DEFAULT NULL,
182 p_expiration_event_date DATE DEFAULT NULL,
183 p_expiration_days NUMBER DEFAULT NULL,
184 p_completed_flag VARCHAR2 DEFAULT NULL,
185 p_reason_removal_date DATE DEFAULT NULL);
186
187
188 PROCEDURE delete_line_conts (
189 p_customer_trx_line_id NUMBER,
190 p_contingency_id NUMBER);
191
192 /* 5142216 - This function was defined as public so it could be used
193 in sql within the package. It is not intended for public use...
194 although it technically poses no risk by its exposure */
195
196 FUNCTION get_line_id (p_so_line_id IN NUMBER) RETURN number;
197
198 END ar_revenue_management_pvt;