DBA Data[Home] [Help]

APPS.OE_HEADER_PRICE_AATTR_UTIL SQL Statements

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

Line: 38

		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: 95

 	x_Header_Adj_Att_Tbl(l_count).LAST_UPDATE_DATE	:=	iml_rec.LAST_UPDATE_DATE;
Line: 96

 	x_Header_Adj_Att_Tbl(l_count).LAST_UPDATED_BY	:=	iml_rec.LAST_UPDATED_BY;
Line: 97

 	x_Header_Adj_Att_Tbl(l_count).LAST_UPDATE_LOGIN	:=	iml_rec.LAST_UPDATE_LOGIN;
Line: 100

 	x_Header_Adj_Att_Tbl(l_count).PROGRAM_UPDATE_DATE 	:= iml_rec.PROGRAM_UPDATE_DATE;
Line: 149

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;
Line: 160

	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
	 );
Line: 211

	  ,   'Insert_Row'
	 );
Line: 216

END Insert_Row;
Line: 218

PROCEDURE Update_Row
( p_Header_Adj_Att_Rec			IN OUT NOCOPY OE_Order_PUB.Header_Adj_Att_Rec_Type
)
IS
l_lock_control		NUMBER;
Line: 228

 	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;
Line: 235

	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;
Line: 268

			 ,   'Update_Row'
			);
Line: 275

END Update_Row ;
Line: 277

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: 289

	DELETE OE_PRICE_ADJ_ATTRIBS
	WHERE price_adjustment_id   = p_price_adjustment_id;
Line: 292

	DELETE OE_PRICE_ADJ_ATTRIBS
	WHERE PRICE_ADJ_ATTRIB_ID   = p_price_adj_attrib_id;
Line: 303

		,   'Delete_Row'
		);
Line: 308

END Delete_Row;
Line: 342

    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;
Line: 346

    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;
Line: 350

    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;
Line: 362

    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;
Line: 425

    IF l_Header_Adj_Att_rec.LAST_UPDATE_DATE = FND_API.G_MISS_DATE THEN
        l_Header_Adj_Att_rec.LAST_UPDATE_DATE := Null;
Line: 429

    IF l_Header_Adj_Att_rec.LAST_UPDATED_BY = FND_API.G_MISS_NUM THEN
        l_Header_Adj_Att_rec.LAST_UPDATED_BY := Null;
Line: 433

    IF l_Header_Adj_Att_rec.LAST_UPDATE_LOGIN = FND_API.G_MISS_NUM THEN
        l_Header_Adj_Att_rec.LAST_UPDATE_LOGIN := Null;
Line: 445

    IF l_Header_Adj_Att_rec.PROGRAM_UPDATE_DATE = FND_API.G_MISS_DATE THEN
        l_Header_Adj_Att_rec.PROGRAM_UPDATE_DATE := Null;
Line: 525

    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: 612

            FND_MESSAGE.SET_NAME('ONT','OE_LOCK_ROW_DELETED');
Line: 648

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

    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: 729

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