APPS.XTR_STOCK_POSITION_P dependencies on XTR_STOCK_ALLOC_DETAILS

Line 238: from xtr_stock_alloc_details

234:
235: cursor STOCK_LAST_PROC_DATE(V_AS_AT_DATE DATE,
236: V_DEAL_NUMBER NUMBER)is
237: select cross_ref_start_date
238: from xtr_stock_alloc_details
239: where deal_no = V_DEAL_NUMBER
240: and CROSS_REF_START_DATE <= V_AS_AT_DATE
241: and avg_rate_last_processed is null
242: order by cross_ref_start_date;

Line 247: From XTR_STOCK_ALLOC_DETAILS

243:
244:
245: cursor get_stock_resale ( V_AS_AT_DATE DATE) is
246: Select min(remaining_quantity), max(cross_ref_start_date)
247: From XTR_STOCK_ALLOC_DETAILS
248: Where deal_no = P_DEAL_NUMBER
249: and cross_ref_start_date <= V_AS_AT_DATE;
250:
251:

Line 347: FROM xtr_stock_alloc_details a

343: if get_stock_resale%found and l_cross_ref_start_date is not null then
344:
345: select price_per_share into
346: l_price_per_share
347: FROM xtr_stock_alloc_details a
348: WHERE deal_no = P_DEAL_NUMBER
349: and cross_ref_start_date = l_cross_ref_start_date
350: and cross_ref_no = ( select max(cross_ref_no) -- multiple sales on the same date
351: FROM xtr_stock_alloc_details

Line 351: FROM xtr_stock_alloc_details

347: FROM xtr_stock_alloc_details a
348: WHERE deal_no = P_DEAL_NUMBER
349: and cross_ref_start_date = l_cross_ref_start_date
350: and cross_ref_no = ( select max(cross_ref_no) -- multiple sales on the same date
351: FROM xtr_stock_alloc_details
352: WHERE deal_no = a.deal_no
353: and cross_ref_start_date = l_cross_ref_start_date);
354:
355: l_transaction_rate := l_price_per_share;

Line 435: Update XTR_STOCK_ALLOC_DETAILS

431:
432: end if;
433:
434: if P_DEAL_TYPE = 'STOCK' and l_remaining_quantity is not null then
435: Update XTR_STOCK_ALLOC_DETAILS
436: set avg_rate_last_processed = greatest(nvl(avg_rate_last_processed,
437: L_AS_AT_DATE),
438: L_AS_AT_DATE)
439: where deal_no = P_DEAL_NUMBER;

Line 533: From XTR_STOCK_ALLOC_DETAILS

529: D get_stock_deals%rowtype;
530:
531: cursor get_stock_total_resale is
532: Select min(remaining_quantity), max(cross_ref_start_date)
533: From XTR_STOCK_ALLOC_DETAILS
534: Where deal_no = D.DEAL_Number
535: and cross_ref_start_date <= L_DATE;
536:
537: BEGIN

Line 553: Update XTR_STOCK_ALLOC_DETAILS

549: OPEN get_stock_total_resale;
550: FETCH get_stock_total_resale into
551: l_remaining_quantity,l_cross_ref_start_date;
552: if nvl(l_remaining_quantity,0)= 0 then
553: Update XTR_STOCK_ALLOC_DETAILS
554: Set avg_rate_last_processed = L_DATE
555: where deal_no = d.deal_number
556: and cross_ref_start_date = l_cross_ref_start_date;
557: close get_stock_total_resale;