[Home] [Help]
PACKAGE: APPS.OE_CREDIT_EXPOSURE_PVT
Source
1 PACKAGE OE_CREDIT_EXPOSURE_PVT AUTHID CURRENT_USER AS
2 -- $Header: OEXVCRXS.pls 120.2 2011/03/16 09:58:57 cpati ship $
3
4 --+=======================================================================+
5 --| Copyright (c) 1998 Oracle Corporation |
6 --| Redwood Shores, CA, USA |
7 --| All rights reserved. |
8 --+=======================================================================+
9 --| FILENAME |
10 --| OEXVCRXS.pls |
11 --| |
12 --| DESCRIPTION |
13 --| Spec. of OE_CREDIT_EXPOSURE_PVT |
14 --| |
15 --| HISTORY |
16 --| 06/05/2001 Rene Schaub Created |
17 --| 01-29-2002 rajkrish updated for Multi org project OM H |
18 --| ontdev => 115.3 2001/08/25 |
19 --| 03/15/2002 vto Added G_EXTERNAL_EXPOSURE balance type |
20 --| 06/18/2002 vto renee logic init summary only |
21 --| oct-30 2002 updates |
22 --| 12/06/2002 vto Added NOCOPY to OUT variables |
23 --| 07/02/2003 tsimmond Added new balance type globals for the |
24 --| Returns project |
25 --+======================================================================*/
26
27 --===================
28 -- TYPES
29 --===================
30
31 TYPE Binary_rec_type IS RECORD
32 ( bucket NUMBER
33 , bucket_length NUMBER
34 );
35
36 TYPE Binary_tbl_type IS TABLE OF Binary_rec_type
37 INDEX BY BINARY_INTEGER;
38
39 --===================
40 -- CONSTANTS
41 --===================
42
43 G_HEADER_UNINVOICED_ORDERS CONSTANT NUMBER := 1;
44 G_LINE_UNINVOICED_ORDERS CONSTANT NUMBER := 2;
45 G_HEADER_UNINVOICED_ORDERS_TAX CONSTANT NUMBER := 3;
46 G_LINE_UNINVOICED_ORDERS_TAX CONSTANT NUMBER := 4;
47 G_HEADER_UNINVOICED_FREIGHT CONSTANT NUMBER := 5;
48 G_LINE_UNINVOICED_FREIGHT CONSTANT NUMBER := 6;
49 G_HEADER_AND_LINE_FREIGHT CONSTANT NUMBER := 7;
50 G_INVOICES CONSTANT NUMBER := 8;
51 G_PAYMENTS_AT_RISK CONSTANT NUMBER := 9;
52 G_ORDER_HOLDS CONSTANT NUMBER := 10;
53 G_LINE_HOLDS CONSTANT NUMBER := 11;
54 G_ORDER_TAX_HOLDS CONSTANT NUMBER := 13;
55 G_LINE_TAX_HOLDS CONSTANT NUMBER := 14;
56 G_ORDER_FREIGHT_HOLDS CONSTANT NUMBER := 15;
57 G_LINE_FREIGHT_HOLDS CONSTANT NUMBER := 16;
61 G_BR_INVOICES CONSTANT NUMBER := 21;
58 G_HEADER_LINE_FREIGHT_HOLDS CONSTANT NUMBER := 17;
59 G_EXTERNAL_EXPOSURE CONSTANT NUMBER := 18;
60 G_PAST_DUE_INVOICES CONSTANT NUMBER := 20;
62 G_BR_PAYMENTS_AT_RISK CONSTANT NUMBER := 22;
63
64 -------added for the Returns project (FPJ)
65 G_HEAD_RETURN_UNINV_ORDERS CONSTANT NUMBER := 23;
66 G_LINE_RETURN_UNINV_ORDERS CONSTANT NUMBER := 24;
67 G_HEAD_RETURN_UNINV_ORD_TAX CONSTANT NUMBER := 25;
68 G_LINE_RETURN_UNINV_ORD_TAX CONSTANT NUMBER := 26;
69 G_HEAD_RETURN_UNINV_FREIGHT CONSTANT NUMBER := 27;
70 G_LINE_RETURN_UNINV_FREIGHT CONSTANT NUMBER := 28;
71 G_HEAD_LINE_RETURN_FREIGHT CONSTANT NUMBER := 29;
72 G_ORDER_RETURN_HOLDS CONSTANT NUMBER := 30;
73 G_LINE_RETURN_HOLDS CONSTANT NUMBER := 31;
74 G_ORDER_RETURN_TAX_HOLDS CONSTANT NUMBER := 32;
75 G_LINE_RETURN_TAX_HOLDS CONSTANT NUMBER := 33;
76 G_ORDER_RETURN_FREIGHT_HOLDS CONSTANT NUMBER := 34;
77 G_LINE_RETURN_FREIGHT_HOLDS CONSTANT NUMBER := 35;
78 G_H_L_RETURN_FREIGHT_HOLDS CONSTANT NUMBER := 36;
79 --TaxER start
80 G_HEADER_UNINVOICED_FREIGHT_T CONSTANT NUMBER := 37;
81 G_LINE_UNINVOICED_FREIGHT_T CONSTANT NUMBER := 38;
82 G_HEADER_AND_LINE_FREIGHT_T CONSTANT NUMBER := 39;
83 G_ORDER_FREIGHT_HOLDS_T CONSTANT NUMBER := 40;
84 G_LINE_FREIGHT_HOLDS_T CONSTANT NUMBER := 41;
85 G_HEADER_LINE_FREIGHT_HOLDS_T CONSTANT NUMBER := 42;
86 G_HEAD_RETURN_UNINV_FREIGHT_T CONSTANT NUMBER := 43;
87 G_LINE_RETURN_UNINV_FREIGHT_T CONSTANT NUMBER := 44;
88 G_HEAD_LINE_RETURN_FREIGHT_T CONSTANT NUMBER := 45;
89 G_ORDER_RETURN_FREIGHT_HOLDS_T CONSTANT NUMBER := 46;
90 G_LINE_RETURN_FREIGHT_HOLDS_T CONSTANT NUMBER := 47;
91 G_H_L_RETURN_FREIGHT_HOLDS_T CONSTANT NUMBER := 48;
92 --TaxER end
93
94 --===================
95 -- GLOBAL VARIABLES
96 --===================
97
98 G_MAX_BUCKET_LEVEL NUMBER := 8;
99 G_MAX_BUCKET_LENGTH NUMBER := 256; -- 2^8
100 G_COMPLETE BOOLEAN := TRUE;
101
102
103 --========================================================================
104 -- PROCEDURE : Init_Summary_Table PUBLIC
105 -- PARAMETERS: x_retcode 0 success, 1 warning, 2 error
106 -- x_errbuf error buffer
107 -- p_lock_tables 'Y' or 'N' for all transaction tables
108 ---
109 -- COMMENT : This is the concurrent program specification for
110 -- Initialize Credit Summaries Table
111 -- which will repopulate oe_credit_summaries table with summarized
112 -- credit exposure information.
113 -- The p_lock_tables flag specifies if
114 -- the oe_order_lines_all, oe_order_headers_all,
115 -- oe_cash_adjustments, ar_payment_schedules_all,
116 -- ar_cash_receipts_all tables should all be locked in exclusive mode
117 -- until all of the summary data is obtained.
118 -- If the flag is not set to 'Y', none of the tables is locked.
119 --=======================================================================--
120
121
122 PROCEDURE Init_Summary_Table
123 ( x_retcode OUT NOCOPY VARCHAR2
124 , x_errbuf OUT NOCOPY VARCHAR2
125 , p_lock_tables IN VARCHAR2 DEFAULT 'N'
126 );
127
128
129 --========================================================================
130 -- PROCEDURE : Get_Exposure PUBLIC
131 -- PARAMETERS: x_retcode 0 success, 1 warning, 2 error
132 -- x_errbuf error buffer
133 -- p_customer_id not null
137 -- p_system_parameters_rec
134 -- p_site_use_id can be null
135 -- p_header_id order header
136 -- p_credit_check_rule_rec
138 -- p_limit_curr_code currency in which to show the exposure
139 -- p_usage_curr_tbl only include transactions in these currencies
140 -- p_include_all_flag include transactions in any currency
141 -- x_total_exposure
142 -- x_return_status
143 -- x_error_curr_tbl contains currencies with no rates
144
145 ---
146 -- COMMENT : This returns the total exposure for a customer or customer site
147 -- using precalculated data.
148 --=======================================================================--
149 PROCEDURE Get_Exposure
150 ( p_customer_id IN NUMBER
151 , p_site_use_id IN NUMBER
152 , p_party_id IN NUMBER := NULL
153 , p_header_id IN NUMBER
154 , p_credit_check_rule_rec IN
155 OE_CREDIT_CHECK_UTIL.oe_credit_rules_rec_type
156 , p_system_parameters_rec IN
157 OE_CREDIT_CHECK_UTIL.oe_systems_param_rec_type
158 , p_limit_curr_code IN
159 HZ_CREDIT_PROFILE_AMTS.currency_code%TYPE
160 , p_usage_curr_tbl IN OE_CREDIT_CHECK_UTIL.curr_tbl_type
161 , p_include_all_flag IN VARCHAR2
162 , p_global_exposure_flag IN VARCHAR2 := 'N'
163 , p_need_exposure_details IN VARCHAR2 := 'N'
164 , x_total_exposure OUT NOCOPY NUMBER
165 , x_order_amount OUT NOCOPY NUMBER
166 , x_order_hold_amount OUT NOCOPY NUMBER
167 , x_ar_amount OUT NOCOPY NUMBER
168 , x_return_status OUT NOCOPY VARCHAR2
169 , x_error_curr_tbl OUT NOCOPY OE_CREDIT_CHECK_UTIL.curr_tbl_type
170 );
171
172
173
174 PROCEDURE get_invoices_over_duedate
175 ( p_customer_id IN NUMBER
176 , p_site_use_id IN NUMBER
177 , p_party_id IN NUMBER
178 , p_credit_check_rule_rec IN
179 OE_CREDIT_CHECK_UTIL.OE_credit_rules_rec_type
180 , p_credit_level IN VARCHAR2
181 , p_usage_curr IN oe_credit_check_util.curr_tbl_type
182 , p_include_all_flag IN VARCHAR2
183 , p_global_exposure_flag IN VARCHAR2 := 'N'
184 , p_org_id IN NUMBER
185 , x_exist_flag OUT NOCOPY VARCHAR2
186 )
187 ;
188 --TaxER Start
189 FUNCTION Is_Equal(p_param1 varchar2,p_param2 number)
190 RETURN varchar2;
191 --TaxER End
192
193
194
195 END OE_CREDIT_EXPOSURE_PVT;