[Home] [Help]
The following lines contain the word 'select', 'insert', 'update' or 'delete':
SELECT
HEADER_ID
,LINE_ID
,CREATION_DATE
,CREATED_BY
,LAST_UPDATE_DATE
,LAST_UPDATED_BY
,LAST_UPDATE_LOGIN
,PROGRAM_APPLICATION_ID
,PROGRAM_ID
,PROGRAM_UPDATE_DATE
,REQUEST_ID
,PRICING_CONTEXT
,PRICING_ATTRIBUTE1
,PRICING_ATTRIBUTE2
,PRICING_ATTRIBUTE3
,PRICING_ATTRIBUTE4
,PRICING_ATTRIBUTE5
,PRICING_ATTRIBUTE6
,PRICING_ATTRIBUTE7
,PRICING_ATTRIBUTE8
,PRICING_ATTRIBUTE9
,PRICING_ATTRIBUTE10
,PRICING_ATTRIBUTE11
,PRICING_ATTRIBUTE12
,PRICING_ATTRIBUTE13
,PRICING_ATTRIBUTE14
,PRICING_ATTRIBUTE15
,PRICING_ATTRIBUTE16
,PRICING_ATTRIBUTE17
,PRICING_ATTRIBUTE18
,PRICING_ATTRIBUTE19
,PRICING_ATTRIBUTE20
,PRICING_ATTRIBUTE21
,PRICING_ATTRIBUTE22
,PRICING_ATTRIBUTE23
,PRICING_ATTRIBUTE24
,PRICING_ATTRIBUTE25
,PRICING_ATTRIBUTE26
,PRICING_ATTRIBUTE27
,PRICING_ATTRIBUTE28
,PRICING_ATTRIBUTE29
,PRICING_ATTRIBUTE30
,PRICING_ATTRIBUTE31
,PRICING_ATTRIBUTE32
,PRICING_ATTRIBUTE33
,PRICING_ATTRIBUTE34
,PRICING_ATTRIBUTE35
,PRICING_ATTRIBUTE36
,PRICING_ATTRIBUTE37
,PRICING_ATTRIBUTE38
,PRICING_ATTRIBUTE39
,PRICING_ATTRIBUTE40
,PRICING_ATTRIBUTE41
,PRICING_ATTRIBUTE42
,PRICING_ATTRIBUTE43
,PRICING_ATTRIBUTE44
,PRICING_ATTRIBUTE45
,PRICING_ATTRIBUTE46
,PRICING_ATTRIBUTE47
,PRICING_ATTRIBUTE48
,PRICING_ATTRIBUTE49
,PRICING_ATTRIBUTE50
,PRICING_ATTRIBUTE51
,PRICING_ATTRIBUTE52
,PRICING_ATTRIBUTE53
,PRICING_ATTRIBUTE54
,PRICING_ATTRIBUTE55
,PRICING_ATTRIBUTE56
,PRICING_ATTRIBUTE57
,PRICING_ATTRIBUTE58
,PRICING_ATTRIBUTE59
,PRICING_ATTRIBUTE60
,PRICING_ATTRIBUTE61
,PRICING_ATTRIBUTE62
,PRICING_ATTRIBUTE63
,PRICING_ATTRIBUTE64
,PRICING_ATTRIBUTE65
,PRICING_ATTRIBUTE66
,PRICING_ATTRIBUTE67
,PRICING_ATTRIBUTE68
,PRICING_ATTRIBUTE69
,PRICING_ATTRIBUTE70
,PRICING_ATTRIBUTE71
,PRICING_ATTRIBUTE72
,PRICING_ATTRIBUTE73
,PRICING_ATTRIBUTE74
,PRICING_ATTRIBUTE75
,PRICING_ATTRIBUTE76
,PRICING_ATTRIBUTE77
,PRICING_ATTRIBUTE78
,PRICING_ATTRIBUTE79
,PRICING_ATTRIBUTE80
,PRICING_ATTRIBUTE81
,PRICING_ATTRIBUTE82
,PRICING_ATTRIBUTE83
,PRICING_ATTRIBUTE84
,PRICING_ATTRIBUTE85
,PRICING_ATTRIBUTE86
,PRICING_ATTRIBUTE87
,PRICING_ATTRIBUTE88
,PRICING_ATTRIBUTE89
,PRICING_ATTRIBUTE90
,PRICING_ATTRIBUTE91
,PRICING_ATTRIBUTE92
,PRICING_ATTRIBUTE93
,PRICING_ATTRIBUTE94
,PRICING_ATTRIBUTE95
,PRICING_ATTRIBUTE96
,PRICING_ATTRIBUTE97
,PRICING_ATTRIBUTE98
,PRICING_ATTRIBUTE99
,PRICING_ATTRIBUTE100
,CONTEXT
,ATTRIBUTE1
,ATTRIBUTE2
,ATTRIBUTE3
,ATTRIBUTE4
,ATTRIBUTE5
,ATTRIBUTE6
,ATTRIBUTE7
,ATTRIBUTE8
,ATTRIBUTE9
,ATTRIBUTE10
,ATTRIBUTE11
,ATTRIBUTE12
,ATTRIBUTE13
,ATTRIBUTE14
,ATTRIBUTE15
,FLEX_TITLE
,ORDER_PRICE_ATTRIB_ID
,OVERRIDE_FLAG
,LOCK_CONTROL
,ORIG_SYS_ATTS_REF
FROM OE_ORDER_PRICE_ATTRIBS
WHERE ( ORDER_PRICE_ATTRIB_ID = p_order_price_attrib_id
Or line_id = p_Line_Id );
x_line_price_att_tbl(l_count).last_updated_by := imp_rec.last_updated_by;
x_line_price_att_tbl(l_count).last_update_date := imp_rec.last_update_date;
/* Insert Row */
PROCEDURE Insert_Row
( p_Line_Price_Att_rec IN OUT NOCOPY OE_Order_PUB.Line_Price_Att_Rec_Type
)
IS
l_lock_control NUMBER := 1;
oe_debug_pub.add('Entering OE_Line_Patt_UTIL.INSERT_ROW', 1);
INSERT INTO OE_ORDER_PRICE_ATTRIBS
( HEADER_ID
,LINE_ID
,CREATION_DATE
,CREATED_BY
,LAST_UPDATE_DATE
,LAST_UPDATED_BY
,LAST_UPDATE_LOGIN
,PROGRAM_APPLICATION_ID
,PROGRAM_ID
,PROGRAM_UPDATE_DATE
,REQUEST_ID
,PRICING_CONTEXT
,PRICING_ATTRIBUTE1
,PRICING_ATTRIBUTE2
,PRICING_ATTRIBUTE3
,PRICING_ATTRIBUTE4
,PRICING_ATTRIBUTE5
,PRICING_ATTRIBUTE6
,PRICING_ATTRIBUTE7
,PRICING_ATTRIBUTE8
,PRICING_ATTRIBUTE9
,PRICING_ATTRIBUTE10
,PRICING_ATTRIBUTE11
,PRICING_ATTRIBUTE12
,PRICING_ATTRIBUTE13
,PRICING_ATTRIBUTE14
,PRICING_ATTRIBUTE15
,PRICING_ATTRIBUTE16
,PRICING_ATTRIBUTE17
,PRICING_ATTRIBUTE18
,PRICING_ATTRIBUTE19
,PRICING_ATTRIBUTE20
,PRICING_ATTRIBUTE21
,PRICING_ATTRIBUTE22
,PRICING_ATTRIBUTE23
,PRICING_ATTRIBUTE24
,PRICING_ATTRIBUTE25
,PRICING_ATTRIBUTE26
,PRICING_ATTRIBUTE27
,PRICING_ATTRIBUTE28
,PRICING_ATTRIBUTE29
,PRICING_ATTRIBUTE30
,PRICING_ATTRIBUTE31
,PRICING_ATTRIBUTE32
,PRICING_ATTRIBUTE33
,PRICING_ATTRIBUTE34
,PRICING_ATTRIBUTE35
,PRICING_ATTRIBUTE36
,PRICING_ATTRIBUTE37
,PRICING_ATTRIBUTE38
,PRICING_ATTRIBUTE39
,PRICING_ATTRIBUTE40
,PRICING_ATTRIBUTE41
,PRICING_ATTRIBUTE42
,PRICING_ATTRIBUTE43
,PRICING_ATTRIBUTE44
,PRICING_ATTRIBUTE45
,PRICING_ATTRIBUTE46
,PRICING_ATTRIBUTE47
,PRICING_ATTRIBUTE48
,PRICING_ATTRIBUTE49
,PRICING_ATTRIBUTE50
,PRICING_ATTRIBUTE51
,PRICING_ATTRIBUTE52
,PRICING_ATTRIBUTE53
,PRICING_ATTRIBUTE54
,PRICING_ATTRIBUTE55
,PRICING_ATTRIBUTE56
,PRICING_ATTRIBUTE57
,PRICING_ATTRIBUTE58
,PRICING_ATTRIBUTE59
,PRICING_ATTRIBUTE60
,PRICING_ATTRIBUTE61
,PRICING_ATTRIBUTE62
,PRICING_ATTRIBUTE63
,PRICING_ATTRIBUTE64
,PRICING_ATTRIBUTE65
,PRICING_ATTRIBUTE66
,PRICING_ATTRIBUTE67
,PRICING_ATTRIBUTE68
,PRICING_ATTRIBUTE69
,PRICING_ATTRIBUTE70
,PRICING_ATTRIBUTE71
,PRICING_ATTRIBUTE72
,PRICING_ATTRIBUTE73
,PRICING_ATTRIBUTE74
,PRICING_ATTRIBUTE75
,PRICING_ATTRIBUTE76
,PRICING_ATTRIBUTE77
,PRICING_ATTRIBUTE78
,PRICING_ATTRIBUTE79
,PRICING_ATTRIBUTE80
,PRICING_ATTRIBUTE81
,PRICING_ATTRIBUTE82
,PRICING_ATTRIBUTE83
,PRICING_ATTRIBUTE84
,PRICING_ATTRIBUTE85
,PRICING_ATTRIBUTE86
,PRICING_ATTRIBUTE87
,PRICING_ATTRIBUTE88
,PRICING_ATTRIBUTE89
,PRICING_ATTRIBUTE90
,PRICING_ATTRIBUTE91
,PRICING_ATTRIBUTE92
,PRICING_ATTRIBUTE93
,PRICING_ATTRIBUTE94
,PRICING_ATTRIBUTE95
,PRICING_ATTRIBUTE96
,PRICING_ATTRIBUTE97
,PRICING_ATTRIBUTE98
,PRICING_ATTRIBUTE99
,PRICING_ATTRIBUTE100
,CONTEXT
,ATTRIBUTE1
,ATTRIBUTE2
,ATTRIBUTE3
,ATTRIBUTE4
,ATTRIBUTE5
,ATTRIBUTE6
,ATTRIBUTE7
,ATTRIBUTE8
,ATTRIBUTE9
,ATTRIBUTE10
,ATTRIBUTE11
,ATTRIBUTE12
,ATTRIBUTE13
,ATTRIBUTE14
,ATTRIBUTE15
,FLEX_TITLE
,ORDER_PRICE_ATTRIB_ID
,OVERRIDE_FLAG
,LOCK_CONTROL
,ORIG_SYS_ATTS_REF
)
VALUES
( p_Line_Price_Att_rec.HEADER_ID
,p_Line_Price_Att_rec.LINE_ID
,p_Line_Price_Att_rec.CREATION_DATE
,p_Line_Price_Att_rec.CREATED_BY
,p_Line_Price_Att_rec.LAST_UPDATE_DATE
,p_Line_Price_Att_rec.LAST_UPDATED_BY
,p_Line_Price_Att_rec.LAST_UPDATE_LOGIN
,p_Line_Price_Att_rec.PROGRAM_APPLICATION_ID
,p_Line_Price_Att_rec.PROGRAM_ID
,p_Line_Price_Att_rec.PROGRAM_UPDATE_DATE
,p_Line_Price_Att_rec.REQUEST_ID
,p_Line_Price_Att_rec.PRICING_CONTEXT
,p_Line_Price_Att_rec.PRICING_ATTRIBUTE1
,p_Line_Price_Att_rec.PRICING_ATTRIBUTE2
,p_Line_Price_Att_rec.PRICING_ATTRIBUTE3
,p_Line_Price_Att_rec.PRICING_ATTRIBUTE4
,p_Line_Price_Att_rec.PRICING_ATTRIBUTE5
,p_Line_Price_Att_rec.PRICING_ATTRIBUTE6
,p_Line_Price_Att_rec.PRICING_ATTRIBUTE7
,p_Line_Price_Att_rec.PRICING_ATTRIBUTE8
,p_Line_Price_Att_rec.PRICING_ATTRIBUTE9
,p_Line_Price_Att_rec.PRICING_ATTRIBUTE10
,p_Line_Price_Att_rec.PRICING_ATTRIBUTE11
,p_Line_Price_Att_rec.PRICING_ATTRIBUTE12
,p_Line_Price_Att_rec.PRICING_ATTRIBUTE13
,p_Line_Price_Att_rec.PRICING_ATTRIBUTE14
,p_Line_Price_Att_rec.PRICING_ATTRIBUTE15
,p_Line_Price_Att_rec.PRICING_ATTRIBUTE16
,p_Line_Price_Att_rec.PRICING_ATTRIBUTE17
,p_Line_Price_Att_rec.PRICING_ATTRIBUTE18
,p_Line_Price_Att_rec.PRICING_ATTRIBUTE19
,p_Line_Price_Att_rec.PRICING_ATTRIBUTE20
,p_Line_Price_Att_rec.PRICING_ATTRIBUTE21
,p_Line_Price_Att_rec.PRICING_ATTRIBUTE22
,p_Line_Price_Att_rec.PRICING_ATTRIBUTE23
,p_Line_Price_Att_rec.PRICING_ATTRIBUTE24
,p_Line_Price_Att_rec.PRICING_ATTRIBUTE25
,p_Line_Price_Att_rec.PRICING_ATTRIBUTE26
,p_Line_Price_Att_rec.PRICING_ATTRIBUTE27
,p_Line_Price_Att_rec.PRICING_ATTRIBUTE28
,p_Line_Price_Att_rec.PRICING_ATTRIBUTE29
,p_Line_Price_Att_rec.PRICING_ATTRIBUTE30
,p_Line_Price_Att_rec.PRICING_ATTRIBUTE31
,p_Line_Price_Att_rec.PRICING_ATTRIBUTE32
,p_Line_Price_Att_rec.PRICING_ATTRIBUTE33
,p_Line_Price_Att_rec.PRICING_ATTRIBUTE34
,p_Line_Price_Att_rec.PRICING_ATTRIBUTE35
,p_Line_Price_Att_rec.PRICING_ATTRIBUTE36
,p_Line_Price_Att_rec.PRICING_ATTRIBUTE37
,p_Line_Price_Att_rec.PRICING_ATTRIBUTE38
,p_Line_Price_Att_rec.PRICING_ATTRIBUTE39
,p_Line_Price_Att_rec.PRICING_ATTRIBUTE40
,p_Line_Price_Att_rec.PRICING_ATTRIBUTE41
,p_Line_Price_Att_rec.PRICING_ATTRIBUTE42
,p_Line_Price_Att_rec.PRICING_ATTRIBUTE43
,p_Line_Price_Att_rec.PRICING_ATTRIBUTE44
,p_Line_Price_Att_rec.PRICING_ATTRIBUTE45
,p_Line_Price_Att_rec.PRICING_ATTRIBUTE46
,p_Line_Price_Att_rec.PRICING_ATTRIBUTE47
,p_Line_Price_Att_rec.PRICING_ATTRIBUTE48
,p_Line_Price_Att_rec.PRICING_ATTRIBUTE49
,p_Line_Price_Att_rec.PRICING_ATTRIBUTE50
,p_Line_Price_Att_rec.PRICING_ATTRIBUTE51
,p_Line_Price_Att_rec.PRICING_ATTRIBUTE52
,p_Line_Price_Att_rec.PRICING_ATTRIBUTE53
,p_Line_Price_Att_rec.PRICING_ATTRIBUTE54
,p_Line_Price_Att_rec.PRICING_ATTRIBUTE55
,p_Line_Price_Att_rec.PRICING_ATTRIBUTE56
,p_Line_Price_Att_rec.PRICING_ATTRIBUTE57
,p_Line_Price_Att_rec.PRICING_ATTRIBUTE58
,p_Line_Price_Att_rec.PRICING_ATTRIBUTE59
,p_Line_Price_Att_rec.PRICING_ATTRIBUTE60
,p_Line_Price_Att_rec.PRICING_ATTRIBUTE61
,p_Line_Price_Att_rec.PRICING_ATTRIBUTE62
,p_Line_Price_Att_rec.PRICING_ATTRIBUTE63
,p_Line_Price_Att_rec.PRICING_ATTRIBUTE64
,p_Line_Price_Att_rec.PRICING_ATTRIBUTE65
,p_Line_Price_Att_rec.PRICING_ATTRIBUTE66
,p_Line_Price_Att_rec.PRICING_ATTRIBUTE67
,p_Line_Price_Att_rec.PRICING_ATTRIBUTE68
,p_Line_Price_Att_rec.PRICING_ATTRIBUTE69
,p_Line_Price_Att_rec.PRICING_ATTRIBUTE70
,p_Line_Price_Att_rec.PRICING_ATTRIBUTE71
,p_Line_Price_Att_rec.PRICING_ATTRIBUTE72
,p_Line_Price_Att_rec.PRICING_ATTRIBUTE73
,p_Line_Price_Att_rec.PRICING_ATTRIBUTE74
,p_Line_Price_Att_rec.PRICING_ATTRIBUTE75
,p_Line_Price_Att_rec.PRICING_ATTRIBUTE76
,p_Line_Price_Att_rec.PRICING_ATTRIBUTE77
,p_Line_Price_Att_rec.PRICING_ATTRIBUTE78
,p_Line_Price_Att_rec.PRICING_ATTRIBUTE79
,p_Line_Price_Att_rec.PRICING_ATTRIBUTE80
,p_Line_Price_Att_rec.PRICING_ATTRIBUTE81
,p_Line_Price_Att_rec.PRICING_ATTRIBUTE82
,p_Line_Price_Att_rec.PRICING_ATTRIBUTE83
,p_Line_Price_Att_rec.PRICING_ATTRIBUTE84
,p_Line_Price_Att_rec.PRICING_ATTRIBUTE85
,p_Line_Price_Att_rec.PRICING_ATTRIBUTE86
,p_Line_Price_Att_rec.PRICING_ATTRIBUTE87
,p_Line_Price_Att_rec.PRICING_ATTRIBUTE88
,p_Line_Price_Att_rec.PRICING_ATTRIBUTE89
,p_Line_Price_Att_rec.PRICING_ATTRIBUTE90
,p_Line_Price_Att_rec.PRICING_ATTRIBUTE91
,p_Line_Price_Att_rec.PRICING_ATTRIBUTE92
,p_Line_Price_Att_rec.PRICING_ATTRIBUTE93
,p_Line_Price_Att_rec.PRICING_ATTRIBUTE94
,p_Line_Price_Att_rec.PRICING_ATTRIBUTE95
,p_Line_Price_Att_rec.PRICING_ATTRIBUTE96
,p_Line_Price_Att_rec.PRICING_ATTRIBUTE97
,p_Line_Price_Att_rec.PRICING_ATTRIBUTE98
,p_Line_Price_Att_rec.PRICING_ATTRIBUTE99
,p_Line_Price_Att_rec.PRICING_ATTRIBUTE100
,p_Line_Price_Att_rec.CONTEXT
,p_Line_Price_Att_rec.ATTRIBUTE1
,p_Line_Price_Att_rec.ATTRIBUTE2
,p_Line_Price_Att_rec.ATTRIBUTE3
,p_Line_Price_Att_rec.ATTRIBUTE4
,p_Line_Price_Att_rec.ATTRIBUTE5
,p_Line_Price_Att_rec.ATTRIBUTE6
,p_Line_Price_Att_rec.ATTRIBUTE7
,p_Line_Price_Att_rec.ATTRIBUTE8
,p_Line_Price_Att_rec.ATTRIBUTE9
,p_Line_Price_Att_rec.ATTRIBUTE10
,p_Line_Price_Att_rec.ATTRIBUTE11
,p_Line_Price_Att_rec.ATTRIBUTE12
,p_Line_Price_Att_rec.ATTRIBUTE13
,p_Line_Price_Att_rec.ATTRIBUTE14
,p_Line_Price_Att_rec.ATTRIBUTE15
,p_Line_Price_Att_rec.FLEX_TITLE
,p_Line_Price_Att_rec.ORDER_PRICE_ATTRIB_ID
,p_Line_Price_Att_rec.OVERRIDE_FLAG
,l_lock_control
,p_Line_Price_Att_rec.ORIG_SYS_ATTS_REF
);
oe_debug_pub.add('Exiting OE_Line_Patt_UTIL.INSERT_ROW', 1);
, 'Insert_Row'
);
END Insert_Row;
PROCEDURE Delete_Row
( p_order_price_attrib_id NUMBER :=
FND_API.G_MISS_NUM
, p_line_id NUMBER :=
FND_API.G_MISS_NUM
)
IS
BEGIN
IF p_line_id <> FND_API.G_MISS_NUM then
DELETE FROM OE_ORDER_PRICE_ATTRIBS
WHERE Line_Id = p_Line_id;
DELETE FROM OE_ORDER_PRICE_ATTRIBS
WHERE ORDER_PRICE_ATTRIB_ID = p_order_price_attrib_id;
, 'Delete_Row'
);
END Delete_Row;
/* Update Row */
PROCEDURE Update_Row
( p_Line_Price_Att_rec IN OUT NOCOPY OE_Order_PUB.Line_Price_Att_Rec_Type
)
IS
l_lock_control NUMBER;
oe_debug_pub.add('Entering OE_Line_PATT_UTIL.UPDATE_ROW', 1);
SELECT lock_control
INTO l_lock_control
FROM OE_ORDER_PRICE_ATTRIBS
WHERE order_price_attrib_id = p_line_Price_Att_rec.order_price_attrib_id;
UPDATE OE_ORDER_PRICE_ATTRIBS
SET HEADER_ID = p_Line_Price_Att_rec.HEADER_ID
,LINE_ID = p_Line_Price_Att_rec.LINE_ID
,OVERRIDE_FLAG = p_Line_Price_Att_rec.OVERRIDE_FLAG
,CREATION_DATE = p_Line_Price_Att_rec.CREATION_DATE
,CREATED_BY = p_Line_Price_Att_rec.CREATED_BY
,LAST_UPDATE_DATE = p_Line_Price_Att_rec.LAST_UPDATE_DATE
,LAST_UPDATED_BY = p_Line_Price_Att_rec.LAST_UPDATED_BY
,LAST_UPDATE_LOGIN = p_Line_Price_Att_rec.LAST_UPDATE_LOGIN
,PROGRAM_APPLICATION_ID = p_Line_Price_Att_rec.PROGRAM_APPLICATION_ID
,PROGRAM_ID = p_Line_Price_Att_rec.PROGRAM_ID
,PROGRAM_UPDATE_DATE = p_Line_Price_Att_rec.PROGRAM_UPDATE_DATE
,REQUEST_ID = p_Line_Price_Att_rec.REQUEST_ID
,PRICING_CONTEXT = p_Line_Price_Att_rec.PRICING_CONTEXT
,PRICING_ATTRIBUTE1 = p_Line_Price_Att_rec.PRICING_ATTRIBUTE1
,PRICING_ATTRIBUTE2 = p_Line_Price_Att_rec.PRICING_ATTRIBUTE2
,PRICING_ATTRIBUTE3 = p_Line_Price_Att_rec.PRICING_ATTRIBUTE3 ,PRICING_ATTRIBUTE4 = p_Line_Price_Att_rec.PRICING_ATTRIBUTE4
,PRICING_ATTRIBUTE5 = p_Line_Price_Att_rec.PRICING_ATTRIBUTE5
,PRICING_ATTRIBUTE6 = p_Line_Price_Att_rec.PRICING_ATTRIBUTE6
,PRICING_ATTRIBUTE7 = p_Line_Price_Att_rec.PRICING_ATTRIBUTE7
,PRICING_ATTRIBUTE8 = p_Line_Price_Att_rec.PRICING_ATTRIBUTE8
,PRICING_ATTRIBUTE9 = p_Line_Price_Att_rec.PRICING_ATTRIBUTE9
,PRICING_ATTRIBUTE10 = p_Line_Price_Att_rec.PRICING_ATTRIBUTE10
,PRICING_ATTRIBUTE11 = p_Line_Price_Att_rec.PRICING_ATTRIBUTE11
,PRICING_ATTRIBUTE12 = p_Line_Price_Att_rec.PRICING_ATTRIBUTE12
,PRICING_ATTRIBUTE13 = p_Line_Price_Att_rec.PRICING_ATTRIBUTE13
,PRICING_ATTRIBUTE14 = p_Line_Price_Att_rec.PRICING_ATTRIBUTE14
,PRICING_ATTRIBUTE15 = p_Line_Price_Att_rec.PRICING_ATTRIBUTE15
,PRICING_ATTRIBUTE16 = p_Line_Price_Att_rec.PRICING_ATTRIBUTE16
,PRICING_ATTRIBUTE17 = p_Line_Price_Att_rec.PRICING_ATTRIBUTE17
,PRICING_ATTRIBUTE18 = p_Line_Price_Att_rec.PRICING_ATTRIBUTE18
,PRICING_ATTRIBUTE19 = p_Line_Price_Att_rec.PRICING_ATTRIBUTE19
,PRICING_ATTRIBUTE20 = p_Line_Price_Att_rec.PRICING_ATTRIBUTE20
,PRICING_ATTRIBUTE21 = p_Line_Price_Att_rec.PRICING_ATTRIBUTE21
,PRICING_ATTRIBUTE22 = p_Line_Price_Att_rec.PRICING_ATTRIBUTE22
,PRICING_ATTRIBUTE23 = p_Line_Price_Att_rec.PRICING_ATTRIBUTE23
,PRICING_ATTRIBUTE24 = p_Line_Price_Att_rec.PRICING_ATTRIBUTE24
,PRICING_ATTRIBUTE25 = p_Line_Price_Att_rec.PRICING_ATTRIBUTE25
,PRICING_ATTRIBUTE26 = p_Line_Price_Att_rec.PRICING_ATTRIBUTE26
,PRICING_ATTRIBUTE27 = p_Line_Price_Att_rec.PRICING_ATTRIBUTE27
,PRICING_ATTRIBUTE28 = p_Line_Price_Att_rec.PRICING_ATTRIBUTE28
,PRICING_ATTRIBUTE29 = p_Line_Price_Att_rec.PRICING_ATTRIBUTE29
,PRICING_ATTRIBUTE30 = p_Line_Price_Att_rec.PRICING_ATTRIBUTE30
,PRICING_ATTRIBUTE31 = p_Line_Price_Att_rec.PRICING_ATTRIBUTE31
,PRICING_ATTRIBUTE32 = p_Line_Price_Att_rec.PRICING_ATTRIBUTE32
,PRICING_ATTRIBUTE33 = p_Line_Price_Att_rec.PRICING_ATTRIBUTE33
,PRICING_ATTRIBUTE34 = p_Line_Price_Att_rec.PRICING_ATTRIBUTE34
,PRICING_ATTRIBUTE35 = p_Line_Price_Att_rec.PRICING_ATTRIBUTE35
,PRICING_ATTRIBUTE36 = p_Line_Price_Att_rec.PRICING_ATTRIBUTE36
,PRICING_ATTRIBUTE37 = p_Line_Price_Att_rec.PRICING_ATTRIBUTE37
,PRICING_ATTRIBUTE38 = p_Line_Price_Att_rec.PRICING_ATTRIBUTE38
,PRICING_ATTRIBUTE39 = p_Line_Price_Att_rec.PRICING_ATTRIBUTE39
,PRICING_ATTRIBUTE40 = p_Line_Price_Att_rec.PRICING_ATTRIBUTE40
,PRICING_ATTRIBUTE41 = p_Line_Price_Att_rec.PRICING_ATTRIBUTE41
,PRICING_ATTRIBUTE42 = p_Line_Price_Att_rec.PRICING_ATTRIBUTE42
,PRICING_ATTRIBUTE43 = p_Line_Price_Att_rec.PRICING_ATTRIBUTE43
,PRICING_ATTRIBUTE44 = p_Line_Price_Att_rec.PRICING_ATTRIBUTE44
,PRICING_ATTRIBUTE45 = p_Line_Price_Att_rec.PRICING_ATTRIBUTE45
,PRICING_ATTRIBUTE46 = p_Line_Price_Att_rec.PRICING_ATTRIBUTE46
,PRICING_ATTRIBUTE47 = p_Line_Price_Att_rec.PRICING_ATTRIBUTE47
,PRICING_ATTRIBUTE48 = p_Line_Price_Att_rec.PRICING_ATTRIBUTE48
,PRICING_ATTRIBUTE49 = p_Line_Price_Att_rec.PRICING_ATTRIBUTE49
,PRICING_ATTRIBUTE50 = p_Line_Price_Att_rec.PRICING_ATTRIBUTE50
,PRICING_ATTRIBUTE51 = p_Line_Price_Att_rec.PRICING_ATTRIBUTE51
,PRICING_ATTRIBUTE52 = p_Line_Price_Att_rec.PRICING_ATTRIBUTE52
,PRICING_ATTRIBUTE53 = p_Line_Price_Att_rec.PRICING_ATTRIBUTE53
,PRICING_ATTRIBUTE54 = p_Line_Price_Att_rec.PRICING_ATTRIBUTE54
,PRICING_ATTRIBUTE55 = p_Line_Price_Att_rec.PRICING_ATTRIBUTE55
,PRICING_ATTRIBUTE56 = p_Line_Price_Att_rec.PRICING_ATTRIBUTE56
,PRICING_ATTRIBUTE57 = p_Line_Price_Att_rec.PRICING_ATTRIBUTE57
,PRICING_ATTRIBUTE58 = p_Line_Price_Att_rec.PRICING_ATTRIBUTE58
,PRICING_ATTRIBUTE59 = p_Line_Price_Att_rec.PRICING_ATTRIBUTE59
,PRICING_ATTRIBUTE60 = p_Line_Price_Att_rec.PRICING_ATTRIBUTE60
,PRICING_ATTRIBUTE61 = p_Line_Price_Att_rec.PRICING_ATTRIBUTE61
,PRICING_ATTRIBUTE62 = p_Line_Price_Att_rec.PRICING_ATTRIBUTE62
,PRICING_ATTRIBUTE63 = p_Line_Price_Att_rec.PRICING_ATTRIBUTE63
,PRICING_ATTRIBUTE64 = p_Line_Price_Att_rec.PRICING_ATTRIBUTE64
,PRICING_ATTRIBUTE65 = p_Line_Price_Att_rec.PRICING_ATTRIBUTE65
,PRICING_ATTRIBUTE66 = p_Line_Price_Att_rec.PRICING_ATTRIBUTE66
,PRICING_ATTRIBUTE67 = p_Line_Price_Att_rec.PRICING_ATTRIBUTE67
,PRICING_ATTRIBUTE68 = p_Line_Price_Att_rec.PRICING_ATTRIBUTE68
,PRICING_ATTRIBUTE69 = p_Line_Price_Att_rec.PRICING_ATTRIBUTE69
,PRICING_ATTRIBUTE70 = p_Line_Price_Att_rec.PRICING_ATTRIBUTE70
,PRICING_ATTRIBUTE71 = p_Line_Price_Att_rec.PRICING_ATTRIBUTE71
,PRICING_ATTRIBUTE72 = p_Line_Price_Att_rec.PRICING_ATTRIBUTE72
,PRICING_ATTRIBUTE73 = p_Line_Price_Att_rec.PRICING_ATTRIBUTE73
,PRICING_ATTRIBUTE74 = p_Line_Price_Att_rec.PRICING_ATTRIBUTE74
,PRICING_ATTRIBUTE75 = p_Line_Price_Att_rec.PRICING_ATTRIBUTE75
,PRICING_ATTRIBUTE76 = p_Line_Price_Att_rec.PRICING_ATTRIBUTE76
,PRICING_ATTRIBUTE77 = p_Line_Price_Att_rec.PRICING_ATTRIBUTE77
,PRICING_ATTRIBUTE78 = p_Line_Price_Att_rec.PRICING_ATTRIBUTE78
,PRICING_ATTRIBUTE79 = p_Line_Price_Att_rec.PRICING_ATTRIBUTE79
,PRICING_ATTRIBUTE80 = p_Line_Price_Att_rec.PRICING_ATTRIBUTE80
,PRICING_ATTRIBUTE81 = p_Line_Price_Att_rec.PRICING_ATTRIBUTE81
,PRICING_ATTRIBUTE82 = p_Line_Price_Att_rec.PRICING_ATTRIBUTE82
,PRICING_ATTRIBUTE83 = p_Line_Price_Att_rec.PRICING_ATTRIBUTE83
,PRICING_ATTRIBUTE84 = p_Line_Price_Att_rec.PRICING_ATTRIBUTE84
,PRICING_ATTRIBUTE85 = p_Line_Price_Att_rec.PRICING_ATTRIBUTE85
,PRICING_ATTRIBUTE86 = p_Line_Price_Att_rec.PRICING_ATTRIBUTE86
,PRICING_ATTRIBUTE87 = p_Line_Price_Att_rec.PRICING_ATTRIBUTE87
,PRICING_ATTRIBUTE88 = p_Line_Price_Att_rec.PRICING_ATTRIBUTE88
,PRICING_ATTRIBUTE89 = p_Line_Price_Att_rec.PRICING_ATTRIBUTE89
,PRICING_ATTRIBUTE90 = p_Line_Price_Att_rec.PRICING_ATTRIBUTE90
,PRICING_ATTRIBUTE91 = p_Line_Price_Att_rec.PRICING_ATTRIBUTE91
,PRICING_ATTRIBUTE92 = p_Line_Price_Att_rec.PRICING_ATTRIBUTE92
,PRICING_ATTRIBUTE93 = p_Line_Price_Att_rec.PRICING_ATTRIBUTE93
,PRICING_ATTRIBUTE94 = p_Line_Price_Att_rec.PRICING_ATTRIBUTE94
,PRICING_ATTRIBUTE95 = p_Line_Price_Att_rec.PRICING_ATTRIBUTE95
,PRICING_ATTRIBUTE96 = p_Line_Price_Att_rec.PRICING_ATTRIBUTE96
,PRICING_ATTRIBUTE97 = p_Line_Price_Att_rec.PRICING_ATTRIBUTE97
,PRICING_ATTRIBUTE98 = p_Line_Price_Att_rec.PRICING_ATTRIBUTE98
,PRICING_ATTRIBUTE99 = p_Line_Price_Att_rec.PRICING_ATTRIBUTE99
,PRICING_ATTRIBUTE100 = p_Line_Price_Att_rec.PRICING_ATTRIBUTE100
,ATTRIBUTE1 = p_Line_Price_Att_rec.ATTRIBUTE1
,ATTRIBUTE2 = p_Line_Price_Att_rec.ATTRIBUTE2
,ATTRIBUTE3 = p_Line_Price_Att_rec.ATTRIBUTE3
,ATTRIBUTE4 = p_Line_Price_Att_rec.ATTRIBUTE4
,ATTRIBUTE5 = p_Line_Price_Att_rec.ATTRIBUTE5
,ATTRIBUTE6 = p_Line_Price_Att_rec.ATTRIBUTE6
,ATTRIBUTE7 = p_Line_Price_Att_rec.ATTRIBUTE7
,ATTRIBUTE8 = p_Line_Price_Att_rec.ATTRIBUTE8
,ATTRIBUTE9 = p_Line_Price_Att_rec.ATTRIBUTE9
,ATTRIBUTE10 = p_Line_Price_Att_rec.ATTRIBUTE10
,ATTRIBUTE11 = p_Line_Price_Att_rec.ATTRIBUTE11
,ATTRIBUTE12 = p_Line_Price_Att_rec.ATTRIBUTE12
,ATTRIBUTE13 = p_Line_Price_Att_rec.ATTRIBUTE13
,ATTRIBUTE14 = p_Line_Price_Att_rec.ATTRIBUTE14
,ATTRIBUTE15 = p_Line_Price_Att_rec.ATTRIBUTE15
,FLEX_TITLE = p_Line_Price_Att_rec.FLEX_TITLE
,ORDER_PRICE_ATTRIB_ID = p_Line_Price_Att_rec.ORDER_PRICE_ATTRIB_ID
,LOCK_CONTROL = l_lock_control
,ORIG_SYS_ATTS_REF = p_Line_Price_Att_rec.ORIG_SYS_ATTS_REF
WHERE ORDER_PRICE_ATTRIB_ID =
p_Line_Price_Att_rec.order_price_attrib_id;
oe_debug_pub.add('Exiting OE_Line_Patt_UTIL.UPDATE_ROW', 1);
, 'Update_Row'
);
END Update_Row;
IF NOT OE_GLOBALS.Equal(p_x_Line_Price_Att_rec.last_updated_by,p_old_Line_price_att_rec.last_updated_by)
THEN
l_index := l_index + 1;
l_src_attr_tbl(l_index) := OE_Line_PAttr_Util.G_LAST_UPDATED_BY;
IF NOT OE_GLOBALS.Equal(p_x_Line_Price_Att_rec.last_update_date,p_old_Line_price_att_rec.last_update_date)
THEN
l_index := l_index + 1;
l_src_attr_tbl(l_index) := OE_Line_PAttr_Util.G_LAST_UPDATE_DATE;
IF NOT OE_GLOBALS.Equal(p_x_Line_Price_Att_rec.last_update_login,p_old_Line_price_att_rec.last_update_login)
THEN
l_index := l_index + 1;
l_src_attr_tbl(l_index) := OE_Line_PAttr_Util.G_LAST_UPDATE_LOGIN;
IF NOT OE_GLOBALS.Equal(p_x_Line_Price_Att_rec.program_update_date,p_old_Line_price_att_rec.program_update_date)
THEN
l_index := l_index + 1;
l_src_attr_tbl(l_index) := OE_Line_PAttr_Util.G_PROGRAM_UPDATE_DATE;
ELSIF p_attr_id = G_LAST_UPDATED_BY THEN
l_index := l_index + 1;
l_src_attr_tbl(l_index) := OE_Line_PAttr_Util.G_LAST_UPDATED_BY;
ELSIF p_attr_id = G_LAST_UPDATE_DATE THEN
l_index := l_index + 1;
l_src_attr_tbl(l_index) := OE_Line_PAttr_Util.G_LAST_UPDATE_DATE;
ELSIF p_attr_id = G_LAST_UPDATE_LOGIN THEN
l_index := l_index + 1;
l_src_attr_tbl(l_index) := OE_Line_PAttr_Util.G_LAST_UPDATE_LOGIN;
ELSIF p_attr_id = G_PROGRAM_UPDATE_DATE THEN
l_index := l_index + 1;
l_src_attr_tbl(l_index) := OE_Line_PAttr_Util.G_PROGRAM_UPDATE_DATE;
IF l_Line_price_att_rec.last_updated_by = FND_API.G_MISS_NUM THEN
l_Line_price_att_rec.last_updated_by := p_old_Line_price_att_rec.last_updated_by;
IF l_Line_price_att_rec.last_update_date = FND_API.G_MISS_DATE THEN
l_Line_price_att_rec.last_update_date := p_old_Line_price_att_rec.last_update_date;
IF l_Line_price_att_rec.last_update_login = FND_API.G_MISS_NUM THEN
l_Line_price_att_rec.last_update_login := p_old_Line_price_att_rec.last_update_login;
IF l_Line_price_att_rec.program_update_date = FND_API.G_MISS_DATE THEN
l_Line_price_att_rec.program_update_date := p_old_Line_price_att_rec.program_update_date;
IF l_Line_price_att_rec.last_updated_by = FND_API.G_MISS_NUM THEN
l_Line_price_att_rec.last_updated_by := NULL;
IF l_Line_price_att_rec.last_update_date = FND_API.G_MISS_DATE THEN
l_Line_price_att_rec.last_update_date := NULL;
IF l_Line_price_att_rec.last_update_login = FND_API.G_MISS_NUM THEN
l_Line_price_att_rec.last_update_login := NULL;
IF l_Line_price_att_rec.program_update_date = FND_API.G_MISS_DATE THEN
l_Line_price_att_rec.program_update_date := NULL;
is select price_adjustment_id,list_line_type_code from
oe_price_adjustments
where line_id = l_lineid1 and list_header_id = l_list_hdr_id1;
FUNCTION delete_price_adj(l_prc_adj_id IN number,l_lst_code IN varchar2)
RETURN BOOLEAN is
begin
if l_lst_code in ('PRG','IUE','OID') then
null; --do not expect these cases to be overriden
delete from oe_price_adjustments where price_adjustment_id in
(select rltd_price_adj_id from oe_price_adj_assocs where
price_adjustment_id = l_prc_adj_id
union
select price_adjustment_id from oe_price_adj_assocs where
price_adjustment_id = l_prc_adj_id
);
delete from oe_price_adj_assocs where
price_adjustment_id = l_prc_adj_id;
select 1 into l_tmp1
from oe_price_adj_assocs opaa,oe_price_adjustments opa
where opaa.rltd_price_adj_id = l_prc_adj_id and
opaa.price_adjustment_id = opa.price_adjustment_id and
opa.list_line_type_code = 'PRG';
delete from oe_price_adjustments where
price_adjustment_id = l_prc_adj_id;
IF NOT oe_globals.Equal(p_x_Line_Price_Att_rec.last_updated_by,p_old_Line_price_att_rec.last_updated_by)
THEN
NULL;
IF NOT oe_globals.Equal(p_x_Line_Price_Att_rec.last_update_date,p_old_Line_price_att_rec.last_update_date)
THEN
NULL;
IF NOT oe_globals.Equal(p_x_Line_Price_Att_rec.last_update_login,p_old_Line_price_att_rec.last_update_login)
THEN
NULL;
SELECT order_quantity_uom
INTO l_order_quantity_uom
FROM oe_order_lines_all
WHERE line_id = p_x_Line_Price_Att_rec.line_id;
IF NOT oe_globals.Equal(p_x_Line_Price_Att_rec.program_update_date,p_old_Line_price_att_rec.program_update_date)
THEN
NULL;
if p_x_line_price_att_rec.operation = OE_GLOBALS.G_OPR_DELETE
and p_x_line_price_att_rec.flex_title = 'QP_ATTR_DEFNS_QUALIFIER'
and p_x_line_price_att_rec.pricing_context = 'MODLIST'
and p_x_line_price_att_rec.pricing_attribute1 is not null
then
IF (p_x_line_price_att_rec.pricing_attribute2 is not null) THEN
begin
select price_adjustment_id,list_line_type_code
into l_price_adj_id1,l_lst_type_code
from oe_price_adjustments
where line_id = p_x_line_price_att_rec.line_id
and list_line_id = p_x_line_price_att_rec.pricing_attribute2
and updated_flag = 'Y';
l_price_flag := delete_price_adj(l_price_adj_id1,l_lst_type_code);
select 1 into l_tmp1 from dual
where exists
(select 1 from oe_price_adjustments where
list_header_id = p_x_line_price_att_rec.pricing_attribute1
and updated_flag = 'Y');
delete_price_adj(l_prj_adj_cur.price_adjustment_id,
l_prj_adj_cur.list_line_type_code);
Select booked_flag,shipping_quantity into
l_booked_flag,l_shipping_quantity
From OE_Order_lines where
Line_id = p_x_Line_Price_Att_rec.Line_Id;
p_operation=>OE_GLOBALS.G_OPR_UPDATE);
Select booked_flag,shipping_quantity into
l_booked_flag,l_shipping_quantity
From OE_Order_lines where
Line_id = p_x_Line_Price_Att_rec.Line_Id;
SELECT order_price_attrib_id
INTO l_order_price_attrib_id
FROM oe_order_price_attribs
WHERE order_price_attrib_id = l_order_price_attrib_id
FOR UPDATE NOWAIT;
FND_MESSAGE.SET_NAME('OE','OE_LOCK_ROW_DELETED');
SELECT order_price_attrib_id
FROM oe_order_price_attribs
WHERE line_id = p_line_id
FOR UPDATE NOWAIT;
SELECT order_price_attrib_id
INTO l_order_price_attrib_id
FROM oe_order_price_attribs
WHERE order_price_attrib_id = p_order_price_attrib_id
FOR UPDATE NOWAIT;
fnd_message.set_name('ONT','OE_LOCK_ROW_DELETED');
SELECT header_id, line_id
FROM oe_order_lines
WHERE top_model_line_id = p_model_line_id
AND (item_type_code = OE_GLOBALS.G_ITEM_OPTION
OR item_type_code = OE_GLOBALS.G_ITEM_CLASS
OR item_type_code = OE_GLOBALS.G_ITEM_KIT);
SELECT top_model_line_id, header_id
INTO l_top_model_line_id, l_from_header_id
FROM oe_order_lines
WHERE line_id = p_to_line_id;