[Home] [Help]
The following lines contain the word 'select', 'insert', 'update' or 'delete':
PROCEDURE Insert_Row(X_Rowid IN OUT NOCOPY VARCHAR2,
X_Standard_Operation_Id IN OUT NOCOPY NUMBER,
X_Operation_Code VARCHAR2,
X_Operation_Type NUMBER,
X_Line_Id NUMBER DEFAULT NULL,
X_Sequence_Num NUMBER DEFAULT NULL,
X_Organization_Id NUMBER,
X_Department_Id NUMBER,
X_Last_Update_Date DATE,
X_Last_Updated_By NUMBER,
X_Creation_Date DATE,
X_Created_By NUMBER,
X_Last_Update_Login NUMBER DEFAULT NULL,
X_Minimum_Transfer_Quantity NUMBER DEFAULT NULL,
X_Count_Point_Type NUMBER DEFAULT NULL,
X_Operation_Description VARCHAR2 DEFAULT NULL,
X_Option_Dependent_Flag NUMBER DEFAULT NULL,
X_Attribute_Category VARCHAR2 DEFAULT NULL,
X_Attribute1 VARCHAR2 DEFAULT NULL,
X_Attribute2 VARCHAR2 DEFAULT NULL,
X_Attribute3 VARCHAR2 DEFAULT NULL,
X_Attribute4 VARCHAR2 DEFAULT NULL,
X_Attribute5 VARCHAR2 DEFAULT NULL,
X_Attribute6 VARCHAR2 DEFAULT NULL,
X_Attribute7 VARCHAR2 DEFAULT NULL,
X_Attribute8 VARCHAR2 DEFAULT NULL,
X_Attribute9 VARCHAR2 DEFAULT NULL,
X_Attribute10 VARCHAR2 DEFAULT NULL,
X_Attribute11 VARCHAR2 DEFAULT NULL,
X_Attribute12 VARCHAR2 DEFAULT NULL,
X_Attribute13 VARCHAR2 DEFAULT NULL,
X_Attribute14 VARCHAR2 DEFAULT NULL,
X_Attribute15 VARCHAR2 DEFAULT NULL,
X_Backflush_Flag NUMBER DEFAULT NULL,
X_Wms_Task_Type NUMBER DEFAULT NULL,
X_Yield NUMBER DEFAULT NULL,
X_Operation_Yield_Enabled NUMBER DEFAULT NULL,
X_Shutdown_Type VARCHAR2 DEFAULT NULL
) IS
CURSOR C IS SELECT rowid FROM BOM_STANDARD_OPERATIONS
WHERE standard_operation_id = X_Standard_Operation_Id;
CURSOR C2 IS SELECT bom_standard_operations_s.nextval FROM sys.dual;
INSERT INTO BOM_STANDARD_OPERATIONS(
standard_operation_id,
operation_code,
operation_type,
line_id,
sequence_num,
organization_id,
department_id,
last_update_date,
last_updated_by,
creation_date,
created_by,
last_update_login,
minimum_transfer_quantity,
count_point_type,
operation_description,
option_dependent_flag,
attribute_category,
attribute1,
attribute2,
attribute3,
attribute4,
attribute5,
attribute6,
attribute7,
attribute8,
attribute9,
attribute10,
attribute11,
attribute12,
attribute13,
attribute14,
attribute15,
backflush_flag,
wms_task_type,
yield,
operation_yield_enabled,
shutdown_type
) VALUES (
X_Standard_Operation_Id,
X_Operation_Code,
X_Operation_Type,
X_Line_Id,
X_Sequence_Num,
X_Organization_Id,
X_Department_Id,
X_Last_Update_Date,
X_Last_Updated_By,
X_Creation_Date,
X_Created_By,
X_Last_Update_Login,
X_Minimum_Transfer_Quantity,
X_Count_Point_Type,
X_Operation_Description,
X_Option_Dependent_Flag,
X_Attribute_Category,
X_Attribute1,
X_Attribute2,
X_Attribute3,
X_Attribute4,
X_Attribute5,
X_Attribute6,
X_Attribute7,
X_Attribute8,
X_Attribute9,
X_Attribute10,
X_Attribute11,
X_Attribute12,
X_Attribute13,
X_Attribute14,
X_Attribute15,
X_Backflush_Flag,
X_Wms_Task_Type,
X_Yield,
X_Operation_Yield_Enabled,
X_Shutdown_Type
);
END Insert_Row;
PROCEDURE Insert_Row(X_Rowid IN OUT NOCOPY VARCHAR2,
X_Standard_Operation_Id IN OUT NOCOPY NUMBER,
X_Operation_Code VARCHAR2,
X_Operation_Type NUMBER,
X_Line_Id NUMBER DEFAULT NULL,
X_Sequence_Num NUMBER DEFAULT NULL,
X_Organization_Id NUMBER,
X_Department_Id NUMBER,
X_Last_Update_Date DATE,
X_Last_Updated_By NUMBER,
X_Creation_Date DATE,
X_Created_By NUMBER,
X_Last_Update_Login NUMBER DEFAULT NULL,
X_Minimum_Transfer_Quantity NUMBER DEFAULT NULL,
X_Count_Point_Type NUMBER DEFAULT NULL,
X_Operation_Description VARCHAR2 DEFAULT NULL,
X_Option_Dependent_Flag NUMBER DEFAULT NULL,
X_Attribute_Category VARCHAR2 DEFAULT NULL,
X_Attribute1 VARCHAR2 DEFAULT NULL,
X_Attribute2 VARCHAR2 DEFAULT NULL,
X_Attribute3 VARCHAR2 DEFAULT NULL,
X_Attribute4 VARCHAR2 DEFAULT NULL,
X_Attribute5 VARCHAR2 DEFAULT NULL,
X_Attribute6 VARCHAR2 DEFAULT NULL,
X_Attribute7 VARCHAR2 DEFAULT NULL,
X_Attribute8 VARCHAR2 DEFAULT NULL,
X_Attribute9 VARCHAR2 DEFAULT NULL,
X_Attribute10 VARCHAR2 DEFAULT NULL,
X_Attribute11 VARCHAR2 DEFAULT NULL,
X_Attribute12 VARCHAR2 DEFAULT NULL,
X_Attribute13 VARCHAR2 DEFAULT NULL,
X_Attribute14 VARCHAR2 DEFAULT NULL,
X_Attribute15 VARCHAR2 DEFAULT NULL,
X_Backflush_Flag NUMBER DEFAULT NULL,
X_Wms_Task_Type NUMBER DEFAULT NULL,
X_Yield NUMBER DEFAULT NULL,
X_Operation_Yield_Enabled NUMBER DEFAULT NULL,
X_Shutdown_Type VARCHAR2 DEFAULT NULL,
X_Default_SubInventory VARCHAR2,
X_Default_Locator_Id NUMBER,
X_Value_added VARCHAR2 DEFAULT NULL,
X_Critical_To_Quality VARCHAR2 DEFAULT NULL
) IS
BEGIN
Insert_Row(
X_Rowid => X_Rowid,
X_Operation_type => X_Operation_type,
X_Line_Id => X_Line_Id,
X_Sequence_Num => X_Sequence_Num,
X_Standard_Operation_Id => X_Standard_Operation_Id,
X_Operation_Code => X_Operation_Code,
X_Organization_Id => X_Organization_Id,
X_Department_Id => X_Department_Id,
X_Last_Update_Date => X_Last_Update_Date,
X_Last_Updated_By => X_Last_Updated_By,
X_Creation_Date => X_Creation_Date,
X_Created_By => X_Created_By,
X_Last_Update_Login => X_Last_Update_Login,
X_Minimum_Transfer_Quantity => X_Minimum_Transfer_Quantity,
X_Count_Point_Type => X_Count_Point_Type,
X_Operation_Description => X_Operation_Description,
X_Option_Dependent_Flag => X_Option_Dependent_Flag,
X_Attribute_Category => X_Attribute_Category,
X_Attribute1 => X_Attribute1,
X_Attribute2 => X_Attribute2,
X_Attribute3 => X_Attribute3,
X_Attribute4 => X_Attribute4,
X_Attribute5 => X_Attribute5,
X_Attribute6 => X_Attribute6,
X_Attribute7 => X_Attribute7,
X_Attribute8 => X_Attribute8,
X_Attribute9 => X_Attribute9,
X_Attribute10 => X_Attribute10,
X_Attribute11 => X_Attribute11,
X_Attribute12 => X_Attribute12,
X_Attribute13 => X_Attribute13,
X_Attribute14 => X_Attribute14,
X_Attribute15 => X_Attribute15,
X_Backflush_Flag => X_Backflush_Flag,
X_Wms_Task_Type => X_Wms_Task_Type,
X_Yield => X_Yield,
X_Operation_Yield_Enabled => X_Operation_Yield_Enabled,
X_Shutdown_Type => X_Shutdown_Type,
X_Default_Subinventory => X_Default_Subinventory,
X_Default_locator_id => X_Default_locator_id,
X_value_added => X_value_added,
X_Critical_To_Quality => X_Critical_To_Quality,
X_Lowest_Acceptable_Yield => NULL,
X_Use_Org_Settings => NULL,
X_Queue_Mandatory_Flag => NULL,
X_Run_Mandatory_Flag => NULL,
X_To_Move_Mandatory_Flag => NULL,
X_Show_Next_Op_By_Default => NULL,
X_Show_Scrap_Code => NULL,
X_Show_Lot_Attrib => NULL,
X_Track_Multiple_Res_Usage_Dts => NULL);
END Insert_Row;
PROCEDURE Insert_Row(X_Rowid IN OUT NOCOPY VARCHAR2,
X_Standard_Operation_Id IN OUT NOCOPY NUMBER,
X_Operation_Code VARCHAR2,
X_Operation_Type NUMBER,
X_Line_Id NUMBER DEFAULT NULL,
X_Sequence_Num NUMBER DEFAULT NULL,
X_Organization_Id NUMBER,
X_Department_Id NUMBER,
X_Last_Update_Date DATE,
X_Last_Updated_By NUMBER,
X_Creation_Date DATE,
X_Created_By NUMBER,
X_Last_Update_Login NUMBER DEFAULT NULL,
X_Minimum_Transfer_Quantity NUMBER DEFAULT NULL,
X_Count_Point_Type NUMBER DEFAULT NULL,
X_Operation_Description VARCHAR2 DEFAULT NULL,
X_Option_Dependent_Flag NUMBER DEFAULT NULL,
X_Attribute_Category VARCHAR2 DEFAULT NULL,
X_Attribute1 VARCHAR2 DEFAULT NULL,
X_Attribute2 VARCHAR2 DEFAULT NULL,
X_Attribute3 VARCHAR2 DEFAULT NULL,
X_Attribute4 VARCHAR2 DEFAULT NULL,
X_Attribute5 VARCHAR2 DEFAULT NULL,
X_Attribute6 VARCHAR2 DEFAULT NULL,
X_Attribute7 VARCHAR2 DEFAULT NULL,
X_Attribute8 VARCHAR2 DEFAULT NULL,
X_Attribute9 VARCHAR2 DEFAULT NULL,
X_Attribute10 VARCHAR2 DEFAULT NULL,
X_Attribute11 VARCHAR2 DEFAULT NULL,
X_Attribute12 VARCHAR2 DEFAULT NULL,
X_Attribute13 VARCHAR2 DEFAULT NULL,
X_Attribute14 VARCHAR2 DEFAULT NULL,
X_Attribute15 VARCHAR2 DEFAULT NULL,
X_Backflush_Flag NUMBER DEFAULT NULL,
X_Wms_Task_Type NUMBER DEFAULT NULL,
X_Yield NUMBER DEFAULT NULL,
X_Operation_Yield_Enabled NUMBER DEFAULT NULL,
X_Shutdown_Type VARCHAR2 DEFAULT NULL,
X_Default_SubInventory VARCHAR2,
X_Default_Locator_Id NUMBER,
X_Value_added VARCHAR2 DEFAULT NULL,
X_Critical_To_Quality VARCHAR2 DEFAULT NULL,
--OSFM-MES:Following new arguments are added
X_LOWEST_ACCEPTABLE_YIELD NUMBER,
X_USE_ORG_SETTINGS NUMBER,
X_QUEUE_MANDATORY_FLAG NUMBER,
X_RUN_MANDATORY_FLAG NUMBER,
X_TO_MOVE_MANDATORY_FLAG NUMBER,
X_SHOW_NEXT_OP_BY_DEFAULT NUMBER,
X_SHOW_SCRAP_CODE NUMBER,
X_SHOW_LOT_ATTRIB NUMBER,
X_TRACK_MULTIPLE_RES_USAGE_DTS NUMBER,
-- Added for labor skills validation project
X_CHECK_SKILL NUMBER DEFAULT NULL
) IS
CURSOR C IS SELECT rowid FROM BOM_STANDARD_OPERATIONS
WHERE standard_operation_id = X_Standard_Operation_Id;
CURSOR C2 IS SELECT bom_standard_operations_s.nextval FROM sys.dual;
INSERT INTO BOM_STANDARD_OPERATIONS(
standard_operation_id,
operation_code,
operation_type,
line_id,
sequence_num,
organization_id,
department_id,
last_update_date,
last_updated_by,
creation_date,
created_by,
last_update_login,
minimum_transfer_quantity,
count_point_type,
operation_description,
option_dependent_flag,
attribute_category,
attribute1,
attribute2,
attribute3,
attribute4,
attribute5,
attribute6,
attribute7,
attribute8,
attribute9,
attribute10,
attribute11,
attribute12,
attribute13,
attribute14,
attribute15,
backflush_flag,
wms_task_type,
yield,
operation_yield_enabled,
shutdown_type,
default_subinventory,
default_locator_id,
value_added,
critical_to_quality,
--OSFM-MES:Following new Colunbs are added
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,
-- Added for labor skills validation project
CHECK_SKILL
) VALUES (
X_Standard_Operation_Id,
X_Operation_Code,
X_Operation_Type,
X_Line_Id,
X_Sequence_Num,
X_Organization_Id,
X_Department_Id,
X_Last_Update_Date,
X_Last_Updated_By,
X_Creation_Date,
X_Created_By,
X_Last_Update_Login,
X_Minimum_Transfer_Quantity,
X_Count_Point_Type,
X_Operation_Description,
X_Option_Dependent_Flag,
X_Attribute_Category,
X_Attribute1,
X_Attribute2,
X_Attribute3,
X_Attribute4,
X_Attribute5,
X_Attribute6,
X_Attribute7,
X_Attribute8,
X_Attribute9,
X_Attribute10,
X_Attribute11,
X_Attribute12,
X_Attribute13,
X_Attribute14,
X_Attribute15,
X_Backflush_Flag,
X_Wms_Task_Type,
X_Yield,
X_Operation_Yield_Enabled,
X_Shutdown_Type,
X_Default_SubInventory,
X_Default_Locator_Id,
X_Value_added,
X_Critical_to_Quality,
--OSFM-MES:Following new Colunbs are added
X_LOWEST_ACCEPTABLE_YIELD,
X_USE_ORG_SETTINGS,
X_QUEUE_MANDATORY_FLAG,
X_RUN_MANDATORY_FLAG ,
X_TO_MOVE_MANDATORY_FLAG ,
X_SHOW_NEXT_OP_BY_DEFAULT,
X_SHOW_SCRAP_CODE ,
X_SHOW_LOT_ATTRIB ,
X_TRACK_MULTIPLE_RES_USAGE_DTS,
-- Added for labor skills validation project
X_CHECK_SKILL
);
END Insert_Row;
SELECT *
FROM BOM_STANDARD_OPERATIONS
WHERE rowid = X_Rowid
FOR UPDATE of Standard_Operation_Id NOWAIT;
FND_MESSAGE.SET_NAME('FND', 'FORM_RECORD_DELETED');
SELECT *
FROM BOM_STANDARD_OPERATIONS
WHERE rowid = X_Rowid
FOR UPDATE of Standard_Operation_Id NOWAIT;
FND_MESSAGE.SET_NAME('FND', 'FORM_RECORD_DELETED');
PROCEDURE Update_Row(X_Rowid VARCHAR2,
X_Standard_Operation_Id NUMBER,
X_Operation_Code VARCHAR2,
X_Operation_Type NUMBER,
X_Line_Id NUMBER DEFAULT NULL,
X_Sequence_Num NUMBER DEFAULT NULL,
X_Organization_Id NUMBER,
X_Department_Id NUMBER,
X_Last_Update_Date DATE,
X_Last_Updated_By NUMBER,
X_Last_Update_Login NUMBER DEFAULT NULL,
X_Minimum_Transfer_Quantity NUMBER DEFAULT NULL,
X_Count_Point_Type NUMBER DEFAULT NULL,
X_Operation_Description VARCHAR2 DEFAULT NULL,
X_Option_Dependent_Flag NUMBER DEFAULT NULL,
X_Attribute_Category VARCHAR2 DEFAULT NULL,
X_Attribute1 VARCHAR2 DEFAULT NULL,
X_Attribute2 VARCHAR2 DEFAULT NULL,
X_Attribute3 VARCHAR2 DEFAULT NULL,
X_Attribute4 VARCHAR2 DEFAULT NULL,
X_Attribute5 VARCHAR2 DEFAULT NULL,
X_Attribute6 VARCHAR2 DEFAULT NULL,
X_Attribute7 VARCHAR2 DEFAULT NULL,
X_Attribute8 VARCHAR2 DEFAULT NULL,
X_Attribute9 VARCHAR2 DEFAULT NULL,
X_Attribute10 VARCHAR2 DEFAULT NULL,
X_Attribute11 VARCHAR2 DEFAULT NULL,
X_Attribute12 VARCHAR2 DEFAULT NULL,
X_Attribute13 VARCHAR2 DEFAULT NULL,
X_Attribute14 VARCHAR2 DEFAULT NULL,
X_Attribute15 VARCHAR2 DEFAULT NULL,
X_Backflush_Flag NUMBER DEFAULT NULL,
X_Wms_Task_Type NUMBER DEFAULT NULL,
X_Yield NUMBER DEFAULT NULL,
X_Operation_Yield_Enabled NUMBER DEFAULT NULL,
X_Shutdown_Type VARCHAR2 DEFAULT NULL
) IS
BEGIN
UPDATE BOM_STANDARD_OPERATIONS
SET
standard_operation_id = X_Standard_Operation_Id,
operation_code = X_Operation_Code,
operation_type = X_Operation_Type,
line_id = X_Line_Id,
sequence_num = X_Sequence_Num,
organization_id = X_Organization_Id,
department_id = X_Department_Id,
last_update_date = X_Last_Update_Date,
last_updated_by = X_Last_Updated_By,
last_update_login = X_Last_Update_Login,
minimum_transfer_quantity = X_Minimum_Transfer_Quantity,
count_point_type = X_Count_Point_Type,
operation_description = X_Operation_Description,
option_dependent_flag = X_Option_Dependent_Flag,
attribute_category = X_Attribute_Category,
attribute1 = X_Attribute1,
attribute2 = X_Attribute2,
attribute3 = X_Attribute3,
attribute4 = X_Attribute4,
attribute5 = X_Attribute5,
attribute6 = X_Attribute6,
attribute7 = X_Attribute7,
attribute8 = X_Attribute8,
attribute9 = X_Attribute9,
attribute10 = X_Attribute10,
attribute11 = X_Attribute11,
attribute12 = X_Attribute12,
attribute13 = X_Attribute13,
attribute14 = X_Attribute14,
attribute15 = X_Attribute15,
backflush_flag = X_Backflush_Flag,
wms_task_type = X_Wms_Task_Type,
yield = X_Yield,
operation_yield_enabled = X_Operation_Yield_Enabled,
shutdown_type = X_Shutdown_Type
WHERE rowid = X_rowid;
END Update_Row;
PROCEDURE Update_Row(X_Rowid VARCHAR2,
X_Standard_Operation_Id NUMBER,
X_Operation_Code VARCHAR2,
X_Operation_Type NUMBER,
X_Line_Id NUMBER DEFAULT NULL,
X_Sequence_Num NUMBER DEFAULT NULL,
X_Organization_Id NUMBER,
X_Department_Id NUMBER,
X_Last_Update_Date DATE,
X_Last_Updated_By NUMBER,
X_Last_Update_Login NUMBER DEFAULT NULL,
X_Minimum_Transfer_Quantity NUMBER DEFAULT NULL,
X_Count_Point_Type NUMBER DEFAULT NULL,
X_Operation_Description VARCHAR2 DEFAULT NULL,
X_Option_Dependent_Flag NUMBER DEFAULT NULL,
X_Attribute_Category VARCHAR2 DEFAULT NULL,
X_Attribute1 VARCHAR2 DEFAULT NULL,
X_Attribute2 VARCHAR2 DEFAULT NULL,
X_Attribute3 VARCHAR2 DEFAULT NULL,
X_Attribute4 VARCHAR2 DEFAULT NULL,
X_Attribute5 VARCHAR2 DEFAULT NULL,
X_Attribute6 VARCHAR2 DEFAULT NULL,
X_Attribute7 VARCHAR2 DEFAULT NULL,
X_Attribute8 VARCHAR2 DEFAULT NULL,
X_Attribute9 VARCHAR2 DEFAULT NULL,
X_Attribute10 VARCHAR2 DEFAULT NULL,
X_Attribute11 VARCHAR2 DEFAULT NULL,
X_Attribute12 VARCHAR2 DEFAULT NULL,
X_Attribute13 VARCHAR2 DEFAULT NULL,
X_Attribute14 VARCHAR2 DEFAULT NULL,
X_Attribute15 VARCHAR2 DEFAULT NULL,
X_Backflush_Flag NUMBER DEFAULT NULL,
X_Wms_Task_Type NUMBER DEFAULT NULL,
X_Yield NUMBER DEFAULT NULL,
X_Operation_Yield_Enabled NUMBER DEFAULT NULL,
X_Shutdown_Type VARCHAR2 DEFAULT NULL,
X_Default_SubInventory VARCHAR2,
X_Default_Locator_Id NUMBER,
X_Value_added VARCHAR2 DEFAULT NULL,
X_Critical_To_quality VARCHAR2 DEFAULT NULL
) IS
BEGIN
Update_Row(
X_Rowid => X_Rowid,
X_Standard_Operation_Id => X_Standard_Operation_Id,
X_Operation_Code => X_Operation_Code,
X_Operation_Type => X_Operation_Type,
X_Line_Id => X_Line_Id,
X_Sequence_Num => X_Sequence_Num,
X_Organization_Id => X_Organization_Id ,
X_Department_Id => X_Department_Id ,
X_Last_Update_Date => X_Last_Update_Date ,
X_Last_Updated_By => X_Last_Updated_By ,
X_Last_Update_Login => X_Last_Update_Login ,
X_Minimum_Transfer_Quantity => X_Minimum_Transfer_Quantity,
X_Count_Point_Type => X_Count_Point_Type ,
X_Operation_Description => X_Operation_Description ,
X_Option_Dependent_Flag => X_Option_Dependent_Flag ,
X_Attribute_Category => X_Attribute_Category,
X_Attribute1 => X_Attribute1,
X_Attribute2 => X_Attribute2,
X_Attribute3 => X_Attribute3,
X_Attribute4 => X_Attribute4,
X_Attribute5 => X_Attribute5,
X_Attribute6 => X_Attribute6,
X_Attribute7 => X_Attribute7,
X_Attribute8 => X_Attribute8,
X_Attribute9 => X_Attribute9,
X_Attribute10 => X_Attribute10,
X_Attribute11 => X_Attribute11,
X_Attribute12 => X_Attribute12,
X_Attribute13 => X_Attribute13,
X_Attribute14 => X_Attribute14,
X_Attribute15 => X_Attribute15,
X_Backflush_Flag => X_Backflush_Flag,
X_Wms_Task_Type => X_Wms_Task_Type,
X_Yield => X_Yield,
X_Operation_Yield_Enabled => X_Operation_Yield_Enabled,
X_Shutdown_Type => X_Shutdown_Type,
X_Default_SubInventory => X_Default_SubInventory,
X_Default_Locator_Id => X_Default_Locator_Id,
X_Value_added => X_Value_added,
X_Critical_To_Quality => X_Critical_To_Quality,
X_Lowest_Acceptable_Yield => NULL,
X_Use_Org_Settings => NULL,
X_Queue_Mandatory_Flag => NULL,
X_Run_Mandatory_Flag => NULL,
X_To_Move_Mandatory_Flag => NULL,
X_Show_Next_Op_By_Default => NULL,
X_Show_Scrap_Code => NULL,
X_Show_Lot_Attrib => NULL,
X_Track_Multiple_Res_Usage_Dts => NULL);
END Update_Row;
PROCEDURE Update_Row(X_Rowid VARCHAR2,
X_Standard_Operation_Id NUMBER,
X_Operation_Code VARCHAR2,
X_Operation_Type NUMBER,
X_Line_Id NUMBER DEFAULT NULL,
X_Sequence_Num NUMBER DEFAULT NULL,
X_Organization_Id NUMBER,
X_Department_Id NUMBER,
X_Last_Update_Date DATE,
X_Last_Updated_By NUMBER,
X_Last_Update_Login NUMBER DEFAULT NULL,
X_Minimum_Transfer_Quantity NUMBER DEFAULT NULL,
X_Count_Point_Type NUMBER DEFAULT NULL,
X_Operation_Description VARCHAR2 DEFAULT NULL,
X_Option_Dependent_Flag NUMBER DEFAULT NULL,
X_Attribute_Category VARCHAR2 DEFAULT NULL,
X_Attribute1 VARCHAR2 DEFAULT NULL,
X_Attribute2 VARCHAR2 DEFAULT NULL,
X_Attribute3 VARCHAR2 DEFAULT NULL,
X_Attribute4 VARCHAR2 DEFAULT NULL,
X_Attribute5 VARCHAR2 DEFAULT NULL,
X_Attribute6 VARCHAR2 DEFAULT NULL,
X_Attribute7 VARCHAR2 DEFAULT NULL,
X_Attribute8 VARCHAR2 DEFAULT NULL,
X_Attribute9 VARCHAR2 DEFAULT NULL,
X_Attribute10 VARCHAR2 DEFAULT NULL,
X_Attribute11 VARCHAR2 DEFAULT NULL,
X_Attribute12 VARCHAR2 DEFAULT NULL,
X_Attribute13 VARCHAR2 DEFAULT NULL,
X_Attribute14 VARCHAR2 DEFAULT NULL,
X_Attribute15 VARCHAR2 DEFAULT NULL,
X_Backflush_Flag NUMBER DEFAULT NULL,
X_Wms_Task_Type NUMBER DEFAULT NULL,
X_Yield NUMBER DEFAULT NULL,
X_Operation_Yield_Enabled NUMBER DEFAULT NULL,
X_Shutdown_Type VARCHAR2 DEFAULT NULL,
X_Default_SubInventory VARCHAR2,
X_Default_Locator_Id NUMBER,
X_Value_added VARCHAR2 DEFAULT NULL,
X_Critical_To_quality VARCHAR2 DEFAULT NULL,
--OSFM-MES:Following new arguments are added
X_LOWEST_ACCEPTABLE_YIELD NUMBER,
X_USE_ORG_SETTINGS NUMBER,
X_QUEUE_MANDATORY_FLAG NUMBER,
X_RUN_MANDATORY_FLAG NUMBER,
X_TO_MOVE_MANDATORY_FLAG NUMBER,
X_SHOW_NEXT_OP_BY_DEFAULT NUMBER,
X_SHOW_SCRAP_CODE NUMBER,
X_SHOW_LOT_ATTRIB NUMBER,
X_TRACK_MULTIPLE_RES_USAGE_DTS NUMBER,
X_CHECK_SKILL NUMBER DEFAULT NULL
) IS
BEGIN
UPDATE BOM_STANDARD_OPERATIONS
SET
standard_operation_id = X_Standard_Operation_Id,
operation_code = X_Operation_Code,
operation_type = X_Operation_Type,
line_id = X_Line_Id,
sequence_num = X_Sequence_Num,
organization_id = X_Organization_Id,
department_id = X_Department_Id,
last_update_date = X_Last_Update_Date,
last_updated_by = X_Last_Updated_By,
last_update_login = X_Last_Update_Login,
minimum_transfer_quantity = X_Minimum_Transfer_Quantity,
count_point_type = X_Count_Point_Type,
operation_description = X_Operation_Description,
option_dependent_flag = X_Option_Dependent_Flag,
attribute_category = X_Attribute_Category,
attribute1 = X_Attribute1,
attribute2 = X_Attribute2,
attribute3 = X_Attribute3,
attribute4 = X_Attribute4,
attribute5 = X_Attribute5,
attribute6 = X_Attribute6,
attribute7 = X_Attribute7,
attribute8 = X_Attribute8,
attribute9 = X_Attribute9,
attribute10 = X_Attribute10,
attribute11 = X_Attribute11,
attribute12 = X_Attribute12,
attribute13 = X_Attribute13,
attribute14 = X_Attribute14,
attribute15 = X_Attribute15,
backflush_flag = X_Backflush_Flag,
wms_task_type = X_Wms_Task_Type,
yield = X_Yield,
operation_yield_enabled = X_Operation_Yield_Enabled,
shutdown_type = X_Shutdown_Type,
default_subinventory = X_Default_SubInventory,
default_locator_id = X_Default_Locator_Id,
value_added = X_Value_Added,
critical_to_quality = X_Critical_To_Quality,
LOWEST_ACCEPTABLE_YIELD = X_LOWEST_ACCEPTABLE_YIELD,
USE_ORG_SETTINGS = X_USE_ORG_SETTINGS,
QUEUE_MANDATORY_FLAG = X_QUEUE_MANDATORY_FLAG,
RUN_MANDATORY_FLAG = X_RUN_MANDATORY_FLAG,
TO_MOVE_MANDATORY_FLAG = X_TO_MOVE_MANDATORY_FLAG ,
SHOW_NEXT_OP_BY_DEFAULT = X_SHOW_NEXT_OP_BY_DEFAULT ,
SHOW_SCRAP_CODE = X_SHOW_SCRAP_CODE ,
SHOW_LOT_ATTRIB = X_SHOW_LOT_ATTRIB,
TRACK_MULTIPLE_RES_USAGE_DATES = X_TRACK_MULTIPLE_RES_USAGE_DTS,
CHECK_SKILL = X_CHECK_SKILL
WHERE rowid = X_rowid;
END Update_Row;
PROCEDURE Delete_Row(X_Rowid VARCHAR2,
X_Standard_Operation_Id NUMBER) IS
BEGIN
DELETE FROM BOM_STANDARD_OPERATIONS
WHERE rowid = X_Rowid;
Delete_Details(X_Standard_Operation_Id);
END Delete_Row;
SELECT 1 INTO dummy FROM DUAL WHERE NOT EXISTS
(SELECT 1 FROM BOM_STANDARD_OPERATIONS
WHERE Organization_Id = X_Organization_Id
AND Operation_Code = X_Operation_Code
AND (Operation_Type = X_Operation_Type
OR Operation_Type IS NULL)
AND Line_Id IS NULL
AND ((X_Rowid IS NULL) OR (ROWID <> X_Rowid))
);
SELECT 1 INTO dummy FROM DUAL WHERE NOT EXISTS
(SELECT 1 FROM BOM_STANDARD_OPERATIONS
WHERE Organization_Id = X_Organization_Id
AND Operation_Code = X_Operation_Code
AND (Operation_Type = X_Operation_Type
OR Operation_Type IS NULL)
AND Line_Id = X_Line_Id
-- OR Line_Id IS NULL) Commented for bug 4173389 and modified above line.
AND ((X_Rowid IS NULL) OR (ROWID <> X_Rowid))
);
SELECT 1 INTO dummy FROM DUAL WHERE NOT EXISTS
(SELECT 1 FROM BOM_STANDARD_OPERATIONS
WHERE Organization_Id = X_Organization_Id
AND (Operation_Type = X_Operation_Type
OR Operation_Type IS NULL)
AND (Line_Id = X_Line_Id
OR Line_Id IS NULL)
AND Sequence_Num = X_Sequence_Num
AND ((X_Rowid IS NULL) OR (ROWID <> X_Rowid))
);
SELECT LINE_CODE into x_line_code from WIP_LINES where LINE_ID = X_Line_id;
SELECT 1 INTO dummy FROM DUAL WHERE NOT EXISTS
(SELECT 1 FROM BOM_OPERATION_SEQUENCES
WHERE STANDARD_OPERATION_ID = X_Standard_Operation_Id
AND ((DISABLE_DATE > SYSDATE) OR (DISABLE_DATE IS NULL))
);
PROCEDURE Delete_Details(X_Standard_Operation_Id NUMBER) IS
BEGIN
DELETE FROM BOM_STD_OP_RESOURCES
WHERE STANDARD_OPERATION_ID = X_Standard_Operation_Id;
DELETE FROM BOM_OPERATION_SKILLS
WHERE STANDARD_OPERATION_ID = X_Standard_Operation_Id
and LEVEL_ID=1;
END Delete_Details;
SELECT 1 FROM fnd_application app, fnd_product_installations inst
WHERE app.application_short_name = 'WMS'
AND inst.application_id = app.application_id
AND inst.status <> 'N';
v_sqlstr := 'SELECT 1 FROM wms_rules_b WHERE type_hdr_id = :a AND type_code = 3 AND rownum < 2';
SELECT 1 INTO l_dummy FROM DUAL WHERE NOT EXISTS
(SELECT 1 FROM BOM_SETUP_TRANSITIONS
WHERE OPERATION_ID = P_Standard_Operation_Id
);