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 88: g_error_curr_tbl OE_CREDIT_CHECK_UTIL.curr_tbl_type;

84: b34 NUMBER;
85: b35 NUMBER;
86: b36 NUMBER;
87:
88: g_error_curr_tbl OE_CREDIT_CHECK_UTIL.curr_tbl_type;
89: g_conversion_type OE_Credit_Check_Rules.conversion_type%TYPE;
90: g_functional_currency FND_CURRENCIES.Currency_code%TYPE;
91: g_use_party_hierarchy VARCHAR2(1) ;
92:

Line 126: OE_CREDIT_CHECK_UTIL.OE_credit_rules_rec_type

122: ( p_customer_id IN NUMBER
123: , p_site_use_id IN NUMBER
124: , p_party_id IN NUMBER
125: , p_credit_check_rule_rec IN
126: OE_CREDIT_CHECK_UTIL.OE_credit_rules_rec_type
127: , p_credit_level IN VARCHAR2
128: , p_usage_curr IN oe_credit_check_util.curr_tbl_type
129: , p_include_all_flag IN VARCHAR2
130: , p_global_exposure_flag IN VARCHAR2 := 'N'

Line 128: , p_usage_curr IN oe_credit_check_util.curr_tbl_type

124: , p_party_id IN NUMBER
125: , p_credit_check_rule_rec IN
126: OE_CREDIT_CHECK_UTIL.OE_credit_rules_rec_type
127: , p_credit_level IN VARCHAR2
128: , p_usage_curr IN oe_credit_check_util.curr_tbl_type
129: , p_include_all_flag IN VARCHAR2
130: , p_global_exposure_flag IN VARCHAR2 := 'N'
131: , p_org_id IN NUMBER
132: , x_exist_flag OUT NOCOPY VARCHAR2

Line 181: OE_CREDIT_CHECK_UTIL.G_hierarchy_type

177: and hn.child_object_type = 'ORGANIZATION'
178: and hn.effective_start_date <= sysdate
179: and hn.effective_end_date >= SYSDATE
180: and hn.hierarchy_type =
181: OE_CREDIT_CHECK_UTIL.G_hierarchy_type
182: AND oes.party_id = hn.child_id
183: AND oes.currency_code = p_curr_code
184: AND oes.bucket <= l_jdate
185: AND oes.balance_type = 20

Line 237: OE_CREDIT_CHECK_UTIL.G_hierarchy_type

233: and hn.child_object_type = 'ORGANIZATION'
234: and hn.effective_start_date <= sysdate
235: and hn.effective_end_date >= SYSDATE
236: and hn.hierarchy_type =
237: OE_CREDIT_CHECK_UTIL.G_hierarchy_type
238: AND oes.party_id = hn.child_id
239: AND oes.bucket <= l_jdate
240: AND oes.balance_type = 20
241: AND oes.bucket_duration = 1;

Line 431: ( x_error_curr_tbl IN OUT NOCOPY OE_CREDIT_CHECK_UTIL.curr_tbl_type

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

Line 509: ( p_credit_check_rule_rec IN OE_CREDIT_CHECK_UTIL.oe_credit_rules_rec_type

505: END open_date;
506:
507:
508: PROCEDURE balance_types_om_and_ar
509: ( p_credit_check_rule_rec IN OE_CREDIT_CHECK_UTIL.oe_credit_rules_rec_type
510: )
511: IS
512: BEGIN
513: b1 := -1;

Line 767: (p_credit_check_rule_rec IN OE_CREDIT_CHECK_UTIL.oe_credit_rules_rec_type

763: -- balance types
764: -----------------------------------------------------------
765:
766: PROCEDURE balance_types_om_nohold
767: (p_credit_check_rule_rec IN OE_CREDIT_CHECK_UTIL.oe_credit_rules_rec_type
768: )
769: IS
770: BEGIN
771: b1 := -1;

Line 901: (p_credit_check_rule_rec IN OE_CREDIT_CHECK_UTIL.oe_credit_rules_rec_type

897: END balance_types_om_nohold;
898: ---------------------------------------------------------------
899:
900: PROCEDURE balance_types_om_hold
901: (p_credit_check_rule_rec IN OE_CREDIT_CHECK_UTIL.oe_credit_rules_rec_type
902: )
903: IS
904: BEGIN
905: b1 := -1;

Line 1050: ( p_credit_check_rule_rec IN OE_CREDIT_CHECK_UTIL.oe_credit_rules_rec_type

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

Line 1274: ( p_credit_check_rule_rec IN OE_CREDIT_CHECK_UTIL.oe_credit_rules_rec_type

1270: -- This procedure will set the balance types for the
1271: -- AR exposure based on the credit check rules setup
1272: ----------------------------------------------------------
1273: PROCEDURE balance_types_ar
1274: ( p_credit_check_rule_rec IN OE_CREDIT_CHECK_UTIL.oe_credit_rules_rec_type
1275: )
1276: IS
1277: BEGIN
1278: b1 := -1;

Line 1491: OE_CREDIT_CHECK_UTIL.convert_currency_amount

1487: l_term NUMBER;
1488: BEGIN
1489: BEGIN
1490: l_term :=
1491: OE_CREDIT_CHECK_UTIL.convert_currency_amount
1492: ( p_amount => p_amount
1493: , p_transactional_currency => p_transactional_currency
1494: , p_limit_currency => p_limit_currency
1495: , p_functional_currency => g_functional_currency

Line 1527: , p_usage_curr_tbl IN OE_CREDIT_CHECK_UTIL.curr_tbl_type

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

Line 1532: OE_CREDIT_CHECK_UTIL.oe_credit_rules_rec_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
1533: , x_error_curr_tbl IN OUT NOCOPY OE_CREDIT_CHECK_UTIL.curr_tbl_type
1534: )
1535: RETURN NUMBER
1536: IS

Line 1533: , x_error_curr_tbl IN OUT NOCOPY OE_CREDIT_CHECK_UTIL.curr_tbl_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
1533: , x_error_curr_tbl IN OUT NOCOPY OE_CREDIT_CHECK_UTIL.curr_tbl_type
1534: )
1535: RETURN NUMBER
1536: IS
1537: i BINARY_INTEGER;

Line 1858: = OE_CREDIT_CHECK_UTIL.G_hierarchy_type

1854: and hn.child_object_type = 'ORGANIZATION'
1855: and hn.effective_start_date <= sysdate
1856: and hn.effective_end_date >= SYSDATE
1857: and hn.hierarchy_type
1858: = OE_CREDIT_CHECK_UTIL.G_hierarchy_type
1859: AND oes.party_id = hn.child_id
1860: AND oes.currency_code = l_currency_code
1861: AND oes.bucket = l_bucket
1862: AND oes.bucket_duration = l_bucket_length

Line 1884: = OE_CREDIT_CHECK_UTIL.G_hierarchy_type

1880: and hn.child_object_type = 'ORGANIZATION'
1881: and hn.effective_start_date <= sysdate
1882: and hn.effective_end_date >= SYSDATE
1883: and hn.hierarchy_type
1884: = OE_CREDIT_CHECK_UTIL.G_hierarchy_type
1885: AND oes.party_id = hn.child_id
1886: AND oes.currency_code = l_currency_code
1887: AND oes.bucket = l_bucket
1888: AND oes.bucket_duration = l_bucket_length

Line 1906: = OE_CREDIT_CHECK_UTIL.G_hierarchy_type

1902: and hn.child_object_type = 'ORGANIZATION'
1903: and hn.effective_start_date <= sysdate
1904: and hn.effective_end_date >= SYSDATE
1905: and hn.hierarchy_type
1906: = OE_CREDIT_CHECK_UTIL.G_hierarchy_type
1907: AND oes.party_id = hn.child_id
1908: AND oes.currency_code = l_currency_code
1909: AND oes.bucket < l_bucket
1910: AND oes.bucket_duration = l_bucket_length

Line 1931: = OE_CREDIT_CHECK_UTIL.G_hierarchy_type

1927: and hn.child_object_type = 'ORGANIZATION'
1928: and hn.effective_start_date <= sysdate
1929: and hn.effective_end_date >= SYSDATE
1930: and hn.hierarchy_type
1931: = OE_CREDIT_CHECK_UTIL.G_hierarchy_type
1932: AND oes.party_id = hn.child_id
1933: AND oes.currency_code = l_currency_code
1934: AND oes.bucket < l_bucket
1935: AND oes.bucket_duration = l_bucket_length

Line 1952: = OE_CREDIT_CHECK_UTIL.G_hierarchy_type

1948: and hn.child_object_type = 'ORGANIZATION'
1949: and hn.effective_start_date <= sysdate
1950: and hn.effective_end_date >= SYSDATE
1951: and hn.hierarchy_type
1952: = OE_CREDIT_CHECK_UTIL.G_hierarchy_type
1953: AND oes.party_id = hn.child_id
1954: AND oes.currency_code = l_currency_code
1955: AND oes.bucket < l_br_bucket
1956: AND oes.bucket_duration = l_br_bucket_length

Line 2291: = OE_CREDIT_CHECK_UTIL.G_hierarchy_type

2287: and hn.child_object_type = 'ORGANIZATION'
2288: and hn.effective_start_date <= sysdate
2289: and hn.effective_end_date >= SYSDATE
2290: and hn.hierarchy_type
2291: = OE_CREDIT_CHECK_UTIL.G_hierarchy_type
2292: AND oes.party_id = hn.child_id
2293: AND oes.bucket = l_bucket
2294: AND oes.bucket_duration = l_bucket_length
2295: GROUP BY oes.currency_code

Line 2317: = OE_CREDIT_CHECK_UTIL.G_hierarchy_type

2313: and hn.child_object_type = 'ORGANIZATION'
2314: and hn.effective_start_date <= sysdate
2315: and hn.effective_end_date >= SYSDATE
2316: and hn.hierarchy_type
2317: = OE_CREDIT_CHECK_UTIL.G_hierarchy_type
2318: AND oes.party_id = hn.child_id
2319: AND oes.bucket = l_bucket
2320: AND oes.bucket_duration = l_bucket_length
2321: GROUP BY oes.currency_code

Line 2339: = OE_CREDIT_CHECK_UTIL.G_hierarchy_type

2335: and hn.child_object_type = 'ORGANIZATION'
2336: and hn.effective_start_date <= sysdate
2337: and hn.effective_end_date >= SYSDATE
2338: and hn.hierarchy_type
2339: = OE_CREDIT_CHECK_UTIL.G_hierarchy_type
2340: AND oes.party_id = hn.child_id
2341: AND oes.bucket < l_bucket
2342: AND oes.bucket_duration = l_bucket_length
2343: GROUP BY oes.currency_code

Line 2365: = OE_CREDIT_CHECK_UTIL.G_hierarchy_type

2361: and hn.child_object_type = 'ORGANIZATION'
2362: and hn.effective_start_date <= sysdate
2363: and hn.effective_end_date >= SYSDATE
2364: and hn.hierarchy_type
2365: = OE_CREDIT_CHECK_UTIL.G_hierarchy_type
2366: AND oes.party_id = hn.child_id
2367: AND oes.bucket < l_bucket
2368: AND oes.bucket_duration = l_bucket_length
2369: GROUP BY oes.currency_code

Line 2386: = OE_CREDIT_CHECK_UTIL.G_hierarchy_type

2382: and hn.child_object_type = 'ORGANIZATION'
2383: and hn.effective_start_date <= sysdate
2384: and hn.effective_end_date >= SYSDATE
2385: and hn.hierarchy_type
2386: = OE_CREDIT_CHECK_UTIL.G_hierarchy_type
2387: AND oes.party_id = hn.child_id
2388: AND oes.bucket < l_br_bucket
2389: AND oes.bucket_duration = l_br_bucket_length
2390: GROUP BY oes.currency_code

Line 2496: oe_credit_check_util.get_drawee_site_use_id ( p_site_use_id);

2492:
2493: IF p_credit_check_rule_rec.open_ar_balance_flag = 'Y'
2494: THEN
2495: l_br_site_use_id :=
2496: oe_credit_check_util.get_drawee_site_use_id ( p_site_use_id);
2497: END IF;
2498:
2499: IF b8 = G_INVOICES
2500: THEN

Line 2580: OE_CREDIT_CHECK_UTIL.CONVERT_CURRENCY_AMOUNT

2576: END IF;
2577:
2578: BEGIN
2579: l_term :=
2580: OE_CREDIT_CHECK_UTIL.CONVERT_CURRENCY_AMOUNT
2581: ( p_amount => l_balance
2582: , p_transactional_currency => l_currency_code
2583: , p_limit_currency => p_limit_curr_code
2584: , p_functional_currency => g_functional_currency

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

2642: || l_bucket || '/' || l_bucket_length, 2 );
2643: END IF;
2644:
2645:
2646: IF ( NVL(INSTRB(OE_CREDIT_CHECK_UTIL.G_excl_curr_list,
2647: l_currency_code ,1,1),0) = 0 )
2648: OR
2649: ((NVL(INSTRB(OE_CREDIT_CHECK_UTIL.G_excl_curr_list,
2650: l_currency_code ,1,1),0) > 0 )

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

2645:
2646: IF ( NVL(INSTRB(OE_CREDIT_CHECK_UTIL.G_excl_curr_list,
2647: l_currency_code ,1,1),0) = 0 )
2648: OR
2649: ((NVL(INSTRB(OE_CREDIT_CHECK_UTIL.G_excl_curr_list,
2650: l_currency_code ,1,1),0) > 0 )
2651: AND ( l_currency_code = p_limit_curr_code )
2652: )
2653: THEN

Line 2656: OE_CREDIT_CHECK_UTIL.CONVERT_CURRENCY_AMOUNT

2652: )
2653: THEN
2654: BEGIN
2655: l_term :=
2656: OE_CREDIT_CHECK_UTIL.CONVERT_CURRENCY_AMOUNT
2657: ( p_amount => l_balance
2658: , p_transactional_currency => l_currency_code
2659: , p_limit_currency => p_limit_curr_code
2660: , p_functional_currency => g_functional_currency

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

2710: || l_bucket || '/' || l_bucket_length, 2 );
2711: END IF;
2712:
2713:
2714: IF ( NVL(INSTRB(OE_CREDIT_CHECK_UTIL.G_excl_curr_list,
2715: l_currency_code ,1,1),0) = 0 )
2716: OR
2717: ((NVL(INSTRB(OE_CREDIT_CHECK_UTIL.G_excl_curr_list,
2718: l_currency_code ,1,1),0) > 0 )

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

2713:
2714: IF ( NVL(INSTRB(OE_CREDIT_CHECK_UTIL.G_excl_curr_list,
2715: l_currency_code ,1,1),0) = 0 )
2716: OR
2717: ((NVL(INSTRB(OE_CREDIT_CHECK_UTIL.G_excl_curr_list,
2718: l_currency_code ,1,1),0) > 0 )
2719: AND ( l_currency_code = p_limit_curr_code )
2720: )
2721: THEN

Line 2724: OE_CREDIT_CHECK_UTIL.CONVERT_CURRENCY_AMOUNT

2720: )
2721: THEN
2722: BEGIN
2723: l_term :=
2724: OE_CREDIT_CHECK_UTIL.CONVERT_CURRENCY_AMOUNT
2725: ( p_amount => l_balance
2726: , p_transactional_currency => l_currency_code
2727: , p_limit_currency => p_limit_curr_code
2728: , p_functional_currency => g_functional_currency

Line 2761: oe_credit_check_util.get_drawee_site_use_id ( p_site_use_id);

2757: ---------------------start BR -------------------
2758: IF p_credit_check_rule_rec.open_ar_balance_flag = 'Y'
2759: THEN
2760: l_br_site_use_id :=
2761: oe_credit_check_util.get_drawee_site_use_id ( p_site_use_id);
2762: END IF;
2763:
2764: IF l_br_site_use_id IS NOT NULL
2765: AND b8 = G_INVOICES

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

2786: || l_br_balance || ' and bucket/length '
2787: || l_bucket || '/' || l_bucket_length, 2 );
2788: END IF;
2789:
2790: IF ( NVL(INSTRB(OE_CREDIT_CHECK_UTIL.G_excl_curr_list,
2791: l_currency_code ,1,1),0) = 0 )
2792: OR
2793: ((NVL(INSTRB(OE_CREDIT_CHECK_UTIL.G_excl_curr_list,
2794: l_currency_code ,1,1),0) > 0 )

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

2789:
2790: IF ( NVL(INSTRB(OE_CREDIT_CHECK_UTIL.G_excl_curr_list,
2791: l_currency_code ,1,1),0) = 0 )
2792: OR
2793: ((NVL(INSTRB(OE_CREDIT_CHECK_UTIL.G_excl_curr_list,
2794: l_currency_code ,1,1),0) > 0 )
2795: AND ( l_currency_code = p_limit_curr_code )
2796: )
2797: THEN

Line 2800: OE_CREDIT_CHECK_UTIL.CONVERT_CURRENCY_AMOUNT

2796: )
2797: THEN
2798: BEGIN
2799: l_term :=
2800: OE_CREDIT_CHECK_UTIL.CONVERT_CURRENCY_AMOUNT
2801: ( p_amount => l_br_balance
2802: , p_transactional_currency => l_currency_code
2803: , p_limit_currency => p_limit_curr_code
2804: , p_functional_currency => g_functional_currency

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

2856: || l_balance || ' and bucket/length ' || l_bucket
2857: || '/' || l_bucket_length, 2 );
2858: END IF;
2859:
2860: IF ( NVL(INSTRB(OE_CREDIT_CHECK_UTIL.G_excl_curr_list,
2861: l_currency_code ,1,1),0) = 0 )
2862: OR
2863: ((NVL(INSTRB(OE_CREDIT_CHECK_UTIL.G_excl_curr_list,
2864: l_currency_code ,1,1),0) > 0 )

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

2859:
2860: IF ( NVL(INSTRB(OE_CREDIT_CHECK_UTIL.G_excl_curr_list,
2861: l_currency_code ,1,1),0) = 0 )
2862: OR
2863: ((NVL(INSTRB(OE_CREDIT_CHECK_UTIL.G_excl_curr_list,
2864: l_currency_code ,1,1),0) > 0 )
2865: AND ( l_currency_code = p_limit_curr_code )
2866: )
2867: THEN

Line 2870: OE_CREDIT_CHECK_UTIL.CONVERT_CURRENCY_AMOUNT

2866: )
2867: THEN
2868: BEGIN
2869: l_term :=
2870: OE_CREDIT_CHECK_UTIL.CONVERT_CURRENCY_AMOUNT
2871: ( p_amount => l_balance
2872: , p_transactional_currency => l_currency_code
2873: , p_limit_currency => p_limit_curr_code
2874: , p_functional_currency => g_functional_currency

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

2914: || l_balance || ' and bucket/length ' || l_bucket
2915: || '/' || l_bucket_length, 2 );
2916: END IF;
2917:
2918: IF ( NVL(INSTRB(OE_CREDIT_CHECK_UTIL.G_excl_curr_list,
2919: l_currency_code ,1,1),0) = 0 )
2920: OR
2921: ((NVL(INSTRB(OE_CREDIT_CHECK_UTIL.G_excl_curr_list,
2922: l_currency_code ,1,1),0) > 0 )

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

2917:
2918: IF ( NVL(INSTRB(OE_CREDIT_CHECK_UTIL.G_excl_curr_list,
2919: l_currency_code ,1,1),0) = 0 )
2920: OR
2921: ((NVL(INSTRB(OE_CREDIT_CHECK_UTIL.G_excl_curr_list,
2922: l_currency_code ,1,1),0) > 0 )
2923: AND ( l_currency_code = p_limit_curr_code )
2924: )
2925: THEN

Line 2928: OE_CREDIT_CHECK_UTIL.CONVERT_CURRENCY_AMOUNT

2924: )
2925: THEN
2926: BEGIN
2927: l_term :=
2928: OE_CREDIT_CHECK_UTIL.CONVERT_CURRENCY_AMOUNT
2929: ( p_amount => l_balance
2930: , p_transactional_currency => l_currency_code
2931: , p_limit_currency => p_limit_curr_code
2932: , p_functional_currency => g_functional_currency

Line 3030: OE_CREDIT_CHECK_UTIL.CONVERT_CURRENCY_AMOUNT

3026: || ' currency with BR balance ' || l_br_balance, 2 );
3027: END IF;
3028: BEGIN
3029: l_term :=
3030: OE_CREDIT_CHECK_UTIL.CONVERT_CURRENCY_AMOUNT
3031: ( p_amount => l_balance +
3032: NVL(l_br_balance,0)
3033: , p_transactional_currency => l_currency_code
3034: , p_limit_currency => p_limit_curr_code

Line 3085: OE_CREDIT_CHECK_UTIL.CONVERT_CURRENCY_AMOUNT

3081: || ' currency with balance ' || l_balance, 2 );
3082: END IF;
3083: BEGIN
3084: l_term :=
3085: OE_CREDIT_CHECK_UTIL.CONVERT_CURRENCY_AMOUNT
3086: ( p_amount => l_balance
3087: , p_transactional_currency => l_currency_code
3088: , p_limit_currency => p_limit_curr_code
3089: , p_functional_currency => g_functional_currency

Line 3155: OE_CREDIT_CHECK_UTIL.CONVERT_CURRENCY_AMOUNT

3151: END IF;
3152:
3153: BEGIN
3154: l_term :=
3155: OE_CREDIT_CHECK_UTIL.CONVERT_CURRENCY_AMOUNT
3156: ( p_amount => l_balance +
3157: NVL(l_br_balance,0)
3158: , p_transactional_currency => l_currency_code
3159: , p_limit_currency => p_limit_curr_code

Line 3211: OE_CREDIT_CHECK_UTIL.CONVERT_CURRENCY_AMOUNT

3207: END IF;
3208:
3209: BEGIN
3210: l_term :=
3211: OE_CREDIT_CHECK_UTIL.CONVERT_CURRENCY_AMOUNT
3212: ( p_amount => l_balance
3213: , p_transactional_currency => l_currency_code
3214: , p_limit_currency => p_limit_curr_code
3215: , p_functional_currency => g_functional_currency

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

3282: || l_balance || ' and bucket/length '
3283: || l_bucket || '/' || l_bucket_length, 2 );
3284: END IF;
3285:
3286: IF ( NVL(INSTRB(OE_CREDIT_CHECK_UTIL.G_excl_curr_list,
3287: l_currency_code ,1,1),0) = 0 )
3288: OR
3289: ((NVL(INSTRB(OE_CREDIT_CHECK_UTIL.G_excl_curr_list,
3290: l_currency_code ,1,1),0) > 0 )

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

3285:
3286: IF ( NVL(INSTRB(OE_CREDIT_CHECK_UTIL.G_excl_curr_list,
3287: l_currency_code ,1,1),0) = 0 )
3288: OR
3289: ((NVL(INSTRB(OE_CREDIT_CHECK_UTIL.G_excl_curr_list,
3290: l_currency_code ,1,1),0) > 0 )
3291: AND ( l_currency_code = p_limit_curr_code )
3292: )
3293: THEN

Line 3296: OE_CREDIT_CHECK_UTIL.CONVERT_CURRENCY_AMOUNT

3292: )
3293: THEN
3294: BEGIN
3295: l_term :=
3296: OE_CREDIT_CHECK_UTIL.CONVERT_CURRENCY_AMOUNT
3297: ( p_amount => l_balance
3298: , p_transactional_currency => l_currency_code
3299: , p_limit_currency => p_limit_curr_code
3300: , p_functional_currency => g_functional_currency

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

3337: || l_balance || ' and bucket/length '
3338: || l_bucket || '/' || l_bucket_length, 2 );
3339: END IF;
3340:
3341: IF ( NVL(INSTRB(OE_CREDIT_CHECK_UTIL.G_excl_curr_list,
3342: l_currency_code ,1,1),0) = 0 )
3343: OR
3344: ((NVL(INSTRB(OE_CREDIT_CHECK_UTIL.G_excl_curr_list,
3345: l_currency_code ,1,1),0) > 0 )

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

3340:
3341: IF ( NVL(INSTRB(OE_CREDIT_CHECK_UTIL.G_excl_curr_list,
3342: l_currency_code ,1,1),0) = 0 )
3343: OR
3344: ((NVL(INSTRB(OE_CREDIT_CHECK_UTIL.G_excl_curr_list,
3345: l_currency_code ,1,1),0) > 0 )
3346: AND ( l_currency_code = p_limit_curr_code )
3347: )
3348: THEN

Line 3351: OE_CREDIT_CHECK_UTIL.CONVERT_CURRENCY_AMOUNT

3347: )
3348: THEN
3349: BEGIN
3350: l_term :=
3351: OE_CREDIT_CHECK_UTIL.CONVERT_CURRENCY_AMOUNT
3352: ( p_amount => l_balance
3353: , p_transactional_currency => l_currency_code
3354: , p_limit_currency => p_limit_curr_code
3355: , p_functional_currency => g_functional_currency

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

3412: || l_bucket || '/' || l_bucket_length, 2 );
3413: END IF;
3414:
3415:
3416: IF ( NVL(INSTRB(OE_CREDIT_CHECK_UTIL.G_excl_curr_list,
3417: l_currency_code ,1,1),0) = 0 )
3418: OR
3419: ((NVL(INSTRB(OE_CREDIT_CHECK_UTIL.G_excl_curr_list,
3420: l_currency_code ,1,1),0) > 0 )

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

3415:
3416: IF ( NVL(INSTRB(OE_CREDIT_CHECK_UTIL.G_excl_curr_list,
3417: l_currency_code ,1,1),0) = 0 )
3418: OR
3419: ((NVL(INSTRB(OE_CREDIT_CHECK_UTIL.G_excl_curr_list,
3420: l_currency_code ,1,1),0) > 0 )
3421: AND ( l_currency_code = p_limit_curr_code )
3422: )
3423: THEN

Line 3426: OE_CREDIT_CHECK_UTIL.CONVERT_CURRENCY_AMOUNT

3422: )
3423: THEN
3424: BEGIN
3425: l_term :=
3426: OE_CREDIT_CHECK_UTIL.CONVERT_CURRENCY_AMOUNT
3427: ( p_amount => l_br_balance
3428: , p_transactional_currency => l_currency_code
3429: , p_limit_currency => p_limit_curr_code
3430: , p_functional_currency => g_functional_currency

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

3482: || l_bucket || '/' || l_bucket_length, 2 );
3483:
3484: END IF;
3485:
3486: IF ( NVL(INSTRB(OE_CREDIT_CHECK_UTIL.G_excl_curr_list,
3487: l_currency_code ,1,1),0) = 0 )
3488: OR
3489: ((NVL(INSTRB(OE_CREDIT_CHECK_UTIL.G_excl_curr_list,
3490: l_currency_code ,1,1),0) > 0 )

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

3485:
3486: IF ( NVL(INSTRB(OE_CREDIT_CHECK_UTIL.G_excl_curr_list,
3487: l_currency_code ,1,1),0) = 0 )
3488: OR
3489: ((NVL(INSTRB(OE_CREDIT_CHECK_UTIL.G_excl_curr_list,
3490: l_currency_code ,1,1),0) > 0 )
3491: AND ( l_currency_code = p_limit_curr_code )
3492: )
3493: THEN

Line 3496: OE_CREDIT_CHECK_UTIL.CONVERT_CURRENCY_AMOUNT

3492: )
3493: THEN
3494: BEGIN
3495: l_term :=
3496: OE_CREDIT_CHECK_UTIL.CONVERT_CURRENCY_AMOUNT
3497: ( p_amount => l_balance
3498: , p_transactional_currency => l_currency_code
3499: , p_limit_currency => p_limit_curr_code
3500: , p_functional_currency => g_functional_currency

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

3538: || l_bucket || '/' || l_bucket_length, 2 );
3539:
3540: END IF;
3541:
3542: IF ( NVL(INSTRB(OE_CREDIT_CHECK_UTIL.G_excl_curr_list,
3543: l_currency_code ,1,1),0) = 0 )
3544: OR
3545: ((NVL(INSTRB(OE_CREDIT_CHECK_UTIL.G_excl_curr_list,
3546: l_currency_code ,1,1),0) > 0 )

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

3541:
3542: IF ( NVL(INSTRB(OE_CREDIT_CHECK_UTIL.G_excl_curr_list,
3543: l_currency_code ,1,1),0) = 0 )
3544: OR
3545: ((NVL(INSTRB(OE_CREDIT_CHECK_UTIL.G_excl_curr_list,
3546: l_currency_code ,1,1),0) > 0 )
3547: AND ( l_currency_code = p_limit_curr_code )
3548: )
3549: THEN

Line 3552: OE_CREDIT_CHECK_UTIL.CONVERT_CURRENCY_AMOUNT

3548: )
3549: THEN
3550: BEGIN
3551: l_term :=
3552: OE_CREDIT_CHECK_UTIL.CONVERT_CURRENCY_AMOUNT
3553: ( p_amount => l_balance
3554: , p_transactional_currency => l_currency_code
3555: , p_limit_currency => p_limit_curr_code
3556: , p_functional_currency => g_functional_currency

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

3607: || l_balance || ' and bucket/length '
3608: || l_bucket || '/' || l_bucket_length, 2 );
3609: END IF;
3610:
3611: IF ( NVL(INSTRB(OE_CREDIT_CHECK_UTIL.G_excl_curr_list,
3612: l_currency_code ,1,1),0) = 0 )
3613: OR
3614: ((NVL(INSTRB(OE_CREDIT_CHECK_UTIL.G_excl_curr_list,
3615: l_currency_code ,1,1),0) > 0 )

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

3610:
3611: IF ( NVL(INSTRB(OE_CREDIT_CHECK_UTIL.G_excl_curr_list,
3612: l_currency_code ,1,1),0) = 0 )
3613: OR
3614: ((NVL(INSTRB(OE_CREDIT_CHECK_UTIL.G_excl_curr_list,
3615: l_currency_code ,1,1),0) > 0 )
3616: AND ( l_currency_code = p_limit_curr_code )
3617: )
3618: THEN

Line 3621: OE_CREDIT_CHECK_UTIL.CONVERT_CURRENCY_AMOUNT

3617: )
3618: THEN
3619: BEGIN
3620: l_term :=
3621: OE_CREDIT_CHECK_UTIL.CONVERT_CURRENCY_AMOUNT
3622: ( p_amount => l_balance
3623: , p_transactional_currency => l_currency_code
3624: , p_limit_currency => p_limit_curr_code
3625: , p_functional_currency => g_functional_currency

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

3665: || l_balance || ' and bucket/length '
3666: || l_bucket || '/' || l_bucket_length, 2 );
3667: END IF;
3668:
3669: IF ( NVL(INSTRB(OE_CREDIT_CHECK_UTIL.G_excl_curr_list,
3670: l_currency_code ,1,1),0) = 0 )
3671: OR
3672: ((NVL(INSTRB(OE_CREDIT_CHECK_UTIL.G_excl_curr_list,
3673: l_currency_code ,1,1),0) > 0 )

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

3668:
3669: IF ( NVL(INSTRB(OE_CREDIT_CHECK_UTIL.G_excl_curr_list,
3670: l_currency_code ,1,1),0) = 0 )
3671: OR
3672: ((NVL(INSTRB(OE_CREDIT_CHECK_UTIL.G_excl_curr_list,
3673: l_currency_code ,1,1),0) > 0 )
3674: AND ( l_currency_code = p_limit_curr_code )
3675: )
3676: THEN

Line 3679: OE_CREDIT_CHECK_UTIL.CONVERT_CURRENCY_AMOUNT

3675: )
3676: THEN
3677: BEGIN
3678: l_term :=
3679: OE_CREDIT_CHECK_UTIL.CONVERT_CURRENCY_AMOUNT
3680: ( p_amount => l_balance
3681: , p_transactional_currency => l_currency_code
3682: , p_limit_currency => p_limit_curr_code
3683: , p_functional_currency => g_functional_currency

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

3728: || l_br_balance || ' and bucket/length '
3729: || l_bucket || '/' || l_bucket_length, 2 );
3730: END IF;
3731:
3732: IF ( NVL(INSTRB(OE_CREDIT_CHECK_UTIL.G_excl_curr_list,
3733: l_currency_code ,1,1),0) = 0 )
3734: OR
3735: ((NVL(INSTRB(OE_CREDIT_CHECK_UTIL.G_excl_curr_list,
3736: l_currency_code ,1,1),0) > 0 )

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

3731:
3732: IF ( NVL(INSTRB(OE_CREDIT_CHECK_UTIL.G_excl_curr_list,
3733: l_currency_code ,1,1),0) = 0 )
3734: OR
3735: ((NVL(INSTRB(OE_CREDIT_CHECK_UTIL.G_excl_curr_list,
3736: l_currency_code ,1,1),0) > 0 )
3737: AND ( l_currency_code = p_limit_curr_code )
3738: )
3739: THEN

Line 3742: OE_CREDIT_CHECK_UTIL.CONVERT_CURRENCY_AMOUNT

3738: )
3739: THEN
3740: BEGIN
3741: l_term :=
3742: OE_CREDIT_CHECK_UTIL.CONVERT_CURRENCY_AMOUNT
3743: ( p_amount => l_br_balance
3744: , p_transactional_currency => l_currency_code
3745: , p_limit_currency => p_limit_curr_code
3746: , p_functional_currency => g_functional_currency

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

3797: || l_balance || ' and bucket/length '
3798: || l_bucket || '/' || l_bucket_length, 2 );
3799: END IF;
3800:
3801: IF ( NVL(INSTRB(OE_CREDIT_CHECK_UTIL.G_excl_curr_list,
3802: l_currency_code ,1,1),0) = 0 )
3803: OR
3804: ((NVL(INSTRB(OE_CREDIT_CHECK_UTIL.G_excl_curr_list,
3805: l_currency_code ,1,1),0) > 0 )

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

3800:
3801: IF ( NVL(INSTRB(OE_CREDIT_CHECK_UTIL.G_excl_curr_list,
3802: l_currency_code ,1,1),0) = 0 )
3803: OR
3804: ((NVL(INSTRB(OE_CREDIT_CHECK_UTIL.G_excl_curr_list,
3805: l_currency_code ,1,1),0) > 0 )
3806: AND ( l_currency_code = p_limit_curr_code )
3807: )
3808: THEN

Line 3811: OE_CREDIT_CHECK_UTIL.CONVERT_CURRENCY_AMOUNT

3807: )
3808: THEN
3809: BEGIN
3810: l_term :=
3811: OE_CREDIT_CHECK_UTIL.CONVERT_CURRENCY_AMOUNT
3812: ( p_amount => l_balance
3813: , p_transactional_currency => l_currency_code
3814: , p_limit_currency => p_limit_curr_code
3815: , p_functional_currency => g_functional_currency

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

3854: || l_balance || ' and bucket/length '
3855: || l_bucket || '/' || l_bucket_length, 2 );
3856: END IF;
3857:
3858: IF ( NVL(INSTRB(OE_CREDIT_CHECK_UTIL.G_excl_curr_list,
3859: l_currency_code ,1,1),0) = 0 )
3860: OR
3861: ((NVL(INSTRB(OE_CREDIT_CHECK_UTIL.G_excl_curr_list,
3862: l_currency_code ,1,1),0) > 0 )

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

3857:
3858: IF ( NVL(INSTRB(OE_CREDIT_CHECK_UTIL.G_excl_curr_list,
3859: l_currency_code ,1,1),0) = 0 )
3860: OR
3861: ((NVL(INSTRB(OE_CREDIT_CHECK_UTIL.G_excl_curr_list,
3862: l_currency_code ,1,1),0) > 0 )
3863: AND ( l_currency_code = p_limit_curr_code )
3864: )
3865: THEN

Line 3868: OE_CREDIT_CHECK_UTIL.CONVERT_CURRENCY_AMOUNT

3864: )
3865: THEN
3866: BEGIN
3867: l_term :=
3868: OE_CREDIT_CHECK_UTIL.CONVERT_CURRENCY_AMOUNT
3869: ( p_amount => l_balance
3870: , p_transactional_currency => l_currency_code
3871: , p_limit_currency => p_limit_curr_code
3872: , p_functional_currency => g_functional_currency

Line 3974: OE_CREDIT_CHECK_UTIL.CONVERT_CURRENCY_AMOUNT

3970: || ' currency with BR balance ' || l_br_balance, 2 );
3971: END IF;
3972: BEGIN
3973: l_term :=
3974: OE_CREDIT_CHECK_UTIL.CONVERT_CURRENCY_AMOUNT
3975: ( p_amount => l_balance +
3976: NVL(l_br_balance,0)
3977: , p_transactional_currency => l_currency_code
3978: , p_limit_currency => p_limit_curr_code

Line 4035: OE_CREDIT_CHECK_UTIL.CONVERT_CURRENCY_AMOUNT

4031: || ' currency with balance ' || l_balance, 2 );
4032: END IF;
4033: BEGIN
4034: l_term :=
4035: OE_CREDIT_CHECK_UTIL.CONVERT_CURRENCY_AMOUNT
4036: ( p_amount => l_balance
4037: , p_transactional_currency => l_currency_code
4038: , p_limit_currency => p_limit_curr_code
4039: , p_functional_currency => g_functional_currency

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

4069: ELSE --- Hierarchy usages
4070: IF G_debug_flag = 'Y'
4071: THEN
4072: oe_debug_pub.add(' Hierarchy Usages ',1);
4073: oe_debug_pub.add(' OE_CREDIT_CHECK_UTIL.G_hierarchy_type => '||
4074: OE_CREDIT_CHECK_UTIL.G_hierarchy_type );
4075: oe_debug_pub.add(' G_MAX_BUCKET_LENGTH => '||
4076: G_MAX_BUCKET_LENGTH);
4077: END IF;

Line 4074: OE_CREDIT_CHECK_UTIL.G_hierarchy_type );

4070: IF G_debug_flag = 'Y'
4071: THEN
4072: oe_debug_pub.add(' Hierarchy Usages ',1);
4073: oe_debug_pub.add(' OE_CREDIT_CHECK_UTIL.G_hierarchy_type => '||
4074: OE_CREDIT_CHECK_UTIL.G_hierarchy_type );
4075: oe_debug_pub.add(' G_MAX_BUCKET_LENGTH => '||
4076: G_MAX_BUCKET_LENGTH);
4077: END IF;
4078:

Line 4119: OE_CREDIT_CHECK_UTIL.CONVERT_CURRENCY_AMOUNT

4115: END IF;
4116:
4117: BEGIN
4118: l_term :=
4119: OE_CREDIT_CHECK_UTIL.CONVERT_CURRENCY_AMOUNT
4120: ( p_amount => l_balance
4121: + nvl(l_br_balance ,0)
4122: , p_transactional_currency => l_currency_code
4123: , p_limit_currency => p_limit_curr_code

Line 4177: OE_CREDIT_CHECK_UTIL.CONVERT_CURRENCY_AMOUNT

4173: END IF;
4174:
4175: BEGIN
4176: l_term :=
4177: OE_CREDIT_CHECK_UTIL.CONVERT_CURRENCY_AMOUNT
4178: ( p_amount => l_balance
4179: , p_transactional_currency => l_currency_code
4180: , p_limit_currency => p_limit_curr_code
4181: , p_functional_currency => g_functional_currency

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

4249: || l_balance || ' and bucket/length '
4250: || l_bucket || '/' || l_bucket_length, 2 );
4251: END IF;
4252:
4253: IF ( NVL(INSTRB(OE_CREDIT_CHECK_UTIL.G_excl_curr_list,
4254: l_currency_code ,1,1),0) = 0 )
4255: OR
4256: ((NVL(INSTRB(OE_CREDIT_CHECK_UTIL.G_excl_curr_list,
4257: l_currency_code ,1,1),0) > 0 )

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

4252:
4253: IF ( NVL(INSTRB(OE_CREDIT_CHECK_UTIL.G_excl_curr_list,
4254: l_currency_code ,1,1),0) = 0 )
4255: OR
4256: ((NVL(INSTRB(OE_CREDIT_CHECK_UTIL.G_excl_curr_list,
4257: l_currency_code ,1,1),0) > 0 )
4258: AND ( l_currency_code = p_limit_curr_code )
4259: )
4260: THEN

Line 4263: OE_CREDIT_CHECK_UTIL.CONVERT_CURRENCY_AMOUNT

4259: )
4260: THEN
4261: BEGIN
4262: l_term :=
4263: OE_CREDIT_CHECK_UTIL.CONVERT_CURRENCY_AMOUNT
4264: ( p_amount => l_balance
4265: , p_transactional_currency => l_currency_code
4266: , p_limit_currency => p_limit_curr_code
4267: , p_functional_currency => g_functional_currency

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

4306: || l_balance || ' and bucket/length '
4307: || l_bucket || '/' || l_bucket_length, 2 );
4308: END IF;
4309:
4310: IF ( NVL(INSTRB(OE_CREDIT_CHECK_UTIL.G_excl_curr_list,
4311: l_currency_code ,1,1),0) = 0 )
4312: OR
4313: ((NVL(INSTRB(OE_CREDIT_CHECK_UTIL.G_excl_curr_list,
4314: l_currency_code ,1,1),0) > 0 )

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

4309:
4310: IF ( NVL(INSTRB(OE_CREDIT_CHECK_UTIL.G_excl_curr_list,
4311: l_currency_code ,1,1),0) = 0 )
4312: OR
4313: ((NVL(INSTRB(OE_CREDIT_CHECK_UTIL.G_excl_curr_list,
4314: l_currency_code ,1,1),0) > 0 )
4315: AND ( l_currency_code = p_limit_curr_code )
4316: )
4317: THEN

Line 4320: OE_CREDIT_CHECK_UTIL.CONVERT_CURRENCY_AMOUNT

4316: )
4317: THEN
4318: BEGIN
4319: l_term :=
4320: OE_CREDIT_CHECK_UTIL.CONVERT_CURRENCY_AMOUNT
4321: ( p_amount => l_balance
4322: , p_transactional_currency => l_currency_code
4323: , p_limit_currency => p_limit_curr_code
4324: , p_functional_currency => g_functional_currency

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

4370: || l_br_balance || ' and bucket/length '
4371: || l_bucket || '/' || l_bucket_length, 2 );
4372: END IF;
4373:
4374: IF ( NVL(INSTRB(OE_CREDIT_CHECK_UTIL.G_excl_curr_list,
4375: l_currency_code ,1,1),0) = 0 )
4376: OR
4377: ((NVL(INSTRB(OE_CREDIT_CHECK_UTIL.G_excl_curr_list,
4378: l_currency_code ,1,1),0) > 0 )

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

4373:
4374: IF ( NVL(INSTRB(OE_CREDIT_CHECK_UTIL.G_excl_curr_list,
4375: l_currency_code ,1,1),0) = 0 )
4376: OR
4377: ((NVL(INSTRB(OE_CREDIT_CHECK_UTIL.G_excl_curr_list,
4378: l_currency_code ,1,1),0) > 0 )
4379: AND ( l_currency_code = p_limit_curr_code )
4380: )
4381: THEN

Line 4384: OE_CREDIT_CHECK_UTIL.CONVERT_CURRENCY_AMOUNT

4380: )
4381: THEN
4382: BEGIN
4383: l_term :=
4384: OE_CREDIT_CHECK_UTIL.CONVERT_CURRENCY_AMOUNT
4385: ( p_amount => l_br_balance
4386: , p_transactional_currency => l_currency_code
4387: , p_limit_currency => p_limit_curr_code
4388: , p_functional_currency => g_functional_currency

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

4442: || l_balance || ' and bucket/length '
4443: || l_bucket || '/' || l_bucket_length, 2 );
4444: END IF;
4445:
4446: IF ( NVL(INSTRB(OE_CREDIT_CHECK_UTIL.G_excl_curr_list,
4447: l_currency_code ,1,1),0) = 0 )
4448: OR
4449: ((NVL(INSTRB(OE_CREDIT_CHECK_UTIL.G_excl_curr_list,
4450: l_currency_code ,1,1),0) > 0 )

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

4445:
4446: IF ( NVL(INSTRB(OE_CREDIT_CHECK_UTIL.G_excl_curr_list,
4447: l_currency_code ,1,1),0) = 0 )
4448: OR
4449: ((NVL(INSTRB(OE_CREDIT_CHECK_UTIL.G_excl_curr_list,
4450: l_currency_code ,1,1),0) > 0 )
4451: AND ( l_currency_code = p_limit_curr_code )
4452: )
4453: THEN

Line 4456: OE_CREDIT_CHECK_UTIL.CONVERT_CURRENCY_AMOUNT

4452: )
4453: THEN
4454: BEGIN
4455: l_term :=
4456: OE_CREDIT_CHECK_UTIL.CONVERT_CURRENCY_AMOUNT
4457: ( p_amount => l_balance
4458: , p_transactional_currency => l_currency_code
4459: , p_limit_currency => p_limit_curr_code
4460: , p_functional_currency => g_functional_currency

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

4501: || l_balance || ' and bucket/length '
4502: || l_bucket || '/' || l_bucket_length, 2 );
4503: END IF;
4504:
4505: IF ( NVL(INSTRB(OE_CREDIT_CHECK_UTIL.G_excl_curr_list,
4506: l_currency_code ,1,1),0) = 0 )
4507: OR
4508: ((NVL(INSTRB(OE_CREDIT_CHECK_UTIL.G_excl_curr_list,
4509: l_currency_code ,1,1),0) > 0 )

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

4504:
4505: IF ( NVL(INSTRB(OE_CREDIT_CHECK_UTIL.G_excl_curr_list,
4506: l_currency_code ,1,1),0) = 0 )
4507: OR
4508: ((NVL(INSTRB(OE_CREDIT_CHECK_UTIL.G_excl_curr_list,
4509: l_currency_code ,1,1),0) > 0 )
4510: AND ( l_currency_code = p_limit_curr_code )
4511: )
4512: THEN

Line 4515: OE_CREDIT_CHECK_UTIL.CONVERT_CURRENCY_AMOUNT

4511: )
4512: THEN
4513: BEGIN
4514: l_term :=
4515: OE_CREDIT_CHECK_UTIL.CONVERT_CURRENCY_AMOUNT
4516: ( p_amount => l_balance
4517: , p_transactional_currency => l_currency_code
4518: , p_limit_currency => p_limit_curr_code
4519: , p_functional_currency => g_functional_currency

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

4574: || l_balance || ' and bucket/length '
4575: || l_bucket || '/' || l_bucket_length, 2 );
4576: END IF;
4577:
4578: IF ( NVL(INSTRB(OE_CREDIT_CHECK_UTIL.G_excl_curr_list,
4579: l_currency_code ,1,1),0) = 0 )
4580: OR
4581: ((NVL(INSTRB(OE_CREDIT_CHECK_UTIL.G_excl_curr_list,
4582: l_currency_code ,1,1),0) > 0 )

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

4577:
4578: IF ( NVL(INSTRB(OE_CREDIT_CHECK_UTIL.G_excl_curr_list,
4579: l_currency_code ,1,1),0) = 0 )
4580: OR
4581: ((NVL(INSTRB(OE_CREDIT_CHECK_UTIL.G_excl_curr_list,
4582: l_currency_code ,1,1),0) > 0 )
4583: AND ( l_currency_code = p_limit_curr_code )
4584: )
4585: THEN

Line 4588: OE_CREDIT_CHECK_UTIL.CONVERT_CURRENCY_AMOUNT

4584: )
4585: THEN
4586: BEGIN
4587: l_term :=
4588: OE_CREDIT_CHECK_UTIL.CONVERT_CURRENCY_AMOUNT
4589: ( p_amount => l_balance
4590: , p_transactional_currency => l_currency_code
4591: , p_limit_currency => p_limit_curr_code
4592: , p_functional_currency => g_functional_currency

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

4633: || l_balance || ' and bucket/length '
4634: || l_bucket || '/' || l_bucket_length, 2 );
4635: END IF;
4636:
4637: IF ( NVL(INSTRB(OE_CREDIT_CHECK_UTIL.G_excl_curr_list,
4638: l_currency_code ,1,1),0) = 0 )
4639: OR
4640: ((NVL(INSTRB(OE_CREDIT_CHECK_UTIL.G_excl_curr_list,
4641: l_currency_code ,1,1),0) > 0 )

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

4636:
4637: IF ( NVL(INSTRB(OE_CREDIT_CHECK_UTIL.G_excl_curr_list,
4638: l_currency_code ,1,1),0) = 0 )
4639: OR
4640: ((NVL(INSTRB(OE_CREDIT_CHECK_UTIL.G_excl_curr_list,
4641: l_currency_code ,1,1),0) > 0 )
4642: AND ( l_currency_code = p_limit_curr_code )
4643: )
4644: THEN

Line 4647: OE_CREDIT_CHECK_UTIL.CONVERT_CURRENCY_AMOUNT

4643: )
4644: THEN
4645: BEGIN
4646: l_term :=
4647: OE_CREDIT_CHECK_UTIL.CONVERT_CURRENCY_AMOUNT
4648: ( p_amount => l_balance
4649: , p_transactional_currency => l_currency_code
4650: , p_limit_currency => p_limit_curr_code
4651: , p_functional_currency => g_functional_currency

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

4695: || l_BR_balance || ' and bucket/length '
4696: || l_bucket || '/' || l_bucket_length, 2 );
4697: END IF;
4698:
4699: IF ( NVL(INSTRB(OE_CREDIT_CHECK_UTIL.G_excl_curr_list,
4700: l_currency_code ,1,1),0) = 0 )
4701: OR
4702: ((NVL(INSTRB(OE_CREDIT_CHECK_UTIL.G_excl_curr_list,
4703: l_currency_code ,1,1),0) > 0 )

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

4698:
4699: IF ( NVL(INSTRB(OE_CREDIT_CHECK_UTIL.G_excl_curr_list,
4700: l_currency_code ,1,1),0) = 0 )
4701: OR
4702: ((NVL(INSTRB(OE_CREDIT_CHECK_UTIL.G_excl_curr_list,
4703: l_currency_code ,1,1),0) > 0 )
4704: AND ( l_currency_code = p_limit_curr_code )
4705: )
4706: THEN

Line 4709: OE_CREDIT_CHECK_UTIL.CONVERT_CURRENCY_AMOUNT

4705: )
4706: THEN
4707: BEGIN
4708: l_term :=
4709: OE_CREDIT_CHECK_UTIL.CONVERT_CURRENCY_AMOUNT
4710: ( p_amount => l_br_balance
4711: , p_transactional_currency => l_currency_code
4712: , p_limit_currency => p_limit_curr_code
4713: , p_functional_currency => g_functional_currency

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

4762: || l_balance || ' and bucket/length '
4763: || l_bucket || '/' || l_bucket_length, 2 );
4764: END IF;
4765:
4766: IF ( NVL(INSTRB(OE_CREDIT_CHECK_UTIL.G_excl_curr_list,
4767: l_currency_code ,1,1),0) = 0 )
4768: OR
4769: ((NVL(INSTRB(OE_CREDIT_CHECK_UTIL.G_excl_curr_list,
4770: l_currency_code ,1,1),0) > 0 )

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

4765:
4766: IF ( NVL(INSTRB(OE_CREDIT_CHECK_UTIL.G_excl_curr_list,
4767: l_currency_code ,1,1),0) = 0 )
4768: OR
4769: ((NVL(INSTRB(OE_CREDIT_CHECK_UTIL.G_excl_curr_list,
4770: l_currency_code ,1,1),0) > 0 )
4771: AND ( l_currency_code = p_limit_curr_code )
4772: )
4773: THEN

Line 4776: OE_CREDIT_CHECK_UTIL.CONVERT_CURRENCY_AMOUNT

4772: )
4773: THEN
4774: BEGIN
4775: l_term :=
4776: OE_CREDIT_CHECK_UTIL.CONVERT_CURRENCY_AMOUNT
4777: ( p_amount => l_balance
4778: , p_transactional_currency => l_currency_code
4779: , p_limit_currency => p_limit_curr_code
4780: , p_functional_currency => g_functional_currency

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

4821: || l_balance || ' and bucket/length '
4822: || l_bucket || '/' || l_bucket_length, 2 );
4823: END IF;
4824:
4825: IF ( NVL(INSTRB(OE_CREDIT_CHECK_UTIL.G_excl_curr_list,
4826: l_currency_code ,1,1),0) = 0 )
4827: OR
4828: ((NVL(INSTRB(OE_CREDIT_CHECK_UTIL.G_excl_curr_list,
4829: l_currency_code ,1,1),0) > 0 )

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

4824:
4825: IF ( NVL(INSTRB(OE_CREDIT_CHECK_UTIL.G_excl_curr_list,
4826: l_currency_code ,1,1),0) = 0 )
4827: OR
4828: ((NVL(INSTRB(OE_CREDIT_CHECK_UTIL.G_excl_curr_list,
4829: l_currency_code ,1,1),0) > 0 )
4830: AND ( l_currency_code = p_limit_curr_code )
4831: )
4832: THEN

Line 4835: OE_CREDIT_CHECK_UTIL.CONVERT_CURRENCY_AMOUNT

4831: )
4832: THEN
4833: BEGIN
4834: l_term :=
4835: OE_CREDIT_CHECK_UTIL.CONVERT_CURRENCY_AMOUNT
4836: ( p_amount => l_balance
4837: , p_transactional_currency => l_currency_code
4838: , p_limit_currency => p_limit_curr_code
4839: , p_functional_currency => g_functional_currency

Line 8300: OE_CREDIT_CHECK_UTIL.oe_credit_rules_rec_type

8296: , p_site_use_id IN NUMBER
8297: , p_party_id IN NUMBER := NULL
8298: , p_header_id IN NUMBER
8299: , p_credit_check_rule_rec IN
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

Line 8302: OE_CREDIT_CHECK_UTIL.oe_systems_param_rec_type

8298: , p_header_id IN NUMBER
8299: , p_credit_check_rule_rec IN
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

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

Line 8314: , x_error_curr_tbl OUT NOCOPY OE_CREDIT_CHECK_UTIL.curr_tbl_type

8310: , x_order_amount OUT NOCOPY NUMBER
8311: , x_order_hold_amount OUT NOCOPY NUMBER
8312: , x_ar_amount OUT NOCOPY NUMBER
8313: , x_return_status OUT NOCOPY VARCHAR2
8314: , x_error_curr_tbl OUT NOCOPY OE_CREDIT_CHECK_UTIL.curr_tbl_type
8315: )
8316: IS
8317:
8318: i BINARY_INTEGER;

Line 8348: = OE_CREDIT_CHECK_UTIL.G_hierarchy_type ;

8344: and hn.child_object_type = 'ORGANIZATION'
8345: and hn.effective_start_date <= sysdate
8346: and hn.effective_end_date >= SYSDATE
8347: and hn.hierarchy_type
8348: = OE_CREDIT_CHECK_UTIL.G_hierarchy_type ;
8349:
8350: BEGIN
8351: g_use_party_hierarchy := 'N' ;
8352:

Line 8488: g_functional_currency := oe_credit_check_util.Get_GL_Currency;

8484:
8485: -- Get the functional currency for use in currency conversion
8486: -- using triangulation
8487:
8488: g_functional_currency := oe_credit_check_util.Get_GL_Currency;
8489:
8490: l_org_id := OE_CREDIT_CHECK_UTIL.G_org_id; --bug# 5031301
8491: l_total := 0;
8492: l_both_exposure := 'N' ;

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

8486: -- using triangulation
8487:
8488: g_functional_currency := oe_credit_check_util.Get_GL_Currency;
8489:
8490: l_org_id := OE_CREDIT_CHECK_UTIL.G_org_id; --bug# 5031301
8491: l_total := 0;
8492: l_both_exposure := 'N' ;
8493:
8494: x_ar_amount := NULL;