1 PACKAGE OE_Credit_check_lines_PVT AUTHID CURRENT_USER AS
2 -- $Header: OEXVCRLS.pls 120.2.12010000.1 2008/07/25 07:59:18 appldev ship $
3 --+=======================================================================+
4 --| Copyright (c) 2001 Oracle Corporation |
5 --| Redwood Shores, CA, USA |
6 --| All rights reserved. |
7 --+=======================================================================+
8 --| |
9 --| FILENAME OEXVCRLS.pls |
10 --| DESCRIPTION Spec of package OE_Credit_check_lines_PVT |
11 --| Determines if an Order is Subject to Credit Check. |
12 --| |
13 --| HISTORY |
14 --| Mar-27-2002 dbdrv |
15 --| Aug-23-2002 tsimmond added Release_Line_CC_Hold procedure |
16 --| Oct-XX-2002 rajkrish party |
17 --| Dec-06-2002 vto Added NOCOPY to OUT variables |
18 --| Mar-31-2003 vto 2878410.Added line count global |
19 --|=======================================================================+
20
21 ---------------------------------------------
22 ----------- PL/SQL table record types
23 ------------------------------------------
24 TYPE Line_Hold_Rectype IS RECORD
25 ( line_id NUMBER
26 , line_number NUMBER
27 , hold VARCHAR2(30)
28 , limit_used VARCHAR2(80)
29 , profile_used VARCHAR2(30)
30 , customer_id NUMBER
31 , site_use_id NUMBER
32 , party_id NUMBER
33 , item_category_id NUMBER
34 , line_total NUMBER -- ER 6135714
35 );
36
37 TYPE Line_Holds_Tbl_Rectype IS TABLE OF Line_Hold_Rectype
38 INDEX BY BINARY_INTEGER;
39
40 --------------------------------------------
41 -- Global Variables
42 --------------------------------------------
43 G_line_hold_count NUMBER;
44
45 ---------------------------------------------------------
46 -- Release credit check holds on order lines belonging to
47 -- a bill-to site
48 ---------------------------------------------------------
49
50 PROCEDURE Release_Line_CC_Hold
51 ( p_header_id IN NUMBER
52 , p_order_number IN NUMBER
53 , p_line_id IN NUMBER
54 , p_line_number IN NUMBER
55 , p_calling_action IN VARCHAR2 DEFAULT NULL
56 , p_credit_hold_level IN VARCHAR2
57 , x_cc_result_out OUT NOCOPY VARCHAR2
58 );
59
60
61 ------------------------------------------
62 -- Mainline procedure that will read --
63 -- an Order Header and determine --
64 -- if should be checked, determines --
65 -- if order has passed or failed --
66 -- the credit check (no holds placed) --
67 ------------------------------------------
68
69 PROCEDURE Check_order_lines_credit
70 ( p_header_rec IN OE_ORDER_PUB.Header_Rec_Type
71 , p_calling_action IN VARCHAR2 DEFAULT 'BOOKING'
72 , p_credit_check_rule_rec IN OE_CREDIT_CHECK_UTIL.OE_credit_rules_rec_type
73 , p_system_parameter_rec IN OE_CREDIT_CHECK_UTIL.OE_systems_param_rec_type
74 , x_msg_count OUT NOCOPY NUMBER
75 , x_msg_data OUT NOCOPY VARCHAR2
76 , x_cc_result_out OUT NOCOPY VARCHAR2
77 , x_cc_limit_used OUT NOCOPY VARCHAR2
78 , x_cc_profile_used OUT NOCOPY VARCHAR2
79 , x_return_status OUT NOCOPY VARCHAR2
80 ) ;
81
82 -------------------------------------------------
83 ---- Check_Order_lines_exposure
84 -- Checks the overall credit exposure for order line level
85 -- bill to site.
86 -- Will select the overall exposure from the pre-calculated
87 -- exposure table
88 ---------------------------------------------------
89
90 PROCEDURE Check_Order_lines_exposure
91 ( p_customer_id IN NUMBER
92 , p_site_use_id IN NUMBER
93 , p_header_id IN NUMBER
94 , p_credit_level IN VARCHAR2
95 , p_limit_curr_code IN VARCHAR2
96 , p_overall_credit_limit IN NUMBER
97 , p_calling_action IN VARCHAR2
98 , p_usage_curr IN OE_CREDIT_CHECK_UTIL.curr_tbl_type
99 , p_include_all_flag IN VARCHAR2 DEFAULT 'N'
100 , p_holds_rel_flag IN VARCHAR2 DEFAULT 'N'
101 , p_default_limit_flag IN VARCHAR2 DEFAULT 'N'
102 , p_credit_check_rule_rec IN OE_Credit_Check_Util.OE_credit_rules_rec_type
103 , p_system_parameter_rec IN OE_Credit_Check_Util.OE_systems_param_rec_type
104 , p_global_exposure_flag IN VARCHAR2 := 'N'
105 , p_party_id IN NUMBER
106 , p_credit_limit_entity_id IN NUMBER
107 , x_total_exposure OUT NOCOPY NUMBER
108 , x_cc_result_out OUT NOCOPY VARCHAR2
109 , x_error_curr_tbl OUT NOCOPY OE_CREDIT_CHECK_UTIL.curr_tbl_type
110 , x_return_status OUT NOCOPY VARCHAR2
111 );
112
113
114
115
116 END OE_Credit_check_lines_PVT;