DBA Data[Home] [Help]

APPS.OE_CREDIT_CHECK_UTIL dependencies on HZ_CREDIT_PROFILE_AMTS

Line 82: , limit_curr_code HZ_CREDIT_PROFILE_AMTS.currency_code%TYPE

78:
79: TYPE Items_Limit_Rec IS RECORD
80: ( grouping_id NUMBER
81: , item_category_id HZ_CREDIT_PROFILES.item_category_id%type
82: , limit_curr_code HZ_CREDIT_PROFILE_AMTS.currency_code%TYPE
83: , item_limit HZ_CREDIT_PROFILE_AMTS.trx_credit_limit%TYPE
84: , ctg_line_amount NUMBER
85: );
86:

Line 83: , item_limit HZ_CREDIT_PROFILE_AMTS.trx_credit_limit%TYPE

79: TYPE Items_Limit_Rec IS RECORD
80: ( grouping_id NUMBER
81: , item_category_id HZ_CREDIT_PROFILES.item_category_id%type
82: , limit_curr_code HZ_CREDIT_PROFILE_AMTS.currency_code%TYPE
83: , item_limit HZ_CREDIT_PROFILE_AMTS.trx_credit_limit%TYPE
84: , ctg_line_amount NUMBER
85: );
86:
87:

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

89: INDEX BY BINARY_INTEGER;
90:
91:
92: TYPE Usage_Curr_Rec IS RECORD
93: ( usage_curr_code HZ_CREDIT_PROFILE_AMTS.currency_code%TYPE );
94:
95:
96: TYPE CURR_TBL_TYPE IS TABLE OF Usage_Curr_Rec
97: INDEX BY BINARY_INTEGER;

Line 185: HZ_CREDIT_PROFILE_AMTS.currency_code%TYPE

181: , p_entity_id IN NUMBER
182: , p_cust_account_id IN NUMBER
183: , p_party_id IN NUMBER
184: , p_trx_curr_code IN
185: HZ_CREDIT_PROFILE_AMTS.currency_code%TYPE
186: , p_suppress_unused_usages_flag IN VARCHAR2 := 'N'
187: , p_navigate_to_next_level IN VARCHAR2 := 'Y'
188: , p_precalc_exposure_used IN VARCHAR2 := 'N'
189: , x_limit_curr_code OUT NOCOPY

Line 190: HZ_CREDIT_PROFILE_AMTS.currency_code%TYPE

186: , p_suppress_unused_usages_flag IN VARCHAR2 := 'N'
187: , p_navigate_to_next_level IN VARCHAR2 := 'Y'
188: , p_precalc_exposure_used IN VARCHAR2 := 'N'
189: , x_limit_curr_code OUT NOCOPY
190: HZ_CREDIT_PROFILE_AMTS.currency_code%TYPE
191: , x_trx_limit OUT NOCOPY NUMBER
192: , x_overall_limit OUT NOCOPY NUMBER
193: , x_include_all_flag OUT NOCOPY VARCHAR2
194: , x_usage_curr_tbl OUT NOCOPY

Line 214: HZ_CREDIT_PROFILE_AMTS.currency_code%TYPE

210: PROCEDURE Get_Usages (
211: p_entity_type IN VARCHAR2
212: , p_entity_id IN NUMBER
213: , p_limit_curr_code IN
214: HZ_CREDIT_PROFILE_AMTS.currency_code%TYPE
215: , p_suppress_unused_usages_flag IN VARCHAR2 := 'N'
216: , p_default_limit_flag IN VARCHAR2 := 'N'
217: , p_global_exposure_flag IN VARCHAR2 := 'N'
218: , x_include_all_flag OUT NOCOPY VARCHAR2