APPS.CHV_CREATE_BUCKETS dependencies on PO_SESSION_GT

Line 480: insert into po_session_gt

476: END IF;
477:
478: FORALL x_bucket_count IN 1..60
479:
480: insert into po_session_gt
481: (num1,
482: num2 )
483: select nvl(sum(round(cio.order_quantity,5)),0) release_quantity,
484: 0 forecast_quantity

Line 535: update po_session_gt

531: and p_bucket_descriptor_table(x_bucket_count) = 'FUTURE' ;
532:
533: -- num3 total_quantity = release_quantity+forecast_quantity
534: --Calculating total_quantity TABLE = release_quantity + forecast_quantity
535: update po_session_gt
536: set num3 = Nvl(num1,0)+ Nvl(num2,0);
537:
538: --calculating cumulative quantity
539: update po_session_gt psg1

Line 539: update po_session_gt psg1

535: update po_session_gt
536: set num3 = Nvl(num1,0)+ Nvl(num2,0);
537:
538: --calculating cumulative quantity
539: update po_session_gt psg1
540: SET num4 = (SELECT
541: SUM(SUM(num1)) OVER
542: (ORDER BY rowid ROWS BETWEEN UNBOUNDED PRECEDING AND CURRENT ROW)
543: +

Line 548: FROM po_session_gt psg2

544: SUM(SUM(num2)) OVER
545: (ORDER BY rowid ROWS BETWEEN UNBOUNDED PRECEDING AND CURRENT ROW)
546: +
547: nvl(p_cum_quantity_received,0)
548: FROM po_session_gt psg2
549: where psg1.rowid= psg2.rowid
550: GROUP BY psg2.rowid
551: );
552:

Line 563: from po_session_gt;

559: bulk collect into x_release_quantity_table
560: ,x_forecast_quantity_table
561: ,x_total_quantity_table
562: ,x_cum_quantity_table
563: from po_session_gt;
564:
565: -- deleting the data frmo po_session_gt.
566: DELETE FROM po_session_gt;
567:

Line 565: -- deleting the data frmo po_session_gt.

561: ,x_total_quantity_table
562: ,x_cum_quantity_table
563: from po_session_gt;
564:
565: -- deleting the data frmo po_session_gt.
566: DELETE FROM po_session_gt;
567:
568: /*new code ends*/
569:

Line 566: DELETE FROM po_session_gt;

562: ,x_cum_quantity_table
563: from po_session_gt;
564:
565: -- deleting the data frmo po_session_gt.
566: DELETE FROM po_session_gt;
567:
568: /*new code ends*/
569:
570: /* Initialize row_select_order and row_type and call stored