[Home] [Help]
PACKAGE: APPS.OE_CREDIT_CHECK_PVT
Source
1 PACKAGE OE_Credit_Check_PVT AS
2 -- $Header: OEXVCRCS.pls 120.0 2005/06/01 01:52:17 appldev noship $
3
4 --------------------
5 -- TYPE DECLARATIONS
6 --------------------
7
8 ------------
9 -- CONSTANTS
10 ------------
11
12 -------------------
13 -- PUBLIC VARIABLES
14 -------------------
15
16 ---------------------------
17 -- PROCEDURES AND FUNCTIONS
18 ---------------------------
19
20 ------------------------------------------------------------------------------
21 -- PROCEDURE : Get_Limit_Info PUBLIC
22 -- COMMENT : Returns the credit limit info of a customer or a site
23 -- PARAMETER LIST :
24 -- IN
25 -- p_header_id
26 -- p_entity_type
27 -- p_entity_id
28 -- p_trx_curr_code
29 -- p_include_all_flag
30 -- p_suppress_unused_usages_flag
31 --
32 -- OUT
33 --
34 -- x_limit_curr_code
35 -- x_trx_limit
36 -- x_overall_limit
37 -- x_default_limit_flag
38 -- x_credit_check_flag
39 -- x_include all flag
40 -- x_item_limits_tbl
41 -- x_usage_curr_tbl
42
43
44 -- PRE-CONDITIONS : None
45 -- POST-CONDITIONS : None
46 -- EXCEPTIONS : None
47 ------------------------------------------------------------------------------
48 PROCEDURE get_limit_info (
49 p_header_id IN NUMBER
50 , p_entity_type IN VARCHAR2
51 , p_entity_id IN NUMBER
52 , p_trx_curr_code IN
53 HZ_CREDIT_PROFILE_AMTS.currency_code%TYPE
54 , p_suppress_unused_usages_flag IN VARCHAR2 DEFAULT 'Y'
55 , x_limit_curr_code OUT NOCOPY
56
57 HZ_CREDIT_PROFILE_AMTS.currency_code%TYPE
58 , x_trx_limit OUT NOCOPY NUMBER
59
60 , x_overall_limit OUT NOCOPY NUMBER
61
62 , x_credit_check_flag OUT NOCOPY VARCHAR2
63
64 , x_include_all_flag OUT NOCOPY VARCHAR2
65
66 , x_usage_curr_tbl OUT NOCOPY
67
68 OE_CREDIT_CHECK_GLOBALS.usage_curr_tbl_type
69 , x_default_limit_flag OUT NOCOPY VARCHAR2
70
71 );
72
73
74
75 ------------------------------------------------------------------------------
76 -- PROCEDURE : Get_Usages PUBLIC
77 -- COMMENT : Returns the Usages
78 --
79 -- PARAMETER LIST :
80 -- IN
81 -- p_entity_type
82 -- p_entity_id
83 -- p_limit_curr_code
84 -- p_suppress_unused_usages_flag
85 --
86 -- OUT
87 --
88
89 -- x_include all flag
90 -- x_usage_curr_tbl
91
92
93 -- PRE-CONDITIONS : None
94 -- POST-CONDITIONS : None
95 -- EXCEPTIONS : None
96 ------------------------------------------------------------------------------
97 PROCEDURE Get_Usages (
98 p_entity_type IN VARCHAR2
99 , p_entity_id IN NUMBER
100 , p_limit_curr_code IN
101 HZ_CREDIT_PROFILE_AMTS.currency_code%TYPE
102 , p_suppress_unused_usages_flag IN VARCHAR2 DEFAULT 'Y'
103 , p_default_limit_flag IN VARCHAR2 DEFAULT 'N'
104 , x_include_all_flag OUT NOCOPY VARCHAR2
105
106 , x_usage_curr_tbl OUT NOCOPY
107
108 OE_CREDIT_CHECK_GLOBALS.usage_curr_tbl_type
109 );
110
111
112 -----------------------------------------------------------------------------
113 -- PROCEDURE : GET_Item_Limit PUBLIC
114 -- COMMENT : Returns the limit associated with the Items.
115 --
116 ------------------------------------------------------------------------------
117 PROCEDURE GET_Item_Limit
118 ( p_header_id IN NUMBER
119 , p_trx_curr_code IN VARCHAR2
120 , p_site_use_id IN NUMBER
121 , x_item_limits_tbl OUT NOCOPY
122
123 OE_CREDIT_CHECK_GLOBALS.item_limits_tbl_type
124 , x_lines_tbl OUT NOCOPY OE_CREDIT_CHECK_GLOBALS.lines_Rec_tbl_type
125
126 );
127
128
129 --========================================================================
130 -- PROCEDURE : Currency_List
131 -- Comments : This procedure is used by the credit snapshot report to derive
132 -- a comma delimited string of currencies defined in credit usage
133 -- Parameters: c_entity_type IN 'CUSTOMER' or 'SITE'
134 -- c_entity_id IN Customer_Id or Site_Id
135 -- c_trx_curr_code IN Transaction Currency
136 -- l_limit_curr_code OUT Currency Limit used for credit checking
137 -- Curr_list OUT Comma delimited string of currencies
138 -- covered by limit currency code
139 --========================================================================
140 PROCEDURE Currency_List(
141 c_entity_type IN VARCHAR2
142 , c_entity_id IN NUMBER
143 , c_trx_curr_code IN VARCHAR2
144 , l_limit_curr_code OUT NOCOPY VARCHAR2
145
146 , l_default_limit_flag OUT NOCOPY VARCHAR2
147
148 , Curr_list OUT NOCOPY VARCHAR2
149
150 );
151
152
153
154 END OE_Credit_Check_PVT;