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.XTR_LIMITS_P dependencies on XTR_LIMITS_P

Line 1: PACKAGE BODY XTR_LIMITS_P as

1: PACKAGE BODY XTR_LIMITS_P as
2: /* $Header: xtrlmtsb.pls 120.8 2012/03/19 22:57:32 nipant ship $ */
3: --
4: -- Global Variables/Exceptions
5: --

Line 231: v_hce_amount := xtr_limits_p.CONVERT_TO_HCE_AMOUNT(abs(p_amount),

227: */
228: --
229: -- Compute usage for this new (as yet uncommitted) record,
230: -- first calculate home-currency-equivalent for p_amount...
231: v_hce_amount := xtr_limits_p.CONVERT_TO_HCE_AMOUNT(abs(p_amount),
232: p_CURRENCY,
233: v_company_code);
234: --
235: v_new_hce_util := xtr_limits_p.WEIGHTED_USAGE(p_deal_type,p_deal_subtype,

Line 235: v_new_hce_util := xtr_limits_p.WEIGHTED_USAGE(p_deal_type,p_deal_subtype,

231: v_hce_amount := xtr_limits_p.CONVERT_TO_HCE_AMOUNT(abs(p_amount),
232: p_CURRENCY,
233: v_company_code);
234: --
235: v_new_hce_util := xtr_limits_p.WEIGHTED_USAGE(p_deal_type,p_deal_subtype,
236: p_amount_date,v_hce_amount);
237: --
238: --bug 1687715 ONC deals has deal number while insert the check should be done for trans no
239: if p_deal_number is NOT NULL and p_deal_type <> 'ONC' then

Line 309: XTR_LIMITS_P.GET_LIM_GLOBAL (p_DEAL_NUMBER,v_company_code,p_limit_code,

305: then
306: IF xtr_debug_pkg.pg_sqlplus_enable_flag = 1 THEN
307: xtr_debug_pkg.debug('Before Get_lim_global on:'||to_char(sysdate,'MM:DD:HH24:MI:SS'));
308: END IF;
309: XTR_LIMITS_P.GET_LIM_GLOBAL (p_DEAL_NUMBER,v_company_code,p_limit_code,
310: v_limit_amt,v_util_amt,v_err_code);
311: IF xtr_debug_pkg.pg_sqlplus_enable_flag = 1 THEN
312: xtr_debug_pkg.debug('After Get_lim_global on:'||to_char(sysdate,'MM:DD:HH24:MI:SS'));
313: END IF;

Line 353: XTR_LIMITS_P.GET_LIM_SOVEREIGN(p_DEAL_NUMBER,v_company_code,upper(v_country_code),

349: --
350: --
351: if v_company_code is NOT null and v_country_code is NOT null and v_settle_warn = 'WARNING'
352: then
353: XTR_LIMITS_P.GET_LIM_SOVEREIGN(p_DEAL_NUMBER,v_company_code,upper(v_country_code),
354: v_limit_amt,v_util_amt,v_err_code);
355: if v_err_code is null then
356: v_util_amt := v_util_amt + v_new_hce_util;
357: if v_util_amt > v_limit_amt then

Line 396: XTR_LIMITS_P.GET_LIM_DEALER_DEAL ( p_DEAL_NUMBER,p_dealer_code,p_deal_type,p_product_type,

392: -- ********** 3. check dealer-deal limits
393: --
394: if p_dealer_code is NOT null and p_deal_type is NOT null and p_product_type is NOT null
395: and v_settle_warn = 'WARNING' then
396: XTR_LIMITS_P.GET_LIM_DEALER_DEAL ( p_DEAL_NUMBER,p_dealer_code,p_deal_type,p_product_type,
397: v_limit_amt,v_err_code);
398: if v_err_code is null then
399: v_util_amt := v_hce_amount;
400: if v_gross_amt > v_limit_amt then

Line 453: XTR_LIMITS_P.GET_LIM_CPARTY( p_DEAL_NUMBER,v_company_code,p_cparty_code,p_limit_code,

449: -- ********** 4. check cparty limits
450: --
451: if v_company_code is NOT null and p_cparty_code is NOT null and p_limit_code is NOT null
452: and v_settle_warn = 'WARNING' then
453: XTR_LIMITS_P.GET_LIM_CPARTY( p_DEAL_NUMBER,v_company_code,p_cparty_code,p_limit_code,
454: v_limit_amt,v_util_amt,v_err_code);
455: if v_err_code is null then
456: v_util_amt := v_util_amt + v_new_hce_util;
457: if v_util_amt > v_limit_amt then

Line 507: XTR_LIMITS_P.GET_LIM_SETTLE( p_DEAL_NUMBER,v_company_code,p_limit_party,p_amount_date,

503: if v_company_code is NOT null and p_limit_party is NOT null and p_amount_date is NOT null and v_dummy=0 then
504: -- end bug 2428516
505: if v_settle_warn = 'WARNING' then
506: -- call normal settlement check - ie reflects excess if all settlements occur on amount date (warning only)
507: XTR_LIMITS_P.GET_LIM_SETTLE( p_DEAL_NUMBER,v_company_code,p_limit_party,p_amount_date,
508: v_limit_amt,v_util_amt,v_err_code);
509: else
510: -- excess only for authorised settlements - ie actual excess as settlements are authorised in pro0007
511: -- ie this is an actal excess as the settlements have been authorised

Line 512: XTR_LIMITS_P.GET_ACTUAL_SETTLE_EXCESS( p_DEAL_NUMBER,v_company_code,p_limit_party,p_amount_date,

508: v_limit_amt,v_util_amt,v_err_code);
509: else
510: -- excess only for authorised settlements - ie actual excess as settlements are authorised in pro0007
511: -- ie this is an actal excess as the settlements have been authorised
512: XTR_LIMITS_P.GET_ACTUAL_SETTLE_EXCESS( p_DEAL_NUMBER,v_company_code,p_limit_party,p_amount_date,
513: v_limit_amt,v_util_amt,v_err_code);
514: end if;
515: if v_err_code is null then
516: v_util_amt := v_util_amt + v_hce_amount;

Line 563: XTR_LIMITS_P.GET_LIM_CCY(p_DEAL_NUMBER,p_currency,v_limit_amt,v_util_amt,v_err_code);

559: -- if p_currency is NOT null and p_currency <> v_home_ccy and v_settle_warn = 'WARNING' then
560: if p_currency is NOT null and v_settle_warn = 'WARNING' then
561: -- end bug 1289530
562: -- Only check currency limits for non domestic currencies
563: XTR_LIMITS_P.GET_LIM_CCY(p_DEAL_NUMBER,p_currency,v_limit_amt,v_util_amt,v_err_code);
564: if v_err_code is null then
565: v_util_amt := v_util_amt + v_hce_amount;
566: if v_util_amt > v_limit_amt then
567: INSERT into XTR_limit_excess_log

Line 605: XTR_LIMITS_P.GET_LIM_CCY(p_DEAL_NUMBER,p_currency_second,v_limit_amt,v_util_amt,v_err_code);

601: -- bug 1289530 currency limit check for second currency
602: -- ********** 6.2. Check Currency Limits for second currency
603: --
604: if p_currency_second is NOT null and v_settle_warn = 'WARNING' then
605: XTR_LIMITS_P.GET_LIM_CCY(p_DEAL_NUMBER,p_currency_second,v_limit_amt,v_util_amt,v_err_code);
606: if v_err_code is null then
607: v_util_amt := v_util_amt + v_hce_amount;
608: if v_util_amt > v_limit_amt then
609: INSERT into XTR_limit_excess_log

Line 652: XTR_LIMITS_P.GET_LIM_GROUP(p_DEAL_NUMBER,v_company_code,v_limit_type,v_group_party,

648: open c_get_limit_type(p_limit_code,v_company_code);
649: fetch c_get_limit_type into v_limit_type;
650: close c_get_limit_type;
651: --
652: XTR_LIMITS_P.GET_LIM_GROUP(p_DEAL_NUMBER,v_company_code,v_limit_type,v_group_party,
653: v_limit_amt,v_util_amt,v_err_code);
654: if v_err_code is null then
655: v_util_amt := v_util_amt + v_new_hce_util;
656: if v_util_amt > v_limit_amt then

Line 736: XTR_LIMITS_P.GET_LIM_INTRA_DAY ( p_DEAL_NUMBER,p_dealer_code,p_deal_type,

732: /*
733: -- ********** check intra-day limits (NOT REQD AT THIS STAGE)
734: --
735: if p_dealer_code is NOT null and p_deal_type is NOT null then
736: XTR_LIMITS_P.GET_LIM_INTRA_DAY ( p_DEAL_NUMBER,p_dealer_code,p_deal_type,
737: v_limit_amt,v_util_amt,v_err_code);
738: if v_err_code is null then
739: v_util_amt := v_util_amt + v_hce_amount;
740: if v_util_amt > v_limit_amt then

Line 889: l_new_utilamt := XTR_LIMITS_P.WEIGHTED_USAGE(c.deal_type,c.deal_subtype,

885: xtr_debug_pkg.debug('After delete xtr_mirror_dda_limit_row('||to_char(sql%rowcount)||') on:'||to_char(sysdate,'MM:DD:HH24:MI:SS'));
886: END IF;
887: FOR c in HCE LOOP
888: -- Calculate weighted usage for this data.
889: l_new_utilamt := XTR_LIMITS_P.WEIGHTED_USAGE(c.deal_type,c.deal_subtype,
890: c.amount_date,c.amount);
891:
892: l_new_hce_utilamt := XTR_LIMITS_P.CONVERT_TO_HCE_AMOUNT( l_new_utilamt,
893: c.currency,

Line 892: l_new_hce_utilamt := XTR_LIMITS_P.CONVERT_TO_HCE_AMOUNT( l_new_utilamt,

888: -- Calculate weighted usage for this data.
889: l_new_utilamt := XTR_LIMITS_P.WEIGHTED_USAGE(c.deal_type,c.deal_subtype,
890: c.amount_date,c.amount);
891:
892: l_new_hce_utilamt := XTR_LIMITS_P.CONVERT_TO_HCE_AMOUNT( l_new_utilamt,
893: c.currency,
894: c.company_code);
895: l_new_hce_amt := XTR_LIMITS_P.CONVERT_TO_HCE_AMOUNT(c.amount,
896: c.currency,

Line 895: l_new_hce_amt := XTR_LIMITS_P.CONVERT_TO_HCE_AMOUNT(c.amount,

891:
892: l_new_hce_utilamt := XTR_LIMITS_P.CONVERT_TO_HCE_AMOUNT( l_new_utilamt,
893: c.currency,
894: c.company_code);
895: l_new_hce_amt := XTR_LIMITS_P.CONVERT_TO_HCE_AMOUNT(c.amount,
896: c.currency,
897: c.company_code);
898: update XTR_mirror_dda_limit_row
899: set hce_amount = l_new_hce_amt,

Line 1022: v_utilised_amount := XTR_LIMITS_P.WEIGHTED_USAGE(p_new_deal_type,

1018:
1019: if p_action <> 'DELETE' and (p_new_status_code = 'CURRENT'
1020: OR (p_old_limit_code is not null and p_new_limit_code is not null and p_new_status_code IN ('EXERCISED','SETTLED','CANCELLED'))) then
1021: -- Calculate weighted usage for this data.
1022: v_utilised_amount := XTR_LIMITS_P.WEIGHTED_USAGE(p_new_deal_type,
1023: p_new_deal_subtype,
1024: p_new_amount_date,
1025: p_new_amount);
1026: -- Now calculate home-currency-equivalent for v_utilised_amt...

Line 1027: v_hce_utilised_amt := XTR_LIMITS_P.CONVERT_TO_HCE_AMOUNT(v_utilised_amount,

1023: p_new_deal_subtype,
1024: p_new_amount_date,
1025: p_new_amount);
1026: -- Now calculate home-currency-equivalent for v_utilised_amt...
1027: v_hce_utilised_amt := XTR_LIMITS_P.CONVERT_TO_HCE_AMOUNT(v_utilised_amount,
1028: p_new_currency,
1029: p_new_company_code);
1030: v_hce_amt := XTR_LIMITS_P.CONVERT_TO_HCE_AMOUNT(p_new_amount,
1031: p_new_currency,

Line 1030: v_hce_amt := XTR_LIMITS_P.CONVERT_TO_HCE_AMOUNT(p_new_amount,

1026: -- Now calculate home-currency-equivalent for v_utilised_amt...
1027: v_hce_utilised_amt := XTR_LIMITS_P.CONVERT_TO_HCE_AMOUNT(v_utilised_amount,
1028: p_new_currency,
1029: p_new_company_code);
1030: v_hce_amt := XTR_LIMITS_P.CONVERT_TO_HCE_AMOUNT(p_new_amount,
1031: p_new_currency,
1032: p_new_company_code);
1033: else
1034: v_utilised_amount := 0;

Line 1860: end XTR_LIMITS_P;

1856: --
1857: delete from xtr_MIRROR_DDA_LIM_ROW_TMP_V;
1858: END reinitialize_limits;
1859: ---------------------------------------------------------------
1860: end XTR_LIMITS_P;