The following lines contain the word 'select', 'insert', 'update' or 'delete':
mrp_calendar.select_calendar_defaults(arg_planned_organization,
var_calendar_code,
var_exception_set_id);
SELECT count(*)
INTO dummy
FROM mfg_lookups
WHERE lookup_type = 'MRP_WORKBENCH_BUCKET_TYPE'
AND lookup_code = arg_bucket_type;
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');
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;
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;
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;
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;
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;
INSERT INTO mrp_workbench_bucket_dates
(organization_id,
planned_organization,
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_planned_organization,
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));
INSERT INTO mrp_workbench_bucket_dates
(organization_id,
planned_organization,
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_planned_organization,
arg_compile_designator,
arg_bucket_type,
SYSDATE,
-1, -- var_user_id,
SYSDATE,
-1, -- var_user_id,
var_dates1(1), var_dates1(2), var_dates1(3), var_dates1(4),
var_dates1(5), var_dates1(6), var_dates1(7), var_dates1(8),
var_dates1(9), var_dates1(10), var_dates1(11), var_dates1(12),
var_dates1(13), var_dates1(14), var_dates1(15), var_dates1(16),
var_dates1(17), var_dates1(18), var_dates1(19), var_dates1(20),
var_dates1(21), var_dates1(22), var_dates1(23), var_dates1(24),
var_dates1(25), var_dates1(26), var_dates1(27), var_dates1(28),
var_dates1(29), var_dates1(30), var_dates1(31), var_dates1(32),
var_dates1(33), var_dates1(34), var_dates1(35), var_dates1(36),
var_dates1(37));
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 planned_organization = arg_planned_organization
AND NVL(planned_organization,organization_id) = arg_planned_organization
AND bucket_type = HP_DAILY_BUCKET;
SELECT date1
INTO var_curr_start_date1
FROM mrp_workbench_bucket_dates
WHERE compile_designator = arg_compile_designator
AND NVL(planned_organization, organization_id) =
arg_planned_organization
AND bucket_type = -4;
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;
DELETE mrp_workbench_bucket_dates
WHERE compile_designator = arg_compile_designator
AND organization_id = arg_organization_id
AND NVL(planned_organization,organization_id) = arg_planned_organization
AND bucket_type IN (DAILY_BUCKET, WEEKLY_BUCKET, PERIODIC_BUCKET,HP_DAILY_BUCKET,HP_WEEKLY_BUCKET,HP_PERIODIC_BUCKET);
DELETE mrp_material_plans
WHERE compile_designator = arg_compile_designator
AND organization_id = arg_organization_id;
DELETE mrp_workbench_bucket_dates
WHERE compile_designator = arg_compile_designator
AND organization_id = arg_organization_id
AND NVL(planned_organization,organization_id) =
arg_planned_organization
AND bucket_type IN (-1, -2, -3,-4,-5,-6);
DELETE mrp_material_plans
WHERE compile_designator = arg_compile_designator
AND organization_id = arg_organization_id;