[Home] [Help]
442: -- conversion to the credit limit currencies
443: -----------------------------------------------------
444: PROCEDURE add_error_currency
445: ( x_error_curr_tbl IN OUT NOCOPY OE_CREDIT_CHECK_UTIL.curr_tbl_type
446: , p_error_currency IN HZ_CREDIT_PROFILE_AMTS.currency_code%TYPE
447: )
448: IS
449: i BINARY_INTEGER;
450: BEGIN
1816: , p_party_id IN NUMBER
1817: , p_org_id IN NUMBER
1818: , p_include_all_flag IN VARCHAR2
1819: , p_usage_curr_tbl IN OE_CREDIT_CHECK_UTIL.curr_tbl_type
1820: , p_limit_curr_code IN HZ_CREDIT_PROFILE_AMTS.currency_code%TYPE
1821: , p_main_bucket IN NUMBER
1822: , p_global_exposure_flag IN VARCHAR2
1823: , p_credit_check_rule_rec IN
1824: OE_CREDIT_CHECK_UTIL.oe_credit_rules_rec_type
1828: IS
1829: i BINARY_INTEGER;
1830: l_site_use_id NUMBER;
1831: l_br_site_use_id NUMBER;
1832: l_currency_code HZ_CREDIT_PROFILE_AMTS.currency_code%TYPE;
1833:
1834: l_balance NUMBER := 0 ;
1835: l_br_balance NUMBER := 0 ;
1836: l_term NUMBER := 0 ;
10326: OE_CREDIT_CHECK_UTIL.oe_credit_rules_rec_type
10327: , p_system_parameters_rec IN
10328: OE_CREDIT_CHECK_UTIL.oe_systems_param_rec_type
10329: , p_limit_curr_code IN
10330: HZ_CREDIT_PROFILE_AMTS.currency_code%TYPE
10331: , p_usage_curr_tbl IN OE_CREDIT_CHECK_UTIL.curr_tbl_type
10332: , p_include_all_flag IN VARCHAR2
10333: , p_global_exposure_flag IN VARCHAR2 := 'N'
10334: , p_need_exposure_details IN VARCHAR2 := 'N'
10343:
10344: i BINARY_INTEGER;
10345: l_site_use_id NUMBER;
10346: l_org_id NUMBER;
10347: l_currency_code HZ_CREDIT_PROFILE_AMTS.currency_code%TYPE;
10348: l_balance NUMBER;
10349: l_term NUMBER;
10350: l_total NUMBER;
10351: