[Home] [Help]
1: PACKAGE BODY CHV_CREATE_BUCKETS as
2: /* $Header: CHVCBKTB.pls 120.2.12020000.2 2013/02/10 22:22:35 vegajula ship $*/
3: /*========================== CHV_CREATE_BUCKETS ==============================*/
4: /*=============================================================================
5:
1: PACKAGE BODY CHV_CREATE_BUCKETS as
2: /* $Header: CHVCBKTB.pls 120.2.12020000.2 2013/02/10 22:22:35 vegajula ship $*/
3: /*========================== CHV_CREATE_BUCKETS ==============================*/
4: /*=============================================================================
5:
6: PROCEDURE NAME: create_bucket_template()
7:
573: */
574:
575: x_row_select_order := 1 ;
576: x_row_type := 'BUCKET_DESCRIPTOR' ;
577: chv_create_buckets.load_horizontal_schedules(p_schedule_id ,
578: p_schedule_item_id ,
579: x_row_select_order ,
580: x_row_type ,
581: p_bucket_descriptor_table ) ;
581: p_bucket_descriptor_table ) ;
582:
583: x_row_select_order := 2 ;
584: x_row_type := 'BUCKET_START_DATE' ;
585: chv_create_buckets.load_horizontal_schedules(p_schedule_id ,
586: p_schedule_item_id ,
587: x_row_select_order ,
588: x_row_type ,
589: p_bucket_start_date_table ) ;
589: p_bucket_start_date_table ) ;
590:
591: x_row_select_order := 3 ;
592: x_row_type := 'RELEASE_QUANTITY' ;
593: chv_create_buckets.load_horizontal_schedules(p_schedule_id ,
594: p_schedule_item_id ,
595: x_row_select_order ,
596: x_row_type ,
597: x_release_quantity_table ) ;
597: x_release_quantity_table ) ;
598:
599: x_row_select_order := 4 ;
600: x_row_type := 'FORECAST_QUANTITY' ;
601: chv_create_buckets.load_horizontal_schedules(p_schedule_id ,
602: p_schedule_item_id ,
603: x_row_select_order ,
604: x_row_type ,
605: x_forecast_quantity_table ) ;
604: x_row_type ,
605: x_forecast_quantity_table ) ;
606: x_row_select_order := 5 ;
607: x_row_type := 'TOTAL_QUANTITY' ;
608: chv_create_buckets.load_horizontal_schedules(p_schedule_id ,
609: p_schedule_item_id ,
610: x_row_select_order ,
611: x_row_type ,
612: x_total_quantity_table ) ;
612: x_total_quantity_table ) ;
613:
614: x_row_select_order := 6 ;
615: x_row_type := 'CUM_QUANTITY' ;
616: chv_create_buckets.load_horizontal_schedules(p_schedule_id ,
617: p_schedule_item_id ,
618: x_row_select_order ,
619: x_row_type ,
620: x_cum_quantity_table ) ;
620: x_cum_quantity_table ) ;
621:
622: x_row_select_order := 7 ;
623: x_row_type := 'BUCKET_END_DATE' ;
624: chv_create_buckets.load_horizontal_schedules(p_schedule_id ,
625: p_schedule_item_id ,
626: x_row_select_order ,
627: x_row_type ,
628: p_bucket_end_date_table ) ;
632: raise;
633:
634: END calculate_buckets ;
635:
636: END CHV_CREATE_BUCKETS ;