[Home] [Help]
3: --------------------------------------------------------------------------------------------
4: /********************************************************************************************/
5: /*This procedure calculate NI effective interest. user inputs: */
6: /* p_face_value : the face value of transaction */
7: /* p_all_in_rate : XTR_ROLLOVER_TRANSACTIONS.all_in_rate column */
8: /* p_deal_date : call from the accrual process - deal.start_date */
9: /* call from the resale form - buy start date */
10: /* p_start_date : call from the accrual process - nvl(ni_reneg_date, batch_end_date) */
11: /* call from the resale form - sell start date */
330: nvl(d.day_count_type,'L') day_count_type, -- AW Japan Project
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'
810: -- AW Japan Project
811: cursor CHK_FIRST_TRAN(l_deal_type VARCHAR2, l_deal_no NUMBER, l_tran_no NUMBER,
812: l_date_from DATE, l_date_to DATE) is
813: select 1
814: from XTR_ROLLOVER_TRANSACTIONS
815: where deal_type = l_deal_type
816: and deal_number = l_deal_no
817: and transaction_number <> l_tran_no
818: and start_date <= l_date_from
856: 'ONC', nvl(a.first_transaction_flag,'N'),
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
988: nvl(d.rounding_type,'R') rounding_type, -- AW Japan Project
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
3821: decode(b.day_count_type,'F','PRIOR','L','FOLLOWING','B') day_count_type, -- AW Japan Project
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')