The following lines contain the word 'select', 'insert', 'update' or 'delete':
l_rowtype_rec.DW_UPDATE_ADVICE_FLAG := FND_API.G_MISS_CHAR;
l_rowtype_rec.LAST_UPDATED_BY := FND_API.G_MISS_NUM;
l_rowtype_rec.LAST_UPDATE_DATE := FND_API.G_MISS_DATE;
l_rowtype_rec.LAST_UPDATE_LOGIN := FND_API.G_MISS_NUM;
l_rowtype_rec.WH_UPDATE_DATE := FND_API.G_MISS_DATE;
x_rowtype_rec.DW_UPDATE_ADVICE_FLAG := p_line_scredit_rec.DW_UPDATE_ADVICE_FLAG;
x_rowtype_rec.LAST_UPDATED_BY := p_line_scredit_rec.LAST_UPDATED_BY;
x_rowtype_rec.LAST_UPDATE_DATE := p_line_scredit_rec.LAST_UPDATE_DATE;
x_rowtype_rec.LAST_UPDATE_LOGIN := p_line_scredit_rec.LAST_UPDATE_LOGIN;
x_rowtype_rec.WH_UPDATE_DATE := p_line_scredit_rec.WH_UPDATE_DATE;
x_api_rec.DW_UPDATE_ADVICE_FLAG := p_record.DW_UPDATE_ADVICE_FLAG;
x_api_rec.LAST_UPDATED_BY := p_record.LAST_UPDATED_BY;
x_api_rec.LAST_UPDATE_DATE := p_record.LAST_UPDATE_DATE;
x_api_rec.LAST_UPDATE_LOGIN := p_record.LAST_UPDATE_LOGIN;
x_api_rec.WH_UPDATE_DATE := p_record.WH_UPDATE_DATE;
IF NOT OE_GLOBALS.Equal(p_x_Line_Scredit_rec.dw_update_advice_flag,p_old_Line_Scredit_rec.dw_update_advice_flag)
THEN
l_index := l_index + 1;
l_src_attr_tbl(l_index) := OE_LINE_SCREDIT_UTIL.G_DW_UPDATE_ADVICE;
IF NOT OE_GLOBALS.Equal(p_x_Line_Scredit_rec.last_updated_by,p_old_Line_Scredit_rec.last_updated_by)
THEN
l_index := l_index + 1;
l_src_attr_tbl(l_index) := OE_LINE_SCREDIT_UTIL.G_LAST_UPDATED_BY;
IF NOT OE_GLOBALS.Equal(p_x_Line_Scredit_rec.last_update_date,p_old_Line_Scredit_rec.last_update_date)
THEN
l_index := l_index + 1;
l_src_attr_tbl(l_index) := OE_LINE_SCREDIT_UTIL.G_LAST_UPDATE_DATE;
IF NOT OE_GLOBALS.Equal(p_x_Line_Scredit_rec.last_update_login,p_old_Line_Scredit_rec.last_update_login)
THEN
l_index := l_index + 1;
l_src_attr_tbl(l_index) := OE_LINE_SCREDIT_UTIL.G_LAST_UPDATE_LOGIN;
IF NOT OE_GLOBALS.Equal(p_x_Line_Scredit_rec.wh_update_date,p_old_Line_Scredit_rec.wh_update_date)
THEN
l_index := l_index + 1;
l_src_attr_tbl(l_index) := OE_LINE_SCREDIT_UTIL.G_WH_UPDATE_DATE;
ELSIF p_attr_id = G_DW_UPDATE_ADVICE THEN
l_index := l_index + 1;
l_src_attr_tbl(l_index) := OE_LINE_SCREDIT_UTIL.G_DW_UPDATE_ADVICE;
ELSIF p_attr_id = G_LAST_UPDATED_BY THEN
l_index := l_index + 1;
l_src_attr_tbl(l_index) := OE_LINE_SCREDIT_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_SCREDIT_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_SCREDIT_UTIL.G_LAST_UPDATE_LOGIN;
ELSIF p_attr_id = G_WH_UPDATE_DATE THEN
l_index := l_index + 1;
l_src_attr_tbl(l_index) := OE_LINE_SCREDIT_UTIL.G_WH_UPDATE_DATE;
ELSIF l_dep_attr_tbl(I) = OE_LINE_SCREDIT_UTIL.G_DW_UPDATE_ADVICE THEN
p_x_Line_Scredit_rec.DW_UPDATE_ADVICE_FLAG := FND_API.G_MISS_CHAR;
ELSIF l_dep_attr_tbl(I) = OE_LINE_SCREDIT_UTIL.G_LAST_UPDATED_BY THEN
p_x_Line_Scredit_rec.LAST_UPDATED_BY := FND_API.G_MISS_NUM;
ELSIF l_dep_attr_tbl(I) = OE_LINE_SCREDIT_UTIL.G_LAST_UPDATE_DATE THEN
p_x_Line_Scredit_rec.LAST_UPDATE_DATE := FND_API.G_MISS_DATE;
ELSIF l_dep_attr_tbl(I) = OE_LINE_SCREDIT_UTIL.G_LAST_UPDATE_LOGIN THEN
p_x_Line_Scredit_rec.LAST_UPDATE_LOGIN := FND_API.G_MISS_NUM;
ELSIF l_dep_attr_tbl(I) = OE_LINE_SCREDIT_UTIL.G_WH_UPDATE_DATE THEN
p_x_Line_Scredit_rec.WH_UPDATE_DATE := FND_API.G_MISS_DATE;
IF NOT OE_GLOBALS.Equal(p_x_Line_Scredit_rec.dw_update_advice_flag,p_old_Line_Scredit_rec.dw_update_advice_flag)
THEN
NULL;
IF NOT OE_GLOBALS.Equal(p_x_Line_Scredit_rec.last_updated_by,p_old_Line_Scredit_rec.last_updated_by)
THEN
NULL;
IF NOT OE_GLOBALS.Equal(p_x_Line_Scredit_rec.last_update_date,p_old_Line_Scredit_rec.last_update_date)
THEN
NULL;
IF NOT OE_GLOBALS.Equal(p_x_Line_Scredit_rec.last_update_login,p_old_Line_Scredit_rec.last_update_login)
THEN
NULL;
nvl(p_x_line_Scredit_rec.sales_group_updated_flag,'N') = 'Y' THEN
oe_debug_pub.add('do not re-default sales group');
IF nvl(p_x_line_Scredit_rec.sales_group_updated_flag,'N') <> 'Y'
AND nvl(p_x_line_Scredit_rec.salesrep_id,FND_API.G_MISS_NUM)<>FND_API.G_MISS_NUM
THEN
IF OE_ORDER_CACHE.G_HEADER_REC.header_id IS NULL THEN
--header not available in cache, load info to cache
IF p_x_line_Scredit_rec.Header_Id IS NOT NULL THEN
OE_ORDER_CACHE.Load_Order_Header(p_x_line_Scredit_rec.Header_Id);
IF NOT OE_GLOBALS.Equal(p_x_Line_Scredit_rec.wh_update_date,p_old_Line_Scredit_rec.wh_update_date)
THEN
NULL;
IF p_x_Line_Scredit_rec.dw_update_advice_flag = FND_API.G_MISS_CHAR THEN
p_x_Line_Scredit_rec.dw_update_advice_flag := p_old_Line_Scredit_rec.dw_update_advice_flag;
IF p_x_Line_Scredit_rec.last_updated_by = FND_API.G_MISS_NUM THEN
p_x_Line_Scredit_rec.last_updated_by := p_old_Line_Scredit_rec.last_updated_by;
IF p_x_Line_Scredit_rec.last_update_date = FND_API.G_MISS_DATE THEN
p_x_Line_Scredit_rec.last_update_date := p_old_Line_Scredit_rec.last_update_date;
IF p_x_Line_Scredit_rec.last_update_login = FND_API.G_MISS_NUM THEN
p_x_Line_Scredit_rec.last_update_login := p_old_Line_Scredit_rec.last_update_login;
IF p_x_Line_Scredit_rec.wh_update_date = FND_API.G_MISS_DATE THEN
p_x_Line_Scredit_rec.wh_update_date := p_old_Line_Scredit_rec.wh_update_date;
IF p_x_Line_Scredit_rec.dw_update_advice_flag = FND_API.G_MISS_CHAR THEN
p_x_Line_Scredit_rec.dw_update_advice_flag := NULL;
IF p_x_Line_Scredit_rec.last_updated_by = FND_API.G_MISS_NUM THEN
p_x_Line_Scredit_rec.last_updated_by := NULL;
IF p_x_Line_Scredit_rec.last_update_date = FND_API.G_MISS_DATE THEN
p_x_Line_Scredit_rec.last_update_date := NULL;
IF p_x_Line_Scredit_rec.last_update_login = FND_API.G_MISS_NUM THEN
p_x_Line_Scredit_rec.last_update_login := NULL;
IF p_x_Line_Scredit_rec.wh_update_date = FND_API.G_MISS_DATE THEN
p_x_Line_Scredit_rec.wh_update_date := NULL;
PROCEDURE Update_Row
( p_Line_Scredit_rec IN OUT NOCOPY OE_Order_PUB.Line_Scredit_Rec_Type
)
IS
l_lock_control NUMBER;
oe_debug_pub.add( 'ENTERING OE_LINE_SCREDIT_UTIL.UPDATE_ROW' , 1 ) ;
SELECT lock_control
INTO l_lock_control
FROM OE_SALES_CREDITS
WHERE sales_credit_id = p_Line_Scredit_rec.sales_credit_id;
oe_debug_pub.add( 'BEFORE UPDATE , SALES_CREDIT_ID= '|| L_LINE_SCREDIT_REC.SALES_CREDIT_ID , 1 ) ;
UPDATE OE_SALES_CREDITS
SET ATTRIBUTE1 = p_Line_Scredit_rec.attribute1
, ATTRIBUTE10 = p_Line_Scredit_rec.attribute10
, ATTRIBUTE11 = p_Line_Scredit_rec.attribute11
, ATTRIBUTE12 = p_Line_Scredit_rec.attribute12
, ATTRIBUTE13 = p_Line_Scredit_rec.attribute13
, ATTRIBUTE14 = p_Line_Scredit_rec.attribute14
, ATTRIBUTE15 = p_Line_Scredit_rec.attribute15
, ATTRIBUTE2 = p_Line_Scredit_rec.attribute2
, ATTRIBUTE3 = p_Line_Scredit_rec.attribute3
, ATTRIBUTE4 = p_Line_Scredit_rec.attribute4
, ATTRIBUTE5 = p_Line_Scredit_rec.attribute5
, ATTRIBUTE6 = p_Line_Scredit_rec.attribute6
, ATTRIBUTE7 = p_Line_Scredit_rec.attribute7
, ATTRIBUTE8 = p_Line_Scredit_rec.attribute8
, ATTRIBUTE9 = p_Line_Scredit_rec.attribute9
, CONTEXT = p_Line_Scredit_rec.context
, CREATED_BY = p_Line_Scredit_rec.created_by
, CREATION_DATE = p_Line_Scredit_rec.creation_date
, DW_UPDATE_ADVICE_FLAG = p_Line_Scredit_rec.dw_update_advice_flag
, HEADER_ID = p_Line_Scredit_rec.header_id
, LAST_UPDATED_BY = p_Line_Scredit_rec.last_updated_by
, LAST_UPDATE_DATE = p_Line_Scredit_rec.last_update_date
, LAST_UPDATE_LOGIN = p_Line_Scredit_rec.last_update_login
, LINE_ID = p_Line_Scredit_rec.line_id
, PERCENT = p_Line_Scredit_rec.percent
, SALESREP_ID = p_Line_Scredit_rec.salesrep_id
, sales_credit_type_id = p_Line_Scredit_rec.sales_credit_type_id
, SALES_CREDIT_ID = p_Line_Scredit_rec.sales_credit_id
, WH_UPDATE_DATE = p_Line_Scredit_rec.wh_update_date
, LOCK_CONTROL = l_lock_control
--SG{
, sales_group_id = p_line_Scredit_rec.sales_group_id
, sales_group_updated_flag = p_line_Scredit_rec.sales_group_updated_flag
--SG}
WHERE SALES_CREDIT_ID = p_Line_Scredit_rec.sales_credit_id
;
oe_debug_pub.add( 'AFTER UPDATE , OLD SALES CREDIT ID= ' || L_LINE_SCREDIT_REC.SALES_CREDIT_ID ) ;
oe_debug_pub.add( 'AFTER UPDATE , NEW SALES CREDIT ID= ' || P_LINE_SCREDIT_REC.SALES_CREDIT_ID ) ;
OE_ORDER_UTIL.Update_Global_Picture
(p_Upd_New_Rec_If_Exists =>True,
p_line_scr_rec => p_line_scredit_rec,
p_old_line_scr_rec => l_line_scredit_rec,
p_line_scr_id => p_line_scredit_rec.sales_credit_id,
x_index => l_index,
x_return_status => l_return_status);
oe_debug_pub.add( 'UPDATE_GLOBAL RETURN STATUS FROM OE_LINE_SCREDIT_UTIL.UPDATE_ROW IS: ' || L_RETURN_STATUS ) ;
oe_debug_pub.add( 'EXITING OE_LINE_SCREDIT_UTIL.UPDATE_ROW' , 1 ) ;
oe_debug_pub.add( 'UPDATE_GLOBAL_PICTURE ERROR IN OE_LINE_SCREDIT_UTIL.UPDATE_ROW' ) ;
oe_debug_pub.add( 'EXITING OE_LINE_SCREDIT_UTIL.UPDATE_ROW' , 1 ) ;
oe_debug_pub.add( 'EXITING OE_LINE_SCREDIT_UTIL.UPDATE_ROW' , 1 ) ;
, 'Update_Row'
);
END Update_Row;
PROCEDURE Insert_Row
( p_Line_Scredit_rec IN OUT NOCOPY OE_Order_PUB.Line_Scredit_Rec_Type
)
IS
l_lock_control NUMBER:= 1;
oe_debug_pub.add( 'ENTERING OE_LINE_SCREDIT_UTIL.INSERT_ROW' , 1 ) ;
INSERT INTO OE_SALES_CREDITS
( ATTRIBUTE1
, ATTRIBUTE10
, ATTRIBUTE11
, ATTRIBUTE12
, ATTRIBUTE13
, ATTRIBUTE14
, ATTRIBUTE15
, ATTRIBUTE2
, ATTRIBUTE3
, ATTRIBUTE4
, ATTRIBUTE5
, ATTRIBUTE6
, ATTRIBUTE7
, ATTRIBUTE8
, ATTRIBUTE9
, CONTEXT
, CREATED_BY
, CREATION_DATE
, DW_UPDATE_ADVICE_FLAG
, HEADER_ID
, LAST_UPDATED_BY
, LAST_UPDATE_DATE
, LAST_UPDATE_LOGIN
, LINE_ID
, PERCENT
, SALESREP_ID
, sales_credit_type_id
, SALES_CREDIT_ID
, WH_UPDATE_DATE
, ORIG_SYS_CREDIT_REF
--SG{
, sales_group_id
, sales_group_updated_flag
--SG}
, LOCK_CONTROL
)
VALUES
( p_Line_Scredit_rec.attribute1
, p_Line_Scredit_rec.attribute10
, p_Line_Scredit_rec.attribute11
, p_Line_Scredit_rec.attribute12
, p_Line_Scredit_rec.attribute13
, p_Line_Scredit_rec.attribute14
, p_Line_Scredit_rec.attribute15
, p_Line_Scredit_rec.attribute2
, p_Line_Scredit_rec.attribute3
, p_Line_Scredit_rec.attribute4
, p_Line_Scredit_rec.attribute5
, p_Line_Scredit_rec.attribute6
, p_Line_Scredit_rec.attribute7
, p_Line_Scredit_rec.attribute8
, p_Line_Scredit_rec.attribute9
, p_Line_Scredit_rec.context
, p_Line_Scredit_rec.created_by
, p_Line_Scredit_rec.creation_date
, p_Line_Scredit_rec.dw_update_advice_flag
, p_Line_Scredit_rec.header_id
, p_Line_Scredit_rec.last_updated_by
, p_Line_Scredit_rec.last_update_date
, p_Line_Scredit_rec.last_update_login
, p_Line_Scredit_rec.line_id
, p_Line_Scredit_rec.percent
, p_Line_Scredit_rec.salesrep_id
, p_Line_Scredit_rec.sales_credit_type_id
, p_Line_Scredit_rec.sales_credit_id
, p_Line_Scredit_rec.wh_update_date
, p_Line_Scredit_rec.orig_sys_credit_ref
--SG{
, p_line_scredit_rec.sales_group_id
, p_line_scredit_rec.sales_group_updated_flag
--SG}
, l_lock_control
);
OE_ORDER_UTIL.Update_Global_Picture
(p_Upd_New_Rec_If_Exists =>True,
p_line_scr_rec => p_line_scredit_rec,
p_old_line_scr_rec => NULL,
p_line_scr_id => p_line_scredit_rec.sales_credit_id,
x_index => l_index,
x_return_status => l_return_status);
oe_debug_pub.add( 'UPDATE_GLOBAL RETURN STATUS FROM OE_LINE_SCREDIT_UTIL.INSERT_ROW IS: ' || L_RETURN_STATUS ) ;
oe_debug_pub.add( 'EXITING OE_LINE_SCREDIT_UTIL.INSERT_ROW' , 1 ) ;
oe_debug_pub.add( 'UPDATE_GLOBAL_PICTURE ERROR IN OE_LINE_SCREDIT_UTIL.INSERT_ROW' ) ;
oe_debug_pub.add( 'EXITING OE_LINE_SCREDIT_UTIL.INSERT_ROW' , 1 ) ;
oe_debug_pub.add( 'EXITING OE_LINE_SCREDIT_UTIL.INSERT_ROW' , 1 ) ;
, 'Insert_Row'
);
END Insert_Row;
PROCEDURE Delete_Row
( p_sales_credit_id IN NUMBER :=
FND_API.G_MISS_NUM
, p_line_id IN NUMBER :=
FND_API.G_MISS_NUM
)
IS
l_return_status VARCHAR2(30);
SELECT sales_credit_id
FROM OE_SALES_CREDITS
WHERE LINE_ID = p_line_id;
oe_debug_pub.add( 'ENTERING OE_LINE_SCREDIT_UTIL.DELETE_ROW' , 1 ) ;
oe_debug_pub.add( 'IN DELETE ROW , SALES_CREDIT_ID= '|| L_SCR.SALES_CREDIT_ID , 1 ) ;
/* Set the operation on the record so that globals are updated as well */
l_new_line_scredit_rec.operation := OE_GLOBALS.G_OPR_DELETE;
OE_ORDER_UTIL.Update_Global_Picture
(p_Upd_New_Rec_If_Exists =>True,
p_line_scr_rec => l_new_line_scredit_rec,
p_old_line_scr_rec => l_line_scredit_rec,
p_line_scr_id => l_scr.sales_credit_id,
x_index => l_index,
x_return_status => l_return_status);
oe_debug_pub.add( 'UPDATE_GLOBAL RETURN STATUS FROM OE_LINE_SCREDIT_UTIL.DELETE_ROW IS: ' || L_RETURN_STATUS ) ;
oe_debug_pub.add( 'EXITING OE_LINE_SCREDIT_UTIL.DELETE_ROW' , 1 ) ;
oe_debug_pub.add( 'UPDATE_GLOBAL_PICTURE ERROR IN OE_LINE_SCREDIT_UTIL.DELETE_ROW' ) ;
oe_debug_pub.add( 'EXITING OE_LINE_SCREDIT_UTIL.DELETE_ROW' , 1 ) ;
OE_Delayed_Requests_Pvt.Delete_Reqs_for_Deleted_Entity(
p_entity_code => OE_GLOBALS.G_ENTITY_LINE_SCREDIT,
p_entity_id => l_scr.sales_credit_id,
x_return_status => l_return_status
);
DELETE FROM OE_SALES_CREDIT_HISTORY
WHERE LINE_ID = p_line_id
AND NVL(AUDIT_FLAG, 'Y') = 'Y'
AND NVL(VERSION_FLAG, 'N') = 'N'
AND NVL(PHASE_CHANGE_FLAG, 'N') = 'N';
UPDATE OE_SALES_CREDIT_HISTORY
SET AUDIT_FLAG = 'N'
WHERE LINE_ID = p_line_id
AND NVL(AUDIT_FLAG, 'Y') = 'Y'
AND (NVL(VERSION_FLAG, 'N') = 'Y'
OR NVL(PHASE_CHANGE_FLAG, 'N') = 'Y');
DELETE FROM OE_SALES_CREDITS
WHERE LINE_ID = p_line_id;
oe_debug_pub.add( 'IN DELETE ROW , LINE_ID IS G_MISS_NUM , SALES_CREDIT_ID= '|| P_SALES_CREDIT_ID , 1 ) ;
/* Set the operation on the record so that globals are updated as well */
l_new_line_scredit_rec.operation := OE_GLOBALS.G_OPR_DELETE;
OE_ORDER_UTIL.Update_Global_Picture(
p_Upd_New_Rec_If_Exists => True,
p_line_scr_rec => l_new_line_scredit_rec,
p_old_line_scr_rec => l_line_scredit_rec,
p_line_scr_id => p_sales_credit_id,
x_index => l_index,
x_return_status => l_return_status);
oe_debug_pub.add( 'UPDATE_GLOBAL RETURN STATUS FROM OE_LINE_SCREDIT_UTIL.DELETE_ROW IS: ' || L_RETURN_STATUS ) ;
oe_debug_pub.add( 'EXITING OE_LINE_SCREDIT_UTIL.DELETE_ROW' , 1 ) ;
oe_debug_pub.add( 'UPDATE_GLOBAL_PICTURE ERROR IN OE_LINE_SCREDIT_UTIL.DELETE_ROW' ) ;
oe_debug_pub.add( 'EXITING OE_LINE_SCREDIT_UTIL.DELETE_ROW' , 1 ) ;
OE_Delayed_Requests_Pvt.Delete_Reqs_for_Deleted_Entity(
p_entity_code => OE_GLOBALS.G_ENTITY_LINE_SCREDIT,
p_entity_id => p_sales_credit_id,
x_return_status => l_return_status
);
DELETE FROM OE_SALES_CREDIT_HISTORY
WHERE SALES_CREDIT_ID = p_sales_credit_id
AND NVL(AUDIT_FLAG, 'Y') = 'Y'
AND NVL(VERSION_FLAG, 'N') = 'N'
AND NVL(PHASE_CHANGE_FLAG, 'N') = 'N';
UPDATE OE_SALES_CREDIT_HISTORY
SET AUDIT_FLAG = 'N'
WHERE SALES_CREDIT_ID = p_sales_credit_id
AND NVL(AUDIT_FLAG, 'Y') = 'Y'
AND (NVL(VERSION_FLAG, 'N') = 'Y'
OR NVL(PHASE_CHANGE_FLAG, 'N') = 'Y');
DELETE FROM OE_SALES_CREDITS
WHERE SALES_CREDIT_ID = p_sales_credit_id
;
oe_debug_pub.add( 'EXITING OE_LINE_SCREDIT_UTIL.DELETE_ROW' , 1 ) ;
, 'Delete_Row'
);
END Delete_Row;
SELECT ATTRIBUTE1
, ATTRIBUTE10
, ATTRIBUTE11
, ATTRIBUTE12
, ATTRIBUTE13
, ATTRIBUTE14
, ATTRIBUTE15
, ATTRIBUTE2
, ATTRIBUTE3
, ATTRIBUTE4
, ATTRIBUTE5
, ATTRIBUTE6
, ATTRIBUTE7
, ATTRIBUTE8
, ATTRIBUTE9
, CONTEXT
, CREATED_BY
, CREATION_DATE
, DW_UPDATE_ADVICE_FLAG
, HEADER_ID
, LAST_UPDATED_BY
, LAST_UPDATE_DATE
, LAST_UPDATE_LOGIN
, LINE_ID
, PERCENT
, SALESREP_ID
, sales_credit_type_id
, SALES_CREDIT_ID
, WH_UPDATE_DATE
--SG {
, SALES_GROUP_ID
, SALES_GROUP_UPDATED_FLAG
--SG }
, LOCK_CONTROL
FROM OE_SALES_CREDITS
WHERE SALES_CREDIT_ID = p_sales_credit_id;
SELECT ATTRIBUTE1
, ATTRIBUTE10
, ATTRIBUTE11
, ATTRIBUTE12
, ATTRIBUTE13
, ATTRIBUTE14
, ATTRIBUTE15
, ATTRIBUTE2
, ATTRIBUTE3
, ATTRIBUTE4
, ATTRIBUTE5
, ATTRIBUTE6
, ATTRIBUTE7
, ATTRIBUTE8
, ATTRIBUTE9
, CONTEXT
, CREATED_BY
, CREATION_DATE
, DW_UPDATE_ADVICE_FLAG
, HEADER_ID
, LAST_UPDATED_BY
, LAST_UPDATE_DATE
, LAST_UPDATE_LOGIN
, LINE_ID
, PERCENT
, SALESREP_ID
, sales_credit_type_id
, SALES_CREDIT_ID
, WH_UPDATE_DATE
--SG {
, SALES_GROUP_ID
, SALES_GROUP_UPDATED_FLAG
--SG }
, LOCK_CONTROL
FROM OE_SALES_CREDITS
WHERE LINE_ID = p_line_id;
SELECT ATTRIBUTE1
, ATTRIBUTE10
, ATTRIBUTE11
, ATTRIBUTE12
, ATTRIBUTE13
, ATTRIBUTE14
, ATTRIBUTE15
, ATTRIBUTE2
, ATTRIBUTE3
, ATTRIBUTE4
, ATTRIBUTE5
, ATTRIBUTE6
, ATTRIBUTE7
, ATTRIBUTE8
, ATTRIBUTE9
, CONTEXT
, CREATED_BY
, CREATION_DATE
, DW_UPDATE_ADVICE_FLAG
, HEADER_ID
, LAST_UPDATED_BY
, LAST_UPDATE_DATE
, LAST_UPDATE_LOGIN
, LINE_ID
, PERCENT
, SALESREP_ID
, sales_credit_type_id
, SALES_CREDIT_ID
, WH_UPDATE_DATE
--SG {
, SALES_GROUP_ID
, SALES_GROUP_UPDATED_FLAG
--SG }
, LOCK_CONTROL
FROM OE_SALES_CREDITS
WHERE HEADER_ID = p_header_id
AND LINE_ID IS NOT NULL;
x_line_scredit_tbl(l_count).dw_update_advice_flag := l_implicit_rec.DW_UPDATE_ADVICE_FLAG;
x_line_scredit_tbl(l_count).last_updated_by := l_implicit_rec.LAST_UPDATED_BY;
x_line_scredit_tbl(l_count).last_update_date := l_implicit_rec.LAST_UPDATE_DATE;
x_line_scredit_tbl(l_count).last_update_login := l_implicit_rec.LAST_UPDATE_LOGIN;
x_line_scredit_tbl(l_count).wh_update_date := l_implicit_rec.WH_UPDATE_DATE;
x_line_scredit_tbl(l_count).sales_group_updated_flag:=l_implicit_rec.sales_group_updated_flag;
SELECT sales_credit_id
INTO l_sales_credit_id
FROM oe_sales_credits
WHERE sales_credit_id = l_sales_credit_id
FOR UPDATE NOWAIT;
oe_debug_pub.add( 'SELECTED FOR UPDATE' , 1 ) ;
FND_MESSAGE.SET_NAME('ONT','OE_LOCK_ROW_DELETED');
SELECT sales_credit_id
FROM oe_sales_credits
WHERE line_id = p_line_id
FOR UPDATE NOWAIT;
SELECT sales_credit_id
INTO l_sales_credit_id
FROM OE_SALES_CREDITS
WHERE sales_credit_id = p_sales_credit_id
FOR UPDATE NOWAIT;
fnd_message.set_name('ONT','OE_LOCK_ROW_DELETED');
l_update_flag boolean := FALSE;
Select count(sales_credit_id), max(sales_credit_id)
from oe_sales_credits sc,
oe_sales_credit_types sct
where header_id = p_line_rec.header_id
and sc.sales_credit_type_id = sct.sales_credit_type_id
and sct.quota_flag = 'Y'
and line_id = p_line_rec.line_id;
SELECT nvl(Sales_Credit_Type_id,1)
FROM ra_salesreps
WHERE salesrep_id = p_line_rec.salesrep_id;
/*select salesrep_id
into G_SALESREP_ID
from oe_order_headers
where header_id = p_line_rec.header_id; */
ELSIF (p_line_rec.operation = oe_globals.g_opr_update AND
NOT OE_GLOBALS.EQUAL( p_line_rec.salesrep_id,
p_old_line_rec.salesrep_id)) THEN
IF l_debug_level > 0 THEN
oe_debug_pub.add( 'IN OPERATION UPDATE ' ) ;
oe_debug_pub.add( 'IN CREATE FOR UPDATE OPERATION' ) ;
elsif l_sales_credits_count = 1 then -- update with new salesrep
OE_Line_Scredit_Util.Lock_Rows
( p_sales_credit_id => l_sales_credit_id,
x_line_scredit_tbl => l_old_line_scredit_tbl,
x_return_status => l_return_status
);
OE_Line_Scredit_Util.Delete_Row
( p_sales_credit_id => l_sales_credit_id,
p_line_id => p_line_rec.line_id
);
l_line_scredit_tbl(1).operation := oe_globals.g_opr_update;
l_update_flag := TRUE;
IF l_create_flag OR L_update_flag THEN
IF l_debug_level > 0 THEN
oe_debug_pub.add( 'BEFORE CALLING PROCESS ORDER' ) ;
OE_ORDER_UTIL.Update_Global_Picture
(p_Upd_New_Rec_If_Exists =>TRUE
, p_line_scr_rec => l_line_scredit_tbl(1)
, p_old_line_scr_rec => l_old_line_scredit_tbl(1)
, p_line_scr_id => l_line_scredit_tbl(1).sales_credit_id
, x_index => l_notify_index
, x_return_status => l_return_status);
oe_debug_pub.add( 'UPDATE_GLOBAL RET_STATUS FOR LINE_ID '||L_LINE_SCREDIT_TBL ( 1 ) .LINE_ID ||' IS: ' || L_RETURN_STATUS , 1 ) ;
oe_debug_pub.add( 'UPDATE_GLOBAL INDEX FOR LINE_ID '||L_LINE_SCREDIT_TBL ( 1 ) .LINE_ID ||' IS: ' || L_NOTIFY_INDEX , 1 ) ;
if l_sales_credits_count = 1 then -- issue message update with new salesrep
fnd_message.set_name('ONT','OE_OE_UPDATED_LINE_CREDIT');
END IF; -- if l_create_flag or l_update_flag
IF (p_x_line_scredit_rec.operation = OE_GLOBALS.G_OPR_UPDATE) then
IF OE_GLOBALS.G_AUDIT_REASON_RQD_FLAG='Y' then
IF l_debug_level > 0 THEN
oe_debug_pub.add( 'OEXULSCB: AUDIT TRAIL - CHANGE REQUIRES REASON' , 2 ) ;
p_hist_type_code => 'UPDATE');
p_hist_type_code => 'UPDATE',
p_reason_code => p_x_line_scredit_rec.change_reason,
p_comments => p_x_line_scredit_rec.change_comments,
p_wf_activity_code => null,
p_wf_result_code => null,
x_return_status => l_return_status
);
oe_debug_pub.add( 'INSERTING LINE SALES CREDIT HISTORY CAUSED ERROR ' , 1 ) ;