[Home] [Help]
PACKAGE: APPS.OE_CREDIT_ENGINE_GRP
Source
1 PACKAGE OE_Credit_Engine_GRP AS
2 -- $Header: OEXPCRGS.pls 120.1.12010000.1 2008/07/25 07:52:39 appldev 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
56 ---------------------------
57 -- PROCEDURES AND FUNCTIONS
58 ---------------------------
59 ---------------------------------------------------------------------------
60 --PROCEDURE: Credit_check_with_payment_typ
61 --COMMENT: Main API that is interfaced to the existing
62 -- verify_payment package for code switch
63
64 -- 2412678 add a new input parameter for credit check rule
65 ---------------------------------------------------------------------------
66 PROCEDURE Credit_check_with_payment_typ
67 ( p_header_id IN NUMBER
68 , p_calling_action IN VARCHAR2
69 , p_delayed_request IN VARCHAR2
70 , p_credit_check_rule_id IN NUMBER := NULL
71 , x_msg_count OUT NOCOPY /* file.sql.39 change */ NUMBER
72 , x_msg_data OUT NOCOPY /* file.sql.39 change */ VARCHAR2
73 , x_return_status OUT NOCOPY /* file.sql.39 change */ VARCHAR2
74 );
75
76
77 --------------------------------------------------------------------------
78 --PROCEDURE: Check_Credit
79 --COMMENT: Multi currency credit checking API for not electronic
80 --MODIFICATION:
81 -- 02/15/2002 Removed Default NULL for p_calling_action
82 ---------------------------------------------------------------------------
83 PROCEDURE Check_Credit
84 ( p_header_id IN NUMBER
85 , p_calling_action IN VARCHAR2
86 , p_delayed_request IN VARCHAR2 := NULL
87 , p_bill_to_site_use_id IN NUMBER := NULL
88 , p_credit_check_rule_id IN NUMBER := NULL
89 , p_functional_currency_code IN VARCHAR2 := NULL
90 , p_transaction_currency_code IN VARCHAR2 := NULL
91 , p_transaction_amount IN NUMBER := NULL
92 , p_org_id IN NUMBER := NULL
93 , x_cc_hold_comment OUT NOCOPY /* file.sql.39 change */ VARCHAR2
94 , x_msg_count OUT NOCOPY /* file.sql.39 change */ NUMBER
95 , x_msg_data OUT NOCOPY /* file.sql.39 change */ VARCHAR2
96 , x_result_out OUT NOCOPY /* file.sql.39 change */ VARCHAR2
97 , x_return_status OUT NOCOPY /* file.sql.39 change */ VARCHAR2
98 );
99
100 --=========================================================================
101 -- PROCEDURE : Get_customer_exposure PUBLIC
102 -- PARAMETERS : p_customer_id Customer ID
103 -- : p_site_id Bill-to Site ID
104 -- : p_limit_curr_code Credit limit currency code
105 -- : p_credit_check_rule_id Credit Check Rule Id
106 -- : x_total_exposure Credit exposure
107 -- : x_return_status Status
108 -- COMMENT : This procedure calculates credit exposure for given customer
109 --
110 --=========================================================================
111 PROCEDURE Get_customer_exposure
112 ( p_customer_id IN NUMBER
113 , p_site_id IN NUMBER
114 , p_limit_curr_code IN VARCHAR2
115 , p_credit_check_rule_id IN NUMBER
116 , x_total_exposure OUT NOCOPY /* file.sql.39 change */ NUMBER
117 , x_return_status OUT NOCOPY /* file.sql.39 change */ VARCHAR2
118 );
119
120
121 ------------------------------------------------------
122 -- This procedure will be the main procedure from ONT-I
123 -- For backward compatibile Issues, the proginal get_customer_exposure
124 -- will call this procedure - overloading
125 ----------------------------------------------------
126 PROCEDURE Get_customer_exposure
127 ( p_party_id IN NUMBER
128 , p_customer_id IN NUMBER
129 , p_site_id IN NUMBER
130 , p_limit_curr_code IN VARCHAR2
131 , p_credit_check_rule_id IN NUMBER
132 , p_need_exposure_details IN VARCHAR2 := 'N'
133 , x_total_exposure OUT NOCOPY /* file.sql.39 change */ NUMBER
134 , x_order_hold_amount OUT NOCOPY /* file.sql.39 change */ NUMBER
135 , x_order_amount OUT NOCOPY /* file.sql.39 change */ NUMBER
136 , x_ar_amount OUT NOCOPY /* file.sql.39 change */ NUMBER
137 , x_external_amount OUT NOCOPY /* file.sql.39 change */ NUMBER
138 , x_return_status OUT NOCOPY /* file.sql.39 change */ VARCHAR2
139 );
140
141 /* Start MOAC CREDIT CHECK CHANGE */
142 --=========================================================================
143 -- PROCEDURE : Set_Context PRIVATE
144 -- COMMENT : This procedure set the context
145 --
146 --=========================================================================
147 PROCEDURE Set_Context;
148 /* End MOAC CREDIT CHECK CHANGE */
149
150 END OE_Credit_Engine_GRP ;