[Home] [Help]
PACKAGE: APPS.OE_CREDIT_ENGINE_GRP
Source
1 PACKAGE OE_Credit_Engine_GRP AUTHID CURRENT_USER AS
2 -- $Header: OEXPCRGS.pls 120.5 2012/01/04 06:45:52 slagiset ship $
3 --+=======================================================================+
4 --| Copyright (c) 2000 Oracle Corporation |
5 --| Redwood Shores, CA, USA |
6 --| All rights reserved. |
7 --+=======================================================================+
8 --| FILENAME |
9 --| OEXPCRGS.pls |
10 --| |
11 --| DESCRIPTION |
12 --| OE credit check program |
13 --| |
14 --| supports the main credit check engine in retrieving credit data |
15 --| customer or a site (includes multi-currency enhancements) |
16 --| |
17 --| HISTORY |
18 --| 31-JUL-2001 rajkrish 2PM Global for currency error message |
19 --| 12-AUG-2001 tsimmond added procedure Get_Customer_exposure |
20 --| and two global variables |
21 --| G_cust_curr_tbl and G_site_curr_tbl |
22 --| 26-SEP-2001 rajkrish Ingersol BUG |
23 --| 05-FEB-2002 multi org OEXPCRGS.pls 115.7 2001/09/27 22:56:38|
24 --| 13-FEB-2002 vto Modified for legacy support. |
25 --| 11-JUN-2002 rajkrish 2412678S |
26 --| 05-NOV-2002 rajkrish |
27 --| 01-APR-2003 vto 2885044,2853800.Add globals for activity cc holds|
28 --| G_cc_hold_activity_name |
29 --| G_cc_hold_item_type |
30 --+=======================================================================+
31
32 --------------------
33 -- TYPE DECLARATIONS
34 --------------------
35
36 ------------
37 -- CONSTANTS
38 ------------
39
40 -------------------
41 -- PUBLIC VARIABLES
42 -------------------
43 G_cust_curr_tbl OE_CREDIT_CHECK_UTIL.CURR_TBL_TYPE;
44 G_site_curr_tbl OE_CREDIT_CHECK_UTIL.CURR_TBL_TYPE;
45 G_cust_incl_all_flag VARCHAR2(15);
46 G_site_incl_all_flag VARCHAR2(15);
47 GL_CURRENCY VARCHAR2(10);
48 G_currency_error_msg VARCHAR2(3000);
49 -- Ingersol BUG
50 G_delayed_request VARCHAR2(30);
51
52 -- Use to store activity specific hold information
53 G_cc_hold_item_type OE_HOLD_DEFINITIONS.item_type%TYPE;
54 G_cc_hold_activity_name OE_HOLD_DEFINITIONS.activity_name%TYPE;
55 TOLERANCE_CHECK_REQUIRED BOOLEAN := TRUE; --ER 12363706
56 G_Credit_Profile_Level VARCHAR2(30) := NULL; --ER 12363706
57 ---------------------------
58 -- PROCEDURES AND FUNCTIONS
59 ---------------------------
60 ---------------------------------------------------------------------------
61 --PROCEDURE: Credit_check_with_payment_typ
62 --COMMENT: Main API that is interfaced to the existing
63 -- verify_payment package for code switch
64
65 -- 2412678 add a new input parameter for credit check rule
66 ---------------------------------------------------------------------------
67 PROCEDURE Credit_check_with_payment_typ
68 ( p_header_id IN NUMBER
69 , p_calling_action IN VARCHAR2
70 , p_delayed_request IN VARCHAR2
71 , p_credit_check_rule_id IN NUMBER := NULL
72 , x_msg_count OUT NOCOPY /* file.sql.39 change */ NUMBER
73 , x_msg_data OUT NOCOPY /* file.sql.39 change */ VARCHAR2
74 , x_return_status OUT NOCOPY /* file.sql.39 change */ VARCHAR2
75 );
76
77
78 --------------------------------------------------------------------------
79 --PROCEDURE: Check_Credit
80 --COMMENT: Multi currency credit checking API for not electronic
81 --MODIFICATION:
82 -- 02/15/2002 Removed Default NULL for p_calling_action
83 ---------------------------------------------------------------------------
84 PROCEDURE Check_Credit
85 ( p_header_id IN NUMBER
86 , p_calling_action IN VARCHAR2
87 , p_delayed_request IN VARCHAR2 := NULL
88 , p_bill_to_site_use_id IN NUMBER := NULL
89 , p_credit_check_rule_id IN NUMBER := NULL
90 , p_functional_currency_code IN VARCHAR2 := NULL
91 , p_transaction_currency_code IN VARCHAR2 := NULL
92 , p_transaction_amount IN NUMBER := NULL
93 , p_org_id IN NUMBER := NULL
94 , x_cc_hold_comment OUT NOCOPY /* file.sql.39 change */ VARCHAR2
95 , x_msg_count OUT NOCOPY /* file.sql.39 change */ NUMBER
96 , x_msg_data OUT NOCOPY /* file.sql.39 change */ VARCHAR2
97 , x_result_out OUT NOCOPY /* file.sql.39 change */ VARCHAR2
98 , x_return_status OUT NOCOPY /* file.sql.39 change */ VARCHAR2
99 );
100
101 --=========================================================================
102 -- PROCEDURE : Get_customer_exposure PUBLIC
103 -- PARAMETERS : p_customer_id Customer ID
104 -- : p_site_id Bill-to Site ID
105 -- : p_limit_curr_code Credit limit currency code
106 -- : p_credit_check_rule_id Credit Check Rule Id
107 -- : x_total_exposure Credit exposure
108 -- : x_return_status Status
109 -- COMMENT : This procedure calculates credit exposure for given customer
110 --
111 --=========================================================================
112 PROCEDURE Get_customer_exposure
113 ( p_customer_id IN NUMBER
114 , p_site_id IN NUMBER
115 , p_limit_curr_code IN VARCHAR2
116 , p_credit_check_rule_id IN NUMBER
117 , x_total_exposure OUT NOCOPY /* file.sql.39 change */ NUMBER
118 , x_return_status OUT NOCOPY /* file.sql.39 change */ VARCHAR2
119 );
120
121
122 ------------------------------------------------------
123 -- This procedure will be the main procedure from ONT-I
124 -- For backward compatibile Issues, the proginal get_customer_exposure
125 -- will call this procedure - overloading
126 ----------------------------------------------------
127 PROCEDURE Get_customer_exposure
128 ( p_party_id IN NUMBER
129 , p_customer_id IN NUMBER
130 , p_site_id IN NUMBER
131 , p_limit_curr_code IN VARCHAR2
132 , p_credit_check_rule_id IN NUMBER
133 , p_need_exposure_details IN VARCHAR2 := 'N'
134 , x_total_exposure OUT NOCOPY /* file.sql.39 change */ NUMBER
135 , x_order_hold_amount OUT NOCOPY /* file.sql.39 change */ NUMBER
136 , x_order_amount OUT NOCOPY /* file.sql.39 change */ NUMBER
137 , x_ar_amount OUT NOCOPY /* file.sql.39 change */ NUMBER
138 , x_external_amount OUT NOCOPY /* file.sql.39 change */ NUMBER
139 , x_return_status OUT NOCOPY /* file.sql.39 change */ VARCHAR2
140 );
141
142 /* Start MOAC CREDIT CHECK CHANGE */
143 --=========================================================================
144 -- PROCEDURE : Set_Context PRIVATE
145 -- COMMENT : This procedure set the context
146 --
147 --=========================================================================
148 PROCEDURE Set_Context;
149 /* End MOAC CREDIT CHECK CHANGE */
150 --ER 12363706 start
151 FUNCTION Is_Tolerance_Enabled(
152 p_header_id IN NUMBER,
153 p_credit_check_rule_rec OUT NOCOPY OE_CREDIT_CHECK_UTIL.OE_credit_rules_rec_type )
154 RETURN BOOLEAN;
155 FUNCTION Credit_Tolerance_Check(
156 p_header_id IN NUMBER )
157 RETURN BOOLEAN;
158 --ER 12363706 end
159 END OE_Credit_Engine_GRP ;