[Home] [Help]
The following lines contain the word 'select', 'insert', 'update' or 'delete':
G_LAST_UPDATE_DATE DATE := SYSDATE;
G_LAST_UPDATED_BY NUMBER(15) := FND_GLOBAL.user_id;
G_LAST_UPDATE_LOGIN NUMBER(15) := FND_GLOBAL.login_id;
SELECT object_version_number,
standard_operation_flag,
revision_number,
revision_status_code,
revision_status,
start_date_active,
end_date_active,
operation_type_code,
operation_type,
process_code,
process,
--bachandr Enigma Phase I changes -- start
model_code,
model_meaning,
enigma_op_id,
--bachandr Enigma Phase I changes -- end
qa_inspection_type,
qa_inspection_type_desc,
description,
remarks,
revision_notes,
segment1,
segment2,
segment3,
segment4,
segment5,
segment6,
segment7,
segment8,
segment9,
segment10,
segment11,
segment12,
segment13,
segment14,
segment15,
concatenated_segments,
attribute_category,
attribute1,
attribute2,
attribute3,
attribute4,
attribute5,
attribute6,
attribute7,
attribute8,
attribute9,
attribute10,
attribute11,
attribute12,
attribute13,
attribute14,
attribute15
FROM AHL_OPERATIONS_V
WHERE operation_id = c_operation_id;
SELECT 'X'
FROM ahl_operations_b
WHERE ((segment1 is null and c_segment1 is null) or segment1 = c_segment1) AND
((segment2 is null and c_segment2 is null) or segment2 = c_segment2) AND
((segment3 is null and c_segment3 is null) or segment3 = c_segment3) AND
((segment4 is null and c_segment4 is null) or segment4 = c_segment4) AND
((segment5 is null and c_segment5 is null) or segment5 = c_segment5) AND
((segment6 is null and c_segment6 is null) or segment6 = c_segment6) AND
((segment7 is null and c_segment7 is null) or segment7 = c_segment7) AND
((segment8 is null and c_segment8 is null) or segment8 = c_segment8) AND
((segment9 is null and c_segment9 is null) or segment9 = c_segment9) AND
((segment10 is null and c_segment10 is null) or segment10 = c_segment10) AND
((segment11 is null and c_segment11 is null) or segment11 = c_segment11) AND
((segment12 is null and c_segment12 is null) or segment11 = c_segment12) AND
((segment13 is null and c_segment13 is null) or segment13 = c_segment13) AND
((segment14 is null and c_segment14 is null) or segment14 = c_segment14) AND
((segment15 is null and c_segment15 is null) or segment15 = c_segment15);
select 'x'
from ahl_operations_b
where operation_id = p_operation_rec.operation_id and
object_version_number = p_operation_rec.object_version_number;
Select model_code into l_model_code
From ahl_operations_b
Where operation_id = p_operation_rec.operation_id;
SELECT start_date_active
FROM ahl_operations_v
WHERE concatenated_segments = c_concatenated_segments
AND revision_number = c_revision_number - 1;
SELECT operation_id
FROM AHL_OPERATIONS_B
WHERE (c_segment1 is null or nvl(segment1, c_segment1) = c_segment1) AND
(c_segment2 is null or nvl(segment2, c_segment2) = c_segment2) AND
(c_segment3 is null or nvl(segment3, c_segment3) = c_segment3) AND
(c_segment4 is null or nvl(segment4, c_segment4) = c_segment4) AND
(c_segment5 is null or nvl(segment5, c_segment5) = c_segment5) AND
(c_segment6 is null or nvl(segment6, c_segment6) = c_segment6) AND
(c_segment7 is null or nvl(segment7, c_segment7) = c_segment7) AND
(c_segment8 is null or nvl(segment8, c_segment8) = c_segment8) AND
(c_segment9 is null or nvl(segment9, c_segment9) = c_segment9) AND
(c_segment10 is null or nvl(segment10, c_segment10) = c_segment10) AND
(c_segment11 is null or nvl(segment11, c_segment11) = c_segment11) AND
(c_segment12 is null or nvl(segment11, c_segment12) = c_segment12) AND
(c_segment13 is null or nvl(segment13, c_segment13) = c_segment13) AND
(c_segment14 is null or nvl(segment14, c_segment14) = c_segment14) AND
(c_segment15 is null or nvl(segment15, c_segment15) = c_segment15) AND
revision_number = c_revision_number;
SELECT AHL_OPERATIONS_B_S.NEXTVAL
INTO p_x_operation_rec.operation_id
FROM DUAL;
AHL_OPERATIONS_PKG.insert_row
(
X_ROWID => l_rowid ,
X_OPERATION_ID => p_x_operation_rec.operation_id ,
X_OBJECT_VERSION_NUMBER => p_x_operation_rec.object_version_number ,
X_STANDARD_OPERATION_FLAG => p_x_operation_rec.standard_operation_flag ,
X_REVISION_NUMBER => p_x_operation_rec.revision_number ,
X_REVISION_STATUS_CODE => p_x_operation_rec.revision_status_code ,
X_START_DATE_ACTIVE => p_x_operation_rec.active_start_date ,
X_END_DATE_ACTIVE => p_x_operation_rec.active_end_date ,
X_SUMMARY_FLAG => 'N' ,
X_ENABLED_FLAG => 'Y' ,
X_QA_INSPECTION_TYPE => p_x_operation_rec.qa_inspection_type ,
X_OPERATION_TYPE_CODE => p_x_operation_rec.operation_type_code ,
X_PROCESS_CODE => p_x_operation_rec.process_code ,
--bachandr Enigma Phase I changes -- start
X_MODEL_CODE => p_x_operation_rec.model_code,
X_ENIGMA_OP_ID => p_x_operation_rec.enigma_op_id,
--bachandr Enigma Phase I changes -- end
X_SEGMENT1 => p_x_operation_rec.segment1 ,
X_SEGMENT2 => p_x_operation_rec.segment2 ,
X_SEGMENT3 => p_x_operation_rec.segment3 ,
X_SEGMENT4 => p_x_operation_rec.segment4 ,
X_SEGMENT5 => p_x_operation_rec.segment5 ,
X_SEGMENT6 => p_x_operation_rec.segment6 ,
X_SEGMENT7 => p_x_operation_rec.segment7 ,
X_SEGMENT8 => p_x_operation_rec.segment8 ,
X_SEGMENT9 => p_x_operation_rec.segment9 ,
X_SEGMENT10 => p_x_operation_rec.segment10 ,
X_SEGMENT11 => p_x_operation_rec.segment11 ,
X_SEGMENT12 => p_x_operation_rec.segment12 ,
X_SEGMENT13 => p_x_operation_rec.segment13 ,
X_SEGMENT14 => p_x_operation_rec.segment14 ,
X_SEGMENT15 => p_x_operation_rec.segment15 ,
X_ATTRIBUTE_CATEGORY => p_x_operation_rec.attribute_category ,
X_ATTRIBUTE1 => p_x_operation_rec.attribute1 ,
X_ATTRIBUTE2 => p_x_operation_rec.attribute2 ,
X_ATTRIBUTE3 => p_x_operation_rec.attribute3 ,
X_ATTRIBUTE4 => p_x_operation_rec.attribute4 ,
X_ATTRIBUTE5 => p_x_operation_rec.attribute5 ,
X_ATTRIBUTE6 => p_x_operation_rec.attribute6 ,
X_ATTRIBUTE7 => p_x_operation_rec.attribute7 ,
X_ATTRIBUTE8 => p_x_operation_rec.attribute8 ,
X_ATTRIBUTE9 => p_x_operation_rec.attribute9 ,
X_ATTRIBUTE10 => p_x_operation_rec.attribute10 ,
X_ATTRIBUTE11 => p_x_operation_rec.attribute11 ,
X_ATTRIBUTE12 => p_x_operation_rec.attribute12 ,
X_ATTRIBUTE13 => p_x_operation_rec.attribute13 ,
X_ATTRIBUTE14 => p_x_operation_rec.attribute14 ,
X_ATTRIBUTE15 => p_x_operation_rec.attribute15 ,
X_DESCRIPTION => SUBSTR(p_x_operation_rec.description, 1, 500) ,
X_REMARKS => p_x_operation_rec.remarks ,
X_REVISION_NOTES => p_x_operation_rec.revision_notes ,
X_CREATION_DATE => G_CREATION_DATE ,
X_CREATED_BY => G_CREATED_BY ,
X_LAST_UPDATE_DATE => G_LAST_UPDATE_DATE ,
X_LAST_UPDATED_BY => G_LAST_UPDATED_BY ,
X_LAST_UPDATE_LOGIN => G_LAST_UPDATE_LOGIN
);
'AHL_OPERATIONS_B insert error = ['||SQLERRM||']'
);
AHL_OPERATIONS_PKG.update_row
(
X_OPERATION_ID => p_x_operation_rec.operation_id ,
X_OBJECT_VERSION_NUMBER => p_x_operation_rec.object_version_number ,
X_STANDARD_OPERATION_FLAG => p_x_operation_rec.standard_operation_flag ,
X_REVISION_NUMBER => p_x_operation_rec.revision_number ,
X_REVISION_STATUS_CODE => p_x_operation_rec.revision_status_code ,
X_START_DATE_ACTIVE => p_x_operation_rec.active_start_date ,
X_END_DATE_ACTIVE => p_x_operation_rec.active_end_date ,
X_SUMMARY_FLAG => 'N' ,
X_ENABLED_FLAG => 'Y' ,
X_QA_INSPECTION_TYPE => p_x_operation_rec.qa_inspection_type ,
X_OPERATION_TYPE_CODE => p_x_operation_rec.operation_type_code ,
X_PROCESS_CODE => p_x_operation_rec.process_code ,
--bachandr Enigma Phase I changes -- start
X_MODEL_CODE => p_x_operation_rec.model_code,
X_ENIGMA_OP_ID => p_x_operation_rec.enigma_op_id,
--bachandr Enigma Phase I changes -- end
X_SEGMENT1 => p_x_operation_rec.segment1 ,
X_SEGMENT2 => p_x_operation_rec.segment2 ,
X_SEGMENT3 => p_x_operation_rec.segment3 ,
X_SEGMENT4 => p_x_operation_rec.segment4 ,
X_SEGMENT5 => p_x_operation_rec.segment5 ,
X_SEGMENT6 => p_x_operation_rec.segment6 ,
X_SEGMENT7 => p_x_operation_rec.segment7 ,
X_SEGMENT8 => p_x_operation_rec.segment8 ,
X_SEGMENT9 => p_x_operation_rec.segment9 ,
X_SEGMENT10 => p_x_operation_rec.segment10 ,
X_SEGMENT11 => p_x_operation_rec.segment11 ,
X_SEGMENT12 => p_x_operation_rec.segment12 ,
X_SEGMENT13 => p_x_operation_rec.segment13 ,
X_SEGMENT14 => p_x_operation_rec.segment14 ,
X_SEGMENT15 => p_x_operation_rec.segment15 ,
X_ATTRIBUTE_CATEGORY => p_x_operation_rec.attribute_category ,
X_ATTRIBUTE1 => p_x_operation_rec.attribute1 ,
X_ATTRIBUTE2 => p_x_operation_rec.attribute2 ,
X_ATTRIBUTE3 => p_x_operation_rec.attribute3 ,
X_ATTRIBUTE4 => p_x_operation_rec.attribute4 ,
X_ATTRIBUTE5 => p_x_operation_rec.attribute5 ,
X_ATTRIBUTE6 => p_x_operation_rec.attribute6 ,
X_ATTRIBUTE7 => p_x_operation_rec.attribute7 ,
X_ATTRIBUTE8 => p_x_operation_rec.attribute8 ,
X_ATTRIBUTE9 => p_x_operation_rec.attribute9 ,
X_ATTRIBUTE10 => p_x_operation_rec.attribute10 ,
X_ATTRIBUTE11 => p_x_operation_rec.attribute11 ,
X_ATTRIBUTE12 => p_x_operation_rec.attribute12 ,
X_ATTRIBUTE13 => p_x_operation_rec.attribute13 ,
X_ATTRIBUTE14 => p_x_operation_rec.attribute14 ,
X_ATTRIBUTE15 => p_x_operation_rec.attribute15 ,
X_DESCRIPTION => SUBSTR(p_x_operation_rec.description, 1, 500) ,
X_REMARKS => p_x_operation_rec.remarks ,
X_REVISION_NOTES => p_x_operation_rec.revision_notes ,
X_LAST_UPDATE_DATE => G_LAST_UPDATE_DATE ,
X_LAST_UPDATED_BY => G_LAST_UPDATED_BY ,
X_LAST_UPDATE_LOGIN => G_LAST_UPDATE_LOGIN
);
'AHL_OPERATIONS_B insert error = ['||SQLERRM||']'
);
PROCEDURE delete_operation
(
p_api_version IN NUMBER := 1.0,
p_init_msg_list IN VARCHAR2 := FND_API.G_TRUE,
p_commit IN VARCHAR2 := FND_API.G_FALSE,
p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
p_default IN VARCHAR2 := FND_API.G_FALSE,
p_module_type IN VARCHAR2 := NULL,
x_return_status OUT NOCOPY VARCHAR2,
x_msg_count OUT NOCOPY NUMBER,
x_msg_data OUT NOCOPY VARCHAR2,
p_operation_id IN NUMBER,
p_object_version_number IN NUMBER
)
IS
l_api_name CONSTANT VARCHAR2(30) := 'delete_operation';
SELECT doc_title_asso_id
FROM ahl_doc_title_assos_b
WHERE aso_object_id = c_OPERATION_id
AND aso_object_type_code = 'OPERATION';
select 'x'
from ahl_operations_b
where operation_id = p_operation_id and
object_version_number = p_object_version_number;
SAVEPOINT delete_operation_pvt;
Select ENIGMA_OP_ID into l_enig_op_id
From ahl_operations_b
Where operation_id = p_operation_id;
AHL_OPERATIONS_PKG.delete_row
(
X_OPERATION_ID => p_operation_id
);
DELETE AHL_RT_OPER_MATERIALS
WHERE OBJECT_ID = p_operation_id
AND ASSOCIATION_TYPE_CODE = 'OPERATION';
DELETE AHL_RT_OPER_RESOURCES
WHERE OBJECT_ID = p_operation_id
AND ASSOCIATION_TYPE_CODE = 'OPERATION';
ahl_doc_title_assos_pkg.delete_row
(
X_DOC_TITLE_ASSO_ID => I.doc_title_asso_id
);
DELETE AHL_ROUTE_OPERATIONS
WHERE OPERATION_ID = p_operation_id;
DELETE AHL_RT_OPER_ACCESS_PANELS
WHERE OBJECT_ID = p_operation_id
AND ASSOCIATION_TYPE_CODE = 'OPERATION';
ROLLBACK TO delete_OPERATION_PVT;
ROLLBACK TO delete_OPERATION_PVT;
ROLLBACK TO delete_OPERATION_PVT;
END delete_operation;
SELECT MAX( revision_number )
FROM AHL_OPERATIONS_V
WHERE concatenated_segments = c_concatenated_segments;
SELECT doc_title_asso_id,
doc_revision_id,
document_id,
use_latest_rev_flag,
serial_no,
source_ref_code,
chapter,
section,
subject,
page,
figure,
note,
attribute_category,
attribute1,
attribute2,
attribute3,
attribute4,
attribute5,
attribute6,
attribute7,
attribute8,
attribute9,
attribute10,
attribute11,
attribute12,
attribute13,
attribute14,
attribute15
FROM AHL_DOC_TITLE_ASSOS_VL
WHERE aso_object_id = c_operation_id
AND aso_object_type_code = 'OPERATION';
SELECT
RT_OPER_RESOURCE_ID,
OBJECT_ID,
ASSOCIATION_TYPE_CODE,
ASO_RESOURCE_ID,
QUANTITY,
DURATION,
ACTIVITY_ID,
COST_BASIS_ID,
SCHEDULED_TYPE_ID,
AUTOCHARGE_TYPE_ID,
STANDARD_RATE_FLAG,
ATTRIBUTE_CATEGORY,
ATTRIBUTE1,
ATTRIBUTE2,
ATTRIBUTE3,
ATTRIBUTE4,
ATTRIBUTE5,
ATTRIBUTE6,
ATTRIBUTE7,
ATTRIBUTE8,
ATTRIBUTE9,
ATTRIBUTE10,
ATTRIBUTE11,
ATTRIBUTE12,
ATTRIBUTE13,
ATTRIBUTE14,
ATTRIBUTE15,
-- Bug # 7644260 (FP for ER # 6998882) -- start
SCHEDULE_SEQ
-- Bug # 7644260 (FP for ER # 6998882) -- end
FROM ahl_rt_oper_resources
WHERE object_id = c_operation_id
AND association_type_code = 'OPERATION';
SELECT AHL_OPERATIONS_B_S.NEXTVAL
INTO l_operation_id
FROM DUAL;
AHL_OPERATIONS_PKG.insert_row
(
X_ROWID => l_rowid ,
X_OPERATION_ID => l_operation_id ,
X_OBJECT_VERSION_NUMBER => 1 ,
X_STANDARD_OPERATION_FLAG => l_old_operation_rec.standard_operation_flag ,
X_REVISION_NUMBER => l_revision_number ,
X_REVISION_STATUS_CODE => 'DRAFT' ,
X_START_DATE_ACTIVE => l_old_operation_rec.active_start_date ,
X_END_DATE_ACTIVE => NULL ,
X_SUMMARY_FLAG => 'N',
X_ENABLED_FLAG => 'Y',
X_QA_INSPECTION_TYPE => l_old_operation_rec.qa_inspection_type ,
X_OPERATION_TYPE_CODE => l_old_operation_rec.operation_type_code ,
X_PROCESS_CODE => l_old_operation_rec.process_code ,
--bachandr Enigma Phase I changes -- start
X_MODEL_CODE => l_old_operation_rec.model_code,
X_ENIGMA_OP_ID => l_old_operation_rec.enigma_op_id,
--bachandr Enigma Phase I changes -- end
X_SEGMENT1 => l_old_operation_rec.segment1 ,
X_SEGMENT2 => l_old_operation_rec.segment2 ,
X_SEGMENT3 => l_old_operation_rec.segment3 ,
X_SEGMENT4 => l_old_operation_rec.segment4 ,
X_SEGMENT5 => l_old_operation_rec.segment5 ,
X_SEGMENT6 => l_old_operation_rec.segment6 ,
X_SEGMENT7 => l_old_operation_rec.segment7 ,
X_SEGMENT8 => l_old_operation_rec.segment8 ,
X_SEGMENT9 => l_old_operation_rec.segment9 ,
X_SEGMENT10 => l_old_operation_rec.segment10 ,
X_SEGMENT11 => l_old_operation_rec.segment11 ,
X_SEGMENT12 => l_old_operation_rec.segment12 ,
X_SEGMENT13 => l_old_operation_rec.segment13 ,
X_SEGMENT14 => l_old_operation_rec.segment14 ,
X_SEGMENT15 => l_old_operation_rec.segment15 ,
X_ATTRIBUTE_CATEGORY => l_old_operation_rec.attribute_category ,
X_ATTRIBUTE1 => l_old_operation_rec.attribute1 ,
X_ATTRIBUTE2 => l_old_operation_rec.attribute2 ,
X_ATTRIBUTE3 => l_old_operation_rec.attribute3 ,
X_ATTRIBUTE4 => l_old_operation_rec.attribute4 ,
X_ATTRIBUTE5 => l_old_operation_rec.attribute5 ,
X_ATTRIBUTE6 => l_old_operation_rec.attribute6 ,
X_ATTRIBUTE7 => l_old_operation_rec.attribute7 ,
X_ATTRIBUTE8 => l_old_operation_rec.attribute8 ,
X_ATTRIBUTE9 => l_old_operation_rec.attribute9 ,
X_ATTRIBUTE10 => l_old_operation_rec.attribute10 ,
X_ATTRIBUTE11 => l_old_operation_rec.attribute11 ,
X_ATTRIBUTE12 => l_old_operation_rec.attribute12 ,
X_ATTRIBUTE13 => l_old_operation_rec.attribute13 ,
X_ATTRIBUTE14 => l_old_operation_rec.attribute14 ,
X_ATTRIBUTE15 => l_old_operation_rec.attribute15 ,
X_DESCRIPTION => l_old_operation_rec.description ,
X_REMARKS => l_old_operation_rec.remarks ,
X_REVISION_NOTES => NULL ,
X_CREATION_DATE => G_CREATION_DATE ,
X_CREATED_BY => G_CREATED_BY ,
X_LAST_UPDATE_DATE => G_LAST_UPDATE_DATE ,
X_LAST_UPDATED_BY => G_LAST_UPDATED_BY ,
X_LAST_UPDATE_LOGIN => G_LAST_UPDATE_LOGIN
);
'AHL_OPERATIONS_B insert error = ['||SQLERRM||']'
);
INSERT INTO AHL_RT_OPER_MATERIALS
(
RT_OPER_MATERIAL_ID,
OBJECT_VERSION_NUMBER,
OBJECT_ID,
ASSOCIATION_TYPE_CODE,
ITEM_GROUP_ID,
INVENTORY_ITEM_ID,
INVENTORY_ORG_ID,
UOM_CODE,
QUANTITY,
ATTRIBUTE_CATEGORY,
ATTRIBUTE1,
ATTRIBUTE2,
ATTRIBUTE3,
ATTRIBUTE4,
ATTRIBUTE5,
ATTRIBUTE6,
ATTRIBUTE7,
ATTRIBUTE8,
ATTRIBUTE9,
ATTRIBUTE10,
ATTRIBUTE11,
ATTRIBUTE12,
ATTRIBUTE13,
ATTRIBUTE14,
ATTRIBUTE15,
EXCLUDE_FLAG,
LAST_UPDATE_DATE,
LAST_UPDATED_BY,
CREATION_DATE,
CREATED_BY,
LAST_UPDATE_LOGIN,
IN_SERVICE --pdoki added for OGMA 105 issue
)
SELECT
AHL_RT_OPER_MATERIALS_S.NEXTVAL,
1,
l_operation_id,
ASSOCIATION_TYPE_CODE,
ITEM_GROUP_ID,
INVENTORY_ITEM_ID,
INVENTORY_ORG_ID,
UOM_CODE,
QUANTITY,
ATTRIBUTE_CATEGORY,
ATTRIBUTE1,
ATTRIBUTE2,
ATTRIBUTE3,
ATTRIBUTE4,
ATTRIBUTE5,
ATTRIBUTE6,
ATTRIBUTE7,
ATTRIBUTE8,
ATTRIBUTE9,
ATTRIBUTE10,
ATTRIBUTE11,
ATTRIBUTE12,
ATTRIBUTE13,
ATTRIBUTE14,
ATTRIBUTE15,
EXCLUDE_FLAG,
G_LAST_UPDATE_DATE,
G_LAST_UPDATED_BY,
G_CREATION_DATE,
G_CREATED_BY,
G_LAST_UPDATE_LOGIN,
IN_SERVICE --pdoki added for OGMA 105 issue
FROM AHL_RT_OPER_MATERIALS
WHERE object_id = p_operation_id
AND association_type_code = 'OPERATION';
SELECT ahl_rt_oper_resources_s.nextval into l_rt_oper_resource_id
FROM dual;
INSERT INTO AHL_RT_OPER_RESOURCES
(
RT_OPER_RESOURCE_ID,
OBJECT_VERSION_NUMBER,
LAST_UPDATE_DATE,
LAST_UPDATED_BY,
CREATION_DATE,
CREATED_BY,
LAST_UPDATE_LOGIN,
OBJECT_ID,
ASSOCIATION_TYPE_CODE,
ASO_RESOURCE_ID,
QUANTITY,
DURATION,
ACTIVITY_ID,
COST_BASIS_ID,
SCHEDULED_TYPE_ID,
AUTOCHARGE_TYPE_ID,
STANDARD_RATE_FLAG,
ATTRIBUTE_CATEGORY,
ATTRIBUTE1,
ATTRIBUTE2,
ATTRIBUTE3,
ATTRIBUTE4,
ATTRIBUTE5,
ATTRIBUTE6,
ATTRIBUTE7,
ATTRIBUTE8,
ATTRIBUTE9,
ATTRIBUTE10,
ATTRIBUTE11,
ATTRIBUTE12,
ATTRIBUTE13,
ATTRIBUTE14,
ATTRIBUTE15,
-- Bug # 7644260 (FP for ER # 6998882) -- start
SCHEDULE_SEQ
-- Bug # 7644260 (FP for ER # 6998882) -- end
)
VALUES
(
l_rt_oper_resource_id,
1,
G_LAST_UPDATE_DATE,
G_LAST_UPDATED_BY,
G_CREATION_DATE,
G_CREATED_BY,
G_LAST_UPDATE_LOGIN,
l_operation_id,
l_get_rt_oper_resources.ASSOCIATION_TYPE_CODE,
l_get_rt_oper_resources.ASO_RESOURCE_ID,
l_get_rt_oper_resources.QUANTITY,
l_get_rt_oper_resources.DURATION,
l_get_rt_oper_resources.ACTIVITY_ID,
l_get_rt_oper_resources.COST_BASIS_ID,
l_get_rt_oper_resources.SCHEDULED_TYPE_ID,
l_get_rt_oper_resources.AUTOCHARGE_TYPE_ID,
l_get_rt_oper_resources.STANDARD_RATE_FLAG,
l_get_rt_oper_resources.ATTRIBUTE_CATEGORY,
l_get_rt_oper_resources.ATTRIBUTE1,
l_get_rt_oper_resources.ATTRIBUTE2,
l_get_rt_oper_resources.ATTRIBUTE3,
l_get_rt_oper_resources.ATTRIBUTE4,
l_get_rt_oper_resources.ATTRIBUTE5,
l_get_rt_oper_resources.ATTRIBUTE6,
l_get_rt_oper_resources.ATTRIBUTE7,
l_get_rt_oper_resources.ATTRIBUTE8,
l_get_rt_oper_resources.ATTRIBUTE9,
l_get_rt_oper_resources.ATTRIBUTE10,
l_get_rt_oper_resources.ATTRIBUTE11,
l_get_rt_oper_resources.ATTRIBUTE12,
l_get_rt_oper_resources.ATTRIBUTE13,
l_get_rt_oper_resources.ATTRIBUTE14,
l_get_rt_oper_resources.ATTRIBUTE15,
-- Bug # 7644260 (FP for ER # 6998882) -- start
l_get_rt_oper_resources.SCHEDULE_SEQ
-- Bug # 7644260 (FP for ER # 6998882) -- end
);
INSERT INTO AHL_ALTERNATE_RESOURCES
(
ALTERNATE_RESOURCE_ID,
OBJECT_VERSION_NUMBER,
LAST_UPDATE_DATE,
LAST_UPDATED_BY,
CREATION_DATE,
CREATED_BY,
LAST_UPDATE_LOGIN,
RT_OPER_RESOURCE_ID,
ASO_RESOURCE_ID,
PRIORITY,
ATTRIBUTE_CATEGORY,
ATTRIBUTE1,
ATTRIBUTE2,
ATTRIBUTE3,
ATTRIBUTE4,
ATTRIBUTE5,
ATTRIBUTE6,
ATTRIBUTE7,
ATTRIBUTE8,
ATTRIBUTE9,
ATTRIBUTE10,
ATTRIBUTE11,
ATTRIBUTE12,
ATTRIBUTE13,
ATTRIBUTE14,
ATTRIBUTE15
)
SELECT
AHL_ALTERNATE_RESOURCES_S.NEXTVAL,
1,
G_LAST_UPDATE_DATE,
G_LAST_UPDATED_BY,
G_CREATION_DATE,
G_CREATED_BY,
G_LAST_UPDATE_LOGIN,
l_rt_oper_resource_id,
aso_resource_id,
priority,
ATTRIBUTE_CATEGORY,
ATTRIBUTE1,
ATTRIBUTE2,
ATTRIBUTE3,
ATTRIBUTE4,
ATTRIBUTE5,
ATTRIBUTE6,
ATTRIBUTE7,
ATTRIBUTE8,
ATTRIBUTE9,
ATTRIBUTE10,
ATTRIBUTE11,
ATTRIBUTE12,
ATTRIBUTE13,
ATTRIBUTE14,
ATTRIBUTE15
FROM AHL_ALTERNATE_RESOURCES
WHERE rt_oper_resource_id = l_get_rt_oper_resources.rt_oper_resource_id;
SELECT AHL_DOC_TITLE_ASSOS_B_S.NEXTVAL
INTO l_doc_title_assos_id
FROM DUAL;
AHL_DOC_TITLE_ASSOS_PKG.insert_row
(
X_ROWID => l_rowid,
X_DOC_TITLE_ASSO_ID => l_doc_title_assos_id,
X_SERIAL_NO => I.serial_no,
X_ATTRIBUTE_CATEGORY => I.attribute_category,
X_ATTRIBUTE1 => I.attribute1,
X_ATTRIBUTE2 => I.attribute1,
X_ATTRIBUTE3 => I.attribute1,
X_ATTRIBUTE4 => I.attribute1,
X_ATTRIBUTE5 => I.attribute1,
X_ATTRIBUTE6 => I.attribute1,
X_ATTRIBUTE7 => I.attribute1,
X_ATTRIBUTE8 => I.attribute1,
X_ATTRIBUTE9 => I.attribute1,
X_ATTRIBUTE10 => I.attribute1,
X_ATTRIBUTE11 => I.attribute1,
X_ATTRIBUTE12 => I.attribute1,
X_ATTRIBUTE13 => I.attribute1,
X_ATTRIBUTE14 => I.attribute1,
X_ATTRIBUTE15 => I.attribute1,
X_ASO_OBJECT_TYPE_CODE => 'OPERATION',
X_SOURCE_REF_CODE => I.source_ref_code,
X_ASO_OBJECT_ID => l_operation_id,
X_DOCUMENT_ID => I.document_id,
X_USE_LATEST_REV_FLAG => I.use_latest_rev_flag,
X_DOC_REVISION_ID => I.doc_revision_id,
X_OBJECT_VERSION_NUMBER => 1,
X_CHAPTER => I.chapter,
X_SECTION => I.section,
X_SUBJECT => I.subject,
X_FIGURE => I.figure,
X_PAGE => I.page,
X_NOTE => I.note,
X_CREATION_DATE => G_CREATION_DATE,
X_CREATED_BY => G_CREATED_BY ,
X_LAST_UPDATE_DATE => G_LAST_UPDATE_DATE,
X_LAST_UPDATED_BY => G_LAST_UPDATED_BY ,
X_LAST_UPDATE_LOGIN => G_LAST_UPDATE_LOGIN
);
INSERT INTO AHL_ROUTE_OPERATIONS
(
ROUTE_OPERATION_ID,
OBJECT_VERSION_NUMBER,
ROUTE_ID,
OPERATION_ID,
STEP,
CHECK_POINT_FLAG,
ATTRIBUTE_CATEGORY,
ATTRIBUTE1,
ATTRIBUTE2,
ATTRIBUTE3,
ATTRIBUTE4,
ATTRIBUTE5,
ATTRIBUTE6,
ATTRIBUTE7,
ATTRIBUTE8,
ATTRIBUTE9,
ATTRIBUTE10,
ATTRIBUTE11,
ATTRIBUTE12,
ATTRIBUTE13,
ATTRIBUTE14,
ATTRIBUTE15,
LAST_UPDATE_DATE,
LAST_UPDATED_BY,
CREATION_DATE,
CREATED_BY,
LAST_UPDATE_LOGIN
)
SELECT
AHL_ROUTE_OPERATIONS_S.NEXTVAL,
1,
ROUTE_ID,
l_operation_id,
STEP,
CHECK_POINT_FLAG,
ATTRIBUTE_CATEGORY,
ATTRIBUTE1,
ATTRIBUTE2,
ATTRIBUTE3,
ATTRIBUTE4,
ATTRIBUTE5,
ATTRIBUTE6,
ATTRIBUTE7,
ATTRIBUTE8,
ATTRIBUTE9,
ATTRIBUTE10,
ATTRIBUTE11,
ATTRIBUTE12,
ATTRIBUTE13,
ATTRIBUTE14,
ATTRIBUTE15,
G_LAST_UPDATE_DATE,
G_LAST_UPDATED_BY,
G_CREATION_DATE,
G_CREATED_BY,
G_LAST_UPDATE_LOGIN
FROM AHL_ROUTE_OPERATIONS
WHERE operation_id = p_operation_id;
INSERT INTO AHL_RT_OPER_ACCESS_PANELS
(
RT_OPER_PANEL_ID,
OBJECT_VERSION_NUMBER,
OBJECT_ID,
ASSOCIATION_TYPE_CODE,
PANEL_TYPE_ID,
ATTRIBUTE_CATEGORY,
ATTRIBUTE1,
ATTRIBUTE2,
ATTRIBUTE3,
ATTRIBUTE4,
ATTRIBUTE5,
ATTRIBUTE6,
ATTRIBUTE7,
ATTRIBUTE8,
ATTRIBUTE9,
ATTRIBUTE10,
ATTRIBUTE11,
ATTRIBUTE12,
ATTRIBUTE13,
ATTRIBUTE14,
ATTRIBUTE15,
LAST_UPDATE_DATE,
LAST_UPDATED_BY,
CREATION_DATE,
CREATED_BY,
LAST_UPDATE_LOGIN
)
SELECT
AHL_RT_OPER_ACCESS_PANELS_S.NEXTVAL,
1,
l_operation_id,
ASSOCIATION_TYPE_CODE,
PANEL_TYPE_ID,
ATTRIBUTE_CATEGORY,
ATTRIBUTE1,
ATTRIBUTE2,
ATTRIBUTE3,
ATTRIBUTE4,
ATTRIBUTE5,
ATTRIBUTE6,
ATTRIBUTE7,
ATTRIBUTE8,
ATTRIBUTE9,
ATTRIBUTE10,
ATTRIBUTE11,
ATTRIBUTE12,
ATTRIBUTE13,
ATTRIBUTE14,
ATTRIBUTE15,
SYSDATE,
FND_GLOBAL.user_id,
SYSDATE,
FND_GLOBAL.user_id,
FND_GLOBAL.login_id
FROM AHL_RT_OPER_ACCESS_PANELS
WHERE object_id = p_operation_id
AND association_type_code = 'OPERATION';