[Home] [Help]
The following lines contain the word 'select', 'insert', 'update' or 'delete':
SELECT
vendor_id,
vendor_site_id,
schedule_type,
schedule_subtype,
schedule_horizon_start,
schedule_horizon_end,
bucket_pattern_id,
schedule_num,
organization_id,
mps_schedule_designator,
mrp_compile_designator,
drp_compile_designator,
include_future_releases_flag
FROM chv_schedule_headers csh
WHERE schedule_id = p_schedule_id;
SELECT chv_schedule_headers_s.NEXTVAL
INTO x_schedule_id
FROM DUAL;
INSERT INTO chv_schedule_headers(schedule_id,
vendor_id,
vendor_site_id,
schedule_type,
schedule_subtype,
schedule_num,
schedule_revision,
schedule_horizon_start,
schedule_horizon_end,
bucket_pattern_id,
schedule_owner_id,
last_update_date,
last_updated_by,
creation_date,
created_by,
organization_id,
mps_schedule_designator,
mrp_compile_designator,
drp_compile_designator,
schedule_status,
inquiry_flag,
include_future_releases_flag,
last_update_login,
batch_id)
VALUES (x_schedule_id,
x_vendor_id,
x_vendor_site_id,
x_schedule_type,
x_schedule_subtype,
x_schedule_num,
x_schedule_revision,
x_horizon_start_date,
x_horizon_end_date,
x_bucket_pattern_id,
p_owner_id,
SYSDATE, -- last_update_date
x_user_id, -- last_updated_by
SYSDATE, -- creation_date
x_user_id, -- created_by
x_organization_id,
x_mps_schedule_designator,
x_mrp_compile_designator,
x_drp_compile_designator,
'IN_PROCESS', -- schedule_status
'N', -- inquiry_flag
x_include_future_releases,
x_login_id,
p_batch_id); -- last_update_login