1 PACKAGE OE_Credit_check_order_PVT AUTHID CURRENT_USER AS
2 -- $Header: OEXVCRHS.pls 120.1.12010000.1 2008/07/25 07:59:16 appldev ship $
3
4 -----------------------------------------
5 -- Release order level credit check hold
6 -- in the database.
7 -----------------------------------------
8
9 PROCEDURE Release_Order_CC_Hold
10 ( p_header_id IN NUMBER
11 , p_order_number IN NUMBER
12 , p_calling_action IN VARCHAR2 DEFAULT 'BOOKING'
13 , P_SYSTEM_PARAMETER_REC IN OE_CREDIT_CHECK_UTIL.OE_systems_param_rec_type
14 , x_cc_result_out OUT NOCOPY VARCHAR2
15 );
16
17 ------------------------------------------
18 -- Mainline procedure that will read --
19 -- an Order Header and determine --
20 -- if should be checked, determines --
21 -- if order has passed or failed --
22 -- the credit check (no holds placed) --
23 ------------------------------------------
24
25 PROCEDURE Check_order_credit
26 ( p_header_rec IN OE_ORDER_PUB.Header_Rec_Type
27 , p_calling_action IN VARCHAR2 DEFAULT 'BOOKING'
28 , p_credit_check_rule_rec IN OE_CREDIT_CHECK_UTIL.OE_credit_rules_rec_type
29 , p_system_parameter_rec IN OE_CREDIT_CHECK_UTIL.OE_systems_param_rec_type
30 , p_transaction_amount IN NUMBER DEFAULT NULL
31 , x_msg_count OUT NOCOPY NUMBER
32 , x_msg_data OUT NOCOPY VARCHAR2
33 , x_cc_result_out OUT NOCOPY VARCHAR2
34 , x_cc_hold_comment OUT NOCOPY VARCHAR2
35 , x_return_status OUT NOCOPY VARCHAR2
36 ) ;
37
38
39 -------------------------------------------------------
40 -- Checks the overall credit exposure for the
41 -- credit checking process
42 -- Will calculate exposure from the transaction tables
43 -- directly
44 -----------------------------------------------------------
45 /*
46 PROCEDURE Check_Order_exposure
47 ( p_customer_id IN NUMBER
48 , p_site_use_id IN NUMBER
49 , p_header_id IN NUMBER
50 , p_credit_level IN VARCHAR2
51 , p_transaction_curr_code IN VARCHAR2
52 , p_transaction_amount IN NUMBER DEFAULT 0
53 , p_limit_curr_code IN VARCHAR2
54 , p_overall_credit_limit IN NUMBER
55 , p_calling_action IN VARCHAR2
56 , p_usage_curr IN OE_CREDIT_CHECK_UTIL.curr_tbl_type
57 , p_include_all_flag IN VARCHAR2 DEFAULT 'N'
61 , p_system_parameter_rec IN OE_Credit_Check_Util.OE_systems_param_rec_type
58 , p_holds_rel_flag IN VARCHAR2 DEFAULT 'N'
59 , p_default_limit_flag IN VARCHAR2 DEFAULT 'N'
60 , p_credit_check_rule_rec IN OE_Credit_Check_Util.OE_credit_rules_rec_type
62 , p_global_exposure_flag IN VARCHAR2 := 'N'
63 , x_total_exposure OUT NOCOPY NUMBER
64 , x_cc_result_out OUT NOCOPY VARCHAR2
65 , x_error_curr_tbl OUT NOCOPY OE_CREDIT_CHECK_UTIL.curr_tbl_type
66 , x_return_status OUT NOCOPY VARCHAR2
67 );
68
69 */
70
71 PROCEDURE Check_order_exposure
72 ( p_customer_id IN NUMBER
73 , p_site_use_id IN NUMBER
74 , p_party_id IN NUMBER
75 , p_header_id IN NUMBER
76 , p_credit_level IN VARCHAR2
77 , p_transaction_curr_code IN VARCHAR2
78 , p_transaction_amount IN NUMBER DEFAULT 0
79 , p_limit_curr_code IN VARCHAR2
80 , p_overall_credit_limit IN NUMBER
81 , p_calling_action IN VARCHAR2
82 , p_usage_curr IN OE_CREDIT_CHECK_UTIL.curr_tbl_type
83 , p_include_all_flag IN VARCHAR2 DEFAULT 'N'
84 , p_holds_rel_flag IN VARCHAR2 DEFAULT 'N'
85 , p_default_limit_flag IN VARCHAR2 DEFAULT 'N'
86 , p_credit_check_rule_rec IN OE_Credit_Check_Util.OE_credit_rules_rec_type
87 , p_system_parameter_rec IN OE_Credit_Check_Util.OE_systems_param_rec_type
88 , p_global_exposure_flag IN VARCHAR2 := 'N'
89 , p_credit_limit_entity_id IN VARCHAR2
90 , x_total_exposure OUT NOCOPY NUMBER
91 , x_cc_result_out OUT NOCOPY VARCHAR2
92 , x_error_curr_tbl OUT NOCOPY OE_CREDIT_CHECK_UTIL.curr_tbl_type
93 , x_return_status OUT NOCOPY VARCHAR2
94 );
95
96
97 END OE_Credit_check_order_PVT;