DBA Data[Home] [Help]

APPS.XTR_ACCRUAL_PROCESS_P dependencies on XTR_CALC_P

Line 87: XTR_CALC_P.calc_days_run(p_deal_date,

83: If nvl(l_days_adjust,'FOLLOWING') in ('PRIOR','B') and l_start_date <> p_maturity_date and
84: p_adjust = 'Y' then
85:
86: If l_days_adjust = 'PRIOR' then
87: XTR_CALC_P.calc_days_run(p_deal_date,
88: p_maturity_date,
89: p_year_calc_type,
90: l_deal_no_of_days,
91: p_year_basis,

Line 98: XTR_CALC_P.calc_days_run(p_deal_date,

94: null); -- AW Japan Project
95:
96: -- AW Japan Project
97: elsif l_days_adjust = 'B' then
98: XTR_CALC_P.calc_days_run(p_deal_date,
99: p_maturity_date,
100: p_year_calc_type,
101: l_deal_no_of_days,
102: p_year_basis,

Line 111: XTR_CALC_P.calc_days_run(l_start_date,

107:
108: l_start_date := l_start_date + 1;
109: if l_start_date <> p_maturity_date then
110: if l_days_adjust = 'PRIOR' then -- AW Japan Project
111: XTR_CALC_P.calc_days_run(l_start_date,
112: p_maturity_date,
113: p_year_calc_type,
114: p_no_of_days,
115: p_year_basis,

Line 121: XTR_CALC_P.calc_days_run(l_start_date,

117: p_day_count_type, -- AW Japan Project
118: null); -- AW Japan Project
119: else
120: -- AW Japan Project
121: XTR_CALC_P.calc_days_run(l_start_date,
122: p_maturity_date,
123: p_year_calc_type,
124: p_no_of_days,
125: p_year_basis,

Line 146: XTR_CALC_P.calc_days_run(l_start_date,

142: /* Arrears (FOLLOWING) */
143: /*---------------------*/
144: else
145:
146: XTR_CALC_P.calc_days_run(l_start_date,
147: p_maturity_date,
148: p_year_calc_type,
149: p_no_of_days,
150: p_year_basis,

Line 167: XTR_CALC_P.calc_days_run(p_deal_date,

163: -- total number of days.
164:
165: If (nvl(p_resale_both_flag,'N') = 'Y') then
166:
167: XTR_CALC_P.calc_days_run(p_deal_date,
168: p_maturity_date,
169: p_year_calc_type,
170: l_deal_no_of_days,
171: p_year_basis,

Line 510: XTR_CALC_P.CALC_DAYS_RUN(maturiting_date,

506: maturiting_date := bond_det.maturity_date;
507: end if;
508:
509: if bond_det.maturity_date > maturiting_date then
510: XTR_CALC_P.CALC_DAYS_RUN(maturiting_date,
511: bond_det.maturity_date,
512: l_year_calc_type,
513: calc_days,
514: l_yr_basis,

Line 537: XTR_CALC_P.CALC_DAYS_RUN(bond_cpn.start_date,

533: fetch BOND_COUPONS INTO bond_cpn;
534: EXIT when BOND_COUPONS%NOTFOUND;
535:
536: if maturiting_date > bond_cpn.start_date and maturiting_date <= bond_cpn.maturity_date then
537: XTR_CALC_P.CALC_DAYS_RUN(bond_cpn.start_date,
538: bond_cpn.maturity_date,
539: l_year_calc_type,
540: l_no_of_days,
541: l_yr_basis,

Line 546: XTR_CALC_P.CALC_DAYS_RUN(bond_cpn.start_date,

542: null, -- AW Japan Project
543: bond_cpn.day_count_type, -- AW Japan Project
544: bond_cpn.first_trans_flag); -- AW Japan Project
545:
546: XTR_CALC_P.CALC_DAYS_RUN(bond_cpn.start_date,
547: maturiting_date,
548: l_year_calc_type,
549: calc_days,
550: l_yr_basis,

Line 564: XTR_CALC_P.CALC_DAYS_RUN(maturiting_date,

560:
561:
562:
563: if bond_cpn.maturity_date > maturiting_date then
564: XTR_CALC_P.CALC_DAYS_RUN(maturiting_date,
565: bond_cpn.maturity_date,
566: l_year_calc_type,
567: calc_days,
568: l_yr_basis,

Line 1858: XTR_CALC_P.CALC_DAYS_RUN_C(l_odd_coupon_start,

1854: -- l_length_of_deal = 'No of Days in Current Coupon' for COMPOUND COUPON
1855: -------------------------------------------------------------------------
1856: if p_end_date < l_odd_coupon_maturity then
1857:
1858: XTR_CALC_P.CALC_DAYS_RUN_C(l_odd_coupon_start,
1859: l_odd_coupon_maturity,
1860: l_year_calc_type,
1861: l_frequency,
1862: l_length_of_deal,

Line 1868: XTR_CALC_P.CALC_DAYS_RUN_C(l_prev_coupon_date,

1864: null,
1865: onc_det.day_count_type, -- AW Japan Project
1866: onc_det.first_trans_flag); -- AW Japan Project
1867: else
1868: XTR_CALC_P.CALC_DAYS_RUN_C(l_prev_coupon_date,
1869: l_next_coupon_date,
1870: l_year_calc_type,
1871: l_frequency,
1872: l_length_of_deal,

Line 1880: XTR_CALC_P.CALC_DAYS_RUN_C(l_coupon_start,

1876: onc_det.first_trans_flag); -- AW Japan Project
1877: end if;
1878: else
1879: -- AW 2113171 -- DO NOT ADJUST FOR Length of deal.
1880: XTR_CALC_P.CALC_DAYS_RUN_C(l_coupon_start,
1881: l_coupon_end,
1882: l_year_calc_type,
1883: l_frequency,
1884: l_length_of_deal,

Line 1896: XTR_CALC_P.CALC_DAYS_RUN_C(period_start,

1892: if period_end > period_start then
1893: if onc_det.deal_type = 'BOND' then
1894:
1895: -- AW 2113171 -- DO NOT ADJUST FOR Length of deal.
1896: XTR_CALC_P.CALC_DAYS_RUN_C(period_start,
1897: period_end,
1898: l_year_calc_type,
1899: l_frequency,
1900: l_length_of_deal,

Line 1911: XTR_CALC_P.CALC_DAYS_RUN(period_start - onc_det.forward_adjust,

1907: if ((onc_det.day_count_type='PRIOR') or (onc_det.day_count_type='B' and onc_det.first_trans_flag='Y')) and
1908: onc_det.deal_type = 'ONC' and onc_det.date_to is null then
1909: -- if l_days_adjust = 'PRIOR' and onc_det.deal_type = 'ONC' and onc_det.date_to is null then
1910: -- AW 2113171 Adjust length of deal for ONC with no maturity date
1911: XTR_CALC_P.CALC_DAYS_RUN(period_start - onc_det.forward_adjust,
1912: period_end,
1913: l_year_calc_type,
1914: l_length_of_deal,
1915: l_yr_basis,

Line 1921: XTR_CALC_P.CALC_DAYS_RUN(period_start,

1917: onc_det.day_count_type, -- AW Japan Project
1918: null); -- AW Japan Project
1919: else
1920: -- AW 2113171 -- DO NOT ADJUST FOR Length of deal.
1921: XTR_CALC_P.CALC_DAYS_RUN(period_start,
1922: period_end,
1923: l_year_calc_type,
1924: l_length_of_deal,
1925: l_yr_basis,

Line 1940: XTR_CALC_P.CALC_DAYS_RUN(period_start - onc_det.forward_adjust,

1936: -- if onc_det.day_count_type in ('PRIOR','B') and
1937: -- onc_det.deal_type = 'ONC' and onc_det.date_to is null then
1938: -- if l_days_adjust = 'PRIOR' and onc_det.deal_type = 'ONC' and onc_det.date_to is null then
1939: -- AW 2113171 -- To handle ONC with no maturity date and same day batch
1940: XTR_CALC_P.CALC_DAYS_RUN(period_start - onc_det.forward_adjust,
1941: period_end,
1942: l_year_calc_type,
1943: l_length_of_deal,
1944: l_yr_basis,

Line 1990: XTR_CALC_P.CALC_DAYS_RUN_C(period_start,

1986: -- AW Japan Project
1987: -- When Both days type is selected, system should include both start date and
1988: -- resale date to calculate number of days.
1989: -----------------------------------------------------------------------------
1990: XTR_CALC_P.CALC_DAYS_RUN_C(period_start,
1991: discprem_det.resale_recognition_date,
1992: l_year_calc_type,
1993: l_frequency,
1994: l_no_of_days,

Line 2257: XTR_CALC_P.CALC_DAYS_RUN_C(period_start - onc_det.forward_adjust,

2253: -- if l_days_adjust='PRIOR' and maturing_date<>nvl(onc_det.date_to,p_end_date) and l_day_adjust_flag ='Y' then
2254:
2255: if period_start < maturing_date then
2256: if onc_det.deal_type = 'BOND' then
2257: XTR_CALC_P.CALC_DAYS_RUN_C(period_start - onc_det.forward_adjust,
2258: maturing_date,
2259: l_year_calc_type,
2260: l_frequency,
2261: l_no_of_days,

Line 2268: XTR_CALC_P.CALC_DAYS_RUN(period_start - onc_det.forward_adjust,

2264: onc_det.day_count_type, -- AW Japan Project
2265: null); -- AW Japan Project
2266: else
2267: -- AW 2113171 To handle ONC with no maturity date
2268: XTR_CALC_P.CALC_DAYS_RUN(period_start - onc_det.forward_adjust,
2269: maturing_date,
2270: l_year_calc_type,
2271: l_no_of_days,
2272: deal_yr_basis,

Line 2281: XTR_CALC_P.CALC_DAYS_RUN(period_start - onc_det.forward_adjust,

2277: else
2278: -- AW 2113171 Similar to One day batch
2279: if onc_det.day_count_type = 'PRIOR' and period_start = maturing_date then
2280: -- if l_days_adjust = 'PRIOR' and period_start = maturing_date then
2281: XTR_CALC_P.CALC_DAYS_RUN(period_start - onc_det.forward_adjust,
2282: maturing_date,
2283: l_year_calc_type,
2284: l_no_of_days,
2285: deal_yr_basis,

Line 2304: XTR_CALC_P.CALC_DAYS_RUN_C(period_start,

2300: if onc_det.deal_type = 'BOND' then
2301:
2302: if maturing_date <= onc_det.date_to then
2303: -- AW 2113171 Do not adjust if matured
2304: XTR_CALC_P.CALC_DAYS_RUN_C(period_start,
2305: maturing_date,
2306: l_year_calc_type,
2307: l_frequency,
2308: l_no_of_days,

Line 2314: XTR_CALC_P.CALC_DAYS_RUN_C(period_start - onc_det.forward_adjust,

2310: null,
2311: onc_det.day_count_type, -- AW Japan Project
2312: onc_det.first_trans_flag); -- AW Japan Project
2313: else
2314: XTR_CALC_P.CALC_DAYS_RUN_C(period_start - onc_det.forward_adjust,
2315: maturing_date,
2316: l_year_calc_type,
2317: l_frequency,
2318: l_no_of_days,

Line 2328: XTR_CALC_P.CALC_DAYS_RUN(period_start,

2324: end if;
2325: else
2326: if maturing_date <= onc_det.date_to and onc_det.date_to is not null then
2327: -- AW 2113171 Do not adjust for matured deal
2328: XTR_CALC_P.CALC_DAYS_RUN(period_start,
2329: maturing_date,
2330: l_year_calc_type,
2331: l_no_of_days,
2332: deal_yr_basis,

Line 2339: XTR_CALC_P.CALC_DAYS_RUN(period_start - onc_det.forward_adjust,

2335: onc_det.first_trans_flag); -- AW Japan Project
2336:
2337: else
2338: -- AW 2113171 To handle ONC with no maturity date
2339: XTR_CALC_P.CALC_DAYS_RUN(period_start - onc_det.forward_adjust,
2340: maturing_date,
2341: l_year_calc_type,
2342: l_no_of_days,
2343: deal_yr_basis,

Line 2352: XTR_CALC_P.CALC_DAYS_RUN(period_start - l_forward_adjust,

2348:
2349: /* old
2350: -- AW 2113171
2351: -- Problem - this does not work for FXO
2352: XTR_CALC_P.CALC_DAYS_RUN(period_start - l_forward_adjust,
2353: maturing_date,
2354: l_year_calc_type,
2355: l_no_of_days,
2356: deal_yr_basis,

Line 2366: XTR_CALC_P.CALC_DAYS_RUN(period_start - onc_det.forward_adjust,

2362: -- AW Japan Project
2363: if onc_det.day_count_type = 'PRIOR' then
2364: -- if l_days_adjust = 'PRIOR' then
2365: -- AW 2113171 Same day batch for all deal types need to adjust
2366: XTR_CALC_P.CALC_DAYS_RUN(period_start - onc_det.forward_adjust,
2367: maturing_date,
2368: l_year_calc_type,
2369: l_no_of_days,
2370: deal_yr_basis,

Line 2376: XTR_CALC_P.CALC_DAYS_RUN(period_start - onc_det.forward_adjust,

2372: onc_det.day_count_type, -- AW Japan Project
2373: null); -- AW Japan Project
2374: elsif onc_det.day_count_type = 'B' then -- AW Japan Project
2375: -- AW Japan Project
2376: XTR_CALC_P.CALC_DAYS_RUN(period_start - onc_det.forward_adjust,
2377: maturing_date,
2378: l_year_calc_type,
2379: l_no_of_days,
2380: deal_yr_basis,

Line 2560: XTR_CALC_P.CALC_DAYS_RUN_C(l_prev_coupon_date-l_adj_days, -- forward_adjust

2556: -------------------------------------------------------------------------
2557: -- l_no_of_days = 'Accrual Date to Prev Coupon Date' for COMPOUND COUPON
2558: -------------------------------------------------------------------------
2559: if l_prev_coupon_date <= l_calc_period_end then -- 2737823 prevent ERROR in accrual
2560: XTR_CALC_P.CALC_DAYS_RUN_C(l_prev_coupon_date-l_adj_days, -- forward_adjust
2561: l_calc_period_end, -- 2737823 p_end_date
2562: l_year_calc_type,
2563: l_frequency,
2564: l_no_of_days,

Line 2603: --2422480 XTR_CALC_P.CALC_DAYS_RUN_C(l_adj_coupon_start - onc_det.forward_adjust,

2599:
2600: else
2601:
2602:
2603: --2422480 XTR_CALC_P.CALC_DAYS_RUN_C(l_adj_coupon_start - onc_det.forward_adjust,
2604: XTR_CALC_P.CALC_DAYS_RUN_C(onc_det.date_from - l_adj_days,
2605: l_calc_period_end,
2606: l_year_calc_type,
2607: l_frequency,

Line 2604: XTR_CALC_P.CALC_DAYS_RUN_C(onc_det.date_from - l_adj_days,

2600: else
2601:
2602:
2603: --2422480 XTR_CALC_P.CALC_DAYS_RUN_C(l_adj_coupon_start - onc_det.forward_adjust,
2604: XTR_CALC_P.CALC_DAYS_RUN_C(onc_det.date_from - l_adj_days,
2605: l_calc_period_end,
2606: l_year_calc_type,
2607: l_frequency,
2608: l_no_of_days,

Line 2967: XTR_CALC_P.CALC_DAYS_RUN_C(l_prev_coupon_date - onc_det.forward_adjust,

2963: if l_calc_type = 'COMPOUND COUPON' then
2964: -------------------------------------------------------------------------
2965: -- l_no_of_days = 'Accrual Date to Prev Coupon Date' for COMPOUND COUPON
2966: -------------------------------------------------------------------------
2967: XTR_CALC_P.CALC_DAYS_RUN_C(l_prev_coupon_date - onc_det.forward_adjust,
2968: period_end,
2969: l_year_calc_type,
2970: l_frequency,
2971: l_no_of_days,

Line 3008: XTR_CALC_P.CALC_DAYS_RUN_C(onc_det.date_from - onc_det.forward_adjust,

3004: else
3005:
3006: -- Replaced l_adj_coupon_start with onc_det.date_from for 2422480.
3007:
3008: XTR_CALC_P.CALC_DAYS_RUN_C(onc_det.date_from - onc_det.forward_adjust,
3009: period_end,
3010: l_year_calc_type,
3011: l_frequency,
3012: l_no_of_days,

Line 3551: XTR_CALC_P.CALC_DAYS_RUN(ig_det.balance_date - ig_det.forward_adjust, -- AW Japan Project

3547: -- l_amount_to_accrue_amort:= nvl(ig_det.main_amount,0);
3548:
3549: -- AW 2113171 To handle FORWARD calculation
3550: if ig_det.day_count_type = 'PRIOR' or l_first_tran = 'Y' then -- AW Japan Project
3551: XTR_CALC_P.CALC_DAYS_RUN(ig_det.balance_date - ig_det.forward_adjust, -- AW Japan Project
3552: l_actual_end_date,
3553: l_year_calc_type,
3554: calc_days,
3555: l_year,

Line 3566: XTR_CALC_P.CALC_DAYS_RUN(ig_det.balance_date - ig_det.forward_adjust, -- AW Japan Project

3562: l_amount_to_accrue_amort:= nvl(ig_det.main_amount,0);
3563: end if;
3564: else
3565: -- AW 2113171 To handle FORWARD calculation
3566: XTR_CALC_P.CALC_DAYS_RUN(ig_det.balance_date - ig_det.forward_adjust, -- AW Japan Project
3567: l_actual_end_date,
3568: l_year_calc_type,
3569: calc_days,
3570: l_year,

Line 3677: XTR_CALC_P.CALC_DAYS_RUN(bk_det.balance_date - bk_det.forward_adjust, -- AW Japan Project

3673: -- l_amount_to_accrue_amort:= nvl(bk_det.main_amount,0);
3674:
3675: -- AW 2113171 To handle FORWARD calculation
3676: if bk_det.day_count_type = 'PRIOR' or l_first_tran = 'Y' then -- AW Japan Project
3677: XTR_CALC_P.CALC_DAYS_RUN(bk_det.balance_date - bk_det.forward_adjust, -- AW Japan Project
3678: l_actual_end_date,
3679: bk_det.year_calc_type,
3680: calc_days,
3681: l_year,

Line 3697: XTR_CALC_P.CALC_DAYS_RUN(bk_det.balance_date - bk_det.forward_adjust, -- AW Japan Project

3693: l_amount_to_accrue_amort:= nvl(bk_det.main_amount,0);
3694: end if;
3695: else
3696: -- AW 2113171 To handle FORWARD calculation
3697: XTR_CALC_P.CALC_DAYS_RUN(bk_det.balance_date - bk_det.forward_adjust, -- AW Japan Project
3698: l_actual_end_date,
3699: bk_det.year_calc_type,
3700: calc_days,
3701: l_year,