The following lines contain the word 'select', 'insert', 'update' or 'delete':
PROCEDURE Update_Row
( p_Assignment_rec IN MRP_Src_Assignment_PUB.Assignment_Rec_Type
)
IS
BEGIN
UPDATE MRP_SR_ASSIGNMENTS
SET ASSIGNMENT_ID = p_Assignment_rec.Assignment_Id
, ASSIGNMENT_SET_ID = p_Assignment_rec.Assignment_Set_Id
, ASSIGNMENT_TYPE = p_Assignment_rec.Assignment_Type
, ATTRIBUTE1 = p_Assignment_rec.Attribute1
, ATTRIBUTE10 = p_Assignment_rec.Attribute10
, ATTRIBUTE11 = p_Assignment_rec.Attribute11
, ATTRIBUTE12 = p_Assignment_rec.Attribute12
, ATTRIBUTE13 = p_Assignment_rec.Attribute13
, ATTRIBUTE14 = p_Assignment_rec.Attribute14
, ATTRIBUTE15 = p_Assignment_rec.Attribute15
, ATTRIBUTE2 = p_Assignment_rec.Attribute2
, ATTRIBUTE3 = p_Assignment_rec.Attribute3
, ATTRIBUTE4 = p_Assignment_rec.Attribute4
, ATTRIBUTE5 = p_Assignment_rec.Attribute5
, ATTRIBUTE6 = p_Assignment_rec.Attribute6
, ATTRIBUTE7 = p_Assignment_rec.Attribute7
, ATTRIBUTE8 = p_Assignment_rec.Attribute8
, ATTRIBUTE9 = p_Assignment_rec.Attribute9
, ATTRIBUTE_CATEGORY = p_Assignment_rec.Attribute_Category
, CATEGORY_ID = p_Assignment_rec.Category_Id
, CATEGORY_SET_ID = p_Assignment_rec.Category_Set_Id
, CREATED_BY = p_Assignment_rec.Created_By
, CREATION_DATE = p_Assignment_rec.Creation_Date
, CUSTOMER_ID = p_Assignment_rec.Customer_Id
, INVENTORY_ITEM_ID = p_Assignment_rec.Inventory_Item_Id
, LAST_UPDATED_BY = p_Assignment_rec.Last_Updated_By
, LAST_UPDATE_DATE = p_Assignment_rec.Last_Update_Date
, LAST_UPDATE_LOGIN = p_Assignment_rec.Last_Update_Login
, ORGANIZATION_ID = p_Assignment_rec.Organization_Id
, PROGRAM_APPLICATION_ID = p_Assignment_rec.Program_Application_Id
, PROGRAM_ID = p_Assignment_rec.Program_Id
, PROGRAM_UPDATE_DATE = p_Assignment_rec.Program_Update_Date
, REQUEST_ID = p_Assignment_rec.Request_Id
, SECONDARY_INVENTORY = p_Assignment_rec.Secondary_Inventory
, SHIP_TO_SITE_ID = p_Assignment_rec.Ship_To_Site_Id
, SOURCING_RULE_ID = p_Assignment_rec.Sourcing_Rule_Id
, SOURCING_RULE_TYPE = p_Assignment_rec.Sourcing_Rule_Type
WHERE ASSIGNMENT_ID = p_Assignment_rec.Assignment_Id
;
, 'Update_Row'
);
END Update_Row;
PROCEDURE Insert_Row
( p_Assignment_rec IN MRP_Src_Assignment_PUB.Assignment_Rec_Type
)
IS
BEGIN
INSERT INTO MRP_SR_ASSIGNMENTS
( ASSIGNMENT_ID
, ASSIGNMENT_SET_ID
, ASSIGNMENT_TYPE
, ATTRIBUTE1
, ATTRIBUTE10
, ATTRIBUTE11
, ATTRIBUTE12
, ATTRIBUTE13
, ATTRIBUTE14
, ATTRIBUTE15
, ATTRIBUTE2
, ATTRIBUTE3
, ATTRIBUTE4
, ATTRIBUTE5
, ATTRIBUTE6
, ATTRIBUTE7
, ATTRIBUTE8
, ATTRIBUTE9
, ATTRIBUTE_CATEGORY
, CATEGORY_ID
, CATEGORY_SET_ID
, CREATED_BY
, CREATION_DATE
, CUSTOMER_ID
, INVENTORY_ITEM_ID
, LAST_UPDATED_BY
, LAST_UPDATE_DATE
, LAST_UPDATE_LOGIN
, ORGANIZATION_ID
, PROGRAM_APPLICATION_ID
, PROGRAM_ID
, PROGRAM_UPDATE_DATE
, REQUEST_ID
, SECONDARY_INVENTORY
, SHIP_TO_SITE_ID
, SOURCING_RULE_ID
, SOURCING_RULE_TYPE
)
VALUES
( p_Assignment_rec.Assignment_Id
, p_Assignment_rec.Assignment_Set_Id
, p_Assignment_rec.Assignment_Type
, p_Assignment_rec.Attribute1
, p_Assignment_rec.Attribute10
, p_Assignment_rec.Attribute11
, p_Assignment_rec.Attribute12
, p_Assignment_rec.Attribute13
, p_Assignment_rec.Attribute14
, p_Assignment_rec.Attribute15
, p_Assignment_rec.Attribute2
, p_Assignment_rec.Attribute3
, p_Assignment_rec.Attribute4
, p_Assignment_rec.Attribute5
, p_Assignment_rec.Attribute6
, p_Assignment_rec.Attribute7
, p_Assignment_rec.Attribute8
, p_Assignment_rec.Attribute9
, p_Assignment_rec.Attribute_Category
, p_Assignment_rec.Category_Id
, p_Assignment_rec.Category_Set_Id
, p_Assignment_rec.Created_By
, p_Assignment_rec.Creation_Date
, p_Assignment_rec.Customer_Id
, p_Assignment_rec.Inventory_Item_Id
, p_Assignment_rec.Last_Updated_By
, p_Assignment_rec.Last_Update_Date
, p_Assignment_rec.Last_Update_Login
, p_Assignment_rec.Organization_Id
, p_Assignment_rec.Program_Application_Id
, p_Assignment_rec.Program_Id
, p_Assignment_rec.Program_Update_Date
, p_Assignment_rec.Request_Id
, p_Assignment_rec.Secondary_Inventory
, p_Assignment_rec.Ship_To_Site_Id
, p_Assignment_rec.Sourcing_Rule_Id
, p_Assignment_rec.Sourcing_Rule_Type
);
, 'Insert_Row'
);
END Insert_Row;
PROCEDURE Delete_Row
( p_Assignment_Id IN NUMBER
)
IS
BEGIN
DELETE FROM MRP_SR_ASSIGNMENTS
WHERE ASSIGNMENT_ID = p_Assignment_Id
;
, 'Delete_Row'
);
END Delete_Row;
SELECT ASSIGNMENT_ID
, ASSIGNMENT_SET_ID
, ASSIGNMENT_TYPE
, ATTRIBUTE1
, ATTRIBUTE10
, ATTRIBUTE11
, ATTRIBUTE12
, ATTRIBUTE13
, ATTRIBUTE14
, ATTRIBUTE15
, ATTRIBUTE2
, ATTRIBUTE3
, ATTRIBUTE4
, ATTRIBUTE5
, ATTRIBUTE6
, ATTRIBUTE7
, ATTRIBUTE8
, ATTRIBUTE9
, ATTRIBUTE_CATEGORY
, CATEGORY_ID
, CATEGORY_SET_ID
, CREATED_BY
, CREATION_DATE
, CUSTOMER_ID
, INVENTORY_ITEM_ID
, LAST_UPDATED_BY
, LAST_UPDATE_DATE
, LAST_UPDATE_LOGIN
, ORGANIZATION_ID
, PROGRAM_APPLICATION_ID
, PROGRAM_ID
, PROGRAM_UPDATE_DATE
, REQUEST_ID
, SECONDARY_INVENTORY
, SHIP_TO_SITE_ID
, SOURCING_RULE_ID
, SOURCING_RULE_TYPE
INTO l_Assignment_rec.Assignment_Id
, l_Assignment_rec.Assignment_Set_Id
, l_Assignment_rec.Assignment_Type
, l_Assignment_rec.Attribute1
, l_Assignment_rec.Attribute10
, l_Assignment_rec.Attribute11
, l_Assignment_rec.Attribute12
, l_Assignment_rec.Attribute13
, l_Assignment_rec.Attribute14
, l_Assignment_rec.Attribute15
, l_Assignment_rec.Attribute2
, l_Assignment_rec.Attribute3
, l_Assignment_rec.Attribute4
, l_Assignment_rec.Attribute5
, l_Assignment_rec.Attribute6
, l_Assignment_rec.Attribute7
, l_Assignment_rec.Attribute8
, l_Assignment_rec.Attribute9
, l_Assignment_rec.Attribute_Category
, l_Assignment_rec.Category_Id
, l_Assignment_rec.Category_Set_Id
, l_Assignment_rec.Created_By
, l_Assignment_rec.Creation_Date
, l_Assignment_rec.Customer_Id
, l_Assignment_rec.Inventory_Item_Id
, l_Assignment_rec.Last_Updated_By
, l_Assignment_rec.Last_Update_Date
, l_Assignment_rec.Last_Update_Login
, l_Assignment_rec.Organization_Id
, l_Assignment_rec.Program_Application_Id
, l_Assignment_rec.Program_Id
, l_Assignment_rec.Program_Update_Date
, l_Assignment_rec.Request_Id
, l_Assignment_rec.Secondary_Inventory
, l_Assignment_rec.Ship_To_Site_Id
, l_Assignment_rec.Sourcing_Rule_Id
, l_Assignment_rec.Sourcing_Rule_Type
FROM MRP_SR_ASSIGNMENTS
WHERE ASSIGNMENT_ID = p_Assignment_rec.Assignment_Id
FOR UPDATE NOWAIT;
AND ( (l_Assignment_rec.Last_Updated_By =
p_Assignment_rec.Last_Updated_By) OR
((p_Assignment_rec.Last_Updated_By = FND_API.G_MISS_NUM) OR
( (l_Assignment_rec.Last_Updated_By IS NULL) AND
(p_Assignment_rec.Last_Updated_By IS NULL))))
AND ( (l_Assignment_rec.Last_Update_Date =
p_Assignment_rec.Last_Update_Date) OR
((p_Assignment_rec.Last_Update_Date = FND_API.G_MISS_DATE) OR
( (l_Assignment_rec.Last_Update_Date IS NULL) AND
(p_Assignment_rec.Last_Update_Date IS NULL))))
AND ( (l_Assignment_rec.Last_Update_Login =
p_Assignment_rec.Last_Update_Login) OR
((p_Assignment_rec.Last_Update_Login = FND_API.G_MISS_NUM) OR
( (l_Assignment_rec.Last_Update_Login IS NULL) AND
(p_Assignment_rec.Last_Update_Login IS NULL))))
AND ( (l_Assignment_rec.Organization_Id =
p_Assignment_rec.Organization_Id) OR
((p_Assignment_rec.Organization_Id = FND_API.G_MISS_NUM) OR
( (l_Assignment_rec.Organization_Id IS NULL) AND
(p_Assignment_rec.Organization_Id IS NULL))))
AND ( (l_Assignment_rec.Program_Application_Id =
p_Assignment_rec.Program_Application_Id) OR
((p_Assignment_rec.Program_Application_Id = FND_API.G_MISS_NUM) OR
( (l_Assignment_rec.Program_Application_Id IS NULL) AND
(p_Assignment_rec.Program_Application_Id IS NULL))))
AND ( (l_Assignment_rec.Program_Id =
p_Assignment_rec.Program_Id) OR
((p_Assignment_rec.Program_Id = FND_API.G_MISS_NUM) OR
( (l_Assignment_rec.Program_Id IS NULL) AND
(p_Assignment_rec.Program_Id IS NULL))))
AND ( (l_Assignment_rec.Program_Update_Date =
p_Assignment_rec.Program_Update_Date) OR
((p_Assignment_rec.Program_Update_Date = FND_API.G_MISS_DATE) OR
( (l_Assignment_rec.Program_Update_Date IS NULL) AND
(p_Assignment_rec.Program_Update_Date IS NULL))))
AND ( (l_Assignment_rec.Request_Id =
p_Assignment_rec.Request_Id) OR
((p_Assignment_rec.Request_Id = FND_API.G_MISS_NUM) OR
( (l_Assignment_rec.Request_Id IS NULL) AND
(p_Assignment_rec.Request_Id IS NULL))))
AND ( (l_Assignment_rec.Secondary_Inventory =
p_Assignment_rec.Secondary_Inventory) OR
((p_Assignment_rec.Secondary_Inventory = FND_API.G_MISS_CHAR) OR
( (l_Assignment_rec.Secondary_Inventory IS NULL) AND
(p_Assignment_rec.Secondary_Inventory IS NULL))))
AND ( (l_Assignment_rec.Ship_To_Site_Id =
p_Assignment_rec.Ship_To_Site_Id) OR
((p_Assignment_rec.Ship_To_Site_Id = FND_API.G_MISS_NUM) OR
( (l_Assignment_rec.Ship_To_Site_Id IS NULL) AND
(p_Assignment_rec.Ship_To_Site_Id IS NULL))))
AND ( (l_Assignment_rec.Sourcing_Rule_Id =
p_Assignment_rec.Sourcing_Rule_Id) OR
((p_Assignment_rec.Sourcing_Rule_Id = FND_API.G_MISS_NUM) OR
( (l_Assignment_rec.Sourcing_Rule_Id IS NULL) AND
(p_Assignment_rec.Sourcing_Rule_Id IS NULL))))
AND ( (l_Assignment_rec.Sourcing_Rule_Type =
p_Assignment_rec.Sourcing_Rule_Type) OR
((p_Assignment_rec.Sourcing_Rule_Type = FND_API.G_MISS_NUM) OR
( (l_Assignment_rec.Sourcing_Rule_Type IS NULL) AND
(p_Assignment_rec.Sourcing_Rule_Type IS NULL))))
THEN
-- Row has not changed. Set out parameter.
x_Assignment_rec := l_Assignment_rec;
FND_MESSAGE.SET_NAME('MRP','BOI_LOCK_ROW_DELETED');
SELECT ASSIGNMENT_ID
, ASSIGNMENT_SET_ID
, ASSIGNMENT_TYPE
, ATTRIBUTE1
, ATTRIBUTE10
, ATTRIBUTE11
, ATTRIBUTE12
, ATTRIBUTE13
, ATTRIBUTE14
, ATTRIBUTE15
, ATTRIBUTE2
, ATTRIBUTE3
, ATTRIBUTE4
, ATTRIBUTE5
, ATTRIBUTE6
, ATTRIBUTE7
, ATTRIBUTE8
, ATTRIBUTE9
, ATTRIBUTE_CATEGORY
, CATEGORY_ID
, CATEGORY_SET_ID
, CREATED_BY
, CREATION_DATE
, CUSTOMER_ID
, INVENTORY_ITEM_ID
, LAST_UPDATED_BY
, LAST_UPDATE_DATE
, LAST_UPDATE_LOGIN
, ORGANIZATION_ID
, PROGRAM_APPLICATION_ID
, PROGRAM_ID
, PROGRAM_UPDATE_DATE
, REQUEST_ID
, SECONDARY_INVENTORY
, SHIP_TO_SITE_ID
, SOURCING_RULE_ID
, SOURCING_RULE_TYPE
FROM MRP_SR_ASSIGNMENTS
WHERE ( ASSIGNMENT_ID = p_Assignment_Id
)
OR ( ASSIGNMENT_SET_ID = p_Assignment_Set_Id
);
l_Assignment_rec.Last_Updated_By := l_implicit_rec.LAST_UPDATED_BY;
l_Assignment_rec.Last_Update_Date := l_implicit_rec.LAST_UPDATE_DATE;
l_Assignment_rec.Last_Update_Login := l_implicit_rec.LAST_UPDATE_LOGIN;
l_Assignment_rec.Program_Update_Date := l_implicit_rec.PROGRAM_UPDATE_DATE;
SELECT ASSIGNMENT_ID
, ASSIGNMENT_SET_ID
, ASSIGNMENT_TYPE
, ATTRIBUTE1
, ATTRIBUTE10
, ATTRIBUTE11
, ATTRIBUTE12
, ATTRIBUTE13
, ATTRIBUTE14
, ATTRIBUTE15
, ATTRIBUTE2
, ATTRIBUTE3
, ATTRIBUTE4
, ATTRIBUTE5
, ATTRIBUTE6
, ATTRIBUTE7
, ATTRIBUTE8
, ATTRIBUTE9
, ATTRIBUTE_CATEGORY
, CATEGORY_ID
, CATEGORY_SET_ID
, CREATED_BY
, CREATION_DATE
, CUSTOMER_ID
, INVENTORY_ITEM_ID
, LAST_UPDATED_BY
, LAST_UPDATE_DATE
, LAST_UPDATE_LOGIN
, ORGANIZATION_ID
, PROGRAM_APPLICATION_ID
, PROGRAM_ID
, PROGRAM_UPDATE_DATE
, REQUEST_ID
, SECONDARY_INVENTORY
, SHIP_TO_SITE_ID
, SOURCING_RULE_ID
, SOURCING_RULE_TYPE
FROM MRP_SR_ASSIGNMENTS
WHERE ( ASSIGNMENT_ID = p_Assignment_Id
)
OR ( ASSIGNMENT_SET_ID = p_Assignment_Set_Id
);
l_Assignment_rec.Last_Updated_By := l_implicit_rec.LAST_UPDATED_BY;
l_Assignment_rec.Last_Update_Date := l_implicit_rec.LAST_UPDATE_DATE;
l_Assignment_rec.Last_Update_Login := l_implicit_rec.LAST_UPDATE_LOGIN;
l_Assignment_rec.Program_Update_Date := l_implicit_rec.PROGRAM_UPDATE_DATE;