[Home] [Help]
The following lines contain the word 'select', 'insert', 'update' or 'delete':
PROCEDURE Insert_Row(X_Rowid IN OUT NOCOPY VARCHAR2,
X_Wip_Entity_Id NUMBER,
X_Operation_Seq_Num NUMBER,
X_Organization_Id NUMBER,
X_Repetitive_Schedule_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,
X_Operation_Sequence_Id NUMBER,
X_Standard_Operation_Id NUMBER,
X_Department_Id NUMBER,
X_Shutdown_Type VARCHAR2,
X_Operation_Completed VARCHAR2,
X_Description VARCHAR2,
X_Scheduled_Quantity NUMBER,
X_Quantity_In_Queue NUMBER,
X_Quantity_Running NUMBER,
X_Quantity_Waiting_To_Move NUMBER,
X_Quantity_Rejected NUMBER,
X_Quantity_Scrapped NUMBER,
X_Quantity_Completed NUMBER,
X_First_Unit_Start_Date DATE,
X_First_Unit_Completion_Date DATE,
X_Last_Unit_Start_Date DATE,
X_Last_Unit_Completion_Date DATE,
X_Previous_Operation_Seq_Num NUMBER,
X_Next_Operation_Seq_Num NUMBER,
X_Count_Point_Type NUMBER,
X_Backflush_Flag NUMBER,
X_Minimum_Transfer_Quantity NUMBER,
X_Date_Last_Moved DATE,
X_Attribute_Category VARCHAR2,
X_Attribute1 VARCHAR2,
X_Attribute2 VARCHAR2,
X_Attribute3 VARCHAR2,
X_Attribute4 VARCHAR2,
X_Attribute5 VARCHAR2,
X_Attribute6 VARCHAR2,
X_Attribute7 VARCHAR2,
X_Attribute8 VARCHAR2,
X_Attribute9 VARCHAR2,
X_Attribute10 VARCHAR2,
X_Attribute11 VARCHAR2,
X_Attribute12 VARCHAR2,
X_Attribute13 VARCHAR2,
X_Attribute14 VARCHAR2,
X_Attribute15 VARCHAR2,
X_X_Pos NUMBER,
X_Y_Pos NUMBER,
X_LONG_DESCRIPTION VARCHAR2,
X_L_EAM_OP_REC OUT NOCOPY EAM_PROCESS_WO_PUB.eam_op_rec_type,
X_WO_Start_Date OUT NOCOPY DATE,
X_WO_Completion_Date OUT NOCOPY DATE
) IS
x_user_id number := FND_GLOBAL.USER_ID;
END Insert_Row;
PROCEDURE Update_Row(X_Rowid VARCHAR2,
X_Wip_Entity_Id NUMBER,
X_Operation_Seq_Num NUMBER,
X_Organization_Id NUMBER,
X_Last_Update_Date DATE,
X_Last_Updated_By NUMBER,
X_Last_Update_Login NUMBER,
X_Operation_Sequence_Id NUMBER,
X_Standard_Operation_Id NUMBER,
X_Department_Id NUMBER,
X_Shutdown_Type VARCHAR2,
X_Operation_Completed VARCHAR2,
X_Description VARCHAR2,
X_First_Unit_Start_Date DATE,
X_First_Unit_Completion_Date DATE,
X_Last_Unit_Start_Date DATE,
X_Last_Unit_Completion_Date DATE,
X_Attribute_Category VARCHAR2,
X_Attribute1 VARCHAR2,
X_Attribute2 VARCHAR2,
X_Attribute3 VARCHAR2,
X_Attribute4 VARCHAR2,
X_Attribute5 VARCHAR2,
X_Attribute6 VARCHAR2,
X_Attribute7 VARCHAR2,
X_Attribute8 VARCHAR2,
X_Attribute9 VARCHAR2,
X_Attribute10 VARCHAR2,
X_Attribute11 VARCHAR2,
X_Attribute12 VARCHAR2,
X_Attribute13 VARCHAR2,
X_Attribute14 VARCHAR2,
X_Attribute15 VARCHAR2,
X_X_Pos NUMBER,
X_Y_Pos NUMBER,
X_Long_Description VARCHAR2,
X_L_EAM_OP_REC OUT NOCOPY EAM_PROCESS_WO_PUB.eam_op_rec_type,
X_WO_Start_Date OUT NOCOPY DATE,
X_WO_Completion_Date OUT NOCOPY DATE
) IS
l_return_status VARCHAR2(1);
l_eam_op_rec.TRANSACTION_TYPE := EAM_PROCESS_WO_PUB.G_OPR_UPDATE;
END Update_Row;
SELECT *
FROM WIP_OPERATIONS
WHERE rowid = X_Rowid
FOR UPDATE of Wip_Entity_Id NOWAIT;
FND_MESSAGE.Set_Name('FND', 'FORM_RECORD_DELETED');
PROCEDURE Delete_Row(X_Rowid VARCHAR2,
X_WO_Start_Date OUT NOCOPY DATE,
X_WO_Completion_Date OUT NOCOPY DATE) IS
l_return_status VARCHAR2(1);
select wip_entity_id,
organization_id,
operation_seq_num
into l_wip_entity_id,
l_organization_id,
l_operation_seq_num
from
wip_operations
where rowid=X_Rowid;
l_eam_op_rec.TRANSACTION_TYPE := EAM_PROCESS_WO_PUB.G_OPR_DELETE;
END Delete_Row;