[Home] [Help]
The following lines contain the word 'select', 'insert', 'update' or 'delete':
PROCEDURE Update_Row
( p_Assignment_Set_rec IN MRP_Src_Assignment_PUB.Assignment_Set_Rec_Type
)
IS
BEGIN
UPDATE MRP_ASSIGNMENT_SETS
SET ASSIGNMENT_SET_ID = p_Assignment_Set_rec.Assignment_Set_Id
, ASSIGNMENT_SET_NAME = p_Assignment_Set_rec.Assignment_Set_Name
, ATTRIBUTE1 = p_Assignment_Set_rec.Attribute1
, ATTRIBUTE10 = p_Assignment_Set_rec.Attribute10
, ATTRIBUTE11 = p_Assignment_Set_rec.Attribute11
, ATTRIBUTE12 = p_Assignment_Set_rec.Attribute12
, ATTRIBUTE13 = p_Assignment_Set_rec.Attribute13
, ATTRIBUTE14 = p_Assignment_Set_rec.Attribute14
, ATTRIBUTE15 = p_Assignment_Set_rec.Attribute15
, ATTRIBUTE2 = p_Assignment_Set_rec.Attribute2
, ATTRIBUTE3 = p_Assignment_Set_rec.Attribute3
, ATTRIBUTE4 = p_Assignment_Set_rec.Attribute4
, ATTRIBUTE5 = p_Assignment_Set_rec.Attribute5
, ATTRIBUTE6 = p_Assignment_Set_rec.Attribute6
, ATTRIBUTE7 = p_Assignment_Set_rec.Attribute7
, ATTRIBUTE8 = p_Assignment_Set_rec.Attribute8
, ATTRIBUTE9 = p_Assignment_Set_rec.Attribute9
, ATTRIBUTE_CATEGORY = p_Assignment_Set_rec.Attribute_Category
, CREATED_BY = p_Assignment_Set_rec.Created_By
, CREATION_DATE = p_Assignment_Set_rec.Creation_Date
, DESCRIPTION = p_Assignment_Set_rec.Description
, LAST_UPDATED_BY = p_Assignment_Set_rec.Last_Updated_By
, LAST_UPDATE_DATE = p_Assignment_Set_rec.Last_Update_Date
, LAST_UPDATE_LOGIN = p_Assignment_Set_rec.Last_Update_Login
, PROGRAM_APPLICATION_ID = p_Assignment_Set_rec.Program_Application_Id
, PROGRAM_ID = p_Assignment_Set_rec.Program_Id
, PROGRAM_UPDATE_DATE = p_Assignment_Set_rec.Program_Update_Date
, REQUEST_ID = p_Assignment_Set_rec.Request_Id
WHERE ASSIGNMENT_SET_ID = p_Assignment_Set_rec.Assignment_Set_Id
;
, 'Update_Row'
);
END Update_Row;
PROCEDURE Insert_Row
( p_Assignment_Set_rec IN MRP_Src_Assignment_PUB.Assignment_Set_Rec_Type
)
IS
BEGIN
INSERT INTO MRP_ASSIGNMENT_SETS
( ASSIGNMENT_SET_ID
, ASSIGNMENT_SET_NAME
, ATTRIBUTE1
, ATTRIBUTE10
, ATTRIBUTE11
, ATTRIBUTE12
, ATTRIBUTE13
, ATTRIBUTE14
, ATTRIBUTE15
, ATTRIBUTE2
, ATTRIBUTE3
, ATTRIBUTE4
, ATTRIBUTE5
, ATTRIBUTE6
, ATTRIBUTE7
, ATTRIBUTE8
, ATTRIBUTE9
, ATTRIBUTE_CATEGORY
, CREATED_BY
, CREATION_DATE
, DESCRIPTION
, LAST_UPDATED_BY
, LAST_UPDATE_DATE
, LAST_UPDATE_LOGIN
, PROGRAM_APPLICATION_ID
, PROGRAM_ID
, PROGRAM_UPDATE_DATE
, REQUEST_ID
)
VALUES
( p_Assignment_Set_rec.Assignment_Set_Id
, p_Assignment_Set_rec.Assignment_Set_Name
, p_Assignment_Set_rec.Attribute1
, p_Assignment_Set_rec.Attribute10
, p_Assignment_Set_rec.Attribute11
, p_Assignment_Set_rec.Attribute12
, p_Assignment_Set_rec.Attribute13
, p_Assignment_Set_rec.Attribute14
, p_Assignment_Set_rec.Attribute15
, p_Assignment_Set_rec.Attribute2
, p_Assignment_Set_rec.Attribute3
, p_Assignment_Set_rec.Attribute4
, p_Assignment_Set_rec.Attribute5
, p_Assignment_Set_rec.Attribute6
, p_Assignment_Set_rec.Attribute7
, p_Assignment_Set_rec.Attribute8
, p_Assignment_Set_rec.Attribute9
, p_Assignment_Set_rec.Attribute_Category
, p_Assignment_Set_rec.Created_By
, p_Assignment_Set_rec.Creation_Date
, p_Assignment_Set_rec.Description
, p_Assignment_Set_rec.Last_Updated_By
, p_Assignment_Set_rec.Last_Update_Date
, p_Assignment_Set_rec.Last_Update_Login
, p_Assignment_Set_rec.Program_Application_Id
, p_Assignment_Set_rec.Program_Id
, p_Assignment_Set_rec.Program_Update_Date
, p_Assignment_Set_rec.Request_Id
);
, 'Insert_Row'
);
END Insert_Row;
PROCEDURE Delete_Row
( p_Assignment_Set_Id IN NUMBER
)
IS
l_assignment_id NUMBER;
SELECT assignment_id
FROM MRP_SR_ASSIGNMENTS
WHERE ASSIGNMENT_SET_ID = p_Assignment_Set_Id;
MRP_Assignment_Handlers.Delete_Row (
p_Assignment_Id => l_assignment_id) ;
DELETE FROM MRP_ASSIGNMENT_SETS
WHERE ASSIGNMENT_SET_ID = p_Assignment_Set_Id
;
, 'Delete_Row'
);
END Delete_Row;
SELECT ASSIGNMENT_SET_ID
, ASSIGNMENT_SET_NAME
, ATTRIBUTE1
, ATTRIBUTE10
, ATTRIBUTE11
, ATTRIBUTE12
, ATTRIBUTE13
, ATTRIBUTE14
, ATTRIBUTE15
, ATTRIBUTE2
, ATTRIBUTE3
, ATTRIBUTE4
, ATTRIBUTE5
, ATTRIBUTE6
, ATTRIBUTE7
, ATTRIBUTE8
, ATTRIBUTE9
, ATTRIBUTE_CATEGORY
, CREATED_BY
, CREATION_DATE
, DESCRIPTION
, LAST_UPDATED_BY
, LAST_UPDATE_DATE
, LAST_UPDATE_LOGIN
, PROGRAM_APPLICATION_ID
, PROGRAM_ID
, PROGRAM_UPDATE_DATE
, REQUEST_ID
INTO l_Assignment_Set_rec.Assignment_Set_Id
, l_Assignment_Set_rec.Assignment_Set_Name
, l_Assignment_Set_rec.Attribute1
, l_Assignment_Set_rec.Attribute10
, l_Assignment_Set_rec.Attribute11
, l_Assignment_Set_rec.Attribute12
, l_Assignment_Set_rec.Attribute13
, l_Assignment_Set_rec.Attribute14
, l_Assignment_Set_rec.Attribute15
, l_Assignment_Set_rec.Attribute2
, l_Assignment_Set_rec.Attribute3
, l_Assignment_Set_rec.Attribute4
, l_Assignment_Set_rec.Attribute5
, l_Assignment_Set_rec.Attribute6
, l_Assignment_Set_rec.Attribute7
, l_Assignment_Set_rec.Attribute8
, l_Assignment_Set_rec.Attribute9
, l_Assignment_Set_rec.Attribute_Category
, l_Assignment_Set_rec.Created_By
, l_Assignment_Set_rec.Creation_Date
, l_Assignment_Set_rec.Description
, l_Assignment_Set_rec.Last_Updated_By
, l_Assignment_Set_rec.Last_Update_Date
, l_Assignment_Set_rec.Last_Update_Login
, l_Assignment_Set_rec.Program_Application_Id
, l_Assignment_Set_rec.Program_Id
, l_Assignment_Set_rec.Program_Update_Date
, l_Assignment_Set_rec.Request_Id
FROM MRP_ASSIGNMENT_SETS
WHERE ASSIGNMENT_SET_ID = p_Assignment_Set_rec.Assignment_Set_Id
FOR UPDATE NOWAIT;
AND ( (l_Assignment_Set_rec.Last_Updated_By =
p_Assignment_Set_rec.Last_Updated_By) OR
((p_Assignment_Set_rec.Last_Updated_By = FND_API.G_MISS_NUM) OR
( (l_Assignment_Set_rec.Last_Updated_By IS NULL) AND
(p_Assignment_Set_rec.Last_Updated_By IS NULL))))
AND ( (l_Assignment_Set_rec.Last_Update_Date =
p_Assignment_Set_rec.Last_Update_Date) OR
((p_Assignment_Set_rec.Last_Update_Date = FND_API.G_MISS_DATE) OR
( (l_Assignment_Set_rec.Last_Update_Date IS NULL) AND
(p_Assignment_Set_rec.Last_Update_Date IS NULL))))
AND ( (l_Assignment_Set_rec.Last_Update_Login =
p_Assignment_Set_rec.Last_Update_Login) OR
((p_Assignment_Set_rec.Last_Update_Login = FND_API.G_MISS_NUM) OR
( (l_Assignment_Set_rec.Last_Update_Login IS NULL) AND
(p_Assignment_Set_rec.Last_Update_Login IS NULL))))
AND ( (l_Assignment_Set_rec.Program_Application_Id =
p_Assignment_Set_rec.Program_Application_Id) OR
((p_Assignment_Set_rec.Program_Application_Id = FND_API.G_MISS_NUM) OR
( (l_Assignment_Set_rec.Program_Application_Id IS NULL) AND
(p_Assignment_Set_rec.Program_Application_Id IS NULL))))
AND ( (l_Assignment_Set_rec.Program_Id =
p_Assignment_Set_rec.Program_Id) OR
((p_Assignment_Set_rec.Program_Id = FND_API.G_MISS_NUM) OR
( (l_Assignment_Set_rec.Program_Id IS NULL) AND
(p_Assignment_Set_rec.Program_Id IS NULL))))
AND ( (l_Assignment_Set_rec.Program_Update_Date =
p_Assignment_Set_rec.Program_Update_Date) OR
((p_Assignment_Set_rec.Program_Update_Date = FND_API.G_MISS_DATE) OR
( (l_Assignment_Set_rec.Program_Update_Date IS NULL) AND
(p_Assignment_Set_rec.Program_Update_Date IS NULL))))
AND ( (l_Assignment_Set_rec.Request_Id =
p_Assignment_Set_rec.Request_Id) OR
((p_Assignment_Set_rec.Request_Id = FND_API.G_MISS_NUM) OR
( (l_Assignment_Set_rec.Request_Id IS NULL) AND
(p_Assignment_Set_rec.Request_Id IS NULL))))
THEN
-- Row has not changed. Set out parameter.
x_Assignment_Set_rec := l_Assignment_Set_rec;
FND_MESSAGE.SET_NAME('MRP','BOI_LOCK_ROW_DELETED');
SELECT ASSIGNMENT_SET_ID
, ASSIGNMENT_SET_NAME
, ATTRIBUTE1
, ATTRIBUTE10
, ATTRIBUTE11
, ATTRIBUTE12
, ATTRIBUTE13
, ATTRIBUTE14
, ATTRIBUTE15
, ATTRIBUTE2
, ATTRIBUTE3
, ATTRIBUTE4
, ATTRIBUTE5
, ATTRIBUTE6
, ATTRIBUTE7
, ATTRIBUTE8
, ATTRIBUTE9
, ATTRIBUTE_CATEGORY
, CREATED_BY
, CREATION_DATE
, DESCRIPTION
, LAST_UPDATED_BY
, LAST_UPDATE_DATE
, LAST_UPDATE_LOGIN
, PROGRAM_APPLICATION_ID
, PROGRAM_ID
, PROGRAM_UPDATE_DATE
, REQUEST_ID
INTO l_Assignment_Set_rec.Assignment_Set_Id
, l_Assignment_Set_rec.Assignment_Set_Name
, l_Assignment_Set_rec.Attribute1
, l_Assignment_Set_rec.Attribute10
, l_Assignment_Set_rec.Attribute11
, l_Assignment_Set_rec.Attribute12
, l_Assignment_Set_rec.Attribute13
, l_Assignment_Set_rec.Attribute14
, l_Assignment_Set_rec.Attribute15
, l_Assignment_Set_rec.Attribute2
, l_Assignment_Set_rec.Attribute3
, l_Assignment_Set_rec.Attribute4
, l_Assignment_Set_rec.Attribute5
, l_Assignment_Set_rec.Attribute6
, l_Assignment_Set_rec.Attribute7
, l_Assignment_Set_rec.Attribute8
, l_Assignment_Set_rec.Attribute9
, l_Assignment_Set_rec.Attribute_Category
, l_Assignment_Set_rec.Created_By
, l_Assignment_Set_rec.Creation_Date
, l_Assignment_Set_rec.Description
, l_Assignment_Set_rec.Last_Updated_By
, l_Assignment_Set_rec.Last_Update_Date
, l_Assignment_Set_rec.Last_Update_Login
, l_Assignment_Set_rec.Program_Application_Id
, l_Assignment_Set_rec.Program_Id
, l_Assignment_Set_rec.Program_Update_Date
, l_Assignment_Set_rec.Request_Id
FROM MRP_ASSIGNMENT_SETS
WHERE ASSIGNMENT_SET_ID = p_Assignment_Set_Id
;
SELECT ASSIGNMENT_SET_ID
, ASSIGNMENT_SET_NAME
, ATTRIBUTE1
, ATTRIBUTE10
, ATTRIBUTE11
, ATTRIBUTE12
, ATTRIBUTE13
, ATTRIBUTE14
, ATTRIBUTE15
, ATTRIBUTE2
, ATTRIBUTE3
, ATTRIBUTE4
, ATTRIBUTE5
, ATTRIBUTE6
, ATTRIBUTE7
, ATTRIBUTE8
, ATTRIBUTE9
, ATTRIBUTE_CATEGORY
, CREATED_BY
, CREATION_DATE
, DESCRIPTION
, LAST_UPDATED_BY
, LAST_UPDATE_DATE
, LAST_UPDATE_LOGIN
, PROGRAM_APPLICATION_ID
, PROGRAM_ID
, PROGRAM_UPDATE_DATE
, REQUEST_ID
INTO x_Assignment_Set_rec.Assignment_Set_Id
, x_Assignment_Set_rec.Assignment_Set_Name
, x_Assignment_Set_rec.Attribute1
, x_Assignment_Set_rec.Attribute10
, x_Assignment_Set_rec.Attribute11
, x_Assignment_Set_rec.Attribute12
, x_Assignment_Set_rec.Attribute13
, x_Assignment_Set_rec.Attribute14
, x_Assignment_Set_rec.Attribute15
, x_Assignment_Set_rec.Attribute2
, x_Assignment_Set_rec.Attribute3
, x_Assignment_Set_rec.Attribute4
, x_Assignment_Set_rec.Attribute5
, x_Assignment_Set_rec.Attribute6
, x_Assignment_Set_rec.Attribute7
, x_Assignment_Set_rec.Attribute8
, x_Assignment_Set_rec.Attribute9
, x_Assignment_Set_rec.Attribute_Category
, x_Assignment_Set_rec.Created_By
, x_Assignment_Set_rec.Creation_Date
, x_Assignment_Set_rec.Description
, x_Assignment_Set_rec.Last_Updated_By
, x_Assignment_Set_rec.Last_Update_Date
, x_Assignment_Set_rec.Last_Update_Login
, x_Assignment_Set_rec.Program_Application_Id
, x_Assignment_Set_rec.Program_Id
, x_Assignment_Set_rec.Program_Update_Date
, x_Assignment_Set_rec.Request_Id
FROM MRP_ASSIGNMENT_SETS
WHERE ASSIGNMENT_SET_ID = p_Assignment_Set_Id
;