APPS.MRP_WB_BUCKET_DATES_SC dependencies on MRP_WB_BUCKET_DATES_SC

Line 1: PACKAGE BODY MRP_WB_BUCKET_DATES_SC AS

1: PACKAGE BODY MRP_WB_BUCKET_DATES_SC AS
2: /* $Header: MRPPWBBB.pls 115.10 2004/04/05 21:52:03 skanta ship $ */
3:
4: DAILY_BUCKET CONSTANT INTEGER := 1;
5: WEEKLY_BUCKET CONSTANT INTEGER := 2;

Line 582: mrp_wb_bucket_dates_sc.populate_row(arg_organization_id,

578: AND organization_id = arg_organization_id;
579: --dbms_output.put_line('Blah');
580:
581:
582: mrp_wb_bucket_dates_sc.populate_row(arg_organization_id,
583: arg_planned_organization,
584: arg_compile_designator,
585: DAILY_BUCKET);
586: --dbms_output.put_line('Blah');

Line 588: mrp_wb_bucket_dates_sc.populate_row(arg_organization_id,

584: arg_compile_designator,
585: DAILY_BUCKET);
586: --dbms_output.put_line('Blah');
587:
588: mrp_wb_bucket_dates_sc.populate_row(arg_organization_id,
589: arg_planned_organization,
590: arg_compile_designator,
591: WEEKLY_BUCKET);
592:

Line 593: mrp_wb_bucket_dates_sc.populate_row(arg_organization_id,

589: arg_planned_organization,
590: arg_compile_designator,
591: WEEKLY_BUCKET);
592:
593: mrp_wb_bucket_dates_sc.populate_row(arg_organization_id,
594: arg_planned_organization,
595: arg_compile_designator,
596: PERIODIC_BUCKET);
597: --

Line 599: mrp_wb_bucket_dates_sc.populate_row(arg_organization_id,

595: arg_compile_designator,
596: PERIODIC_BUCKET);
597: --
598: -- Populate data for HP
599: mrp_wb_bucket_dates_sc.populate_row(arg_organization_id,
600: arg_planned_organization,
601: arg_compile_designator,
602: HP_DAILY_BUCKET);
603:

Line 604: mrp_wb_bucket_dates_sc.populate_row(arg_organization_id,

600: arg_planned_organization,
601: arg_compile_designator,
602: HP_DAILY_BUCKET);
603:
604: mrp_wb_bucket_dates_sc.populate_row(arg_organization_id,
605: arg_planned_organization,
606: arg_compile_designator,
607: HP_WEEKLY_BUCKET);
608:

Line 609: mrp_wb_bucket_dates_sc.populate_row(arg_organization_id,

605: arg_planned_organization,
606: arg_compile_designator,
607: HP_WEEKLY_BUCKET);
608:
609: mrp_wb_bucket_dates_sc.populate_row(arg_organization_id,
610: arg_planned_organization,
611: arg_compile_designator,
612: HP_PERIODIC_BUCKET);
613:

Line 652: mrp_wb_bucket_dates_sc.populate_row(arg_organization_id,

648: EXCEPTION WHEN NO_DATA_FOUND THEN
649: NULL;
650: END;
651:
652: mrp_wb_bucket_dates_sc.populate_row(arg_organization_id,
653: arg_planned_organization,
654: arg_compile_designator,
655: -1);
656:

Line 657: mrp_wb_bucket_dates_sc.populate_row(arg_organization_id,

653: arg_planned_organization,
654: arg_compile_designator,
655: -1);
656:
657: mrp_wb_bucket_dates_sc.populate_row(arg_organization_id,
658: arg_planned_organization,
659: arg_compile_designator,
660: -2);
661:

Line 662: mrp_wb_bucket_dates_sc.populate_row(arg_organization_id,

658: arg_planned_organization,
659: arg_compile_designator,
660: -2);
661:
662: mrp_wb_bucket_dates_sc.populate_row(arg_organization_id,
663: arg_planned_organization,
664: arg_compile_designator,
665: -3);
666:

Line 667: mrp_wb_bucket_dates_sc.populate_row(arg_organization_id,

663: arg_planned_organization,
664: arg_compile_designator,
665: -3);
666:
667: mrp_wb_bucket_dates_sc.populate_row(arg_organization_id,
668: arg_planned_organization,
669: arg_compile_designator,
670: -4);
671:

Line 672: mrp_wb_bucket_dates_sc.populate_row(arg_organization_id,

668: arg_planned_organization,
669: arg_compile_designator,
670: -4);
671:
672: mrp_wb_bucket_dates_sc.populate_row(arg_organization_id,
673: arg_planned_organization,
674: arg_compile_designator,
675: -5);
676:

Line 677: mrp_wb_bucket_dates_sc.populate_row(arg_organization_id,

673: arg_planned_organization,
674: arg_compile_designator,
675: -5);
676:
677: mrp_wb_bucket_dates_sc.populate_row(arg_organization_id,
678: arg_planned_organization,
679: arg_compile_designator,
680: -6);
681:

Line 693: END MRP_WB_BUCKET_DATES_sc;

689:
690: COMMIT WORK;
691: END populate_bucket_dates;
692:
693: END MRP_WB_BUCKET_DATES_sc;