1 PACKAGE OE_CREDIT_CHECK_RPT AUTHID CURRENT_USER AS
2 -- $Header: OEXRCRCS.pls 120.0.12020000.1 2012/06/26 09:16:44 appldev ship $
3 --------------------
4 -- TYPE DECLARATIONS
5 --------------------
6
7 ------------
8 -- CONSTANTS
9 ------------
10
11 -------------------
12 -- PUBLIC VARIABLES
13 -------------------
14
15 ---------------------------
16 -- PROCEDURES AND FUNCTIONS
17 ---------------------------
18
19 --=====================================================================
20 --PROCEDURE: Credit_Check_Processor PUBLIC
21 --
22 --COMMENTS: This is the server pl/sql procedure that perform credit
23 -- checking for a batch of sales orders. It is called by
24 -- the Credit Check Processor report.
25 --=====================================================================
26
27 PROCEDURE Credit_Check_Processor
28 ( p_profile_org_id IN NUMBER DEFAULT NULL
29 , p_cust_prof_class_name_from IN VARCHAR2 DEFAULT NULL
30 , p_cust_prof_class_name_to IN VARCHAR2 DEFAULT NULL
31 , p_party_name_from IN VARCHAR2 DEFAULT NULL
32 , p_party_name_to IN VARCHAR2 DEFAULT NULL
33 , p_cust_acct_number_from IN VARCHAR2 DEFAULT NULL
34 , p_cust_acct_number_to IN VARCHAR2 DEFAULT NULL
35 , p_order_date_from IN DATE DEFAULT NULL
36 , p_order_date_to IN DATE DEFAULT NULL
37 , p_header_id IN NUMBER DEFAULT NULL
38 , p_order_by IN VARCHAR2
39 );
40
41 --========================================================================
42 -- PROCEDURE : Get_unchecked_exposure PUBLIC
43 -- PARAMETERS: p_party_id
44 -- p_customer_id customer ID
45 -- p_site_id bill-to site id
46 -- p_base_currency currency of the current operating unit
47 -- p_usage_curr_tbl table of all unchecked currencies
48 -- x_unchecked_expousre unchecked exposure
49 --
50 -- COMMENT : This procedure calculates unchecked exposure in the
51 -- base currency for any given customer.
52 --
53 --=====================================================================
54 PROCEDURE Get_unchecked_exposure
55 ( p_party_id IN NUMBER DEFAULT NULL
56 , p_customer_id IN NUMBER
57 , p_site_id IN NUMBER
58 , p_base_currency IN VARCHAR2
59 , p_credit_check_rule_id IN NUMBER
60 , x_unchecked_expousre OUT NOCOPY NUMBER
61 , x_return_status OUT NOCOPY VARCHAR2
62 );
63
64
65 --========================================================================
66 -- PROCEDURE : Credit_exposure_report_utils PUBLIC
67 -- PARAMETERS: p_report_by_option
68 -- p_specific_party_id
69 -- p_specific_party_num
70 -- p_party_name_low
71 -- p_party_name_high
72 -- p_party_number_low
73 -- p_party_number_high
74 -- p_prof_class_low customer profile class name from
75 -- p_prof_class_high customer profile class name to
76 -- p_customer_name_low customer name from
77 -- p_customer_name_high customer name to
78 -- p_cust_number_low customer number from
79 -- p_cust_number_high customer number to
80 -- p_cr_check_rule_id credit check rule
81 -- p_report_type report type ('S' for Summary, 'D' for Detail)
82 -- p_org_id
83 --
84 -- COMMENT : This is the main procedure for Credit Exposure Report. It calculates
85 -- exposure and populates temp table OE_CREDIT_EXPOSURE_TMP
86 --
87 --=======================================================================--
88 PROCEDURE Credit_exposure_report_utils
89 ( p_report_by_option IN VARCHAR2 DEFAULT NULL
90 , p_specific_party_id IN NUMBER DEFAULT NULL
91 , p_spec_party_num_id IN NUMBER DEFAULT NULL
92 , p_party_name_low IN VARCHAR2 DEFAULT NULL
93 , p_party_name_high IN VARCHAR2 DEFAULT NULL
94 , p_party_number_low IN VARCHAR2 DEFAULT NULL
95 , p_party_number_high IN VARCHAR2 DEFAULT NULL
96 , p_prof_class_low IN VARCHAR2 DEFAULT NULL
97 , p_prof_class_high IN VARCHAR2 DEFAULT NULL
98 , p_customer_name_low IN VARCHAR2 DEFAULT NULL
99 , p_customer_name_high IN VARCHAR2 DEFAULT NULL
100 , p_cust_number_low IN VARCHAR2 DEFAULT NULL
101 , p_cust_number_high IN VARCHAR2 DEFAULT NULL
102 , p_cr_check_rule_id IN NUMBER
103 , p_org_id IN NUMBER
104 , x_return_status OUT NOCOPY VARCHAR2
105 );
106
107 END OE_CREDIT_CHECK_RPT;