DBA Data[Home] [Help]

APPS.OE_CREDIT_EXPOSURE_PVT dependencies on HZ_CREDIT_PROFILE_AMTS

Line 432: , p_error_currency IN HZ_CREDIT_PROFILE_AMTS.currency_code%TYPE

428: -- conversion to the credit limit currencies
429: -----------------------------------------------------
430: PROCEDURE add_error_currency
431: ( x_error_curr_tbl IN OUT NOCOPY OE_CREDIT_CHECK_UTIL.curr_tbl_type
432: , p_error_currency IN HZ_CREDIT_PROFILE_AMTS.currency_code%TYPE
433: )
434: IS
435: i BINARY_INTEGER;
436: BEGIN

Line 1528: , p_limit_curr_code IN HZ_CREDIT_PROFILE_AMTS.currency_code%TYPE

1524: , p_party_id IN NUMBER
1525: , p_org_id IN NUMBER
1526: , p_include_all_flag IN VARCHAR2
1527: , p_usage_curr_tbl IN OE_CREDIT_CHECK_UTIL.curr_tbl_type
1528: , p_limit_curr_code IN HZ_CREDIT_PROFILE_AMTS.currency_code%TYPE
1529: , p_main_bucket IN NUMBER
1530: , p_global_exposure_flag IN VARCHAR2
1531: , p_credit_check_rule_rec IN
1532: OE_CREDIT_CHECK_UTIL.oe_credit_rules_rec_type

Line 1540: l_currency_code HZ_CREDIT_PROFILE_AMTS.currency_code%TYPE;

1536: IS
1537: i BINARY_INTEGER;
1538: l_site_use_id NUMBER;
1539: l_br_site_use_id NUMBER;
1540: l_currency_code HZ_CREDIT_PROFILE_AMTS.currency_code%TYPE;
1541:
1542: l_balance NUMBER := 0 ;
1543: l_br_balance NUMBER := 0 ;
1544: l_term NUMBER := 0 ;

Line 8304: HZ_CREDIT_PROFILE_AMTS.currency_code%TYPE

8300: OE_CREDIT_CHECK_UTIL.oe_credit_rules_rec_type
8301: , p_system_parameters_rec IN
8302: OE_CREDIT_CHECK_UTIL.oe_systems_param_rec_type
8303: , p_limit_curr_code IN
8304: HZ_CREDIT_PROFILE_AMTS.currency_code%TYPE
8305: , p_usage_curr_tbl IN OE_CREDIT_CHECK_UTIL.curr_tbl_type
8306: , p_include_all_flag IN VARCHAR2
8307: , p_global_exposure_flag IN VARCHAR2 := 'N'
8308: , p_need_exposure_details IN VARCHAR2 := 'N'

Line 8321: l_currency_code HZ_CREDIT_PROFILE_AMTS.currency_code%TYPE;

8317:
8318: i BINARY_INTEGER;
8319: l_site_use_id NUMBER;
8320: l_org_id NUMBER;
8321: l_currency_code HZ_CREDIT_PROFILE_AMTS.currency_code%TYPE;
8322: l_balance NUMBER;
8323: l_term NUMBER;
8324: l_total NUMBER;
8325: