DBA Data[Home] [Help]

APPS.OE_CREDIT_CHECK_UTIL dependencies on HZ_CREDIT_PROFILE_AMTS

Line 70: , limit_curr_code HZ_CREDIT_PROFILE_AMTS.currency_code%TYPE

66:
67: TYPE Items_Limit_Rec IS RECORD
68: ( grouping_id NUMBER
69: , item_category_id HZ_CREDIT_PROFILES.item_category_id%type
70: , limit_curr_code HZ_CREDIT_PROFILE_AMTS.currency_code%TYPE
71: , item_limit HZ_CREDIT_PROFILE_AMTS.trx_credit_limit%TYPE
72: , ctg_line_amount NUMBER
73: );
74:

Line 71: , item_limit HZ_CREDIT_PROFILE_AMTS.trx_credit_limit%TYPE

67: TYPE Items_Limit_Rec IS RECORD
68: ( grouping_id NUMBER
69: , item_category_id HZ_CREDIT_PROFILES.item_category_id%type
70: , limit_curr_code HZ_CREDIT_PROFILE_AMTS.currency_code%TYPE
71: , item_limit HZ_CREDIT_PROFILE_AMTS.trx_credit_limit%TYPE
72: , ctg_line_amount NUMBER
73: );
74:
75:

Line 81: ( usage_curr_code HZ_CREDIT_PROFILE_AMTS.currency_code%TYPE );

77: INDEX BY BINARY_INTEGER;
78:
79:
80: TYPE Usage_Curr_Rec IS RECORD
81: ( usage_curr_code HZ_CREDIT_PROFILE_AMTS.currency_code%TYPE );
82:
83:
84: TYPE CURR_TBL_TYPE IS TABLE OF Usage_Curr_Rec
85: INDEX BY BINARY_INTEGER;

Line 166: HZ_CREDIT_PROFILE_AMTS.currency_code%TYPE

162: , p_entity_id IN NUMBER
163: , p_cust_account_id IN NUMBER
164: , p_party_id IN NUMBER
165: , p_trx_curr_code IN
166: HZ_CREDIT_PROFILE_AMTS.currency_code%TYPE
167: , p_suppress_unused_usages_flag IN VARCHAR2 := 'N'
168: , p_navigate_to_next_level IN VARCHAR2 := 'Y'
169: , p_precalc_exposure_used IN VARCHAR2 := 'N'
170: , x_limit_curr_code OUT NOCOPY

Line 171: HZ_CREDIT_PROFILE_AMTS.currency_code%TYPE

167: , p_suppress_unused_usages_flag IN VARCHAR2 := 'N'
168: , p_navigate_to_next_level IN VARCHAR2 := 'Y'
169: , p_precalc_exposure_used IN VARCHAR2 := 'N'
170: , x_limit_curr_code OUT NOCOPY
171: HZ_CREDIT_PROFILE_AMTS.currency_code%TYPE
172: , x_trx_limit OUT NOCOPY NUMBER
173: , x_overall_limit OUT NOCOPY NUMBER
174: , x_include_all_flag OUT NOCOPY VARCHAR2
175: , x_usage_curr_tbl OUT NOCOPY

Line 195: HZ_CREDIT_PROFILE_AMTS.currency_code%TYPE

191: PROCEDURE Get_Usages (
192: p_entity_type IN VARCHAR2
193: , p_entity_id IN NUMBER
194: , p_limit_curr_code IN
195: HZ_CREDIT_PROFILE_AMTS.currency_code%TYPE
196: , p_suppress_unused_usages_flag IN VARCHAR2 := 'N'
197: , p_default_limit_flag IN VARCHAR2 := 'N'
198: , p_global_exposure_flag IN VARCHAR2 := 'N'
199: , x_include_all_flag OUT NOCOPY VARCHAR2