eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.OE_CREDIT_EXPOSURE_PVT dependencies on OE_CREDIT_CHECK_UTIL

Line 47: NVL(oe_credit_check_util.check_debug_flag , 'N' ) ;

43: -- CONSTANTS
44: --===================
45: G_PKG_NAME CONSTANT VARCHAR2(30) := 'OE_CREDIT_EXPOSURE_PVT';
46: G_debug_flag VARCHAR2(1) :=
47: NVL(oe_credit_check_util.check_debug_flag , 'N' ) ;
48: --===================
49: -- GLOBAL VARIABLES
50: --===================
51: b1 NUMBER;

Line 102: g_error_curr_tbl OE_CREDIT_CHECK_UTIL.curr_tbl_type;

98: b47 NUMBER;
99: b48 NUMBER;
100: --TaxER end
101:
102: g_error_curr_tbl OE_CREDIT_CHECK_UTIL.curr_tbl_type;
103: g_conversion_type OE_Credit_Check_Rules.conversion_type%TYPE;
104: g_functional_currency FND_CURRENCIES.Currency_code%TYPE;
105: g_use_party_hierarchy VARCHAR2(1) ;
106:

Line 140: OE_CREDIT_CHECK_UTIL.OE_credit_rules_rec_type

136: ( p_customer_id IN NUMBER
137: , p_site_use_id IN NUMBER
138: , p_party_id IN NUMBER
139: , p_credit_check_rule_rec IN
140: OE_CREDIT_CHECK_UTIL.OE_credit_rules_rec_type
141: , p_credit_level IN VARCHAR2
142: , p_usage_curr IN oe_credit_check_util.curr_tbl_type
143: , p_include_all_flag IN VARCHAR2
144: , p_global_exposure_flag IN VARCHAR2 := 'N'

Line 142: , p_usage_curr IN oe_credit_check_util.curr_tbl_type

138: , p_party_id IN NUMBER
139: , p_credit_check_rule_rec IN
140: OE_CREDIT_CHECK_UTIL.OE_credit_rules_rec_type
141: , p_credit_level IN VARCHAR2
142: , p_usage_curr IN oe_credit_check_util.curr_tbl_type
143: , p_include_all_flag IN VARCHAR2
144: , p_global_exposure_flag IN VARCHAR2 := 'N'
145: , p_org_id IN NUMBER
146: , x_exist_flag OUT NOCOPY VARCHAR2

Line 195: OE_CREDIT_CHECK_UTIL.G_hierarchy_type

191: and hn.child_object_type = 'ORGANIZATION'
192: and hn.effective_start_date <= sysdate
193: and hn.effective_end_date >= SYSDATE
194: and hn.hierarchy_type =
195: OE_CREDIT_CHECK_UTIL.G_hierarchy_type
196: AND oes.party_id = hn.child_id
197: AND oes.currency_code = p_curr_code
198: AND oes.bucket <= l_jdate
199: AND oes.balance_type = 20

Line 251: OE_CREDIT_CHECK_UTIL.G_hierarchy_type

247: and hn.child_object_type = 'ORGANIZATION'
248: and hn.effective_start_date <= sysdate
249: and hn.effective_end_date >= SYSDATE
250: and hn.hierarchy_type =
251: OE_CREDIT_CHECK_UTIL.G_hierarchy_type
252: AND oes.party_id = hn.child_id
253: AND oes.bucket <= l_jdate
254: AND oes.balance_type = 20
255: AND oes.bucket_duration = 1;

Line 445: ( x_error_curr_tbl IN OUT NOCOPY OE_CREDIT_CHECK_UTIL.curr_tbl_type

441: -- used for storing the currencies that failed the
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;

Line 523: ( p_credit_check_rule_rec IN OE_CREDIT_CHECK_UTIL.oe_credit_rules_rec_type

519: END open_date;
520:
521:
522: PROCEDURE balance_types_om_and_ar
523: ( p_credit_check_rule_rec IN OE_CREDIT_CHECK_UTIL.oe_credit_rules_rec_type
524: )
525: IS
526: BEGIN
527: b1 := -1;

Line 865: (p_credit_check_rule_rec IN OE_CREDIT_CHECK_UTIL.oe_credit_rules_rec_type

861: -- balance types
862: -----------------------------------------------------------
863:
864: PROCEDURE balance_types_om_nohold
865: (p_credit_check_rule_rec IN OE_CREDIT_CHECK_UTIL.oe_credit_rules_rec_type
866: )
867: IS
868: BEGIN
869: b1 := -1;

Line 1049: (p_credit_check_rule_rec IN OE_CREDIT_CHECK_UTIL.oe_credit_rules_rec_type

1045: END balance_types_om_nohold;
1046: ---------------------------------------------------------------
1047:
1048: PROCEDURE balance_types_om_hold
1049: (p_credit_check_rule_rec IN OE_CREDIT_CHECK_UTIL.oe_credit_rules_rec_type
1050: )
1051: IS
1052: BEGIN
1053: b1 := -1;

Line 1258: ( p_credit_check_rule_rec IN OE_CREDIT_CHECK_UTIL.oe_credit_rules_rec_type

1254: END IF;
1255: END balance_types_om_hold;
1256:
1257: PROCEDURE balance_types_om
1258: ( p_credit_check_rule_rec IN OE_CREDIT_CHECK_UTIL.oe_credit_rules_rec_type
1259: )
1260: IS
1261: BEGIN
1262: b1 := -1;

Line 1566: ( p_credit_check_rule_rec IN OE_CREDIT_CHECK_UTIL.oe_credit_rules_rec_type

1562: -- This procedure will set the balance types for the
1563: -- AR exposure based on the credit check rules setup
1564: ----------------------------------------------------------
1565: PROCEDURE balance_types_ar
1566: ( p_credit_check_rule_rec IN OE_CREDIT_CHECK_UTIL.oe_credit_rules_rec_type
1567: )
1568: IS
1569: BEGIN
1570: b1 := -1;

Line 1783: OE_CREDIT_CHECK_UTIL.convert_currency_amount

1779: l_term NUMBER;
1780: BEGIN
1781: BEGIN
1782: l_term :=
1783: OE_CREDIT_CHECK_UTIL.convert_currency_amount
1784: ( p_amount => p_amount
1785: , p_transactional_currency => p_transactional_currency
1786: , p_limit_currency => p_limit_currency
1787: , p_functional_currency => g_functional_currency

Line 1819: , p_usage_curr_tbl IN OE_CREDIT_CHECK_UTIL.curr_tbl_type

1815: , p_customer_id IN NUMBER
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

Line 1824: OE_CREDIT_CHECK_UTIL.oe_credit_rules_rec_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
1825: , x_error_curr_tbl IN OUT NOCOPY OE_CREDIT_CHECK_UTIL.curr_tbl_type
1826: )
1827: RETURN NUMBER
1828: IS

Line 1825: , x_error_curr_tbl IN OUT NOCOPY OE_CREDIT_CHECK_UTIL.curr_tbl_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
1825: , x_error_curr_tbl IN OUT NOCOPY OE_CREDIT_CHECK_UTIL.curr_tbl_type
1826: )
1827: RETURN NUMBER
1828: IS
1829: i BINARY_INTEGER;

Line 2150: = OE_CREDIT_CHECK_UTIL.G_hierarchy_type

2146: and hn.child_object_type = 'ORGANIZATION'
2147: and hn.effective_start_date <= sysdate
2148: and hn.effective_end_date >= SYSDATE
2149: and hn.hierarchy_type
2150: = OE_CREDIT_CHECK_UTIL.G_hierarchy_type
2151: AND oes.party_id = hn.child_id
2152: AND oes.currency_code = l_currency_code
2153: AND oes.bucket = l_bucket
2154: AND oes.bucket_duration = l_bucket_length

Line 2176: = OE_CREDIT_CHECK_UTIL.G_hierarchy_type

2172: and hn.child_object_type = 'ORGANIZATION'
2173: and hn.effective_start_date <= sysdate
2174: and hn.effective_end_date >= SYSDATE
2175: and hn.hierarchy_type
2176: = OE_CREDIT_CHECK_UTIL.G_hierarchy_type
2177: AND oes.party_id = hn.child_id
2178: AND oes.currency_code = l_currency_code
2179: AND oes.bucket = l_bucket
2180: AND oes.bucket_duration = l_bucket_length

Line 2198: = OE_CREDIT_CHECK_UTIL.G_hierarchy_type

2194: and hn.child_object_type = 'ORGANIZATION'
2195: and hn.effective_start_date <= sysdate
2196: and hn.effective_end_date >= SYSDATE
2197: and hn.hierarchy_type
2198: = OE_CREDIT_CHECK_UTIL.G_hierarchy_type
2199: AND oes.party_id = hn.child_id
2200: AND oes.currency_code = l_currency_code
2201: AND oes.bucket < l_bucket
2202: AND oes.bucket_duration = l_bucket_length

Line 2223: = OE_CREDIT_CHECK_UTIL.G_hierarchy_type

2219: and hn.child_object_type = 'ORGANIZATION'
2220: and hn.effective_start_date <= sysdate
2221: and hn.effective_end_date >= SYSDATE
2222: and hn.hierarchy_type
2223: = OE_CREDIT_CHECK_UTIL.G_hierarchy_type
2224: AND oes.party_id = hn.child_id
2225: AND oes.currency_code = l_currency_code
2226: AND oes.bucket < l_bucket
2227: AND oes.bucket_duration = l_bucket_length

Line 2244: = OE_CREDIT_CHECK_UTIL.G_hierarchy_type

2240: and hn.child_object_type = 'ORGANIZATION'
2241: and hn.effective_start_date <= sysdate
2242: and hn.effective_end_date >= SYSDATE
2243: and hn.hierarchy_type
2244: = OE_CREDIT_CHECK_UTIL.G_hierarchy_type
2245: AND oes.party_id = hn.child_id
2246: AND oes.currency_code = l_currency_code
2247: AND oes.bucket < l_br_bucket
2248: AND oes.bucket_duration = l_br_bucket_length

Line 2583: = OE_CREDIT_CHECK_UTIL.G_hierarchy_type

2579: and hn.child_object_type = 'ORGANIZATION'
2580: and hn.effective_start_date <= sysdate
2581: and hn.effective_end_date >= SYSDATE
2582: and hn.hierarchy_type
2583: = OE_CREDIT_CHECK_UTIL.G_hierarchy_type
2584: AND oes.party_id = hn.child_id
2585: AND oes.bucket = l_bucket
2586: AND oes.bucket_duration = l_bucket_length
2587: GROUP BY oes.currency_code

Line 2609: = OE_CREDIT_CHECK_UTIL.G_hierarchy_type

2605: and hn.child_object_type = 'ORGANIZATION'
2606: and hn.effective_start_date <= sysdate
2607: and hn.effective_end_date >= SYSDATE
2608: and hn.hierarchy_type
2609: = OE_CREDIT_CHECK_UTIL.G_hierarchy_type
2610: AND oes.party_id = hn.child_id
2611: AND oes.bucket = l_bucket
2612: AND oes.bucket_duration = l_bucket_length
2613: GROUP BY oes.currency_code

Line 2631: = OE_CREDIT_CHECK_UTIL.G_hierarchy_type

2627: and hn.child_object_type = 'ORGANIZATION'
2628: and hn.effective_start_date <= sysdate
2629: and hn.effective_end_date >= SYSDATE
2630: and hn.hierarchy_type
2631: = OE_CREDIT_CHECK_UTIL.G_hierarchy_type
2632: AND oes.party_id = hn.child_id
2633: AND oes.bucket < l_bucket
2634: AND oes.bucket_duration = l_bucket_length
2635: GROUP BY oes.currency_code

Line 2657: = OE_CREDIT_CHECK_UTIL.G_hierarchy_type

2653: and hn.child_object_type = 'ORGANIZATION'
2654: and hn.effective_start_date <= sysdate
2655: and hn.effective_end_date >= SYSDATE
2656: and hn.hierarchy_type
2657: = OE_CREDIT_CHECK_UTIL.G_hierarchy_type
2658: AND oes.party_id = hn.child_id
2659: AND oes.bucket < l_bucket
2660: AND oes.bucket_duration = l_bucket_length
2661: GROUP BY oes.currency_code

Line 2678: = OE_CREDIT_CHECK_UTIL.G_hierarchy_type

2674: and hn.child_object_type = 'ORGANIZATION'
2675: and hn.effective_start_date <= sysdate
2676: and hn.effective_end_date >= SYSDATE
2677: and hn.hierarchy_type
2678: = OE_CREDIT_CHECK_UTIL.G_hierarchy_type
2679: AND oes.party_id = hn.child_id
2680: AND oes.bucket < l_br_bucket
2681: AND oes.bucket_duration = l_br_bucket_length
2682: GROUP BY oes.currency_code

Line 2788: oe_credit_check_util.get_drawee_site_use_id ( p_site_use_id);

2784:
2785: IF p_credit_check_rule_rec.open_ar_balance_flag = 'Y'
2786: THEN
2787: l_br_site_use_id :=
2788: oe_credit_check_util.get_drawee_site_use_id ( p_site_use_id);
2789: END IF;
2790:
2791: IF b8 = G_INVOICES
2792: THEN

Line 2872: OE_CREDIT_CHECK_UTIL.CONVERT_CURRENCY_AMOUNT

2868: END IF;
2869:
2870: BEGIN
2871: l_term :=
2872: OE_CREDIT_CHECK_UTIL.CONVERT_CURRENCY_AMOUNT
2873: ( p_amount => l_balance
2874: , p_transactional_currency => l_currency_code
2875: , p_limit_currency => p_limit_curr_code
2876: , p_functional_currency => g_functional_currency

Line 2938: IF ( NVL(INSTRB(OE_CREDIT_CHECK_UTIL.G_excl_curr_list,

2934: || l_bucket || '/' || l_bucket_length, 2 );
2935: END IF;
2936:
2937:
2938: IF ( NVL(INSTRB(OE_CREDIT_CHECK_UTIL.G_excl_curr_list,
2939: l_currency_code ,1,1),0) = 0 )
2940: OR
2941: ((NVL(INSTRB(OE_CREDIT_CHECK_UTIL.G_excl_curr_list,
2942: l_currency_code ,1,1),0) > 0 )

Line 2941: ((NVL(INSTRB(OE_CREDIT_CHECK_UTIL.G_excl_curr_list,

2937:
2938: IF ( NVL(INSTRB(OE_CREDIT_CHECK_UTIL.G_excl_curr_list,
2939: l_currency_code ,1,1),0) = 0 )
2940: OR
2941: ((NVL(INSTRB(OE_CREDIT_CHECK_UTIL.G_excl_curr_list,
2942: l_currency_code ,1,1),0) > 0 )
2943: AND ( l_currency_code = p_limit_curr_code )
2944: )
2945: THEN

Line 2948: OE_CREDIT_CHECK_UTIL.CONVERT_CURRENCY_AMOUNT

2944: )
2945: THEN
2946: BEGIN
2947: l_term :=
2948: OE_CREDIT_CHECK_UTIL.CONVERT_CURRENCY_AMOUNT
2949: ( p_amount => l_balance
2950: , p_transactional_currency => l_currency_code
2951: , p_limit_currency => p_limit_curr_code
2952: , p_functional_currency => g_functional_currency

Line 3006: IF ( NVL(INSTRB(OE_CREDIT_CHECK_UTIL.G_excl_curr_list,

3002: || l_bucket || '/' || l_bucket_length, 2 );
3003: END IF;
3004:
3005:
3006: IF ( NVL(INSTRB(OE_CREDIT_CHECK_UTIL.G_excl_curr_list,
3007: l_currency_code ,1,1),0) = 0 )
3008: OR
3009: ((NVL(INSTRB(OE_CREDIT_CHECK_UTIL.G_excl_curr_list,
3010: l_currency_code ,1,1),0) > 0 )

Line 3009: ((NVL(INSTRB(OE_CREDIT_CHECK_UTIL.G_excl_curr_list,

3005:
3006: IF ( NVL(INSTRB(OE_CREDIT_CHECK_UTIL.G_excl_curr_list,
3007: l_currency_code ,1,1),0) = 0 )
3008: OR
3009: ((NVL(INSTRB(OE_CREDIT_CHECK_UTIL.G_excl_curr_list,
3010: l_currency_code ,1,1),0) > 0 )
3011: AND ( l_currency_code = p_limit_curr_code )
3012: )
3013: THEN

Line 3016: OE_CREDIT_CHECK_UTIL.CONVERT_CURRENCY_AMOUNT

3012: )
3013: THEN
3014: BEGIN
3015: l_term :=
3016: OE_CREDIT_CHECK_UTIL.CONVERT_CURRENCY_AMOUNT
3017: ( p_amount => l_balance
3018: , p_transactional_currency => l_currency_code
3019: , p_limit_currency => p_limit_curr_code
3020: , p_functional_currency => g_functional_currency

Line 3053: oe_credit_check_util.get_drawee_site_use_id ( p_site_use_id);

3049: ---------------------start BR -------------------
3050: IF p_credit_check_rule_rec.open_ar_balance_flag = 'Y'
3051: THEN
3052: l_br_site_use_id :=
3053: oe_credit_check_util.get_drawee_site_use_id ( p_site_use_id);
3054: END IF;
3055:
3056: IF l_br_site_use_id IS NOT NULL
3057: AND b8 = G_INVOICES

Line 3082: IF ( NVL(INSTRB(OE_CREDIT_CHECK_UTIL.G_excl_curr_list,

3078: || l_br_balance || ' and bucket/length '
3079: || l_bucket || '/' || l_bucket_length, 2 );
3080: END IF;
3081:
3082: IF ( NVL(INSTRB(OE_CREDIT_CHECK_UTIL.G_excl_curr_list,
3083: l_currency_code ,1,1),0) = 0 )
3084: OR
3085: ((NVL(INSTRB(OE_CREDIT_CHECK_UTIL.G_excl_curr_list,
3086: l_currency_code ,1,1),0) > 0 )

Line 3085: ((NVL(INSTRB(OE_CREDIT_CHECK_UTIL.G_excl_curr_list,

3081:
3082: IF ( NVL(INSTRB(OE_CREDIT_CHECK_UTIL.G_excl_curr_list,
3083: l_currency_code ,1,1),0) = 0 )
3084: OR
3085: ((NVL(INSTRB(OE_CREDIT_CHECK_UTIL.G_excl_curr_list,
3086: l_currency_code ,1,1),0) > 0 )
3087: AND ( l_currency_code = p_limit_curr_code )
3088: )
3089: THEN

Line 3092: OE_CREDIT_CHECK_UTIL.CONVERT_CURRENCY_AMOUNT

3088: )
3089: THEN
3090: BEGIN
3091: l_term :=
3092: OE_CREDIT_CHECK_UTIL.CONVERT_CURRENCY_AMOUNT
3093: ( p_amount => l_br_balance
3094: , p_transactional_currency => l_currency_code
3095: , p_limit_currency => p_limit_curr_code
3096: , p_functional_currency => g_functional_currency

Line 3152: IF ( NVL(INSTRB(OE_CREDIT_CHECK_UTIL.G_excl_curr_list,

3148: || l_balance || ' and bucket/length ' || l_bucket
3149: || '/' || l_bucket_length, 2 );
3150: END IF;
3151:
3152: IF ( NVL(INSTRB(OE_CREDIT_CHECK_UTIL.G_excl_curr_list,
3153: l_currency_code ,1,1),0) = 0 )
3154: OR
3155: ((NVL(INSTRB(OE_CREDIT_CHECK_UTIL.G_excl_curr_list,
3156: l_currency_code ,1,1),0) > 0 )

Line 3155: ((NVL(INSTRB(OE_CREDIT_CHECK_UTIL.G_excl_curr_list,

3151:
3152: IF ( NVL(INSTRB(OE_CREDIT_CHECK_UTIL.G_excl_curr_list,
3153: l_currency_code ,1,1),0) = 0 )
3154: OR
3155: ((NVL(INSTRB(OE_CREDIT_CHECK_UTIL.G_excl_curr_list,
3156: l_currency_code ,1,1),0) > 0 )
3157: AND ( l_currency_code = p_limit_curr_code )
3158: )
3159: THEN

Line 3162: OE_CREDIT_CHECK_UTIL.CONVERT_CURRENCY_AMOUNT

3158: )
3159: THEN
3160: BEGIN
3161: l_term :=
3162: OE_CREDIT_CHECK_UTIL.CONVERT_CURRENCY_AMOUNT
3163: ( p_amount => l_balance
3164: , p_transactional_currency => l_currency_code
3165: , p_limit_currency => p_limit_curr_code
3166: , p_functional_currency => g_functional_currency

Line 3210: IF ( NVL(INSTRB(OE_CREDIT_CHECK_UTIL.G_excl_curr_list,

3206: || l_balance || ' and bucket/length ' || l_bucket
3207: || '/' || l_bucket_length, 2 );
3208: END IF;
3209:
3210: IF ( NVL(INSTRB(OE_CREDIT_CHECK_UTIL.G_excl_curr_list,
3211: l_currency_code ,1,1),0) = 0 )
3212: OR
3213: ((NVL(INSTRB(OE_CREDIT_CHECK_UTIL.G_excl_curr_list,
3214: l_currency_code ,1,1),0) > 0 )

Line 3213: ((NVL(INSTRB(OE_CREDIT_CHECK_UTIL.G_excl_curr_list,

3209:
3210: IF ( NVL(INSTRB(OE_CREDIT_CHECK_UTIL.G_excl_curr_list,
3211: l_currency_code ,1,1),0) = 0 )
3212: OR
3213: ((NVL(INSTRB(OE_CREDIT_CHECK_UTIL.G_excl_curr_list,
3214: l_currency_code ,1,1),0) > 0 )
3215: AND ( l_currency_code = p_limit_curr_code )
3216: )
3217: THEN

Line 3220: OE_CREDIT_CHECK_UTIL.CONVERT_CURRENCY_AMOUNT

3216: )
3217: THEN
3218: BEGIN
3219: l_term :=
3220: OE_CREDIT_CHECK_UTIL.CONVERT_CURRENCY_AMOUNT
3221: ( p_amount => l_balance
3222: , p_transactional_currency => l_currency_code
3223: , p_limit_currency => p_limit_curr_code
3224: , p_functional_currency => g_functional_currency

Line 3322: OE_CREDIT_CHECK_UTIL.CONVERT_CURRENCY_AMOUNT

3318: || ' currency with BR balance ' || l_br_balance, 2 );
3319: END IF;
3320: BEGIN
3321: l_term :=
3322: OE_CREDIT_CHECK_UTIL.CONVERT_CURRENCY_AMOUNT
3323: ( p_amount => l_balance +
3324: NVL(l_br_balance,0)
3325: , p_transactional_currency => l_currency_code
3326: , p_limit_currency => p_limit_curr_code

Line 3377: OE_CREDIT_CHECK_UTIL.CONVERT_CURRENCY_AMOUNT

3373: || ' currency with balance ' || l_balance, 2 );
3374: END IF;
3375: BEGIN
3376: l_term :=
3377: OE_CREDIT_CHECK_UTIL.CONVERT_CURRENCY_AMOUNT
3378: ( p_amount => l_balance
3379: , p_transactional_currency => l_currency_code
3380: , p_limit_currency => p_limit_curr_code
3381: , p_functional_currency => g_functional_currency

Line 3447: OE_CREDIT_CHECK_UTIL.CONVERT_CURRENCY_AMOUNT

3443: END IF;
3444:
3445: BEGIN
3446: l_term :=
3447: OE_CREDIT_CHECK_UTIL.CONVERT_CURRENCY_AMOUNT
3448: ( p_amount => l_balance +
3449: NVL(l_br_balance,0)
3450: , p_transactional_currency => l_currency_code
3451: , p_limit_currency => p_limit_curr_code

Line 3503: OE_CREDIT_CHECK_UTIL.CONVERT_CURRENCY_AMOUNT

3499: END IF;
3500:
3501: BEGIN
3502: l_term :=
3503: OE_CREDIT_CHECK_UTIL.CONVERT_CURRENCY_AMOUNT
3504: ( p_amount => l_balance
3505: , p_transactional_currency => l_currency_code
3506: , p_limit_currency => p_limit_curr_code
3507: , p_functional_currency => g_functional_currency

Line 3578: IF ( NVL(INSTRB(OE_CREDIT_CHECK_UTIL.G_excl_curr_list,

3574: || l_balance || ' and bucket/length '
3575: || l_bucket || '/' || l_bucket_length, 2 );
3576: END IF;
3577:
3578: IF ( NVL(INSTRB(OE_CREDIT_CHECK_UTIL.G_excl_curr_list,
3579: l_currency_code ,1,1),0) = 0 )
3580: OR
3581: ((NVL(INSTRB(OE_CREDIT_CHECK_UTIL.G_excl_curr_list,
3582: l_currency_code ,1,1),0) > 0 )

Line 3581: ((NVL(INSTRB(OE_CREDIT_CHECK_UTIL.G_excl_curr_list,

3577:
3578: IF ( NVL(INSTRB(OE_CREDIT_CHECK_UTIL.G_excl_curr_list,
3579: l_currency_code ,1,1),0) = 0 )
3580: OR
3581: ((NVL(INSTRB(OE_CREDIT_CHECK_UTIL.G_excl_curr_list,
3582: l_currency_code ,1,1),0) > 0 )
3583: AND ( l_currency_code = p_limit_curr_code )
3584: )
3585: THEN

Line 3588: OE_CREDIT_CHECK_UTIL.CONVERT_CURRENCY_AMOUNT

3584: )
3585: THEN
3586: BEGIN
3587: l_term :=
3588: OE_CREDIT_CHECK_UTIL.CONVERT_CURRENCY_AMOUNT
3589: ( p_amount => l_balance
3590: , p_transactional_currency => l_currency_code
3591: , p_limit_currency => p_limit_curr_code
3592: , p_functional_currency => g_functional_currency

Line 3633: IF ( NVL(INSTRB(OE_CREDIT_CHECK_UTIL.G_excl_curr_list,

3629: || l_balance || ' and bucket/length '
3630: || l_bucket || '/' || l_bucket_length, 2 );
3631: END IF;
3632:
3633: IF ( NVL(INSTRB(OE_CREDIT_CHECK_UTIL.G_excl_curr_list,
3634: l_currency_code ,1,1),0) = 0 )
3635: OR
3636: ((NVL(INSTRB(OE_CREDIT_CHECK_UTIL.G_excl_curr_list,
3637: l_currency_code ,1,1),0) > 0 )

Line 3636: ((NVL(INSTRB(OE_CREDIT_CHECK_UTIL.G_excl_curr_list,

3632:
3633: IF ( NVL(INSTRB(OE_CREDIT_CHECK_UTIL.G_excl_curr_list,
3634: l_currency_code ,1,1),0) = 0 )
3635: OR
3636: ((NVL(INSTRB(OE_CREDIT_CHECK_UTIL.G_excl_curr_list,
3637: l_currency_code ,1,1),0) > 0 )
3638: AND ( l_currency_code = p_limit_curr_code )
3639: )
3640: THEN

Line 3643: OE_CREDIT_CHECK_UTIL.CONVERT_CURRENCY_AMOUNT

3639: )
3640: THEN
3641: BEGIN
3642: l_term :=
3643: OE_CREDIT_CHECK_UTIL.CONVERT_CURRENCY_AMOUNT
3644: ( p_amount => l_balance
3645: , p_transactional_currency => l_currency_code
3646: , p_limit_currency => p_limit_curr_code
3647: , p_functional_currency => g_functional_currency

Line 3708: IF ( NVL(INSTRB(OE_CREDIT_CHECK_UTIL.G_excl_curr_list,

3704: || l_bucket || '/' || l_bucket_length, 2 );
3705: END IF;
3706:
3707:
3708: IF ( NVL(INSTRB(OE_CREDIT_CHECK_UTIL.G_excl_curr_list,
3709: l_currency_code ,1,1),0) = 0 )
3710: OR
3711: ((NVL(INSTRB(OE_CREDIT_CHECK_UTIL.G_excl_curr_list,
3712: l_currency_code ,1,1),0) > 0 )

Line 3711: ((NVL(INSTRB(OE_CREDIT_CHECK_UTIL.G_excl_curr_list,

3707:
3708: IF ( NVL(INSTRB(OE_CREDIT_CHECK_UTIL.G_excl_curr_list,
3709: l_currency_code ,1,1),0) = 0 )
3710: OR
3711: ((NVL(INSTRB(OE_CREDIT_CHECK_UTIL.G_excl_curr_list,
3712: l_currency_code ,1,1),0) > 0 )
3713: AND ( l_currency_code = p_limit_curr_code )
3714: )
3715: THEN

Line 3718: OE_CREDIT_CHECK_UTIL.CONVERT_CURRENCY_AMOUNT

3714: )
3715: THEN
3716: BEGIN
3717: l_term :=
3718: OE_CREDIT_CHECK_UTIL.CONVERT_CURRENCY_AMOUNT
3719: ( p_amount => l_br_balance
3720: , p_transactional_currency => l_currency_code
3721: , p_limit_currency => p_limit_curr_code
3722: , p_functional_currency => g_functional_currency

Line 3778: IF ( NVL(INSTRB(OE_CREDIT_CHECK_UTIL.G_excl_curr_list,

3774: || l_bucket || '/' || l_bucket_length, 2 );
3775:
3776: END IF;
3777:
3778: IF ( NVL(INSTRB(OE_CREDIT_CHECK_UTIL.G_excl_curr_list,
3779: l_currency_code ,1,1),0) = 0 )
3780: OR
3781: ((NVL(INSTRB(OE_CREDIT_CHECK_UTIL.G_excl_curr_list,
3782: l_currency_code ,1,1),0) > 0 )

Line 3781: ((NVL(INSTRB(OE_CREDIT_CHECK_UTIL.G_excl_curr_list,

3777:
3778: IF ( NVL(INSTRB(OE_CREDIT_CHECK_UTIL.G_excl_curr_list,
3779: l_currency_code ,1,1),0) = 0 )
3780: OR
3781: ((NVL(INSTRB(OE_CREDIT_CHECK_UTIL.G_excl_curr_list,
3782: l_currency_code ,1,1),0) > 0 )
3783: AND ( l_currency_code = p_limit_curr_code )
3784: )
3785: THEN

Line 3788: OE_CREDIT_CHECK_UTIL.CONVERT_CURRENCY_AMOUNT

3784: )
3785: THEN
3786: BEGIN
3787: l_term :=
3788: OE_CREDIT_CHECK_UTIL.CONVERT_CURRENCY_AMOUNT
3789: ( p_amount => l_balance
3790: , p_transactional_currency => l_currency_code
3791: , p_limit_currency => p_limit_curr_code
3792: , p_functional_currency => g_functional_currency

Line 3834: IF ( NVL(INSTRB(OE_CREDIT_CHECK_UTIL.G_excl_curr_list,

3830: || l_bucket || '/' || l_bucket_length, 2 );
3831:
3832: END IF;
3833:
3834: IF ( NVL(INSTRB(OE_CREDIT_CHECK_UTIL.G_excl_curr_list,
3835: l_currency_code ,1,1),0) = 0 )
3836: OR
3837: ((NVL(INSTRB(OE_CREDIT_CHECK_UTIL.G_excl_curr_list,
3838: l_currency_code ,1,1),0) > 0 )

Line 3837: ((NVL(INSTRB(OE_CREDIT_CHECK_UTIL.G_excl_curr_list,

3833:
3834: IF ( NVL(INSTRB(OE_CREDIT_CHECK_UTIL.G_excl_curr_list,
3835: l_currency_code ,1,1),0) = 0 )
3836: OR
3837: ((NVL(INSTRB(OE_CREDIT_CHECK_UTIL.G_excl_curr_list,
3838: l_currency_code ,1,1),0) > 0 )
3839: AND ( l_currency_code = p_limit_curr_code )
3840: )
3841: THEN

Line 3844: OE_CREDIT_CHECK_UTIL.CONVERT_CURRENCY_AMOUNT

3840: )
3841: THEN
3842: BEGIN
3843: l_term :=
3844: OE_CREDIT_CHECK_UTIL.CONVERT_CURRENCY_AMOUNT
3845: ( p_amount => l_balance
3846: , p_transactional_currency => l_currency_code
3847: , p_limit_currency => p_limit_curr_code
3848: , p_functional_currency => g_functional_currency

Line 3903: IF ( NVL(INSTRB(OE_CREDIT_CHECK_UTIL.G_excl_curr_list,

3899: || l_balance || ' and bucket/length '
3900: || l_bucket || '/' || l_bucket_length, 2 );
3901: END IF;
3902:
3903: IF ( NVL(INSTRB(OE_CREDIT_CHECK_UTIL.G_excl_curr_list,
3904: l_currency_code ,1,1),0) = 0 )
3905: OR
3906: ((NVL(INSTRB(OE_CREDIT_CHECK_UTIL.G_excl_curr_list,
3907: l_currency_code ,1,1),0) > 0 )

Line 3906: ((NVL(INSTRB(OE_CREDIT_CHECK_UTIL.G_excl_curr_list,

3902:
3903: IF ( NVL(INSTRB(OE_CREDIT_CHECK_UTIL.G_excl_curr_list,
3904: l_currency_code ,1,1),0) = 0 )
3905: OR
3906: ((NVL(INSTRB(OE_CREDIT_CHECK_UTIL.G_excl_curr_list,
3907: l_currency_code ,1,1),0) > 0 )
3908: AND ( l_currency_code = p_limit_curr_code )
3909: )
3910: THEN

Line 3913: OE_CREDIT_CHECK_UTIL.CONVERT_CURRENCY_AMOUNT

3909: )
3910: THEN
3911: BEGIN
3912: l_term :=
3913: OE_CREDIT_CHECK_UTIL.CONVERT_CURRENCY_AMOUNT
3914: ( p_amount => l_balance
3915: , p_transactional_currency => l_currency_code
3916: , p_limit_currency => p_limit_curr_code
3917: , p_functional_currency => g_functional_currency

Line 3961: IF ( NVL(INSTRB(OE_CREDIT_CHECK_UTIL.G_excl_curr_list,

3957: || l_balance || ' and bucket/length '
3958: || l_bucket || '/' || l_bucket_length, 2 );
3959: END IF;
3960:
3961: IF ( NVL(INSTRB(OE_CREDIT_CHECK_UTIL.G_excl_curr_list,
3962: l_currency_code ,1,1),0) = 0 )
3963: OR
3964: ((NVL(INSTRB(OE_CREDIT_CHECK_UTIL.G_excl_curr_list,
3965: l_currency_code ,1,1),0) > 0 )

Line 3964: ((NVL(INSTRB(OE_CREDIT_CHECK_UTIL.G_excl_curr_list,

3960:
3961: IF ( NVL(INSTRB(OE_CREDIT_CHECK_UTIL.G_excl_curr_list,
3962: l_currency_code ,1,1),0) = 0 )
3963: OR
3964: ((NVL(INSTRB(OE_CREDIT_CHECK_UTIL.G_excl_curr_list,
3965: l_currency_code ,1,1),0) > 0 )
3966: AND ( l_currency_code = p_limit_curr_code )
3967: )
3968: THEN

Line 3971: OE_CREDIT_CHECK_UTIL.CONVERT_CURRENCY_AMOUNT

3967: )
3968: THEN
3969: BEGIN
3970: l_term :=
3971: OE_CREDIT_CHECK_UTIL.CONVERT_CURRENCY_AMOUNT
3972: ( p_amount => l_balance
3973: , p_transactional_currency => l_currency_code
3974: , p_limit_currency => p_limit_curr_code
3975: , p_functional_currency => g_functional_currency

Line 4024: IF ( NVL(INSTRB(OE_CREDIT_CHECK_UTIL.G_excl_curr_list,

4020: || l_br_balance || ' and bucket/length '
4021: || l_bucket || '/' || l_bucket_length, 2 );
4022: END IF;
4023:
4024: IF ( NVL(INSTRB(OE_CREDIT_CHECK_UTIL.G_excl_curr_list,
4025: l_currency_code ,1,1),0) = 0 )
4026: OR
4027: ((NVL(INSTRB(OE_CREDIT_CHECK_UTIL.G_excl_curr_list,
4028: l_currency_code ,1,1),0) > 0 )

Line 4027: ((NVL(INSTRB(OE_CREDIT_CHECK_UTIL.G_excl_curr_list,

4023:
4024: IF ( NVL(INSTRB(OE_CREDIT_CHECK_UTIL.G_excl_curr_list,
4025: l_currency_code ,1,1),0) = 0 )
4026: OR
4027: ((NVL(INSTRB(OE_CREDIT_CHECK_UTIL.G_excl_curr_list,
4028: l_currency_code ,1,1),0) > 0 )
4029: AND ( l_currency_code = p_limit_curr_code )
4030: )
4031: THEN

Line 4034: OE_CREDIT_CHECK_UTIL.CONVERT_CURRENCY_AMOUNT

4030: )
4031: THEN
4032: BEGIN
4033: l_term :=
4034: OE_CREDIT_CHECK_UTIL.CONVERT_CURRENCY_AMOUNT
4035: ( p_amount => l_br_balance
4036: , p_transactional_currency => l_currency_code
4037: , p_limit_currency => p_limit_curr_code
4038: , p_functional_currency => g_functional_currency

Line 4093: IF ( NVL(INSTRB(OE_CREDIT_CHECK_UTIL.G_excl_curr_list,

4089: || l_balance || ' and bucket/length '
4090: || l_bucket || '/' || l_bucket_length, 2 );
4091: END IF;
4092:
4093: IF ( NVL(INSTRB(OE_CREDIT_CHECK_UTIL.G_excl_curr_list,
4094: l_currency_code ,1,1),0) = 0 )
4095: OR
4096: ((NVL(INSTRB(OE_CREDIT_CHECK_UTIL.G_excl_curr_list,
4097: l_currency_code ,1,1),0) > 0 )

Line 4096: ((NVL(INSTRB(OE_CREDIT_CHECK_UTIL.G_excl_curr_list,

4092:
4093: IF ( NVL(INSTRB(OE_CREDIT_CHECK_UTIL.G_excl_curr_list,
4094: l_currency_code ,1,1),0) = 0 )
4095: OR
4096: ((NVL(INSTRB(OE_CREDIT_CHECK_UTIL.G_excl_curr_list,
4097: l_currency_code ,1,1),0) > 0 )
4098: AND ( l_currency_code = p_limit_curr_code )
4099: )
4100: THEN

Line 4103: OE_CREDIT_CHECK_UTIL.CONVERT_CURRENCY_AMOUNT

4099: )
4100: THEN
4101: BEGIN
4102: l_term :=
4103: OE_CREDIT_CHECK_UTIL.CONVERT_CURRENCY_AMOUNT
4104: ( p_amount => l_balance
4105: , p_transactional_currency => l_currency_code
4106: , p_limit_currency => p_limit_curr_code
4107: , p_functional_currency => g_functional_currency

Line 4150: IF ( NVL(INSTRB(OE_CREDIT_CHECK_UTIL.G_excl_curr_list,

4146: || l_balance || ' and bucket/length '
4147: || l_bucket || '/' || l_bucket_length, 2 );
4148: END IF;
4149:
4150: IF ( NVL(INSTRB(OE_CREDIT_CHECK_UTIL.G_excl_curr_list,
4151: l_currency_code ,1,1),0) = 0 )
4152: OR
4153: ((NVL(INSTRB(OE_CREDIT_CHECK_UTIL.G_excl_curr_list,
4154: l_currency_code ,1,1),0) > 0 )

Line 4153: ((NVL(INSTRB(OE_CREDIT_CHECK_UTIL.G_excl_curr_list,

4149:
4150: IF ( NVL(INSTRB(OE_CREDIT_CHECK_UTIL.G_excl_curr_list,
4151: l_currency_code ,1,1),0) = 0 )
4152: OR
4153: ((NVL(INSTRB(OE_CREDIT_CHECK_UTIL.G_excl_curr_list,
4154: l_currency_code ,1,1),0) > 0 )
4155: AND ( l_currency_code = p_limit_curr_code )
4156: )
4157: THEN

Line 4160: OE_CREDIT_CHECK_UTIL.CONVERT_CURRENCY_AMOUNT

4156: )
4157: THEN
4158: BEGIN
4159: l_term :=
4160: OE_CREDIT_CHECK_UTIL.CONVERT_CURRENCY_AMOUNT
4161: ( p_amount => l_balance
4162: , p_transactional_currency => l_currency_code
4163: , p_limit_currency => p_limit_curr_code
4164: , p_functional_currency => g_functional_currency

Line 4266: OE_CREDIT_CHECK_UTIL.CONVERT_CURRENCY_AMOUNT

4262: || ' currency with BR balance ' || l_br_balance, 2 );
4263: END IF;
4264: BEGIN
4265: l_term :=
4266: OE_CREDIT_CHECK_UTIL.CONVERT_CURRENCY_AMOUNT
4267: ( p_amount => l_balance +
4268: NVL(l_br_balance,0)
4269: , p_transactional_currency => l_currency_code
4270: , p_limit_currency => p_limit_curr_code

Line 4327: OE_CREDIT_CHECK_UTIL.CONVERT_CURRENCY_AMOUNT

4323: || ' currency with balance ' || l_balance, 2 );
4324: END IF;
4325: BEGIN
4326: l_term :=
4327: OE_CREDIT_CHECK_UTIL.CONVERT_CURRENCY_AMOUNT
4328: ( p_amount => l_balance
4329: , p_transactional_currency => l_currency_code
4330: , p_limit_currency => p_limit_curr_code
4331: , p_functional_currency => g_functional_currency

Line 4365: oe_debug_pub.add(' OE_CREDIT_CHECK_UTIL.G_hierarchy_type => '||

4361: ELSE --- Hierarchy usages
4362: IF G_debug_flag = 'Y'
4363: THEN
4364: oe_debug_pub.add(' Hierarchy Usages ',1);
4365: oe_debug_pub.add(' OE_CREDIT_CHECK_UTIL.G_hierarchy_type => '||
4366: OE_CREDIT_CHECK_UTIL.G_hierarchy_type );
4367: oe_debug_pub.add(' G_MAX_BUCKET_LENGTH => '||
4368: G_MAX_BUCKET_LENGTH);
4369: END IF;

Line 4366: OE_CREDIT_CHECK_UTIL.G_hierarchy_type );

4362: IF G_debug_flag = 'Y'
4363: THEN
4364: oe_debug_pub.add(' Hierarchy Usages ',1);
4365: oe_debug_pub.add(' OE_CREDIT_CHECK_UTIL.G_hierarchy_type => '||
4366: OE_CREDIT_CHECK_UTIL.G_hierarchy_type );
4367: oe_debug_pub.add(' G_MAX_BUCKET_LENGTH => '||
4368: G_MAX_BUCKET_LENGTH);
4369: END IF;
4370:

Line 4411: OE_CREDIT_CHECK_UTIL.CONVERT_CURRENCY_AMOUNT

4407: END IF;
4408:
4409: BEGIN
4410: l_term :=
4411: OE_CREDIT_CHECK_UTIL.CONVERT_CURRENCY_AMOUNT
4412: ( p_amount => l_balance
4413: + nvl(l_br_balance ,0)
4414: , p_transactional_currency => l_currency_code
4415: , p_limit_currency => p_limit_curr_code

Line 4469: OE_CREDIT_CHECK_UTIL.CONVERT_CURRENCY_AMOUNT

4465: END IF;
4466:
4467: BEGIN
4468: l_term :=
4469: OE_CREDIT_CHECK_UTIL.CONVERT_CURRENCY_AMOUNT
4470: ( p_amount => l_balance
4471: , p_transactional_currency => l_currency_code
4472: , p_limit_currency => p_limit_curr_code
4473: , p_functional_currency => g_functional_currency

Line 4545: IF ( NVL(INSTRB(OE_CREDIT_CHECK_UTIL.G_excl_curr_list,

4541: || l_balance || ' and bucket/length '
4542: || l_bucket || '/' || l_bucket_length, 2 );
4543: END IF;
4544:
4545: IF ( NVL(INSTRB(OE_CREDIT_CHECK_UTIL.G_excl_curr_list,
4546: l_currency_code ,1,1),0) = 0 )
4547: OR
4548: ((NVL(INSTRB(OE_CREDIT_CHECK_UTIL.G_excl_curr_list,
4549: l_currency_code ,1,1),0) > 0 )

Line 4548: ((NVL(INSTRB(OE_CREDIT_CHECK_UTIL.G_excl_curr_list,

4544:
4545: IF ( NVL(INSTRB(OE_CREDIT_CHECK_UTIL.G_excl_curr_list,
4546: l_currency_code ,1,1),0) = 0 )
4547: OR
4548: ((NVL(INSTRB(OE_CREDIT_CHECK_UTIL.G_excl_curr_list,
4549: l_currency_code ,1,1),0) > 0 )
4550: AND ( l_currency_code = p_limit_curr_code )
4551: )
4552: THEN

Line 4555: OE_CREDIT_CHECK_UTIL.CONVERT_CURRENCY_AMOUNT

4551: )
4552: THEN
4553: BEGIN
4554: l_term :=
4555: OE_CREDIT_CHECK_UTIL.CONVERT_CURRENCY_AMOUNT
4556: ( p_amount => l_balance
4557: , p_transactional_currency => l_currency_code
4558: , p_limit_currency => p_limit_curr_code
4559: , p_functional_currency => g_functional_currency

Line 4602: IF ( NVL(INSTRB(OE_CREDIT_CHECK_UTIL.G_excl_curr_list,

4598: || l_balance || ' and bucket/length '
4599: || l_bucket || '/' || l_bucket_length, 2 );
4600: END IF;
4601:
4602: IF ( NVL(INSTRB(OE_CREDIT_CHECK_UTIL.G_excl_curr_list,
4603: l_currency_code ,1,1),0) = 0 )
4604: OR
4605: ((NVL(INSTRB(OE_CREDIT_CHECK_UTIL.G_excl_curr_list,
4606: l_currency_code ,1,1),0) > 0 )

Line 4605: ((NVL(INSTRB(OE_CREDIT_CHECK_UTIL.G_excl_curr_list,

4601:
4602: IF ( NVL(INSTRB(OE_CREDIT_CHECK_UTIL.G_excl_curr_list,
4603: l_currency_code ,1,1),0) = 0 )
4604: OR
4605: ((NVL(INSTRB(OE_CREDIT_CHECK_UTIL.G_excl_curr_list,
4606: l_currency_code ,1,1),0) > 0 )
4607: AND ( l_currency_code = p_limit_curr_code )
4608: )
4609: THEN

Line 4612: OE_CREDIT_CHECK_UTIL.CONVERT_CURRENCY_AMOUNT

4608: )
4609: THEN
4610: BEGIN
4611: l_term :=
4612: OE_CREDIT_CHECK_UTIL.CONVERT_CURRENCY_AMOUNT
4613: ( p_amount => l_balance
4614: , p_transactional_currency => l_currency_code
4615: , p_limit_currency => p_limit_curr_code
4616: , p_functional_currency => g_functional_currency

Line 4666: IF ( NVL(INSTRB(OE_CREDIT_CHECK_UTIL.G_excl_curr_list,

4662: || l_br_balance || ' and bucket/length '
4663: || l_bucket || '/' || l_bucket_length, 2 );
4664: END IF;
4665:
4666: IF ( NVL(INSTRB(OE_CREDIT_CHECK_UTIL.G_excl_curr_list,
4667: l_currency_code ,1,1),0) = 0 )
4668: OR
4669: ((NVL(INSTRB(OE_CREDIT_CHECK_UTIL.G_excl_curr_list,
4670: l_currency_code ,1,1),0) > 0 )

Line 4669: ((NVL(INSTRB(OE_CREDIT_CHECK_UTIL.G_excl_curr_list,

4665:
4666: IF ( NVL(INSTRB(OE_CREDIT_CHECK_UTIL.G_excl_curr_list,
4667: l_currency_code ,1,1),0) = 0 )
4668: OR
4669: ((NVL(INSTRB(OE_CREDIT_CHECK_UTIL.G_excl_curr_list,
4670: l_currency_code ,1,1),0) > 0 )
4671: AND ( l_currency_code = p_limit_curr_code )
4672: )
4673: THEN

Line 4676: OE_CREDIT_CHECK_UTIL.CONVERT_CURRENCY_AMOUNT

4672: )
4673: THEN
4674: BEGIN
4675: l_term :=
4676: OE_CREDIT_CHECK_UTIL.CONVERT_CURRENCY_AMOUNT
4677: ( p_amount => l_br_balance
4678: , p_transactional_currency => l_currency_code
4679: , p_limit_currency => p_limit_curr_code
4680: , p_functional_currency => g_functional_currency

Line 4738: IF ( NVL(INSTRB(OE_CREDIT_CHECK_UTIL.G_excl_curr_list,

4734: || l_balance || ' and bucket/length '
4735: || l_bucket || '/' || l_bucket_length, 2 );
4736: END IF;
4737:
4738: IF ( NVL(INSTRB(OE_CREDIT_CHECK_UTIL.G_excl_curr_list,
4739: l_currency_code ,1,1),0) = 0 )
4740: OR
4741: ((NVL(INSTRB(OE_CREDIT_CHECK_UTIL.G_excl_curr_list,
4742: l_currency_code ,1,1),0) > 0 )

Line 4741: ((NVL(INSTRB(OE_CREDIT_CHECK_UTIL.G_excl_curr_list,

4737:
4738: IF ( NVL(INSTRB(OE_CREDIT_CHECK_UTIL.G_excl_curr_list,
4739: l_currency_code ,1,1),0) = 0 )
4740: OR
4741: ((NVL(INSTRB(OE_CREDIT_CHECK_UTIL.G_excl_curr_list,
4742: l_currency_code ,1,1),0) > 0 )
4743: AND ( l_currency_code = p_limit_curr_code )
4744: )
4745: THEN

Line 4748: OE_CREDIT_CHECK_UTIL.CONVERT_CURRENCY_AMOUNT

4744: )
4745: THEN
4746: BEGIN
4747: l_term :=
4748: OE_CREDIT_CHECK_UTIL.CONVERT_CURRENCY_AMOUNT
4749: ( p_amount => l_balance
4750: , p_transactional_currency => l_currency_code
4751: , p_limit_currency => p_limit_curr_code
4752: , p_functional_currency => g_functional_currency

Line 4797: IF ( NVL(INSTRB(OE_CREDIT_CHECK_UTIL.G_excl_curr_list,

4793: || l_balance || ' and bucket/length '
4794: || l_bucket || '/' || l_bucket_length, 2 );
4795: END IF;
4796:
4797: IF ( NVL(INSTRB(OE_CREDIT_CHECK_UTIL.G_excl_curr_list,
4798: l_currency_code ,1,1),0) = 0 )
4799: OR
4800: ((NVL(INSTRB(OE_CREDIT_CHECK_UTIL.G_excl_curr_list,
4801: l_currency_code ,1,1),0) > 0 )

Line 4800: ((NVL(INSTRB(OE_CREDIT_CHECK_UTIL.G_excl_curr_list,

4796:
4797: IF ( NVL(INSTRB(OE_CREDIT_CHECK_UTIL.G_excl_curr_list,
4798: l_currency_code ,1,1),0) = 0 )
4799: OR
4800: ((NVL(INSTRB(OE_CREDIT_CHECK_UTIL.G_excl_curr_list,
4801: l_currency_code ,1,1),0) > 0 )
4802: AND ( l_currency_code = p_limit_curr_code )
4803: )
4804: THEN

Line 4807: OE_CREDIT_CHECK_UTIL.CONVERT_CURRENCY_AMOUNT

4803: )
4804: THEN
4805: BEGIN
4806: l_term :=
4807: OE_CREDIT_CHECK_UTIL.CONVERT_CURRENCY_AMOUNT
4808: ( p_amount => l_balance
4809: , p_transactional_currency => l_currency_code
4810: , p_limit_currency => p_limit_curr_code
4811: , p_functional_currency => g_functional_currency

Line 4870: IF ( NVL(INSTRB(OE_CREDIT_CHECK_UTIL.G_excl_curr_list,

4866: || l_balance || ' and bucket/length '
4867: || l_bucket || '/' || l_bucket_length, 2 );
4868: END IF;
4869:
4870: IF ( NVL(INSTRB(OE_CREDIT_CHECK_UTIL.G_excl_curr_list,
4871: l_currency_code ,1,1),0) = 0 )
4872: OR
4873: ((NVL(INSTRB(OE_CREDIT_CHECK_UTIL.G_excl_curr_list,
4874: l_currency_code ,1,1),0) > 0 )

Line 4873: ((NVL(INSTRB(OE_CREDIT_CHECK_UTIL.G_excl_curr_list,

4869:
4870: IF ( NVL(INSTRB(OE_CREDIT_CHECK_UTIL.G_excl_curr_list,
4871: l_currency_code ,1,1),0) = 0 )
4872: OR
4873: ((NVL(INSTRB(OE_CREDIT_CHECK_UTIL.G_excl_curr_list,
4874: l_currency_code ,1,1),0) > 0 )
4875: AND ( l_currency_code = p_limit_curr_code )
4876: )
4877: THEN

Line 4880: OE_CREDIT_CHECK_UTIL.CONVERT_CURRENCY_AMOUNT

4876: )
4877: THEN
4878: BEGIN
4879: l_term :=
4880: OE_CREDIT_CHECK_UTIL.CONVERT_CURRENCY_AMOUNT
4881: ( p_amount => l_balance
4882: , p_transactional_currency => l_currency_code
4883: , p_limit_currency => p_limit_curr_code
4884: , p_functional_currency => g_functional_currency

Line 4929: IF ( NVL(INSTRB(OE_CREDIT_CHECK_UTIL.G_excl_curr_list,

4925: || l_balance || ' and bucket/length '
4926: || l_bucket || '/' || l_bucket_length, 2 );
4927: END IF;
4928:
4929: IF ( NVL(INSTRB(OE_CREDIT_CHECK_UTIL.G_excl_curr_list,
4930: l_currency_code ,1,1),0) = 0 )
4931: OR
4932: ((NVL(INSTRB(OE_CREDIT_CHECK_UTIL.G_excl_curr_list,
4933: l_currency_code ,1,1),0) > 0 )

Line 4932: ((NVL(INSTRB(OE_CREDIT_CHECK_UTIL.G_excl_curr_list,

4928:
4929: IF ( NVL(INSTRB(OE_CREDIT_CHECK_UTIL.G_excl_curr_list,
4930: l_currency_code ,1,1),0) = 0 )
4931: OR
4932: ((NVL(INSTRB(OE_CREDIT_CHECK_UTIL.G_excl_curr_list,
4933: l_currency_code ,1,1),0) > 0 )
4934: AND ( l_currency_code = p_limit_curr_code )
4935: )
4936: THEN

Line 4939: OE_CREDIT_CHECK_UTIL.CONVERT_CURRENCY_AMOUNT

4935: )
4936: THEN
4937: BEGIN
4938: l_term :=
4939: OE_CREDIT_CHECK_UTIL.CONVERT_CURRENCY_AMOUNT
4940: ( p_amount => l_balance
4941: , p_transactional_currency => l_currency_code
4942: , p_limit_currency => p_limit_curr_code
4943: , p_functional_currency => g_functional_currency

Line 4991: IF ( NVL(INSTRB(OE_CREDIT_CHECK_UTIL.G_excl_curr_list,

4987: || l_BR_balance || ' and bucket/length '
4988: || l_bucket || '/' || l_bucket_length, 2 );
4989: END IF;
4990:
4991: IF ( NVL(INSTRB(OE_CREDIT_CHECK_UTIL.G_excl_curr_list,
4992: l_currency_code ,1,1),0) = 0 )
4993: OR
4994: ((NVL(INSTRB(OE_CREDIT_CHECK_UTIL.G_excl_curr_list,
4995: l_currency_code ,1,1),0) > 0 )

Line 4994: ((NVL(INSTRB(OE_CREDIT_CHECK_UTIL.G_excl_curr_list,

4990:
4991: IF ( NVL(INSTRB(OE_CREDIT_CHECK_UTIL.G_excl_curr_list,
4992: l_currency_code ,1,1),0) = 0 )
4993: OR
4994: ((NVL(INSTRB(OE_CREDIT_CHECK_UTIL.G_excl_curr_list,
4995: l_currency_code ,1,1),0) > 0 )
4996: AND ( l_currency_code = p_limit_curr_code )
4997: )
4998: THEN

Line 5001: OE_CREDIT_CHECK_UTIL.CONVERT_CURRENCY_AMOUNT

4997: )
4998: THEN
4999: BEGIN
5000: l_term :=
5001: OE_CREDIT_CHECK_UTIL.CONVERT_CURRENCY_AMOUNT
5002: ( p_amount => l_br_balance
5003: , p_transactional_currency => l_currency_code
5004: , p_limit_currency => p_limit_curr_code
5005: , p_functional_currency => g_functional_currency

Line 5058: IF ( NVL(INSTRB(OE_CREDIT_CHECK_UTIL.G_excl_curr_list,

5054: || l_balance || ' and bucket/length '
5055: || l_bucket || '/' || l_bucket_length, 2 );
5056: END IF;
5057:
5058: IF ( NVL(INSTRB(OE_CREDIT_CHECK_UTIL.G_excl_curr_list,
5059: l_currency_code ,1,1),0) = 0 )
5060: OR
5061: ((NVL(INSTRB(OE_CREDIT_CHECK_UTIL.G_excl_curr_list,
5062: l_currency_code ,1,1),0) > 0 )

Line 5061: ((NVL(INSTRB(OE_CREDIT_CHECK_UTIL.G_excl_curr_list,

5057:
5058: IF ( NVL(INSTRB(OE_CREDIT_CHECK_UTIL.G_excl_curr_list,
5059: l_currency_code ,1,1),0) = 0 )
5060: OR
5061: ((NVL(INSTRB(OE_CREDIT_CHECK_UTIL.G_excl_curr_list,
5062: l_currency_code ,1,1),0) > 0 )
5063: AND ( l_currency_code = p_limit_curr_code )
5064: )
5065: THEN

Line 5068: OE_CREDIT_CHECK_UTIL.CONVERT_CURRENCY_AMOUNT

5064: )
5065: THEN
5066: BEGIN
5067: l_term :=
5068: OE_CREDIT_CHECK_UTIL.CONVERT_CURRENCY_AMOUNT
5069: ( p_amount => l_balance
5070: , p_transactional_currency => l_currency_code
5071: , p_limit_currency => p_limit_curr_code
5072: , p_functional_currency => g_functional_currency

Line 5118: IF ( NVL(INSTRB(OE_CREDIT_CHECK_UTIL.G_excl_curr_list,

5114: || l_balance || ' and bucket/length '
5115: || l_bucket || '/' || l_bucket_length, 2 );
5116: END IF;
5117:
5118: IF ( NVL(INSTRB(OE_CREDIT_CHECK_UTIL.G_excl_curr_list,
5119: l_currency_code ,1,1),0) = 0 )
5120: OR
5121: ((NVL(INSTRB(OE_CREDIT_CHECK_UTIL.G_excl_curr_list,
5122: l_currency_code ,1,1),0) > 0 )

Line 5121: ((NVL(INSTRB(OE_CREDIT_CHECK_UTIL.G_excl_curr_list,

5117:
5118: IF ( NVL(INSTRB(OE_CREDIT_CHECK_UTIL.G_excl_curr_list,
5119: l_currency_code ,1,1),0) = 0 )
5120: OR
5121: ((NVL(INSTRB(OE_CREDIT_CHECK_UTIL.G_excl_curr_list,
5122: l_currency_code ,1,1),0) > 0 )
5123: AND ( l_currency_code = p_limit_curr_code )
5124: )
5125: THEN

Line 5128: OE_CREDIT_CHECK_UTIL.CONVERT_CURRENCY_AMOUNT

5124: )
5125: THEN
5126: BEGIN
5127: l_term :=
5128: OE_CREDIT_CHECK_UTIL.CONVERT_CURRENCY_AMOUNT
5129: ( p_amount => l_balance
5130: , p_transactional_currency => l_currency_code
5131: , p_limit_currency => p_limit_curr_code
5132: , p_functional_currency => g_functional_currency

Line 10326: OE_CREDIT_CHECK_UTIL.oe_credit_rules_rec_type

10322: , p_site_use_id IN NUMBER
10323: , p_party_id IN NUMBER := NULL
10324: , p_header_id IN NUMBER
10325: , p_credit_check_rule_rec IN
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

Line 10328: OE_CREDIT_CHECK_UTIL.oe_systems_param_rec_type

10324: , p_header_id IN NUMBER
10325: , p_credit_check_rule_rec IN
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

Line 10331: , p_usage_curr_tbl IN OE_CREDIT_CHECK_UTIL.curr_tbl_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'
10335: , x_total_exposure OUT NOCOPY NUMBER

Line 10340: , x_error_curr_tbl OUT NOCOPY OE_CREDIT_CHECK_UTIL.curr_tbl_type

10336: , x_order_amount OUT NOCOPY NUMBER
10337: , x_order_hold_amount OUT NOCOPY NUMBER
10338: , x_ar_amount OUT NOCOPY NUMBER
10339: , x_return_status OUT NOCOPY VARCHAR2
10340: , x_error_curr_tbl OUT NOCOPY OE_CREDIT_CHECK_UTIL.curr_tbl_type
10341: )
10342: IS
10343:
10344: i BINARY_INTEGER;

Line 10374: = OE_CREDIT_CHECK_UTIL.G_hierarchy_type ;

10370: and hn.child_object_type = 'ORGANIZATION'
10371: and hn.effective_start_date <= sysdate
10372: and hn.effective_end_date >= SYSDATE
10373: and hn.hierarchy_type
10374: = OE_CREDIT_CHECK_UTIL.G_hierarchy_type ;
10375:
10376: BEGIN
10377: g_use_party_hierarchy := 'N' ;
10378:

Line 10514: g_functional_currency := oe_credit_check_util.Get_GL_Currency;

10510:
10511: -- Get the functional currency for use in currency conversion
10512: -- using triangulation
10513:
10514: g_functional_currency := oe_credit_check_util.Get_GL_Currency;
10515:
10516: l_org_id := OE_CREDIT_CHECK_UTIL.G_org_id; --bug# 5031301
10517: l_total := 0;
10518: l_both_exposure := 'N' ;

Line 10516: l_org_id := OE_CREDIT_CHECK_UTIL.G_org_id; --bug# 5031301

10512: -- using triangulation
10513:
10514: g_functional_currency := oe_credit_check_util.Get_GL_Currency;
10515:
10516: l_org_id := OE_CREDIT_CHECK_UTIL.G_org_id; --bug# 5031301
10517: l_total := 0;
10518: l_both_exposure := 'N' ;
10519:
10520: x_ar_amount := NULL;