The following lines contain the word 'select', 'insert', 'update' or 'delete':
SELECT from_op_seq_id
, to_op_seq_id
, transition_type
, planning_pct
-- , effecitvity_date
-- , disable_date
, attribute_category
, attribute1
, attribute2
, attribute3
, attribute4
, attribute5
, attribute6
, attribute7
, attribute8
, attribute9
, attribute10
, attribute11
, attribute12
, attribute13
, attribute14
, attribute15
INTO l_op_network_unexp_rec.from_op_seq_id
, l_op_network_unexp_rec.to_op_seq_id
, l_op_network_rec.connection_type
, l_op_network_rec.planning_percent
-- , l_op_network_rec.effecitvity_date
-- , l_op_network_rec.disable_date
, l_op_network_rec.attribute_category
, l_op_network_rec.attribute1
, l_op_network_rec.attribute2
, l_op_network_rec.attribute3
, l_op_network_rec.attribute4
, l_op_network_rec.attribute5
, l_op_network_rec.attribute6
, l_op_network_rec.attribute7
, l_op_network_rec.attribute8
, l_op_network_rec.attribute9
, l_op_network_rec.attribute10
, l_op_network_rec.attribute11
, l_op_network_rec.attribute12
, l_op_network_rec.attribute13
, l_op_network_rec.attribute14
, l_op_network_rec.attribute15
FROM bom_operation_networks
WHERE from_op_seq_id = p_from_op_seq_id
AND to_op_seq_id = p_to_op_seq_id;
* Procedure : Insert_Row
* Parameters IN : Operation networker exposed column record
* Operation networker unexposed column record
* Parameters OUT: Message Token Table
* Return Status
* Purpose : Procedure will perfrom an insert into the
* rtg_Bill_Of_Materials table thus creating a new bill
*********************************************************************/
PROCEDURE Insert_Row
( p_op_network_rec IN Bom_Rtg_Pub.op_network_Rec_Type
, p_op_network_unexp_rec IN Bom_Rtg_Pub.op_network_Unexposed_Rec_Type
, x_mesg_token_Tbl IN OUT NOCOPY Error_Handler.Mesg_Token_Tbl_Type
, x_return_Status IN OUT NOCOPY VARCHAR2
)
IS
p_start_effectivity_date DATE;
INSERT INTO bom_operation_networks
( from_op_seq_id
, to_op_seq_id
, transition_type
, planning_pct
-- , effectivity_date
-- , disable_date
, attribute_category
, attribute1
, attribute2
, attribute3
, attribute4
, attribute5
, attribute6
, attribute7
, attribute8
, attribute9
, attribute10
, attribute11
, attribute12
, attribute13
, attribute14
, attribute15
, creation_date
, created_by
, last_update_date
, last_updated_by
, last_update_login
, original_system_reference -- Added by MK 05/01
, request_id
, program_id
, program_application_id
, program_update_date
)
VALUES
( p_op_network_unexp_rec.from_op_seq_id
, p_op_network_unexp_rec.to_op_seq_id
, p_op_network_rec.connection_type
, p_op_network_rec.planning_percent
-- , NULL
-- , NULL
, p_op_network_rec.attribute_category
, p_op_network_rec.attribute1
, p_op_network_rec.attribute2
, p_op_network_rec.attribute3
, p_op_network_rec.attribute4
, p_op_network_rec.attribute5
, p_op_network_rec.attribute6
, p_op_network_rec.attribute7
, p_op_network_rec.attribute8
, p_op_network_rec.attribute9
, p_op_network_rec.attribute10
, p_op_network_rec.attribute11
, p_op_network_rec.attribute12
, p_op_network_rec.attribute13
, p_op_network_rec.attribute14
, p_op_network_rec.attribute15
, SYSDATE
, BOM_Rtg_Globals.Get_User_Id
, SYSDATE
, BOM_Rtg_Globals.Get_User_Id
, BOM_Rtg_Globals.Get_Login_Id
, p_op_network_rec.original_system_reference -- Added by MK 05/01
, Fnd_Global.Conc_Request_Id
, Fnd_Global.Conc_Program_Id
, Fnd_Global.Prog_Appl_Id
, SYSDATE
);
update BOM_OPERATION_SEQUENCES set
X_COORDINATE = p_op_network_rec.From_X_Coordinate
,Y_COORDINATE = p_op_network_rec.From_Y_Coordinate
, last_update_date = SYSDATE
, last_updated_by = BOM_Rtg_Globals.Get_User_Id
, last_update_login = BOM_Rtg_Globals.Get_Login_Id
, request_id = Fnd_Global.Conc_Request_Id
, program_id = Fnd_Global.Conc_Program_Id
, program_application_id = Fnd_Global.Prog_Appl_Id
, program_update_date = SYSDATE
where operation_sequence_id =
p_op_network_unexp_rec.from_op_seq_id;
update BOM_OPERATION_SEQUENCES set
X_COORDINATE = p_op_network_rec.To_X_Coordinate
,Y_COORDINATE = p_op_network_rec.To_Y_Coordinate
, last_update_date = SYSDATE
, last_updated_by = BOM_Rtg_Globals.Get_User_Id
, last_update_login = BOM_Rtg_Globals.Get_Login_Id
, request_id = Fnd_Global.Conc_Request_Id
, program_id = Fnd_Global.Conc_Program_Id
, program_application_id = Fnd_Global.Prog_Appl_Id
, program_update_date = SYSDATE
where operation_sequence_id =
p_op_network_unexp_rec.to_op_seq_id;
' :Inserting Record ' ||
SQLERRM
, x_mesg_token_Tbl => x_mesg_token_tbl
);
END Insert_Row;
* Procedure : Update_Row
* Parameters IN : Operation networker exposed column record
* Operation networker unexposed column record
* Parameters OUT: Message Token Table
* Return Status
* Purpose : Procedure will perfrom an Update into the
* rtg_Bill_Of_Materials table.
*********************************************************************/
PROCEDURE Update_Row
( p_op_network_rec IN Bom_Rtg_Pub.op_network_Rec_Type
, p_op_network_unexp_rec IN Bom_Rtg_Pub.op_network_Unexposed_Rec_Type
, x_mesg_token_Tbl IN OUT NOCOPY Error_Handler.Mesg_Token_Tbl_Type
, x_return_Status IN OUT NOCOPY VARCHAR2
)
IS
p_start_effectivity_date DATE;
UPDATE bom_operation_networks
SET
from_op_seq_id = DECODE(p_op_network_unexp_rec.new_from_op_seq_id,
NULL , p_op_network_unexp_rec.from_op_seq_id,
p_op_network_unexp_rec.new_from_op_seq_id
)
, to_op_seq_id = DECODE(p_op_network_unexp_rec.new_to_op_seq_id,
NULL , p_op_network_unexp_rec.to_op_seq_id,
p_op_network_unexp_rec.new_to_op_seq_id
)
, planning_pct = p_op_network_rec.planning_percent
, transition_type =p_op_network_rec.connection_type
, last_update_date = SYSDATE
, last_updated_by = BOM_Rtg_Globals.Get_User_Id
, last_update_login = BOM_Rtg_Globals.Get_Login_Id
, attribute_category =p_op_network_rec.attribute_category
, attribute1 = p_op_network_rec.attribute1
, attribute2 = p_op_network_rec.attribute2
, attribute3 = p_op_network_rec.attribute3
, attribute4 = p_op_network_rec.attribute4
, attribute5 = p_op_network_rec.attribute5
, attribute6 = p_op_network_rec.attribute6
, attribute7 = p_op_network_rec.attribute7
, attribute8 = p_op_network_rec.attribute8
, attribute9 = p_op_network_rec.attribute9
, attribute10= p_op_network_rec.attribute10
, attribute11= p_op_network_rec.attribute11
, attribute12= p_op_network_rec.attribute12
, attribute13= p_op_network_rec.attribute13
, attribute14= p_op_network_rec.attribute14
, attribute15= p_op_network_rec.attribute15
, original_system_reference = p_op_network_rec.original_system_reference
, request_id = Fnd_Global.Conc_Request_Id
, program_id = Fnd_Global.Conc_Program_Id
, program_application_id = Fnd_Global.Prog_Appl_Id
, program_update_date = SYSDATE
WHERE from_op_seq_id = p_op_network_unexp_rec.from_op_seq_id
AND to_op_seq_id = p_op_network_unexp_rec.to_op_seq_id;
update BOM_OPERATION_SEQUENCES set
X_COORDINATE = p_op_network_rec.From_X_Coordinate
,Y_COORDINATE = p_op_network_rec.From_Y_Coordinate
, last_update_date = SYSDATE
, last_updated_by = BOM_Rtg_Globals.Get_User_Id
, last_update_login = BOM_Rtg_Globals.Get_Login_Id
, request_id = Fnd_Global.Conc_Request_Id
, program_id = Fnd_Global.Conc_Program_Id
, program_application_id = Fnd_Global.Prog_Appl_Id
, program_update_date = SYSDATE
where operation_sequence_id =
DECODE(p_op_network_unexp_rec.new_from_op_seq_id,
NULL , p_op_network_unexp_rec.from_op_seq_id,
p_op_network_unexp_rec.new_from_op_seq_id);
update BOM_OPERATION_SEQUENCES set
X_COORDINATE = p_op_network_rec.To_X_Coordinate
,Y_COORDINATE = p_op_network_rec.To_Y_Coordinate
, last_update_date = SYSDATE
, last_updated_by = BOM_Rtg_Globals.Get_User_Id
, last_update_login = BOM_Rtg_Globals.Get_Login_Id
, request_id = Fnd_Global.Conc_Request_Id
, program_id = Fnd_Global.Conc_Program_Id
, program_application_id = Fnd_Global.Prog_Appl_Id
, program_update_date = SYSDATE
where operation_sequence_id =
DECODE(p_op_network_unexp_rec.new_to_op_seq_id,
NULL , p_op_network_unexp_rec.to_op_seq_id,
p_op_network_unexp_rec.new_to_op_seq_id);
END Update_Row;
* Procedure : Delete_Row
* Parameters IN : Operation networker exposed column record
* Operation networker unexposed column record
* Parameters OUT: Message Token Table
* Return Status
* Purpose : Procedure will perfrom an Delete from the
* rtg_Bill_Of_Materials by creating a delete Group.
*********************************************************************/
PROCEDURE Delete_Row
( p_op_network_rec IN Bom_Rtg_Pub.op_network_Rec_Type
, p_op_network_unexp_rec IN Bom_Rtg_Pub.op_network_Unexposed_Rec_Type
, x_mesg_token_Tbl IN OUT NOCOPY Error_Handler.Mesg_Token_Tbl_Type
, x_return_Status IN OUT NOCOPY VARCHAR2
)
IS
l_op_network_unexp_rec Bom_Rtg_Pub.op_network_Unexposed_Rec_Type := p_op_network_unexp_rec;
Error_Handler.Write_Debug('Delete operation network.'
);
DELETE FROM bom_operation_networks
WHERE from_op_seq_id = p_op_network_unexp_rec.from_op_seq_id
AND to_op_seq_id = p_op_network_unexp_rec.to_op_seq_id;
, p_Message_Text => 'ERROR in Delete Operation Network:'
|| substr(SQLERRM, 1, 100) || ' ' ||
to_char(SQLCODE)
, p_Mesg_Token_Tbl => l_Mesg_Token_Tbl
, x_Mesg_Token_Tbl => x_Mesg_Token_Tbl
);
END Delete_Row;
Insert_Row
( p_op_network_rec => p_op_network_rec
, p_op_network_unexp_rec => p_op_network_unexp_rec
, x_mesg_token_Tbl => l_mesg_token_tbl
, x_return_Status => l_return_status
);
Bom_Rtg_Globals.G_OPR_UPDATE
THEN
Update_Row
( p_op_network_rec => p_op_network_rec
, p_op_network_unexp_rec => p_op_network_unexp_rec
, x_mesg_token_Tbl => l_mesg_token_tbl
, x_return_Status => l_return_status
);
BOM_Rtg_Globals.G_OPR_DELETE
THEN
Delete_Row
( p_op_network_rec => p_op_network_rec
, p_op_network_unexp_rec => p_op_network_unexp_rec
, x_mesg_token_Tbl => l_mesg_token_tbl
, x_return_Status => l_return_status
);
select routing_sequence_id, cfm_routing_flag
into l_routing_sequence_id,l_cfm_routing_flag
from bom_operational_routings where
routing_sequence_id = p_routing_sequence_id;
SELECT common_routing_sequence_id
INTO l_common_routing_sequence_id
FROM bom_operational_routings
WHERE routing_sequence_id = l_routing_sequence_id;
select routing_sequence_id, cfm_routing_flag,
completion_subinventory, completion_locator_id,
assembly_item_id , organization_id
into l_routing_sequence_id,l_cfm_routing_flag,
l_rtg_comp_sub_inv , l_rtg_comp_sub_loc,
l_assembly_item_id , l_org_id
from bom_operational_routings where
routing_sequence_id = p_routing_sequence_id;
SELECT common_routing_sequence_id
INTO l_common_routing_sequence_id
FROM bom_operational_routings
WHERE routing_sequence_id = l_routing_sequence_id;
SELECT wip_supply_subinventory, wip_supply_locator_id
INTO l_item_compl_subinv, l_item_loc_id
FROM mtl_system_items
WHERE organization_id = l_org_id
AND inventory_item_id =l_assembly_item_id;
WSMPUTIL.UPDATE_SUB_LOC ( l_common_routing_sequence_id,
l_rtg_comp_sub_inv,
l_rtg_comp_sub_loc,
err_code ,
err_msg ) ;
SELECT bos.OPERATION_SEQUENCE_ID, bos.DISABLE_DATE
FROM BOM_OPERATION_SEQUENCES bos
WHERE
bos.IMPLEMENTATION_DATE IS NOT NULL
AND bos.OPERATION_SEQ_NUM IN
( SELECT bos_first.OPERATION_SEQ_NUM
FROM
BOM_OPERATION_NETWORKS bon_from,
BOM_OPERATION_NETWORKS bon_to,
BOM_OPERATION_SEQUENCES bos_first
WHERE
bon_from.FROM_OP_SEQ_ID = bos_first.OPERATION_SEQUENCE_ID
AND bon_from.TO_OP_SEQ_ID = bon_to.FROM_OP_SEQ_ID
AND bon_from.FROM_OP_SEQ_ID <> bon_to.FROM_OP_SEQ_ID
AND bos_first.IMPLEMENTATION_DATE IS NOT NULL
AND bos_first.ROUTING_SEQUENCE_ID = c_routing_sequence_id )
AND bos.ROUTING_SEQUENCE_ID = c_routing_sequence_id
ORDER BY bos.EFFECTIVITY_DATE DESC;
SELECT bos.OPERATION_SEQUENCE_ID, bos.DISABLE_DATE
FROM BOM_OPERATION_SEQUENCES bos
WHERE
bos.IMPLEMENTATION_DATE IS NOT NULL
AND bos.OPERATION_SEQ_NUM IN
( SELECT bos_last.OPERATION_SEQ_NUM
FROM
BOM_OPERATION_NETWORKS bon_from,
BOM_OPERATION_NETWORKS bon_to,
BOM_OPERATION_SEQUENCES bos_last
WHERE
bon_to.TO_OP_SEQ_ID = bos_last.OPERATION_SEQUENCE_ID
AND bon_from.TO_OP_SEQ_ID = bon_to.FROM_OP_SEQ_ID
AND bon_to.TO_OP_SEQ_ID <> bon_from.TO_OP_SEQ_ID
AND bos_last.IMPLEMENTATION_DATE IS NOT NULL
AND bos_last.ROUTING_SEQUENCE_ID = c_routing_sequence_id )
AND bos.ROUTING_SEQUENCE_ID = c_routing_sequence_id
ORDER BY bos.EFFECTIVITY_DATE DESC;
SELECT BOM_OPERATION_SEQUENCES_S.NEXTVAL
INTO l_op_seq_id
FROM DUAL;
INSERT INTO BOM_OPERATION_SEQUENCES
(
OPERATION_SEQUENCE_ID,
ROUTING_SEQUENCE_ID,
OPERATION_SEQ_NUM,
LAST_UPDATE_DATE,
LAST_UPDATED_BY,
CREATION_DATE,
CREATED_BY,
LAST_UPDATE_LOGIN,
STANDARD_OPERATION_ID,
DEPARTMENT_ID,
OPERATION_LEAD_TIME_PERCENT,
MINIMUM_TRANSFER_QUANTITY,
COUNT_POINT_TYPE,
OPERATION_DESCRIPTION,
EFFECTIVITY_DATE,
DISABLE_DATE,
BACKFLUSH_FLAG,
OPTION_DEPENDENT_FLAG,
ATTRIBUTE_CATEGORY,
ATTRIBUTE1,
ATTRIBUTE2,
ATTRIBUTE3,
ATTRIBUTE4,
ATTRIBUTE5,
ATTRIBUTE6,
ATTRIBUTE7,
ATTRIBUTE8,
ATTRIBUTE9,
ATTRIBUTE10,
ATTRIBUTE11,
ATTRIBUTE12,
ATTRIBUTE13,
ATTRIBUTE14,
ATTRIBUTE15,
REQUEST_ID,
PROGRAM_APPLICATION_ID,
PROGRAM_ID,
PROGRAM_UPDATE_DATE,
OPERATION_TYPE,
REFERENCE_FLAG,
PROCESS_OP_SEQ_ID,
LINE_OP_SEQ_ID,
YIELD,
CUMULATIVE_YIELD,
REVERSE_CUMULATIVE_YIELD,
LABOR_TIME_CALC,
MACHINE_TIME_CALC,
TOTAL_TIME_CALC,
LABOR_TIME_USER,
MACHINE_TIME_USER,
TOTAL_TIME_USER,
NET_PLANNING_PERCENT,
INCLUDE_IN_ROLLUP,
OPERATION_YIELD_ENABLED,
CHANGE_NOTICE,
IMPLEMENTATION_DATE,
SHUTDOWN_TYPE,
LONG_DESCRIPTION,
LOWEST_ACCEPTABLE_YIELD,
USE_ORG_SETTINGS,
QUEUE_MANDATORY_FLAG,
RUN_MANDATORY_FLAG,
TO_MOVE_MANDATORY_FLAG,
SHOW_NEXT_OP_BY_DEFAULT,
SHOW_SCRAP_CODE,
SHOW_LOT_ATTRIB,
TRACK_MULTIPLE_RES_USAGE_DATES
)
SELECT
l_op_seq_id,
BOS.ROUTING_SEQUENCE_ID,
BOS.OPERATION_SEQ_NUM,
SYSDATE, --LAST_UPDATE_DATE
BOM_Rtg_Globals.Get_User_Id, --LAST_UPDATED_BY
SYSDATE, --CREATION_DATE
BOM_Rtg_Globals.Get_User_Id, --CREATED_BY
BOM_Rtg_Globals.Get_Login_Id, --LAST_UPDATE_LOGIN
BOS.STANDARD_OPERATION_ID,
BOS.DEPARTMENT_ID,
BOS.OPERATION_LEAD_TIME_PERCENT,
BOS.MINIMUM_TRANSFER_QUANTITY,
BOS.COUNT_POINT_TYPE,
BOS.OPERATION_DESCRIPTION,
BOS.DISABLE_DATE + (1/86400), -- EFFECTIVITY_DATE
NULL, -- DISABLE_DATE
BOS.BACKFLUSH_FLAG,
BOS.OPTION_DEPENDENT_FLAG,
BOS.ATTRIBUTE_CATEGORY,
BOS.ATTRIBUTE1,
BOS.ATTRIBUTE2,
BOS.ATTRIBUTE3,
BOS.ATTRIBUTE4,
BOS.ATTRIBUTE5,
BOS.ATTRIBUTE6,
BOS.ATTRIBUTE7,
BOS.ATTRIBUTE8,
BOS.ATTRIBUTE9,
BOS.ATTRIBUTE10,
BOS.ATTRIBUTE11,
BOS.ATTRIBUTE12,
BOS.ATTRIBUTE13,
BOS.ATTRIBUTE14,
BOS.ATTRIBUTE15,
BOM_Rtg_Globals.Get_Request_Id,
BOM_Rtg_Globals.Get_Prog_AppId,
BOM_Rtg_Globals.Get_Prog_Id,
SYSDATE, --PROGRAM_UPDATE_DATE
DECODE(BOS.OPERATION_TYPE, 4, 1, BOS.OPERATION_TYPE),
BOS.REFERENCE_FLAG,
BOS.PROCESS_OP_SEQ_ID,
BOS.LINE_OP_SEQ_ID,
BOS.YIELD,
BOS.CUMULATIVE_YIELD,
BOS.REVERSE_CUMULATIVE_YIELD,
BOS.LABOR_TIME_CALC,
BOS.MACHINE_TIME_CALC,
BOS.TOTAL_TIME_CALC,
BOS.LABOR_TIME_USER,
BOS.MACHINE_TIME_USER,
BOS.TOTAL_TIME_USER,
BOS.NET_PLANNING_PERCENT,
BOS.INCLUDE_IN_ROLLUP,
BOS.OPERATION_YIELD_ENABLED,
BOS.CHANGE_NOTICE,
SYSDATE,--IMPLEMENTATION_DATE
BOS.SHUTDOWN_TYPE,
BOS.LONG_DESCRIPTION,
BOS.LOWEST_ACCEPTABLE_YIELD,
BOS.USE_ORG_SETTINGS,
BOS.QUEUE_MANDATORY_FLAG,
BOS.RUN_MANDATORY_FLAG,
BOS.TO_MOVE_MANDATORY_FLAG,
BOS.SHOW_NEXT_OP_BY_DEFAULT,
BOS.SHOW_SCRAP_CODE,
BOS.SHOW_LOT_ATTRIB,
BOS.TRACK_MULTIPLE_RES_USAGE_DATES
FROM
BOM_OPERATION_SEQUENCES BOS
WHERE
BOS.OPERATION_SEQUENCE_ID = p_operation_sequence_id;
INSERT INTO BOM_OPERATION_RESOURCES
(
OPERATION_SEQUENCE_ID,
RESOURCE_SEQ_NUM,
RESOURCE_ID,
ACTIVITY_ID,
STANDARD_RATE_FLAG,
ASSIGNED_UNITS,
USAGE_RATE_OR_AMOUNT,
USAGE_RATE_OR_AMOUNT_INVERSE,
BASIS_TYPE,
SCHEDULE_FLAG,
LAST_UPDATE_DATE,
LAST_UPDATED_BY,
CREATION_DATE,
CREATED_BY,
LAST_UPDATE_LOGIN,
RESOURCE_OFFSET_PERCENT,
AUTOCHARGE_TYPE,
ATTRIBUTE_CATEGORY,
ATTRIBUTE1,
ATTRIBUTE2,
ATTRIBUTE3,
ATTRIBUTE4,
ATTRIBUTE5,
ATTRIBUTE6,
ATTRIBUTE7,
ATTRIBUTE8,
ATTRIBUTE9,
ATTRIBUTE10,
ATTRIBUTE11,
ATTRIBUTE12,
ATTRIBUTE13,
ATTRIBUTE14,
ATTRIBUTE15,
REQUEST_ID,
PROGRAM_APPLICATION_ID,
PROGRAM_ID,
PROGRAM_UPDATE_DATE,
SCHEDULE_SEQ_NUM,
SUBSTITUTE_GROUP_NUM,
PRINCIPLE_FLAG,
SETUP_ID,
CHANGE_NOTICE,
ACD_TYPE,
ORIGINAL_SYSTEM_REFERENCE
)
SELECT
l_op_seq_id,
BOR.RESOURCE_SEQ_NUM,
BOR.RESOURCE_ID,
BOR.ACTIVITY_ID,
BOR.STANDARD_RATE_FLAG,
BOR.ASSIGNED_UNITS,
BOR.USAGE_RATE_OR_AMOUNT,
BOR.USAGE_RATE_OR_AMOUNT_INVERSE,
BOR.BASIS_TYPE,
BOR.SCHEDULE_FLAG,
SYSDATE, --LAST_UPDATE_DATE,
BOM_Rtg_Globals.Get_User_Id, --LAST_UPDATED_BY
SYSDATE, --CREATION_DATE
BOM_Rtg_Globals.Get_User_Id, --CREATED_BY
BOM_Rtg_Globals.Get_Login_Id, --LAST_UPDATE_LOGIN
BOR.RESOURCE_OFFSET_PERCENT,
BOR.AUTOCHARGE_TYPE,
BOR.ATTRIBUTE_CATEGORY,
BOR.ATTRIBUTE1,
BOR.ATTRIBUTE2,
BOR.ATTRIBUTE3,
BOR.ATTRIBUTE4,
BOR.ATTRIBUTE5,
BOR.ATTRIBUTE6,
BOR.ATTRIBUTE7,
BOR.ATTRIBUTE8,
BOR.ATTRIBUTE9,
BOR.ATTRIBUTE10,
BOR.ATTRIBUTE11,
BOR.ATTRIBUTE12,
BOR.ATTRIBUTE13,
BOR.ATTRIBUTE14,
BOR.ATTRIBUTE15,
BOM_Rtg_Globals.Get_Request_Id,
BOM_Rtg_Globals.Get_Prog_AppId,
BOM_Rtg_Globals.Get_Prog_Id,
SYSDATE, --PROGRAM_UPDATE_DATE
BOR.SCHEDULE_SEQ_NUM,
BOR.SUBSTITUTE_GROUP_NUM,
BOR.PRINCIPLE_FLAG,
BOR.SETUP_ID,
BOR.CHANGE_NOTICE,
BOR.ACD_TYPE,
BOR.ORIGINAL_SYSTEM_REFERENCE
FROM
BOM_OPERATION_RESOURCES BOR
WHERE
BOR.OPERATION_SEQUENCE_ID = p_operation_sequence_id;
INSERT INTO BOM_SUB_OPERATION_RESOURCES
(
OPERATION_SEQUENCE_ID,
SUBSTITUTE_GROUP_NUM,
RESOURCE_ID,
SCHEDULE_SEQ_NUM,
REPLACEMENT_GROUP_NUM,
ACTIVITY_ID,
STANDARD_RATE_FLAG,
ASSIGNED_UNITS,
USAGE_RATE_OR_AMOUNT,
USAGE_RATE_OR_AMOUNT_INVERSE,
BASIS_TYPE,
SCHEDULE_FLAG,
LAST_UPDATE_DATE,
LAST_UPDATED_BY,
CREATION_DATE,
CREATED_BY,
LAST_UPDATE_LOGIN,
RESOURCE_OFFSET_PERCENT,
AUTOCHARGE_TYPE,
ATTRIBUTE_CATEGORY,
REQUEST_ID,
PROGRAM_APPLICATION_ID,
PROGRAM_ID,
PROGRAM_UPDATE_DATE,
ATTRIBUTE1,
ATTRIBUTE2,
ATTRIBUTE3,
ATTRIBUTE4,
ATTRIBUTE5,
ATTRIBUTE6,
ATTRIBUTE7,
ATTRIBUTE8,
ATTRIBUTE9,
ATTRIBUTE10,
ATTRIBUTE11,
ATTRIBUTE12,
ATTRIBUTE13,
ATTRIBUTE14,
ATTRIBUTE15,
PRINCIPLE_FLAG,
SETUP_ID,
CHANGE_NOTICE,
ACD_TYPE,
ORIGINAL_SYSTEM_REFERENCE
)
SELECT
l_op_seq_id,
BSOR.SUBSTITUTE_GROUP_NUM,
BSOR.RESOURCE_ID,
BSOR.SCHEDULE_SEQ_NUM,
BSOR.REPLACEMENT_GROUP_NUM,
BSOR.ACTIVITY_ID,
BSOR.STANDARD_RATE_FLAG,
BSOR.ASSIGNED_UNITS,
BSOR.USAGE_RATE_OR_AMOUNT,
BSOR.USAGE_RATE_OR_AMOUNT_INVERSE,
BSOR.BASIS_TYPE,
BSOR.SCHEDULE_FLAG,
SYSDATE, --LAST_UPDATE_DATE,
BOM_Rtg_Globals.Get_User_Id, --LAST_UPDATED_BY
SYSDATE, --CREATION_DATE
BOM_Rtg_Globals.Get_User_Id, --CREATED_BY
BOM_Rtg_Globals.Get_Login_Id, --LAST_UPDATE_LOGIN
BSOR.RESOURCE_OFFSET_PERCENT,
BSOR.AUTOCHARGE_TYPE,
BSOR.ATTRIBUTE_CATEGORY,
BOM_Rtg_Globals.Get_Request_Id,
BOM_Rtg_Globals.Get_Prog_AppId,
BOM_Rtg_Globals.Get_Prog_Id,
SYSDATE, --PROGRAM_UPDATE_DATE
BSOR.ATTRIBUTE1,
BSOR.ATTRIBUTE2,
BSOR.ATTRIBUTE3,
BSOR.ATTRIBUTE4,
BSOR.ATTRIBUTE5,
BSOR.ATTRIBUTE6,
BSOR.ATTRIBUTE7,
BSOR.ATTRIBUTE8,
BSOR.ATTRIBUTE9,
BSOR.ATTRIBUTE10,
BSOR.ATTRIBUTE11,
BSOR.ATTRIBUTE12,
BSOR.ATTRIBUTE13,
BSOR.ATTRIBUTE14,
BSOR.ATTRIBUTE15,
BSOR.PRINCIPLE_FLAG,
BSOR.SETUP_ID,
BSOR.CHANGE_NOTICE,
BSOR.ACD_TYPE,
BSOR.ORIGINAL_SYSTEM_REFERENCE
FROM
BOM_SUB_OPERATION_RESOURCES BSOR
WHERE
BSOR.OPERATION_SEQUENCE_ID = p_operation_sequence_id;