[Home] [Help]
PACKAGE: APPS.HZ_CREDIT_USAGES_PKG
Source
1 PACKAGE HZ_CREDIT_USAGES_PKG AUTHID CURRENT_USER AS
2 /* $Header: ARHUSAGS.pls 115.6 2003/08/18 18:09:04 rajkrish ship $ */
3
4 --======================================================================
5 --CONSTANTS
6 --======================================================================
7 G_PKG_NAME CONSTANT VARCHAR2(30) :='HZ_CREDIT_USAGES_PKG';
8 G_excl_curr_list VARCHAR2(2000);
9
10
11 ----- TYPES
12 TYPE Usage_Curr_Rec IS RECORD
13 ( usage_curr_code HZ_CREDIT_PROFILE_AMTS.currency_code%TYPE );
14
15
16 TYPE CURR_TBL_TYPE IS TABLE OF Usage_Curr_Rec
17 INDEX BY BINARY_INTEGER;
18
19 ---------------------------
20 -- PROCEDURES AND FUNCTIONS
21 ---------------------------
22
23 --========================================================================
24 -- FUNCTION : Check_release PUBLIC
25 -- PARAMETERS:
26
27 -- COMMENT : Function returns 'OLD' if AR Credit Management is not
28 -- installed or not active and returns 'NEW' if AR Credit
29 -- Management is installed and active
30 --========================================================================
31 FUNCTION Check_release
32 RETURN VARCHAR2;
33
34 --========================================================================
35 -- PROCEDURE : Insert_row PUBLIC
36 -- PARAMETERS: p_row_id ROWID of the current record
37 -- p_credit_usage_rule_set_id rule set id
38 -- p_credit_usage_id primary key
39 -- p_credit_profile_amt_id credit_profile_amt_id
40 -- p_cust_acct_profile_amt_id cust_acct_profile_amt_id
41 -- p_profile_class_amt_id profile_class_amt_id
42 -- p_creation_date date, when a record was inserted
43 -- p_created_by userid of the person,who inserted
44 -- a record
45 -- p_last_update_date date, when a record was inserted
46 -- p_last_updated_by userid of the person,who inserted
47 -- a record
48 -- p_last_update_login login of the person,who inserted
49 -- a record
50
51 -- COMMENT : Procedure inserts record into the table HZ_CREDIT_USAGES
52 --========================================================================
53 PROCEDURE Insert_row
54 ( p_row_id OUT NOCOPY VARCHAR2
55 , p_credit_usage_rule_set_id NUMBER
56 , p_credit_usage_id NUMBER
57 , p_credit_profile_amt_id NUMBER
58 , p_cust_acct_profile_amt_id NUMBER
59 , p_profile_class_amt_id NUMBER
60 , p_creation_date DATE
61 , p_created_by NUMBER
62 , p_last_update_date DATE
63 , p_last_updated_by NUMBER
64 , p_last_update_login NUMBER
65 , p_attribute_category VARCHAR2
66 , p_attribute1 VARCHAR2
67 , p_attribute2 VARCHAR2
68 , p_attribute3 VARCHAR2
69 , p_attribute4 VARCHAR2
70 , p_attribute5 VARCHAR2
71 , p_attribute6 VARCHAR2
72 , p_attribute7 VARCHAR2
73 , p_attribute8 VARCHAR2
74 , p_attribute9 VARCHAR2
75 , p_attribute10 VARCHAR2
76 , p_attribute11 VARCHAR2
77 , p_attribute12 VARCHAR2
78 , p_attribute13 VARCHAR2
79 , p_attribute14 VARCHAR2
80 , p_attribute15 VARCHAR2
81 );
82
83
84
85 --========================================================================
86 -- PROCEDURE : Delete_row PUBLIC
87 -- PARAMETERS: p_row_id ROWID of the current record
88 -- COMMENT : Procedure deletes record with ROWID=p_row_id from the
89 -- table HZ_CREDIT_USAGES.
90 --========================================================================
91 PROCEDURE Delete_row
92 ( p_row_id VARCHAR2
93 );
94
95
96 --========================================================================
97 -- PROCEDURE : Lock_row PUBLIC
98 -- PARAMETERS: p_row_id ROWID of the current record
99 -- p_credit_usage_rule_set_id credit_usage_rule_set_id
100 -- p_credit_profile_amt_id
101 -- p_profile_class_amount_id
102 -- p_cust_acct_profile_amt_id
103 --
104 -- COMMENT : Procedure locks current record in the table HZ_CREDIT_USAGES.
105 --========================================================================
106 PROCEDURE Lock_row
107 ( p_row_id VARCHAR2
108 , p_credit_usage_rule_set_id NUMBER
109 , p_credit_profile_amt_id NUMBER
110 , p_profile_class_amount_id NUMBER
111 , p_cust_acct_profile_amt_id NUMBER
112 );
113
114
115 ------------------------------------------------------------------------------
116 -- PROCEDURE : Get_Limit_Currency_usages
117 -- COMMENT : REturns
118 -- a) Limit currency
119 -- b) Credit limits
120 -- c) Associated usage rules
121 ------------------------------------------------------------------------------
122 PROCEDURE Get_Limit_Currency_usages (
123 p_entity_type IN VARCHAR2
124 , p_entity_id IN NUMBER
125 , p_trx_curr_code IN VARCHAR2
126 , x_limit_curr_code OUT NOCOPY VARCHAR2
127 , x_trx_limit OUT NOCOPY NUMBER
128 , x_overall_limit OUT NOCOPY NUMBER
129 , x_cust_acct_profile_amt_id OUT NOCOPY NUMBER
130 , x_global_exposure_flag OUT NOCOPY VARCHAR2
131 , x_include_all_flag OUT NOCOPY VARCHAR2
132 , x_usage_curr_tbl OUT NOCOPY HZ_CREDIT_USAGES_PKG.curr_tbl_type
133 , x_excl_curr_list OUT NOCOPY VARCHAR2
134 ) ;
135
136
137
138 ------------------------------------------------------------------------------
139 -- PROCEDURE : Get_usage_rules
140 -- COMMENT : Returns the Usage currencies associated with a given
141 -- profile amount currency
142 --
143 ------------------------------------------------------------------------------
144 PROCEDURE Get_usage_rules(
145 p_cust_acct_profile_amt_id IN NUMBER
146 ,p_limit_curr_code IN VARCHAR2
147 , x_global_exposure_flag OUT NOCOPY VARCHAR2
148 , x_include_all_flag OUT NOCOPY VARCHAR2
149 , x_usage_curr_tbl OUT NOCOPY HZ_CREDIT_USAGES_PKG.curr_tbl_type
150 , x_excl_curr_list OUT NOCOPY VARCHAR2
151 );
152
153
154 END HZ_CREDIT_USAGES_PKG;