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_ACCRUAL_PROCESS_P dependencies on XTR_DEALS

Line 15: /* p_year_calc_type: xtr_deals.year_calc_type */

11: /* call from the resale form - sell start date */
12: /* p_maturity_date : deal.maturity_date */
13: /* p_adjust : indicator to know if we need to make day adjustment. */
14: /* If p_start_date is a ni_reneg date, then pass 'N', else pass 'Y' */
15: /* p_year_calc_type: xtr_deals.year_calc_type */
16: /* p_calc_basis : XTR_DEALS.calc_basis, if 'DISCOUNT', pass 'D', if 'YIELD', pass 'Y' */
17: /* p_pre_disc_end : the previous Discount amount. */
18: /* For Reval, it's the value from xtr_revaluation_details.ni_disc_amount */
19: /* from previous batch. */

Line 16: /* p_calc_basis : XTR_DEALS.calc_basis, if 'DISCOUNT', pass 'D', if 'YIELD', pass 'Y' */

12: /* p_maturity_date : deal.maturity_date */
13: /* p_adjust : indicator to know if we need to make day adjustment. */
14: /* If p_start_date is a ni_reneg date, then pass 'N', else pass 'Y' */
15: /* p_year_calc_type: xtr_deals.year_calc_type */
16: /* p_calc_basis : XTR_DEALS.calc_basis, if 'DISCOUNT', pass 'D', if 'YIELD', pass 'Y' */
17: /* p_pre_disc_end : the previous Discount amount. */
18: /* For Reval, it's the value from xtr_revaluation_details.ni_disc_amount */
19: /* from previous batch. */
20: /* For Accrual, it's the value from xtr_accrls_amort.accrls_amount_bal */

Line 308: from XTR_DEALS a

304: a.bond_sale_date,a.deal_subtype,a.product_type,a.portfolio_code,a.cparty_code,
305: a.year_calc_type,capital_price,
306: a.day_count_type, a.rounding_type, -- AW Japan Project
307: decode(a.day_count_type,'B','Y','N') first_trans_flag -- AW Japan Project
308: from XTR_DEALS a
309: where a.deal_type = 'BOND'
310: and a.company_code = p_company
311: and a.deal_subtype IN ('BUY','ISSUE')
312: and a.status_code <> 'CANCELLED'

Line 335: XTR_DEALS d

331: nvl(d.rounding_type,'R') rounding_type, -- AW Japan Project
332: decode(nvl(d.day_count_type,'L'),'B',decode(r.transaction_number,2,'Y','N'),
333: 'N') first_trans_flag -- AW Japan Project
334: from XTR_ROLLOVER_TRANSACTIONS r,
335: XTR_DEALS d
336: where r.deal_type = 'BOND'
337: and r.deal_number = l_deal_nos
338: and r.status_code = 'CURRENT'
339: and r.maturity_date > maturiting_date

Line 695: l_cum_ex XTR_DEALS.COUPON_ACTION%TYPE;

691: l_dda_INT NUMBER;
692: l_calc_type XTR_BOND_ISSUES.CALC_TYPE%TYPE; -- renamed l_flat_zero for COMPOUND COUPON
693: l_clean_price NUMBER;
694: l_ccy VARCHAR2(15);
695: l_cum_ex XTR_DEALS.COUPON_ACTION%TYPE;
696: l_coupon_rate NUMBER;
697: l_coupon_start DATE;
698: l_coupon_end DATE;
699: l_cross_ref_start_date DATE;

Line 861: XTR_DEALS d

857: 'BOND',decode(a.transaction_number,2,'Y','N'),
858: 'N'),
859: 'N') first_trans_flag -- AW Japan Project
860: from XTR_ROLLOVER_TRANSACTIONS a,
861: XTR_DEALS d
862: where a.company_code = p_company
863: and a.deal_number = d.deal_no
864: and a.deal_type = d.deal_type
865: and a.deal_type in ('TMM','RTMM','IRS','ONC','BOND')

Line 871: from xtr_deals b

867: and nvl(a.interest_rate,0) <> 0
868: and ((a.start_date <= p_end_date and a.deal_type <> 'BOND')
869: or (a.start_date <= p_end_date and a.deal_type = 'BOND' and
870: p_end_date >= (select b.start_date
871: from xtr_deals b
872: where b.deal_no = a.deal_number
873: and b.deal_type = 'BOND')))
874: and ((a.maturity_date >= p_start_date or a.maturity_date is NULL)
875: or (a.deal_number,a.transaction_number) not in (select b.deal_no,b.trans_no

Line 919: from XTR_DEALS a

915: nvl(a.rounding_type,'R') rounding_type, -- AW Japan Project
916: decode(nvl(a.day_count_type,'L'),'F','PRIOR','L','FOLLOWING','B') day_count_type, -- AW Japan Project
917: decode(nvl(a.day_count_type,'L'),'F',1,0) forward_adjust, -- AW Japan Project
918: decode(nvl(a.day_count_type,'L'),'B','Y','N') first_trans_flag -- AW Japan Project
919: from XTR_DEALS a
920: where a.company_code = p_company
921: and a.deal_type = 'BOND'
922: and a.deal_subtype in ('BUY','ISSUE')
923: and decode(l_trade_settle,'TRADE',a.deal_date,a.start_date) <= p_end_date

Line 993: XTR_DEALS d

989: decode(nvl(d.day_count_type,'L'),'F','PRIOR','L','FOLLOWING','B') day_count_type, -- AW Japan Project
990: decode(nvl(d.day_count_type,'L'),'F',1,0) forward_adjust, -- AW Japan Project
991: decode(nvl(d.day_count_type,'L'),'B','Y','N') first_trans_flag -- AW Japan Project
992: from XTR_ROLLOVER_TRANSACTIONS a,
993: XTR_DEALS d
994: where a.company_code = p_company
995: and a.deal_number = d.deal_no
996: and a.deal_type = d.deal_type
997: and a.deal_type = 'NI'

Line 1040: from XTR_DEALS a

1036: 'R' rounding_type, -- AW Japan Project
1037: l_days_adjust day_count_type, -- AW Japan Project
1038: l_forward_adjust forward_adjust, -- AW Japan Project
1039: 'N' first_trans_flag -- AW Japan Project
1040: from XTR_DEALS a
1041: where a.company_code = p_company
1042: and a.deal_type in ('IRO','BDO','SWPTN','FXO')
1043: and a.premium_date <= p_end_date
1044: and (a.expiry_date >= p_start_date

Line 1093: from XTR_DEALS a

1089: decode(decode(a.deal_type,'FRA',nvl(a.settle_day_count_type,l_days_adjust),
1090: l_days_adjust),
1091: 'F',1,'PRIOR',1,0) forward_adjust,
1092: decode(a.deal_type,'FRA','Y','N') first_trans_flag
1093: from XTR_DEALS a
1094: where a.company_code = p_company
1095: and a.deal_type in ('FRA','BDO','IRO','SWPTN')
1096: and a.maturity_date is not null
1097: and a.start_date < a.maturity_date -- avoid Bug 3006377 in BDO allowing Start >= Maturity Date

Line 1136: -- from XTR_DEALS a

1132: -- a.year_calc_type year_calc_type,
1133: -- a.no_of_days no_of_days,
1134: -- a.bond_issue bond_issue,
1135: -- a.maturity_date deal_action_date
1136: -- from XTR_DEALS a
1137: -- where a.company_code =p_company
1138: -- and a.deal_type in ('FRA','IRO','BDO','SWPTN')
1139: -- and a.start_date <= p_end_date
1140: -- and ((a.maturity_date >= p_start_date or

Line 1180: XTR_DEALS d

1176: b.cross_ref_start_date,
1177: b.face_value,
1178: d.coupon_action -- 2422480 added
1179: from XTR_BOND_ALLOC_DETAILS b,
1180: XTR_DEALS d
1181: where b.deal_no = l_deal_nos
1182: and d.deal_no = l_deal_nos
1183: and b.cross_ref_start_date between l_elig_resale_start and l_elig_resale_end;
1184:

Line 1212: from xtr_deals

1208: -- Get Deal's Year Calc Type
1209: -----------------------------
1210: cursor GET_DEAL_DATA is
1211: select year_calc_type
1212: from xtr_deals
1213: where deal_no = l_deal_nos
1214: and deal_type = l_deal_type;
1215:
1216: ------------------------------------

Line 1226: from xtr_deals

1222: coupon_action,
1223: maturity_amount,
1224: start_amount,
1225: start_date
1226: from xtr_deals
1227: where deal_no = l_deal_nos
1228: and deal_type = l_deal_type;
1229:
1230: ----------------------------------------------

Line 3826: XTR_DEALS b

3822: b.rounding_type rounding_type, -- AW Japan Project
3823: a.trans_closeout_no resale_deal_no, -- Bug 2448432.
3824: a.interest_rate interest_rate --bug 4969194
3825: from XTR_ROLLOVER_TRANSACTIONS a,
3826: XTR_DEALS b
3827: where a.company_code = p_company
3828: and a.deal_type = 'NI'
3829: and a.deal_subtype in ('BUY','SHORT','ISSUE')
3830: and b.company_code = p_company

Line 3916: l_day_cnt_type XTR_DEALS.day_count_type%TYPE := 'L';

3912: l_resale_both VARCHAR2(1) := 'N';
3913: l_accrl_to_date_amt NUMBER := 0;
3914:
3915: Function RESALE_BOTH (p_deal_no IN NUMBER) return BOOLEAN is
3916: l_day_cnt_type XTR_DEALS.day_count_type%TYPE := 'L';
3917: Begin
3918: Select day_count_type
3919: into l_day_cnt_type
3920: from xtr_deals

Line 3920: from xtr_deals

3916: l_day_cnt_type XTR_DEALS.day_count_type%TYPE := 'L';
3917: Begin
3918: Select day_count_type
3919: into l_day_cnt_type
3920: from xtr_deals
3921: where deal_no = p_deal_no;
3922:
3923: If (l_day_cnt_type = 'B') then
3924: Return (true);