[Home] [Help]
9: p_reverse_dda IN BOOLEAN) as
10:
11: cursor CUR_DEAL is
12: select *
13: from XTR_DEALS_V
14: where deal_no = p_deal_no;
15:
16: D CUR_DEAL%ROWTYPE;
17:
202:
203: XTR_FPS2_P.one_step_settlement(p_one_step_rec);
204:
205: If p_one_step_rec.p_exp_number is NOT NULL then
206: Update XTR_DEALS
207: Set tax_settled_reference = p_one_step_rec.p_exp_number
208: Where deal_no = D.deal_no;
209: End if;
210: End if;
236: for update of status_code nowait;
237:
238: cursor BKGE_EXP is
239: select BKGE_SETTLED_REFERENCE
240: from XTR_DEALS_V
241: where deal_type = 'STOCK'
242: and deal_no = p_deal_no
243: and bkge_settled_reference is NOT NULL;
244:
350: While UPD_BUY_DEAL%FOUND loop
351: -- Update BUY deal's remaining quantity and limit amount
352: l_limit_amt := l_init_cons;
353:
354: Update XTR_DEALS
355: Set remaining_quantity = remaining_quantity + l_quantity,
356: status_code = 'CURRENT'
357: where deal_no = l_buy_deal;
358:
627: /* Bug 3737048. Added the condition for the settle date. */
628:
629: select count(*)
630: into l_dummy
631: from xtr_deals d
632: where d.deal_type = 'STOCK'
633: and d.deal_subtype = 'BUY'
634: and d.status_code <> 'CANCELLED'
635: and d.bond_issue = p_stock_issue
672: /* Bug 3737048. Added the condition for settle date. */
673:
674: cursor BUY_DEAL is
675: select deal_no
676: from xtr_deals d
677: where d.deal_type = 'STOCK'
678: and d.deal_subtype = 'BUY'
679: and d.status_code <> 'CANCELLED'
680: and d.deal_no = nvl(p_deal_no,deal_no)
691: and r.settle_date IS NOT NULL);
692:
693: cursor DEAL_DETAIL (l_deal_no NUMBER) is
694: select *
695: from xtr_deals
696: where deal_no = l_deal_no;
697:
698: BUY DEAL_DETAIL%ROWTYPE;
699:
749: d.CLIENT_CODE,
750: d.CPARTY_CODE,
751: d.PRODUCT_TYPE
752: from xtr_stock_alloc_details s,
753: xtr_deals d
754: where s.deal_no = l_buy_deal_no
755: and s.cross_ref_start_date <= p_record_date
756: and s.cross_ref_no = d.deal_no
757: and d.deal_type = 'STOCK'