1 PACKAGE OE_Credit_PUB AUTHID CURRENT_USER AS
2 /* $Header: OEXPCRCS.pls 120.0.12010000.1 2008/07/25 07:52:34 appldev ship $ */
3
4 -- Mainline Function that will read an Order Header and Determine if should be checked,
5 -- Consumes available Credit and applies a credit hold if Appropriate
6
7 PROCEDURE Check_Available_Credit
8 ( p_header_id IN NUMBER := FND_API.G_MISS_NUM
9 , p_calling_action IN VARCHAR2 := 'BOOKING'
10 , p_msg_count OUT NOCOPY /* file.sql.39 change */ NUMBER
11 , p_msg_data OUT NOCOPY /* file.sql.39 change */ VARCHAR2
12 , p_result_out OUT NOCOPY /* file.sql.39 change */ VARCHAR2 -- Pass or Fail Credit Check
13 , p_return_status OUT NOCOPY /* file.sql.39 change */ VARCHAR2
14 );
15
16 -- Function to Determine if the Order is Subject to Credit Check
17
18 PROCEDURE Check_Order
19 ( p_header_rec IN OE_Order_PUB.Header_Rec_Type
20 , p_calling_action IN VARCHAR2 := 'BOOKING'
21 , p_check_order_out OUT NOCOPY /* file.sql.39 change */ VARCHAR2
22 , p_credit_rule_out OUT NOCOPY /* file.sql.39 change */ NUMBER
23 , p_credit_check_lvl_out OUT NOCOPY /* file.sql.39 change */ VARCHAR2
24 , p_overall_credit_limit OUT NOCOPY /* file.sql.39 change */ NUMBER
25 , p_trx_credit_limit OUT NOCOPY /* file.sql.39 change */ NUMBER
26 , p_return_status OUT NOCOPY /* file.sql.39 change */ VARCHAR2
27 );
28
29 -- Function to Determine Credit Exposure
30
31 PROCEDURE Check_Exposure
32 ( p_header_rec IN OE_Order_PUB.Header_Rec_Type
33 , p_credit_check_rule_id IN NUMBER := FND_API.G_MISS_NUM
34 , p_credit_level IN VARCHAR2
35 , p_total_exposure OUT NOCOPY /* file.sql.39 change */ NUMBER
36 , p_return_status OUT NOCOPY /* file.sql.39 change */ VARCHAR2
37 );
38
39 -- bug 1830389, new procedures introduced for line level Credit Checking.
40 PROCEDURE Check_Available_Credit_Line
41 ( p_header_id IN NUMBER := FND_API.G_MISS_NUM
42 , p_invoice_to_org_id IN NUMBER := FND_API.G_MISS_NUM
43 , p_calling_action IN VARCHAR2 := 'BOOKING'
44 , p_msg_count OUT NOCOPY /* file.sql.39 change */ NUMBER
45 , p_msg_data OUT NOCOPY /* file.sql.39 change */ VARCHAR2
46 , p_result_out OUT NOCOPY /* file.sql.39 change */ VARCHAR2 -- Pass or Fail Credit Check
47 , p_return_status OUT NOCOPY /* file.sql.39 change */ VARCHAR2
48 );
49
50 -- Function to Determine if the Order is Subject to Credit Check
51
52 PROCEDURE Check_Order_Line
53 ( p_header_rec IN OE_Order_PUB.Header_Rec_Type
54 , p_invoice_to_org_id IN NUMBER
55 , p_customer_id IN NUMBER
56 , p_calling_action IN VARCHAR2 := 'BOOKING'
57 , p_check_order_out OUT NOCOPY /* file.sql.39 change */ VARCHAR2
58 , p_credit_rule_out OUT NOCOPY /* file.sql.39 change */ NUMBER
59 , p_credit_check_lvl_out OUT NOCOPY /* file.sql.39 change */ VARCHAR2
60 , p_overall_credit_limit OUT NOCOPY /* file.sql.39 change */ NUMBER
61 , p_trx_credit_limit OUT NOCOPY /* file.sql.39 change */ NUMBER
62 , p_return_status OUT NOCOPY /* file.sql.39 change */ VARCHAR2
63 );
64
65 -- Function to Determine Credit Exposure
66
67 PROCEDURE Check_Exposure_Line
68 ( p_header_rec IN OE_Order_PUB.Header_Rec_Type
69 , p_invoice_to_org_id IN NUMBER
70 , p_customer_id IN NUMBER
71 , p_credit_check_rule_id IN NUMBER
72 , p_credit_level IN VARCHAR2
73 , p_total_exposure OUT NOCOPY /* file.sql.39 change */ NUMBER
74 , p_return_status OUT NOCOPY /* file.sql.39 change */ VARCHAR2
75 );
76
77 END OE_Credit_PUB;