[Home] [Help]
2664: for i in 1..g_num_parcels loop
2665: for j in 1..G_Ni_Parcel_Rec(i).PARCEL_SIZE loop
2666: l_tran_no := l_tran_no + 1;
2667:
2668: insert into XTR_ROLLOVER_TRANSACTIONS_V
2669: (DEAL_NUMBER,DEAL_DATE,TRANSACTION_NUMBER,DEAL_TYPE,DEAL_SUBTYPE,
2670: BALANCE_OUT,CURRENCY,PARCEL_SPLIT_NO,CREATED_BY,CREATED_ON,
2671: INTEREST_RATE,START_DATE,MATURITY_DATE,NO_OF_DAYS,COMPANY_CODE,
2672: STATUS_CODE,PRODUCT_TYPE,CLIENT_CODE,INTEREST,ENDORSER_CODE,
2757: sum(balance_out_hce)
2758: into l_total_parcel,
2759: l_total_face_value,
2760: l_total_face_value_hce
2761: from XTR_ROLLOVER_TRANSACTIONS
2762: where company_code = G_Ni_Main_Rec.COMPANY_CODE
2763: and deal_number = G_Ni_Main_Rec.DEAL_NO
2764: and deal_type = 'NI'
2765: and brokerage_amount is null;
2777: end if;
2778: --------------------------------
2779: -- Update RT brokerage amount --
2780: --------------------------------
2781: update XTR_ROLLOVER_TRANSACTIONS_V
2782: set BROKERAGE_AMOUNT = round(decode(l_total_parcel,
2783: 1,G_Ni_Main_Rec.BROKERAGE_AMOUNT- l_running_bkge_amt,
2784: (G_Ni_Main_Rec.BROKERAGE_AMOUNT/l_total_face_value)*balance_out),
2785: l_rounding),
2796: select balance_out,
2797: balance_out_hce
2798: into l_tran_face_value,
2799: l_tran_face_value_hce
2800: from XTR_ROLLOVER_TRANSACTIONS
2801: where company_code = G_Ni_Main_Rec.COMPANY_CODE
2802: and deal_number = G_Ni_Main_Rec.DEAL_NO
2803: and deal_type = 'NI'
2804: and transaction_number = l_tran_no;
2825: /*------------------------------------------------------------*/
2826:
2827: cursor ROLL_ID is
2828: select transaction_number
2829: from xtr_rollover_transactions
2830: where company_code = G_Ni_Main_Rec.company_code
2831: and deal_number = G_Ni_Main_Rec.deal_no
2832: and deal_type = 'NI'
2833: and initial_fair_value is null;