APPS.MRP_WB_BUCKET_DATES_SC dependencies on MRP_WORKBENCH_BUCKET_DATES

Line 16: -- This procedure populates one row in MRP_WORKBENCH_BUCKET_DATES

12: MAX_BUCKETS CONSTANT INTEGER := 36;
13: var_plan_start_date DATE;
14:
15: -- ==============================================================
16: -- This procedure populates one row in MRP_WORKBENCH_BUCKET_DATES
17: -- ==============================================================
18: PROCEDURE populate_row(arg_organization_id IN NUMBER,
19: arg_planned_organization IN NUMBER,
20: arg_compile_designator IN VARCHAR2,

Line 39: -- insert into MRP_WORKBENCH_BUCKET_DATES. It will have the following

35: counter BINARY_INTEGER := 0; -- Array counter
36:
37: -- -------------------------------------------------------------------
38: -- Date array to store days/weeks/periods this array will be used to
39: -- insert into MRP_WORKBENCH_BUCKET_DATES. It will have the following
40: -- data in it
41: -- 1 ... arg_num_days Daily
42: -- arg_num_days + 1 ... arg_num_days + arg_num_weeks Weekly
43: -- arg_num_daye + arg_num_weeks + 1 ... MAX_BUCKETS + 1 Periodic

Line 387: -- Insert the var_dates array into MRP_WORKBENCH_BUCKET_DATES

383: END LOOP;
384: END IF; -- < MAX_BUCKETS
385:
386: -- ----------------------------------------------------------
387: -- Insert the var_dates array into MRP_WORKBENCH_BUCKET_DATES
388: -- ----------------------------------------------------------
389: var_user_id := FND_PROFILE.VALUE('USER_ID');
390: IF arg_bucket_type in (1,2,3,-1,-2,-3) THEN
391: INSERT INTO mrp_workbench_bucket_dates

Line 391: INSERT INTO mrp_workbench_bucket_dates

387: -- Insert the var_dates array into MRP_WORKBENCH_BUCKET_DATES
388: -- ----------------------------------------------------------
389: var_user_id := FND_PROFILE.VALUE('USER_ID');
390: IF arg_bucket_type in (1,2,3,-1,-2,-3) THEN
391: INSERT INTO mrp_workbench_bucket_dates
392: (organization_id,
393: planned_organization,
394: compile_designator,
395: bucket_type,

Line 428: INSERT INTO mrp_workbench_bucket_dates

424: var_dates(33), var_dates(34), var_dates(35), var_dates(36),
425: var_dates(37));
426: --
427: ELSE
428: INSERT INTO mrp_workbench_bucket_dates
429: (organization_id,
430: planned_organization,
431: compile_designator,
432: bucket_type,

Line 468: -- Create all rows in MRP_WORKBENCH_BUCKET_DATES

464: END populate_row;
465:
466:
467: -- ====================================================================
468: -- Create all rows in MRP_WORKBENCH_BUCKET_DATES
469: -- ====================================================================
470: PROCEDURE populate_bucket_dates ( arg_organization_id IN NUMBER,
471: arg_compile_designator IN VARCHAR2,
472: arg_planned_organization IN NUMBER DEFAULT NULL) IS

Line 475: -- MRP_WORKBENCH_BUCKET_DATES

471: arg_compile_designator IN VARCHAR2,
472: arg_planned_organization IN NUMBER DEFAULT NULL) IS
473:
474: var_current_start_date DATE; -- Current first date in
475: -- MRP_WORKBENCH_BUCKET_DATES
476: recreate BOOLEAN := FALSE;
477: var_curr_start_date1 DATE; -- Current first date in MRP_WORKBENCH_BUCKET_DATES
478: -- for current data.
479: recreate1 BOOLEAN := FALSE;

Line 477: var_curr_start_date1 DATE; -- Current first date in MRP_WORKBENCH_BUCKET_DATES

473:
474: var_current_start_date DATE; -- Current first date in
475: -- MRP_WORKBENCH_BUCKET_DATES
476: recreate BOOLEAN := FALSE;
477: var_curr_start_date1 DATE; -- Current first date in MRP_WORKBENCH_BUCKET_DATES
478: -- for current data.
479: recreate1 BOOLEAN := FALSE;
480:
481: BEGIN

Line 485: -- MRP_WORKBENCH_BUCKET_DATES

481: BEGIN
482:
483: -- --------------------------------------------------
484: -- First figure out if we need to do recreate rows in
485: -- MRP_WORKBENCH_BUCKET_DATES
486: -- apatanka -- Fix for Bug No. 353458
487: -- MRP workbench duplicate rows.
488: -- --------------------------------------------------
489:

Line 494: FROM mrp_workbench_bucket_dates

490: BEGIN
491:
492: SELECT date1
493: INTO var_current_start_date
494: FROM mrp_workbench_bucket_dates
495: WHERE compile_designator = arg_compile_designator
496: AND organization_id = arg_organization_id
497: -- AND planned_organization = arg_planned_organization
498: AND NVL(planned_organization,organization_id) = arg_planned_organization

Line 519: FROM mrp_workbench_bucket_dates

515: BEGIN
516:
517: SELECT date1
518: INTO var_curr_start_date1
519: FROM mrp_workbench_bucket_dates
520: WHERE compile_designator = arg_compile_designator
521: AND NVL(planned_organization, organization_id) =
522: arg_planned_organization
523: AND bucket_type = -4;

Line 566: DELETE mrp_workbench_bucket_dates

562:
563:
564: IF recreate = TRUE THEN
565:
566: DELETE mrp_workbench_bucket_dates
567: WHERE compile_designator = arg_compile_designator
568: AND organization_id = arg_organization_id
569: AND NVL(planned_organization,organization_id) = arg_planned_organization
570: AND bucket_type IN (DAILY_BUCKET, WEEKLY_BUCKET, PERIODIC_BUCKET,HP_DAILY_BUCKET,HP_WEEKLY_BUCKET,HP_PERIODIC_BUCKET);

Line 634: DELETE mrp_workbench_bucket_dates

630: -- Reset var_plan_start_date to sysdate
631: -- ----------------------------------------------
632: var_plan_start_date := TRUNC(sysdate);
633: BEGIN
634: DELETE mrp_workbench_bucket_dates
635: WHERE compile_designator = arg_compile_designator
636: AND organization_id = arg_organization_id
637: AND NVL(planned_organization,organization_id) =
638: arg_planned_organization