eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.OE_LINE_PRICE_AATTR_UTIL SQL Statements

The following lines contain the word 'select', 'insert', 'update' or 'delete':

Line: 40


		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;

Line: 97


 	x_Line_Adj_Att_Tbl(l_count).LAST_UPDATE_DATE	:= iml_rec.LAST_UPDATE_DATE;

Line: 98


 	x_Line_Adj_Att_Tbl(l_count).LAST_UPDATED_BY		:= iml_rec.LAST_UPDATED_BY;

Line: 99


 	x_Line_Adj_Att_Tbl(l_count).LAST_UPDATE_LOGIN	:= iml_rec.LAST_UPDATE_LOGIN;

Line: 102


 	x_Line_Adj_Att_Tbl(l_count).PROGRAM_UPDATE_DATE 		:= iml_rec.PROGRAM_UPDATE_DATE;

Line: 149


PROCEDURE Insert_Row
( p_Line_Adj_Att_Rec			IN OUT NOCOPY OE_Order_PUB.Line_Adj_Att_Rec_Type
)
IS
l_lock_control		NUMBER := 1;

Line: 160


   oe_debug_pub.add('Entering  Oe_Line_Price_Aattr_util.insert_row');

Line: 163


	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_Line_Adj_Att_Rec.PRICE_ADJUSTMENT_ID
		,p_Line_Adj_Att_Rec.PRICING_CONTEXT
 		,p_Line_Adj_Att_Rec.PRICING_ATTRIBUTE
 		,p_Line_Adj_Att_Rec.CREATION_DATE
 		,p_Line_Adj_Att_Rec.CREATED_BY
 		,p_Line_Adj_Att_Rec.LAST_UPDATE_DATE
 		,p_Line_Adj_Att_Rec.LAST_UPDATED_BY
 		,p_Line_Adj_Att_Rec.LAST_UPDATE_LOGIN
 		,p_Line_Adj_Att_Rec.PROGRAM_APPLICATION_ID
 		,p_Line_Adj_Att_Rec.PROGRAM_ID
 		,p_Line_Adj_Att_Rec.PROGRAM_UPDATE_DATE
 		,p_Line_Adj_Att_Rec.REQUEST_ID
 		,p_Line_Adj_Att_Rec.PRICING_ATTR_VALUE_FROM
		,p_Line_Adj_Att_Rec.PRICING_ATTR_VALUE_TO
 		,p_Line_Adj_Att_Rec.COMPARISON_OPERATOR
 		,p_Line_Adj_Att_Rec.FLEX_TITLE
 		,p_Line_Adj_Att_Rec.PRICE_ADJ_ATTRIB_ID
		,l_lock_control
	 );

Line: 207


   oe_debug_pub.add('Leaving  Oe_Line_Price_Aattr_util.insert_row');

Line: 218


	  ,   'Insert_Row'
	 );

Line: 223


     oe_debug_pub.add('Exceptions in Oe_Line_Price_Aattr_util.insert_row:'||SQLERRM);

Line: 228


END Insert_Row;

Line: 230


PROCEDURE Update_Row
( p_Line_Adj_Att_Rec			IN OUT NOCOPY OE_Order_PUB.Line_Adj_Att_Rec_Type
)
IS
l_lock_control		NUMBER;

Line: 240


 	SELECT 	lock_control
	INTO		l_lock_control
	FROM		OE_PRICE_ADJ_ATTRIBS
	WHERE	price_adj_attrib_id = p_Line_Adj_Att_rec.price_adj_attrib_id;

Line: 247


	UPDATE OE_PRICE_ADJ_ATTRIBS
	SET 	PRICE_ADJUSTMENT_ID    = p_Line_Adj_Att_Rec.Price_Adjustment_id
		,PRICING_CONTEXT    = p_Line_Adj_Att_Rec.Pricing_Context
 		,PRICING_ATTRIBUTE      = p_Line_Adj_Att_Rec.Pricing_Attribute
 		,CREATION_DATE          = p_Line_Adj_Att_Rec.creation_date
 		,CREATED_BY             = p_Line_Adj_Att_Rec.created_by
 		,LAST_UPDATE_DATE       = p_Line_Adj_Att_Rec.last_update_date
 		,LAST_UPDATED_BY        = p_Line_Adj_Att_Rec.last_updated_by
 		,LAST_UPDATE_LOGIN      = p_Line_Adj_Att_Rec.last_update_login
 		,PROGRAM_APPLICATION_ID = p_Line_Adj_Att_Rec.program_application_id
 		,PROGRAM_ID              = p_Line_Adj_Att_Rec.program_id
 		,PROGRAM_UPDATE_DATE     = p_Line_Adj_Att_Rec.program_update_date
 		,REQUEST_ID              = p_Line_Adj_Att_Rec.request_id
 		,PRICING_ATTR_VALUE_FROM = p_Line_Adj_Att_Rec.pricing_attr_value_from
		,PRICING_ATTR_VALUE_TO   = p_Line_Adj_Att_Rec.pricing_attr_value_to
 		,COMPARISON_OPERATOR     = p_Line_Adj_Att_Rec.comparison_operator
 		,FLEX_TITLE              = p_Line_Adj_Att_Rec.flex_title
 		,PRICE_ADJ_ATTRIB_ID     = p_Line_Adj_Att_Rec.price_adj_attrib_id
		,LOCK_CONTROL			= l_lock_control

	WHERE PRICE_ADJ_ATTRIB_ID  = p_Line_Adj_Att_Rec.price_adj_attrib_id;

Line: 280


			 ,   'Update_Row'
			);

Line: 287


END Update_Row ;

Line: 289


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;

Line: 302


        DELETE FROM OE_PRICE_ADJ_ATTRIBS
        WHERE PRICE_ADJUSTMENT_ID IN (SELECT RLTD_PRICE_ADJ_ID
				      FROM OE_PRICE_ADJ_ASSOCS ASSOCS,
				           OE_PRICE_ADJUSTMENTS PARENT
				      WHERE ASSOCS.PRICE_ADJUSTMENT_ID=PARENT.PRICE_ADJUSTMENT_ID
				      AND PARENT.PRICE_ADJUSTMENT_ID=p_price_adjustment_id
				      AND PARENT.LIST_LINE_TYPE_CODE='PBH');

Line: 310


	   oe_debug_pub.add('pviprana: Deleted '||SQL%ROWCOUNT||' pricing attributes of child lines');

Line: 315


	DELETE  FROM OE_PRICE_ADJ_ATTRIBS
	WHERE   PRICE_ADJUSTMENT_ID = p_price_adjustment_id;

Line: 319


	DELETE OE_PRICE_ADJ_ATTRIBS
	WHERE PRICE_ADJ_ATTRIB_ID   = p_price_adj_attrib_id;

Line: 330


		,   'Delete_Row'
		);

Line: 335


END Delete_Row;

Line: 369


    IF l_Line_Adj_Att_rec.LAST_UPDATE_DATE = FND_API.G_MISS_DATE THEN
        l_Line_Adj_Att_rec.LAST_UPDATE_DATE := p_old_Line_Adj_Att_rec.LAST_UPDATE_DATE;

Line: 373


    IF l_Line_Adj_Att_rec.LAST_UPDATED_BY = FND_API.G_MISS_NUM THEN
        l_Line_Adj_Att_rec.LAST_UPDATED_BY := p_old_Line_Adj_Att_rec.LAST_UPDATED_BY;

Line: 377


    IF l_Line_Adj_Att_rec.LAST_UPDATE_LOGIN = FND_API.G_MISS_NUM THEN
        l_Line_Adj_Att_rec.LAST_UPDATE_LOGIN := p_old_Line_Adj_Att_rec.LAST_UPDATE_LOGIN;

Line: 389


    IF l_Line_Adj_Att_rec.PROGRAM_UPDATE_DATE = FND_API.G_MISS_DATE THEN
        l_Line_Adj_Att_rec.PROGRAM_UPDATE_DATE := p_old_Line_Adj_Att_rec.PROGRAM_UPDATE_DATE;

Line: 452


    IF l_Line_Adj_Att_rec.LAST_UPDATE_DATE = FND_API.G_MISS_DATE THEN
        l_Line_Adj_Att_rec.LAST_UPDATE_DATE := Null;

Line: 456


    IF l_Line_Adj_Att_rec.LAST_UPDATED_BY = FND_API.G_MISS_NUM THEN
        l_Line_Adj_Att_rec.LAST_UPDATED_BY := Null;

Line: 460


    IF l_Line_Adj_Att_rec.LAST_UPDATE_LOGIN = FND_API.G_MISS_NUM THEN
        l_Line_Adj_Att_rec.LAST_UPDATE_LOGIN := Null;

Line: 472


    IF l_Line_Adj_Att_rec.PROGRAM_UPDATE_DATE = FND_API.G_MISS_DATE THEN
        l_Line_Adj_Att_rec.PROGRAM_UPDATE_DATE := Null;

Line: 552


    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;

Line: 638


            FND_MESSAGE.SET_NAME('ONT','OE_LOCK_ROW_DELETED');

Line: 674


  SELECT price_adj_attrib_id
  FROM   oe_price_adj_attribs
  WHERE  price_adjustment_id = p_price_adjustment_id
  FOR UPDATE NOWAIT;

Line: 710


    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;

Line: 755


        fnd_message.set_name('ONT','OE_LOCK_ROW_DELETED');