The following lines contain the word 'select', 'insert', 'update' or 'delete':
/* Delete orphan forecast record in AHL_SCHEDULE_MATERIALS table for
* deleted unit effectivities
* unit effectivities where due date is null after the re-calculation
*/
/*CURSOR delete_schedule_mtl_csr IS
SELECT scheduled_material_id FROM AHL_SCHEDULE_MATERIALS SM
WHERE SM.material_request_type = G_REQ_TYPE_FORECAST
AND SM.unit_effectivity_id IS NOT NULL
AND NOT EXISTS(SELECT 'x' FROM AHL_UNIT_EFFECTIVITIES_APP_V UE WHERE UE.unit_effectivity_id = SM.unit_effectivity_id)
UNION ALL
SELECT scheduled_material_id FROM AHL_SCHEDULE_MATERIALS SM, AHL_UNIT_EFFECTIVITIES_APP_V UE
WHERE (UE.status_code IS NULL OR UE.status_code = 'INIT-DUE')
AND UE.due_date IS NULL
AND SM.unit_effectivity_id IS NOT NULL
AND SM.material_request_type = G_REQ_TYPE_FORECAST
AND SM.unit_effectivity_id = UE.unit_effectivity_id;*/
SELECT UE.unit_effectivity_id, UE.due_date, MR.mr_route_id, R.route_id, R.start_date_active, R.end_date_active
-- FROM AHL_UNIT_EFFECTIVITIES_APP_V UE, AHL_MR_ROUTES_V MR
FROM AHL_UNIT_EFFECTIVITIES_B UE, AHL_ROUTES_B R, AHL_MR_ROUTES MR
WHERE UE.mr_header_id = MR.mr_header_id
AND R.route_id = MR.ROUTE_ID
--AND MR.APPLICATION_USG_CODE = RTRIM(LTRIM(FND_PROFILE.VALUE('AHL_APPLN_USAGE')))
AND UE.APPLICATION_USG_CODE = G_APP_MODULE
AND (UE.status_code IS NULL OR UE.status_code = 'INIT-DUE')
AND UE.due_date IS NOT NULL
AND UE.csi_item_instance_id = p_item_indtance_id
ORDER BY MR.route_id, UE.due_date;
SELECT scheduled_material_id FROM AHL_SCHEDULE_MATERIALS SM
WHERE SM.material_request_type = G_REQ_TYPE_FORECAST
AND SM.mr_route_id = p_mr_route_id
AND SM.unit_effectivity_id IS NOT NULL
AND SM.unit_effectivity_id = p_unit_effectivity_id;
* output record used for DML update operation
*/
CURSOR schedule_mtl_exists_csr(p_unit_effectivity_id IN NUMBER, p_mr_route_id IN NUMBER, p_inventory_item_id IN NUMBER, p_rt_oper_material_id IN NUMBER) IS
SELECT * FROM AHL_SCHEDULE_MATERIALS SM
WHERE SM.material_request_type = G_REQ_TYPE_FORECAST
AND NVL(SM.rt_oper_material_id,-1) = NVL(p_rt_oper_material_id,-1)
AND SM.inventory_item_id = p_inventory_item_id
AND SM.mr_route_id = p_mr_route_id
AND SM.unit_effectivity_id = p_unit_effectivity_id
FOR UPDATE OF REQUESTED_DATE NOWAIT;
SELECT DISTINCT visit_id
FROM ahl_visit_tasks_b
WHERE unit_effectivity_id = p_unit_effectivity_id;
/*FOR delete_mtl_forecast_rec IN delete_schedule_mtl_csr LOOP
AHL_SCHEDULE_MATERIALS_PKG.delete_row(x_scheduled_material_id => delete_mtl_forecast_rec.scheduled_material_id);
'Have succesfully deleted the orphan forecasts'
);
AHL_SCHEDULE_MATERIALS_PKG.delete_row(x_scheduled_material_id => del_exp_route_rec.scheduled_material_id);
'Inserting record in AHL_SCHEDULE_MATERIALS '
);
AHL_SCHEDULE_MATERIALS_PKG.INSERT_ROW
(
X_SCHEDULED_MATERIAL_ID => NULL,
X_OBJECT_VERSION_NUMBER => 1,
X_LAST_UPDATE_DATE => SYSDATE,
X_LAST_UPDATED_BY => fnd_global.user_id,
X_CREATION_DATE => SYSDATE,
X_CREATED_BY => fnd_global.user_id,
X_LAST_UPDATE_LOGIN => fnd_global.user_id,
X_INVENTORY_ITEM_ID => l_Route_Mtl_Req_Tbl(j).inventory_item_id,
X_SCHEDULE_DESIGNATOR => NULL,
X_VISIT_ID => NULL,
X_VISIT_START_DATE => NULL,
X_VISIT_TASK_ID => NULL,
X_ORGANIZATION_ID => NULL,
X_SCHEDULED_DATE => NULL,
X_REQUEST_ID => NULL,
-- AnRaj: truncating Requested Date for Material Requirement based on discussions with PM
X_REQUESTED_DATE => trunc(ue_mr_routes_rec.due_date),
X_SCHEDULED_QUANTITY => NULL,
X_PROCESS_STATUS => NULL,
X_ERROR_MESSAGE => NULL,
X_TRANSACTION_ID => NULL,
X_UOM => l_Route_Mtl_Req_Tbl(j).uom_code,
X_RT_OPER_MATERIAL_ID => l_Route_Mtl_Req_Tbl(j).rt_oper_material_id,
X_OPERATION_CODE => NULL,
X_OPERATION_SEQUENCE => NULL,
X_ITEM_GROUP_ID => l_Route_Mtl_Req_Tbl(j).item_group_id,
X_REQUESTED_QUANTITY => l_Route_Mtl_Req_Tbl(j).quantity,
X_PROGRAM_ID => NULL,
X_PROGRAM_UPDATE_DATE => NULL,
X_LAST_UPDATED_DATE => NULL,
X_WORKORDER_OPERATION_ID => NULL,
X_POSITION_PATH_ID => l_Route_Mtl_Req_Tbl(j).position_path_id,
X_RELATIONSHIP_ID => l_Route_Mtl_Req_Tbl(j).relationship_id,
X_UNIT_EFFECTIVITY_ID => ue_mr_routes_rec.unit_effectivity_id,
X_MR_ROUTE_ID => ue_mr_routes_rec.mr_route_id,
X_MATERIAL_REQUEST_TYPE => G_REQ_TYPE_FORECAST,
-- Added MC_HEADER_ID and POSITION_KEY by surrkuma on 07-Jun-2011 for Service Bulletin
X_MC_HEADER_ID => l_Route_Mtl_Req_Tbl(j).mc_header_id,
X_POSITION_KEY => l_Route_Mtl_Req_Tbl(j).position_key,
X_ATTRIBUTE_CATEGORY => NULL,
X_ATTRIBUTE1 => NULL,
X_ATTRIBUTE2 => NULL,
X_ATTRIBUTE3 => NULL,
X_ATTRIBUTE4 => NULL,
X_ATTRIBUTE5 => NULL,
X_ATTRIBUTE6 => NULL,
X_ATTRIBUTE7 => NULL,
X_ATTRIBUTE8 => NULL,
X_ATTRIBUTE9 => NULL,
X_ATTRIBUTE10 => NULL,
X_ATTRIBUTE11 => NULL,
X_ATTRIBUTE12 => NULL,
X_ATTRIBUTE13 => NULL,
X_ATTRIBUTE14 => NULL,
X_ATTRIBUTE15 => NULL
);
AHL_SCHEDULE_MATERIALS_PKG.UPDATE_ROW
(
X_SCHEDULED_MATERIAL_ID => l_Schedule_Mtl_Req_rec.SCHEDULED_MATERIAL_ID,
X_OBJECT_VERSION_NUMBER => l_Schedule_Mtl_Req_rec.OBJECT_VERSION_NUMBER,--Update Column
X_LAST_UPDATE_DATE => SYSDATE,
X_LAST_UPDATED_BY => fnd_global.user_id,
X_LAST_UPDATE_LOGIN => fnd_global.user_id,
X_INVENTORY_ITEM_ID => l_Schedule_Mtl_Req_rec.INVENTORY_ITEM_ID,
X_SCHEDULE_DESIGNATOR => l_Schedule_Mtl_Req_rec.SCHEDULE_DESIGNATOR,
X_VISIT_ID => l_Schedule_Mtl_Req_rec.VISIT_ID,
X_VISIT_START_DATE => l_Schedule_Mtl_Req_rec.VISIT_START_DATE,
X_VISIT_TASK_ID => l_Schedule_Mtl_Req_rec.VISIT_TASK_ID,
X_ORGANIZATION_ID => l_Schedule_Mtl_Req_rec.ORGANIZATION_ID,
X_SCHEDULED_DATE => l_Schedule_Mtl_Req_rec.SCHEDULED_DATE,
X_REQUEST_ID => l_Schedule_Mtl_Req_rec.REQUEST_ID,
-- AnRaj: truncating Requested Date for Material Requirement based on discussions with PM
X_REQUESTED_DATE => trunc(ue_mr_routes_rec.due_date),--Update Column
X_SCHEDULED_QUANTITY => l_Schedule_Mtl_Req_rec.SCHEDULED_QUANTITY,
X_PROCESS_STATUS => l_Schedule_Mtl_Req_rec.PROCESS_STATUS,
X_ERROR_MESSAGE => l_Schedule_Mtl_Req_rec.ERROR_MESSAGE,
X_TRANSACTION_ID => l_Schedule_Mtl_Req_rec.TRANSACTION_ID,
X_UOM => l_Route_Mtl_Req_Tbl(j).uom_code,--Update Column
X_RT_OPER_MATERIAL_ID => l_Route_Mtl_Req_Tbl(j).rt_oper_material_id,--Update Column
X_OPERATION_CODE => l_Schedule_Mtl_Req_rec.OPERATION_CODE,
X_OPERATION_SEQUENCE => l_Schedule_Mtl_Req_rec.OPERATION_SEQUENCE,
X_ITEM_GROUP_ID => l_Route_Mtl_Req_Tbl(j).item_group_id,--Update Column
X_REQUESTED_QUANTITY => l_Route_Mtl_Req_Tbl(j).quantity,--Update Column
X_PROGRAM_ID => l_Schedule_Mtl_Req_rec.PROGRAM_ID,
X_PROGRAM_UPDATE_DATE => l_Schedule_Mtl_Req_rec.PROGRAM_UPDATE_DATE,
X_LAST_UPDATED_DATE => l_Schedule_Mtl_Req_rec.LAST_UPDATED_DATE,
X_WORKORDER_OPERATION_ID => l_Schedule_Mtl_Req_rec.WORKORDER_OPERATION_ID,
X_POSITION_PATH_ID => l_Route_Mtl_Req_Tbl(j).position_path_id,--Update Column
X_RELATIONSHIP_ID => l_Route_Mtl_Req_Tbl(j).relationship_id,--Update Column
X_UNIT_EFFECTIVITY_ID => l_Schedule_Mtl_Req_rec.UNIT_EFFECTIVITY_ID,
X_MR_ROUTE_ID => l_Schedule_Mtl_Req_rec.MR_ROUTE_ID,
X_MATERIAL_REQUEST_TYPE => l_Schedule_Mtl_Req_rec.MATERIAL_REQUEST_TYPE,
-- Added MC_HEADER_ID and POSITION_KEY by surrkuma on 07-Jun-2011 for Service Bulletin
X_MC_HEADER_ID => l_Route_Mtl_Req_Tbl(j).mc_header_id,
X_POSITION_KEY => l_Route_Mtl_Req_Tbl(j).position_key,
X_ATTRIBUTE_CATEGORY => l_Schedule_Mtl_Req_rec.ATTRIBUTE_CATEGORY,
X_ATTRIBUTE1 => l_Schedule_Mtl_Req_rec.ATTRIBUTE1,
X_ATTRIBUTE2 => l_Schedule_Mtl_Req_rec.ATTRIBUTE2,
X_ATTRIBUTE3 => l_Schedule_Mtl_Req_rec.ATTRIBUTE3,
X_ATTRIBUTE4 => l_Schedule_Mtl_Req_rec.ATTRIBUTE4,
X_ATTRIBUTE5 => l_Schedule_Mtl_Req_rec.ATTRIBUTE5,
X_ATTRIBUTE6 => l_Schedule_Mtl_Req_rec.ATTRIBUTE6,
X_ATTRIBUTE7 => l_Schedule_Mtl_Req_rec.ATTRIBUTE7,
X_ATTRIBUTE8 => l_Schedule_Mtl_Req_rec.ATTRIBUTE8,
X_ATTRIBUTE9 => l_Schedule_Mtl_Req_rec.ATTRIBUTE9,
X_ATTRIBUTE10 => l_Schedule_Mtl_Req_rec.ATTRIBUTE10,
X_ATTRIBUTE11 => l_Schedule_Mtl_Req_rec.ATTRIBUTE11,
X_ATTRIBUTE12 => l_Schedule_Mtl_Req_rec.ATTRIBUTE12,
X_ATTRIBUTE13 => l_Schedule_Mtl_Req_rec.ATTRIBUTE13,
X_ATTRIBUTE14 => l_Schedule_Mtl_Req_rec.ATTRIBUTE14,
X_ATTRIBUTE15 => l_Schedule_Mtl_Req_rec.ATTRIBUTE15
);
SELECT instance_number, active_end_date
FROM csi_item_instances
WHERE instance_id = p_csi_item_instance_id;
SELECT name, csi_item_instance_id, master_config_id, unit_config_status_code
FROM ahl_unit_config_headers
WHERE unit_config_header_id = p_uc_header_id;
SELECT name, master_config_id, unit_config_status_code
FROM ahl_unit_config_headers
WHERE csi_item_instance_id = p_item_instance_id
AND parent_uc_header_id IS NULL;
SELECT rt.mr_route_id, rt.route_id, R.start_date_active, R.end_date_active
FROM AHL_MR_ROUTES rt, ahl_routes_b R
WHERE rt.route_id = r.route_id
AND rt.mr_header_id = p_mr_header_id;
SELECT mr_header_id
FROM ahl_mr_headers_b mr
WHERE application_usg_code = appln_usg_code
AND mr_status_code = 'COMPLETE'
AND EXISTS (SELECT 1
FROM ahl_unit_effectivities_b
WHERE mr_header_id = mr.mr_header_id
AND (status_code IS NULL OR status_code = 'INIT-DUE')
);
SELECT unit_effectivity_id, due_date, csi_item_instance_id
FROM ahl_unit_effectivities_b UE, csi_item_instances II
WHERE UE.mr_header_id = p_mr_header_id
AND UE.csi_item_instance_id = II.instance_id
AND nvl(ii.active_end_date, sysdate+1) > sysdate
AND UE.due_date IS NOT NULL
AND (UE.status_code IS NULL OR UE.status_code = 'INIT-DUE');
SELECT root.object_id
FROM csi_ii_relationships root
WHERE NOT EXISTS (SELECT 'x'
FROM csi_ii_relationships
WHERE subject_id = root.object_id
AND trunc(sysdate) < trunc(nvl(active_end_date, sysdate+1))
)
START WITH root.subject_id = p_instance_id
AND root.relationship_type_code = 'COMPONENT-OF'
AND trunc(nvl(root.active_start_date,sysdate)) <= trunc(sysdate)
AND trunc(sysdate) < trunc(nvl(root.active_end_date, sysdate+1))
CONNECT BY PRIOR root.object_id = root.subject_id
AND root.relationship_type_code = 'COMPONENT-OF'
AND trunc(nvl(root.active_start_date,sysdate)) <= trunc(sysdate)
AND trunc(sysdate) < trunc(nvl(root.active_end_date, sysdate+1));
SELECT subject_id , object_id, position_reference
FROM csi_ii_relationships
START WITH object_id = p_csi_root_instance_id
AND relationship_type_code = 'COMPONENT-OF'
AND trunc(nvl(active_start_date,sysdate)) <= trunc(sysdate)
AND trunc(sysdate) < trunc(nvl(active_end_date, sysdate+1))
CONNECT BY PRIOR subject_id = object_id
AND relationship_type_code = 'COMPONENT-OF'
AND trunc(nvl(active_start_date,sysdate)) <= trunc(sysdate)
AND trunc(sysdate) < trunc(nvl(active_end_date, sysdate+1))
ORDER BY level;
l_subj_id_tbl.DELETE;
l_obj_id_tbl.DELETE;
l_posn_ref_tbl.DELETE;
SELECT scheduled_material_id FROM AHL_SCHEDULE_MATERIALS SM
WHERE SM.material_request_type = G_REQ_TYPE_FORECAST
AND SM.mr_route_id = p_mr_route_id
AND SM.unit_effectivity_id IS NOT NULL
AND SM.unit_effectivity_id = p_unit_effectivity_id;
SELECT * FROM AHL_SCHEDULE_MATERIALS SM
WHERE SM.material_request_type = G_REQ_TYPE_FORECAST
AND NVL(SM.rt_oper_material_id,-1) = NVL(p_rt_oper_material_id,-1)
AND SM.inventory_item_id = p_inventory_item_id
AND SM.mr_route_id = p_mr_route_id
AND SM.unit_effectivity_id = p_unit_effectivity_id
FOR UPDATE OF REQUESTED_DATE NOWAIT;
SELECT DISTINCT visit_id
FROM ahl_visit_tasks_b
WHERE unit_effectivity_id = p_unit_effectivity_id;
AHL_SCHEDULE_MATERIALS_PKG.delete_row(x_scheduled_material_id => del_exp_route_rec.scheduled_material_id);
'Inserting record in AHL_SCHEDULE_MATERIALS ');
AHL_SCHEDULE_MATERIALS_PKG.INSERT_ROW
(
X_SCHEDULED_MATERIAL_ID => NULL,
X_OBJECT_VERSION_NUMBER => 1,
X_LAST_UPDATE_DATE => SYSDATE,
X_LAST_UPDATED_BY => fnd_global.user_id,
X_CREATION_DATE => SYSDATE,
X_CREATED_BY => fnd_global.user_id,
X_LAST_UPDATE_LOGIN => fnd_global.user_id,
X_INVENTORY_ITEM_ID => l_Route_Mtl_Req_Tbl(j).inventory_item_id,
X_SCHEDULE_DESIGNATOR => NULL,
X_VISIT_ID => NULL,
X_VISIT_START_DATE => NULL,
X_VISIT_TASK_ID => NULL,
X_ORGANIZATION_ID => NULL,
X_SCHEDULED_DATE => NULL,
X_REQUEST_ID => NULL,
-- AnRaj: truncating Requested Date for Material Requirement based on discussions with PM
X_REQUESTED_DATE => trunc(p_due_date),
X_SCHEDULED_QUANTITY => NULL,
X_PROCESS_STATUS => NULL,
X_ERROR_MESSAGE => NULL,
X_TRANSACTION_ID => NULL,
X_UOM => l_Route_Mtl_Req_Tbl(j).uom_code,
X_RT_OPER_MATERIAL_ID => l_Route_Mtl_Req_Tbl(j).rt_oper_material_id,
X_OPERATION_CODE => NULL,
X_OPERATION_SEQUENCE => NULL,
X_ITEM_GROUP_ID => l_Route_Mtl_Req_Tbl(j).item_group_id,
X_REQUESTED_QUANTITY => l_Route_Mtl_Req_Tbl(j).quantity,
X_PROGRAM_ID => NULL,
X_PROGRAM_UPDATE_DATE => NULL,
X_LAST_UPDATED_DATE => NULL,
X_WORKORDER_OPERATION_ID => NULL,
X_POSITION_PATH_ID => l_Route_Mtl_Req_Tbl(j).position_path_id,
X_RELATIONSHIP_ID => l_Route_Mtl_Req_Tbl(j).relationship_id,
X_UNIT_EFFECTIVITY_ID => p_unit_effectivity_id,
X_MR_ROUTE_ID => p_mr_route_id,
X_MATERIAL_REQUEST_TYPE => G_REQ_TYPE_FORECAST,
-- Added MC_HEADER_ID and POSITION_KEY by surrkuma on 07-Jun-2011 for Service Bulletin
X_MC_HEADER_ID => l_Route_Mtl_Req_Tbl(j).mc_header_id,
X_POSITION_KEY => l_Route_Mtl_Req_Tbl(j).position_key,
X_ATTRIBUTE_CATEGORY => NULL,
X_ATTRIBUTE1 => NULL,
X_ATTRIBUTE2 => NULL,
X_ATTRIBUTE3 => NULL,
X_ATTRIBUTE4 => NULL,
X_ATTRIBUTE5 => NULL,
X_ATTRIBUTE6 => NULL,
X_ATTRIBUTE7 => NULL,
X_ATTRIBUTE8 => NULL,
X_ATTRIBUTE9 => NULL,
X_ATTRIBUTE10 => NULL,
X_ATTRIBUTE11 => NULL,
X_ATTRIBUTE12 => NULL,
X_ATTRIBUTE13 => NULL,
X_ATTRIBUTE14 => NULL,
X_ATTRIBUTE15 => NULL
);
AHL_SCHEDULE_MATERIALS_PKG.UPDATE_ROW
(
X_SCHEDULED_MATERIAL_ID => l_Schedule_Mtl_Req_rec.SCHEDULED_MATERIAL_ID,
X_OBJECT_VERSION_NUMBER => l_Schedule_Mtl_Req_rec.OBJECT_VERSION_NUMBER,--Update Column
X_LAST_UPDATE_DATE => SYSDATE,
X_LAST_UPDATED_BY => fnd_global.user_id,
X_LAST_UPDATE_LOGIN => fnd_global.user_id,
X_INVENTORY_ITEM_ID => l_Schedule_Mtl_Req_rec.INVENTORY_ITEM_ID,
X_SCHEDULE_DESIGNATOR => l_Schedule_Mtl_Req_rec.SCHEDULE_DESIGNATOR,
X_VISIT_ID => l_Schedule_Mtl_Req_rec.VISIT_ID,
X_VISIT_START_DATE => l_Schedule_Mtl_Req_rec.VISIT_START_DATE,
X_VISIT_TASK_ID => l_Schedule_Mtl_Req_rec.VISIT_TASK_ID,
X_ORGANIZATION_ID => l_Schedule_Mtl_Req_rec.ORGANIZATION_ID,
X_SCHEDULED_DATE => l_Schedule_Mtl_Req_rec.SCHEDULED_DATE,
X_REQUEST_ID => l_Schedule_Mtl_Req_rec.REQUEST_ID,
-- AnRaj: truncating Requested Date for Material Requirement based on discussions with PM
X_REQUESTED_DATE => trunc(p_due_date),--Update Column
X_SCHEDULED_QUANTITY => l_Schedule_Mtl_Req_rec.SCHEDULED_QUANTITY,
X_PROCESS_STATUS => l_Schedule_Mtl_Req_rec.PROCESS_STATUS,
X_ERROR_MESSAGE => l_Schedule_Mtl_Req_rec.ERROR_MESSAGE,
X_TRANSACTION_ID => l_Schedule_Mtl_Req_rec.TRANSACTION_ID,
X_UOM => l_Route_Mtl_Req_Tbl(j).uom_code,--Update Column
X_RT_OPER_MATERIAL_ID => l_Route_Mtl_Req_Tbl(j).rt_oper_material_id,--Update Column
X_OPERATION_CODE => l_Schedule_Mtl_Req_rec.OPERATION_CODE,
X_OPERATION_SEQUENCE => l_Schedule_Mtl_Req_rec.OPERATION_SEQUENCE,
X_ITEM_GROUP_ID => l_Route_Mtl_Req_Tbl(j).item_group_id,--Update Column
X_REQUESTED_QUANTITY => l_Route_Mtl_Req_Tbl(j).quantity,--Update Column
X_PROGRAM_ID => l_Schedule_Mtl_Req_rec.PROGRAM_ID,
X_PROGRAM_UPDATE_DATE => l_Schedule_Mtl_Req_rec.PROGRAM_UPDATE_DATE,
X_LAST_UPDATED_DATE => l_Schedule_Mtl_Req_rec.LAST_UPDATED_DATE,
X_WORKORDER_OPERATION_ID => l_Schedule_Mtl_Req_rec.WORKORDER_OPERATION_ID,
X_POSITION_PATH_ID => l_Route_Mtl_Req_Tbl(j).position_path_id,--Update Column
X_RELATIONSHIP_ID => l_Route_Mtl_Req_Tbl(j).relationship_id,--Update Column
X_UNIT_EFFECTIVITY_ID => l_Schedule_Mtl_Req_rec.UNIT_EFFECTIVITY_ID,
X_MR_ROUTE_ID => l_Schedule_Mtl_Req_rec.MR_ROUTE_ID,
X_MATERIAL_REQUEST_TYPE => l_Schedule_Mtl_Req_rec.MATERIAL_REQUEST_TYPE,
-- Added MC_HEADER_ID and POSITION_KEY by surrkuma on 07-Jun-2011 for Service Bulletin
X_MC_HEADER_ID => l_Route_Mtl_Req_Tbl(j).mc_header_id,
X_POSITION_KEY => l_Route_Mtl_Req_Tbl(j).position_key,
X_ATTRIBUTE_CATEGORY => l_Schedule_Mtl_Req_rec.ATTRIBUTE_CATEGORY,
X_ATTRIBUTE1 => l_Schedule_Mtl_Req_rec.ATTRIBUTE1,
X_ATTRIBUTE2 => l_Schedule_Mtl_Req_rec.ATTRIBUTE2,
X_ATTRIBUTE3 => l_Schedule_Mtl_Req_rec.ATTRIBUTE3,
X_ATTRIBUTE4 => l_Schedule_Mtl_Req_rec.ATTRIBUTE4,
X_ATTRIBUTE5 => l_Schedule_Mtl_Req_rec.ATTRIBUTE5,
X_ATTRIBUTE6 => l_Schedule_Mtl_Req_rec.ATTRIBUTE6,
X_ATTRIBUTE7 => l_Schedule_Mtl_Req_rec.ATTRIBUTE7,
X_ATTRIBUTE8 => l_Schedule_Mtl_Req_rec.ATTRIBUTE8,
X_ATTRIBUTE9 => l_Schedule_Mtl_Req_rec.ATTRIBUTE9,
X_ATTRIBUTE10 => l_Schedule_Mtl_Req_rec.ATTRIBUTE10,
X_ATTRIBUTE11 => l_Schedule_Mtl_Req_rec.ATTRIBUTE11,
X_ATTRIBUTE12 => l_Schedule_Mtl_Req_rec.ATTRIBUTE12,
X_ATTRIBUTE13 => l_Schedule_Mtl_Req_rec.ATTRIBUTE13,
X_ATTRIBUTE14 => l_Schedule_Mtl_Req_rec.ATTRIBUTE14,
X_ATTRIBUTE15 => l_Schedule_Mtl_Req_rec.ATTRIBUTE15
);