APPS.MRP_WB_BUCKET_DATES SQL Statements

The following lines contain the word 'select', 'insert', 'update' or 'delete':

Line: 46

 mrp_calendar.select_calendar_defaults(arg_organization_id,
                              var_calendar_code,
                              var_exception_set_id);

Line: 76

   SELECT count(*)
   INTO   dummy
   FROM   mfg_lookups
   WHERE  lookup_type = 'MRP_WORKBENCH_BUCKET_TYPE'
   AND    lookup_code = arg_bucket_type;

Line: 87

    INSERT INTO mfg_lookups
    	(lookup_type,
	 lookup_code,
	 last_update_date,
	 last_updated_by,
	 creation_date,
	 created_by,
	 meaning,
         enabled_flag)
    VALUES
	('MRP_WORKBENCH_BUCKET_TYPE',
         arg_bucket_type,
         SYSDATE,
         -1,
         SYSDATE,
         -1,
         NVL(arg_bucket_desc , '???'),
         'Y');

Line: 142

  SELECT  calendar_date
  FROM 	  bom_calendar_dates
  WHERE   calendar_code = var_calendar_code
  AND     exception_set_id = var_exception_set_id
  AND     seq_num IS NOT NULL
  AND     calendar_date >= var_the_date
  AND     rownum <= var_num_days + 1
  ORDER BY calendar_date;

Line: 182

  SELECT  week_start_date
  FROM 	  bom_cal_week_start_dates
  WHERE   calendar_code = var_calendar_code
  AND     exception_set_id = var_exception_set_id
  AND     seq_num IS NOT NULL
  AND     week_start_date >=  var_the_date + DECODE(counter, 0, 0, 1)
  AND     rownum <= var_num_weeks + DECODE(counter, 0, 1, 0)
  ORDER BY week_start_date;

Line: 226

  SELECT  period_start_date
  FROM 	  bom_period_start_dates
  WHERE   calendar_code = var_calendar_code
  AND     exception_set_id = var_exception_set_id
  AND     period_start_date >=   var_the_date + DECODE(counter, 0, 0, 1)
  AND     rownum <= var_num_periods + DECODE(counter, 0, 1, 0)
  ORDER BY period_start_date;

Line: 299

 INSERT INTO mrp_workbench_bucket_dates
	(organization_id,
	compile_designator,
	bucket_type,
	last_update_date,
	last_updated_by,
	creation_date,
	created_by,
 	date1,  date2,  date3,  date4,   date5,  date6,
	date7,  date8,  date9,  date10,  date11, date12,
	date13, date14, date15, date16, date17, date18,
	date19, date20, date21, date22, date23, date24,
	date25, date26, date27, date28, date29, date30,
	date31, date32, date33, date34, date35, date36,
	date37)
 VALUES
	(arg_organization_id,
	arg_compile_designator,
	arg_bucket_type,
	SYSDATE,
	-1, -- var_user_id,
	SYSDATE,
	-1, -- var_user_id,
 	var_dates(1),  var_dates(2),  var_dates(3),  var_dates(4),
	var_dates(5),  var_dates(6),  var_dates(7),  var_dates(8),
	var_dates(9),  var_dates(10), var_dates(11), var_dates(12),
	var_dates(13), var_dates(14), var_dates(15), var_dates(16),
	var_dates(17), var_dates(18), var_dates(19), var_dates(20),
	var_dates(21), var_dates(22), var_dates(23), var_dates(24),
	var_dates(25), var_dates(26), var_dates(27), var_dates(28),
	var_dates(29), var_dates(30), var_dates(31), var_dates(32),
	var_dates(33), var_dates(34), var_dates(35), var_dates(36),
	var_dates(37));

Line: 356

  SELECT date1
  INTO   var_current_start_date
  FROM 	 mrp_workbench_bucket_dates
  WHERE  compile_designator = arg_compile_designator
  AND	 organization_id = arg_organization_id
  AND    bucket_type = DAILY_BUCKET;

Line: 380

	SELECT date1
	INTO	var_curr_start_date1
	FROM   	mrp_workbench_bucket_dates
	WHERE 	compile_designator = arg_compile_designator
	AND  	organization_id = arg_organization_id
	AND		bucket_type = -1;

Line: 396

 SELECT TRUNC(plan_start_date)
 INTO	var_plan_start_date
 FROM	mrp_plans
 WHERE  compile_designator = arg_compile_designator
 AND	organization_id = arg_organization_id;

Line: 431

  DELETE mrp_workbench_bucket_dates
  WHERE  compile_designator = arg_compile_designator
  AND    organization_id    = arg_organization_id
  AND    bucket_type IN (DAILY_BUCKET, WEEKLY_BUCKET, PERIODIC_BUCKET);

Line: 436

  DELETE mrp_material_plans
  WHERE  compile_designator = arg_compile_designator
  AND    organization_id    = arg_organization_id;

Line: 473

		DELETE mrp_workbench_bucket_dates
		WHERE  compile_designator = arg_compile_designator
		AND    organization_id    = arg_organization_id
		AND    bucket_type IN (-1, -2, -3);

Line: 482

		DELETE mrp_material_plans
		WHERE  compile_designator = arg_compile_designator
		AND    organization_id    = arg_organization_id;