The following lines contain the word 'select', 'insert', 'update' or 'delete':
SELECT
PRICE_ADJUSTMENT_ID
,PRICING_CONTEXT
,PRICING_ATTRIBUTE
,CREATION_DATE
,CREATED_BY
,LAST_UPDATE_DATE
,LAST_UPDATED_BY
,LAST_UPDATE_LOGIN
,PROGRAM_APPLICATION_ID
,PROGRAM_ID
,PROGRAM_UPDATE_DATE
,REQUEST_ID
,PRICING_ATTR_VALUE_FROM
,PRICING_ATTR_VALUE_TO
,COMPARISON_OPERATOR
,FLEX_TITLE
,PRICE_ADJ_ATTRIB_ID
,LOCK_CONTROL
from oe_price_adj_attribs where
PRICE_ADJ_ATTRIB_ID = p_price_adj_attrib_id
Union all
SELECT
PRICE_ADJUSTMENT_ID
,PRICING_CONTEXT
,PRICING_ATTRIBUTE
,CREATION_DATE
,CREATED_BY
,LAST_UPDATE_DATE
,LAST_UPDATED_BY
,LAST_UPDATE_LOGIN
,PROGRAM_APPLICATION_ID
,PROGRAM_ID
,PROGRAM_UPDATE_DATE
,REQUEST_ID
,PRICING_ATTR_VALUE_FROM
,PRICING_ATTR_VALUE_TO
,COMPARISON_OPERATOR
,FLEX_TITLE
,PRICE_ADJ_ATTRIB_ID
,LOCK_CONTROL
from oe_price_adj_attribs where
price_adjustment_id = p_price_adjustment_id;
x_Header_Adj_Att_Tbl(l_count).LAST_UPDATE_DATE := iml_rec.LAST_UPDATE_DATE;
x_Header_Adj_Att_Tbl(l_count).LAST_UPDATED_BY := iml_rec.LAST_UPDATED_BY;
x_Header_Adj_Att_Tbl(l_count).LAST_UPDATE_LOGIN := iml_rec.LAST_UPDATE_LOGIN;
x_Header_Adj_Att_Tbl(l_count).PROGRAM_UPDATE_DATE := iml_rec.PROGRAM_UPDATE_DATE;
PROCEDURE Insert_Row
( p_Header_Adj_Att_Rec IN OUT NOCOPY OE_Order_PUB.Header_Adj_Att_Rec_Type
)
IS
l_lock_control NUMBER := 1;
INSERT INTO OE_PRICE_ADJ_ATTRIBS
( PRICE_ADJUSTMENT_ID
,PRICING_CONTEXT
,PRICING_ATTRIBUTE
,CREATION_DATE
,CREATED_BY
,LAST_UPDATE_DATE
,LAST_UPDATED_BY
,LAST_UPDATE_LOGIN
,PROGRAM_APPLICATION_ID
,PROGRAM_ID
,PROGRAM_UPDATE_DATE
,REQUEST_ID
,PRICING_ATTR_VALUE_FROM
,PRICING_ATTR_VALUE_TO
,COMPARISON_OPERATOR
,FLEX_TITLE
,PRICE_ADJ_ATTRIB_ID
,LOCK_CONTROL
)
VALUES
( p_Header_Adj_Att_Rec.PRICE_ADJUSTMENT_ID
,p_Header_Adj_Att_Rec.PRICING_CONTEXT
,p_Header_Adj_Att_Rec.PRICING_ATTRIBUTE
,p_Header_Adj_Att_Rec.CREATION_DATE
,p_Header_Adj_Att_Rec.CREATED_BY
,p_Header_Adj_Att_Rec.LAST_UPDATE_DATE
,p_Header_Adj_Att_Rec.LAST_UPDATED_BY
,p_Header_Adj_Att_Rec.LAST_UPDATE_LOGIN
,p_Header_Adj_Att_Rec.PROGRAM_APPLICATION_ID
,p_Header_Adj_Att_Rec.PROGRAM_ID
,p_Header_Adj_Att_Rec.PROGRAM_UPDATE_DATE
,p_Header_Adj_Att_Rec.REQUEST_ID
,p_Header_Adj_Att_Rec.PRICING_ATTR_VALUE_FROM
,p_Header_Adj_Att_Rec.PRICING_ATTR_VALUE_TO
,p_Header_Adj_Att_Rec.COMPARISON_OPERATOR
,p_Header_Adj_Att_Rec.FLEX_TITLE
,p_Header_Adj_Att_Rec.PRICE_ADJ_ATTRIB_ID
,l_lock_control
);
, 'Insert_Row'
);
END Insert_Row;
PROCEDURE Update_Row
( p_Header_Adj_Att_Rec IN OUT NOCOPY OE_Order_PUB.Header_Adj_Att_Rec_Type
)
IS
l_lock_control NUMBER;
SELECT lock_control
INTO l_lock_control
FROM OE_PRICE_ADJ_ATTRIBS
WHERE price_adj_attrib_id = p_Header_Adj_Att_rec.price_adj_attrib_id;
UPDATE OE_PRICE_ADJ_ATTRIBS
SET PRICE_ADJUSTMENT_ID = p_Header_Adj_Att_Rec.Price_Adjustment_id
,PRICING_CONTEXT = p_Header_Adj_Att_Rec.Pricing_Context
,PRICING_ATTRIBUTE = p_Header_Adj_Att_Rec.Pricing_Attribute
,CREATION_DATE = p_Header_Adj_Att_Rec.creation_date
,CREATED_BY = p_Header_Adj_Att_Rec.created_by
,LAST_UPDATE_DATE = p_Header_Adj_Att_Rec.last_update_date
,LAST_UPDATED_BY = p_Header_Adj_Att_Rec.last_updated_by
,LAST_UPDATE_LOGIN = p_Header_Adj_Att_Rec.last_update_login
,PROGRAM_APPLICATION_ID = p_Header_Adj_Att_Rec.program_application_id
,PROGRAM_ID = p_Header_Adj_Att_Rec.program_id
,PROGRAM_UPDATE_DATE = p_Header_Adj_Att_Rec.program_update_date
,REQUEST_ID = p_Header_Adj_Att_Rec.request_id
,PRICING_ATTR_VALUE_FROM = p_Header_Adj_Att_Rec.pricing_attr_value_from
,PRICING_ATTR_VALUE_TO = p_Header_Adj_Att_Rec.pricing_attr_value_to
,COMPARISON_OPERATOR = p_Header_Adj_Att_Rec.comparison_operator
,FLEX_TITLE = p_Header_Adj_Att_Rec.flex_title
,PRICE_ADJ_ATTRIB_ID = p_Header_Adj_Att_Rec.price_adj_attrib_id
,LOCK_CONTROL = l_lock_control
WHERE PRICE_ADJ_ATTRIB_ID = p_Header_Adj_Att_Rec.price_adj_attrib_id;
, 'Update_Row'
);
END Update_Row ;
PROCEDURE Delete_Row
( p_price_adj_attrib_id NUMBER := FND_API.G_MISS_NUM
, p_price_adjustment_id NUMBER := FND_API.G_MISS_NUM
)
IS
--
l_debug_level CONSTANT NUMBER := oe_debug_pub.g_debug_level;
DELETE OE_PRICE_ADJ_ATTRIBS
WHERE price_adjustment_id = p_price_adjustment_id;
DELETE OE_PRICE_ADJ_ATTRIBS
WHERE PRICE_ADJ_ATTRIB_ID = p_price_adj_attrib_id;
, 'Delete_Row'
);
END Delete_Row;
IF l_Header_Adj_Att_rec.LAST_UPDATE_DATE = FND_API.G_MISS_DATE THEN
l_Header_Adj_Att_rec.LAST_UPDATE_DATE := p_old_Header_Adj_Att_rec.LAST_UPDATE_DATE;
IF l_Header_Adj_Att_rec.LAST_UPDATED_BY = FND_API.G_MISS_NUM THEN
l_Header_Adj_Att_rec.LAST_UPDATED_BY := p_old_Header_Adj_Att_rec.LAST_UPDATED_BY;
IF l_Header_Adj_Att_rec.LAST_UPDATE_LOGIN = FND_API.G_MISS_NUM THEN
l_Header_Adj_Att_rec.LAST_UPDATE_LOGIN := p_old_Header_Adj_Att_rec.LAST_UPDATE_LOGIN;
IF l_Header_Adj_Att_rec.PROGRAM_UPDATE_DATE = FND_API.G_MISS_DATE THEN
l_Header_Adj_Att_rec.PROGRAM_UPDATE_DATE := p_old_Header_Adj_Att_rec.PROGRAM_UPDATE_DATE;
IF l_Header_Adj_Att_rec.LAST_UPDATE_DATE = FND_API.G_MISS_DATE THEN
l_Header_Adj_Att_rec.LAST_UPDATE_DATE := Null;
IF l_Header_Adj_Att_rec.LAST_UPDATED_BY = FND_API.G_MISS_NUM THEN
l_Header_Adj_Att_rec.LAST_UPDATED_BY := Null;
IF l_Header_Adj_Att_rec.LAST_UPDATE_LOGIN = FND_API.G_MISS_NUM THEN
l_Header_Adj_Att_rec.LAST_UPDATE_LOGIN := Null;
IF l_Header_Adj_Att_rec.PROGRAM_UPDATE_DATE = FND_API.G_MISS_DATE THEN
l_Header_Adj_Att_rec.PROGRAM_UPDATE_DATE := Null;
SELECT price_adj_attrib_id
INTO l_price_adj_attrib_id
FROM oe_price_adj_attribs
WHERE price_adj_attrib_id = l_price_adj_attrib_id
FOR UPDATE NOWAIT;
FND_MESSAGE.SET_NAME('ONT','OE_LOCK_ROW_DELETED');
SELECT price_adj_attrib_id
FROM oe_price_adj_attribs
WHERE price_adjustment_id = p_price_adjustment_id
FOR UPDATE NOWAIT;
SELECT price_adj_attrib_id
INTO l_price_adj_attrib_id
FROM oe_price_adj_attribs
WHERE price_adj_attrib_id = p_price_adj_attrib_id
FOR UPDATE NOWAIT;
fnd_message.set_name('ONT','OE_LOCK_ROW_DELETED');