DBA Data[Home] [Help]

APPS.OE_HEADER_ADJ_ASSOCS_UTIL SQL Statements

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

Line: 40

		SELECT
		     PRICE_ADJUSTMENT_ID
			,CREATION_DATE
			,CREATED_BY
			,LAST_UPDATE_DATE
			,LAST_UPDATED_BY
			,LAST_UPDATE_LOGIN
			,PROGRAM_APPLICATION_ID
			,PROGRAM_ID
			,PROGRAM_UPDATE_DATE
			,REQUEST_ID
			,PRICE_ADJ_ASSOC_ID
			,LINE_ID
			,RLTD_PRICE_ADJ_ID
			,LOCK_CONTROL
		from oe_price_adj_Assocs where
		( PRICE_ADJ_assoc_ID =  p_price_adj_Assoc_id
			or price_adjustment_id = p_price_adjustment_id);
Line: 70

 	x_Header_Adj_Assoc_Tbl(l_count).LAST_UPDATE_DATE		:= iml_rec.LAST_UPDATE_DATE;
Line: 71

 	x_Header_Adj_Assoc_Tbl(l_count).LAST_UPDATED_BY		:= iml_rec.LAST_UPDATED_BY;
Line: 72

 	x_Header_Adj_Assoc_Tbl(l_count).LAST_UPDATE_LOGIN		:= iml_rec.LAST_UPDATE_LOGIN;
Line: 75

 	x_Header_Adj_Assoc_Tbl(l_count).PROGRAM_UPDATE_DATE 	:= iml_rec.PROGRAM_UPDATE_DATE;
Line: 123

PROCEDURE Insert_Row
( p_Header_Adj_Assoc_Rec		IN OUT NOCOPY	OE_Order_PUB.Header_Adj_Assoc_Rec_Type
)
IS
l_lock_control		NUMBER := 1;
Line: 134

	INSERT INTO OE_PRICE_ADJ_ASSOCS
	( 	PRICE_ADJUSTMENT_ID
 		,CREATION_DATE
 		,CREATED_BY
 		,LAST_UPDATE_DATE
 		,LAST_UPDATED_BY
 		,LAST_UPDATE_LOGIN
 		,PROGRAM_APPLICATION_ID
 		,PROGRAM_ID
 		,PROGRAM_UPDATE_DATE
 		,REQUEST_ID
 		,PRICE_ADJ_ASSOC_ID
		,LINE_ID
		,RLTD_PRICE_ADJ_ID
		,LOCK_CONTROL
	)
	VALUES
	( 	p_Header_Adj_Assoc_Rec.PRICE_ADJUSTMENT_ID
 		,p_Header_Adj_Assoc_Rec.CREATION_DATE
 		,p_Header_Adj_Assoc_Rec.CREATED_BY
 		,p_Header_Adj_Assoc_Rec.LAST_UPDATE_DATE
 		,p_Header_Adj_Assoc_Rec.LAST_UPDATED_BY
 		,p_Header_Adj_Assoc_Rec.LAST_UPDATE_LOGIN
 		,p_Header_Adj_Assoc_Rec.PROGRAM_APPLICATION_ID
 		,p_Header_Adj_Assoc_Rec.PROGRAM_ID
 		,p_Header_Adj_Assoc_Rec.PROGRAM_UPDATE_DATE
 		,p_Header_Adj_Assoc_Rec.REQUEST_ID
 		,p_Header_Adj_Assoc_Rec.PRICE_ADJ_ASSOC_ID
 		,p_Header_Adj_Assoc_Rec.LINE_ID
 		,p_Header_Adj_Assoc_Rec.RLTD_PRICE_ADJ_ID
		,l_lock_control
	 );
Line: 177

	  ,   'Insert_Row'
	 );
Line: 182

END Insert_Row;
Line: 184

PROCEDURE Update_Row
( p_Header_Adj_Assoc_Rec			IN OUT NOCOPY OE_Order_PUB.Header_Adj_Assoc_Rec_Type
)
IS
l_lock_control		NUMBER;
Line: 195

 	SELECT 	lock_control
	INTO		l_lock_control
	FROM		OE_PRICE_ADJ_ASSOCS
	WHERE	price_adj_assoc_id = p_Header_Adj_Assoc_rec.price_adj_assoc_id;
Line: 202

	UPDATE OE_PRICE_ADJ_ASSOCS
	SET 	PRICE_ADJUSTMENT_ID    = p_Header_Adj_Assoc_Rec.Price_Adjustment_id
 		,CREATION_DATE          = p_Header_Adj_Assoc_Rec.creation_date
 		,CREATED_BY             = p_Header_Adj_Assoc_Rec.created_by
 		,LAST_UPDATE_DATE       = p_Header_Adj_Assoc_Rec.last_update_date
 		,LAST_UPDATED_BY        = p_Header_Adj_Assoc_Rec.last_updated_by
 		,LAST_UPDATE_LOGIN      = p_Header_Adj_Assoc_Rec.last_update_login
 		,PROGRAM_APPLICATION_ID = p_Header_Adj_Assoc_Rec.program_application_id
 		,PROGRAM_ID              = p_Header_Adj_Assoc_Rec.program_id
 		,PROGRAM_UPDATE_DATE     = p_Header_Adj_Assoc_Rec.program_update_date
 		,REQUEST_ID              = p_Header_Adj_Assoc_Rec.request_id
 		,LINE_ID     = p_Header_Adj_Assoc_Rec.Line_id
 		,RLTD_PRICE_ADJ_ID     = p_Header_Adj_Assoc_Rec.rltd_price_adj_id
		,LOCK_CONTROL		  	= l_lock_control

	WHERE PRICE_ADJ_ASSOC_ID  = p_Header_Adj_Assoc_Rec.price_adj_Assoc_id;
Line: 229

			 ,   'Update_Row'
			);
Line: 236

END Update_Row ;
Line: 238

PROCEDURE Delete_Row
( p_price_adj_Assoc_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: 249

        DELETE OE_PRICE_ADJ_ASSOCS opaa
        WHERE opaa.price_adjustment_id   = p_price_adjustment_id;
Line: 251

        DELETE OE_PRICE_ADJ_ASSOCS opaa
        WHERE  opaa.rltd_price_adj_id = p_price_adjustment_id;
Line: 254

	DELETE OE_PRICE_ADJ_ASSOCS
	WHERE PRICE_ADJ_Assoc_ID   = p_price_adj_Assoc_id;
Line: 264

		,   'Delete_Row'
		);
Line: 268

END Delete_Row;
Line: 300

    IF l_Header_Adj_Assoc_Rec.LAST_UPDATE_DATE = FND_API.G_MISS_DATE THEN
        l_Header_Adj_Assoc_Rec.LAST_UPDATE_DATE := p_old_Header_Adj_Assoc_Rec.LAST_UPDATE_DATE;
Line: 304

    IF l_Header_Adj_Assoc_Rec.LAST_UPDATED_BY = FND_API.G_MISS_NUM THEN
        l_Header_Adj_Assoc_Rec.LAST_UPDATED_BY := p_old_Header_Adj_Assoc_Rec.LAST_UPDATED_BY;
Line: 308

    IF l_Header_Adj_Assoc_Rec.LAST_UPDATE_LOGIN = FND_API.G_MISS_NUM THEN
        l_Header_Adj_Assoc_Rec.LAST_UPDATE_LOGIN := p_old_Header_Adj_Assoc_Rec.LAST_UPDATE_LOGIN;
Line: 320

    IF l_Header_Adj_Assoc_Rec.PROGRAM_UPDATE_DATE = FND_API.G_MISS_DATE THEN
        l_Header_Adj_Assoc_Rec.PROGRAM_UPDATE_DATE := p_old_Header_Adj_Assoc_Rec.PROGRAM_UPDATE_DATE;
Line: 366

    IF l_Header_Adj_Assoc_Rec.LAST_UPDATE_DATE = FND_API.G_MISS_DATE THEN
        l_Header_Adj_Assoc_Rec.LAST_UPDATE_DATE := Null;
Line: 370

    IF l_Header_Adj_Assoc_Rec.LAST_UPDATED_BY = FND_API.G_MISS_NUM THEN
        l_Header_Adj_Assoc_Rec.LAST_UPDATED_BY := Null;
Line: 374

    IF l_Header_Adj_Assoc_Rec.LAST_UPDATE_LOGIN = FND_API.G_MISS_NUM THEN
        l_Header_Adj_Assoc_Rec.LAST_UPDATE_LOGIN := Null;
Line: 386

    IF l_Header_Adj_Assoc_Rec.PROGRAM_UPDATE_DATE = FND_API.G_MISS_DATE THEN
        l_Header_Adj_Assoc_Rec.PROGRAM_UPDATE_DATE := Null;
Line: 454

    SELECT price_adj_assoc_id
    INTO   l_price_adj_assoc_id
    FROM   oe_price_adj_assocs
    WHERE  price_adj_assoc_id = l_price_adj_assoc_id
    FOR UPDATE NOWAIT;
Line: 541

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

  SELECT price_adj_assoc_id
  FROM   oe_price_adj_assocs
  WHERE  price_adjustment_id = p_price_adjustment_id
  FOR UPDATE NOWAIT;
Line: 613

    SELECT price_adj_assoc_id
    INTO   l_price_adj_assoc_id
    FROM   oe_price_adj_assocs
    WHERE  price_adj_assoc_id = p_price_adj_assoc_id
    FOR UPDATE NOWAIT;
Line: 658

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