The following lines contain the word 'select', 'insert', 'update' or 'delete':
IF NOT QP_GLOBALS.Equal(p_RQT_rec.last_updated_by,p_old_RQT_rec.last_updated_by)
THEN
l_index := l_index + 1;
l_src_attr_tbl(l_index) := QP_RQT_UTIL.G_LAST_UPDATED_BY;
IF NOT QP_GLOBALS.Equal(p_RQT_rec.last_update_date,p_old_RQT_rec.last_update_date)
THEN
l_index := l_index + 1;
l_src_attr_tbl(l_index) := QP_RQT_UTIL.G_LAST_UPDATE_DATE;
IF NOT QP_GLOBALS.Equal(p_RQT_rec.last_update_login,p_old_RQT_rec.last_update_login)
THEN
l_index := l_index + 1;
l_src_attr_tbl(l_index) := QP_RQT_UTIL.G_LAST_UPDATE_LOGIN;
IF NOT QP_GLOBALS.Equal(p_RQT_rec.program_update_date,p_old_RQT_rec.program_update_date)
THEN
l_index := l_index + 1;
l_src_attr_tbl(l_index) := QP_RQT_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) := QP_RQT_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) := QP_RQT_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) := QP_RQT_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) := QP_RQT_UTIL.G_PROGRAM_UPDATE_DATE;
IF NOT QP_GLOBALS.Equal(p_RQT_rec.last_updated_by,p_old_RQT_rec.last_updated_by)
THEN
NULL;
IF NOT QP_GLOBALS.Equal(p_RQT_rec.last_update_date,p_old_RQT_rec.last_update_date)
THEN
NULL;
IF NOT QP_GLOBALS.Equal(p_RQT_rec.last_update_login,p_old_RQT_rec.last_update_login)
THEN
NULL;
IF NOT QP_GLOBALS.Equal(p_RQT_rec.program_update_date,p_old_RQT_rec.program_update_date)
THEN
NULL;
IF l_RQT_rec.last_updated_by = FND_API.G_MISS_NUM THEN
l_RQT_rec.last_updated_by := p_old_RQT_rec.last_updated_by;
IF l_RQT_rec.last_update_date = FND_API.G_MISS_DATE THEN
l_RQT_rec.last_update_date := p_old_RQT_rec.last_update_date;
IF l_RQT_rec.last_update_login = FND_API.G_MISS_NUM THEN
l_RQT_rec.last_update_login := p_old_RQT_rec.last_update_login;
IF l_RQT_rec.program_update_date = FND_API.G_MISS_DATE THEN
l_RQT_rec.program_update_date := p_old_RQT_rec.program_update_date;
IF l_RQT_rec.last_updated_by = FND_API.G_MISS_NUM THEN
l_RQT_rec.last_updated_by := NULL;
IF l_RQT_rec.last_update_date = FND_API.G_MISS_DATE THEN
l_RQT_rec.last_update_date := NULL;
IF l_RQT_rec.last_update_login = FND_API.G_MISS_NUM THEN
l_RQT_rec.last_update_login := NULL;
IF l_RQT_rec.program_update_date = FND_API.G_MISS_DATE THEN
l_RQT_rec.program_update_date := NULL;
PROCEDURE Update_Row
( p_RQT_rec IN QP_Attr_Map_PUB.Rqt_Rec_Type
)
IS
BEGIN
UPDATE QP_PTE_REQUEST_TYPES_b
SET ATTRIBUTE1 = p_RQT_rec.attribute1
, ATTRIBUTE10 = p_RQT_rec.attribute10
, ATTRIBUTE11 = p_RQT_rec.attribute11
, ATTRIBUTE12 = p_RQT_rec.attribute12
, ATTRIBUTE13 = p_RQT_rec.attribute13
, ATTRIBUTE14 = p_RQT_rec.attribute14
, ATTRIBUTE15 = p_RQT_rec.attribute15
, ATTRIBUTE2 = p_RQT_rec.attribute2
, ATTRIBUTE3 = p_RQT_rec.attribute3
, ATTRIBUTE4 = p_RQT_rec.attribute4
, ATTRIBUTE5 = p_RQT_rec.attribute5
, ATTRIBUTE6 = p_RQT_rec.attribute6
, ATTRIBUTE7 = p_RQT_rec.attribute7
, ATTRIBUTE8 = p_RQT_rec.attribute8
, ATTRIBUTE9 = p_RQT_rec.attribute9
, CONTEXT = p_RQT_rec.context
, CREATED_BY = p_RQT_rec.created_by
, CREATION_DATE = p_RQT_rec.creation_date
, ENABLED_FLAG = p_RQT_rec.enabled_flag
, LAST_UPDATED_BY = p_RQT_rec.last_updated_by
, LAST_UPDATE_DATE = p_RQT_rec.last_update_date
, LAST_UPDATE_LOGIN = p_RQT_rec.last_update_login
, LINE_LEVEL_GLOBAL_STRUCT = p_RQT_rec.line_level_global_struct
, LINE_LEVEL_VIEW_NAME = p_RQT_rec.line_level_view_name
, ORDER_LEVEL_GLOBAL_STRUCT = p_RQT_rec.order_level_global_struct
, ORDER_LEVEL_VIEW_NAME = p_RQT_rec.order_level_view_name
, PROGRAM_APPLICATION_ID = p_RQT_rec.program_application_id
, PROGRAM_ID = p_RQT_rec.program_id
, PROGRAM_UPDATE_DATE = p_RQT_rec.program_update_date
, PTE_CODE = p_RQT_rec.pte_code
, REQUEST_TYPE_CODE = p_RQT_rec.request_type_code
WHERE REQUEST_TYPE_CODE = p_RQT_rec.request_type_code ;
UPDATE QP_PTE_REQUEST_TYPES_tl
SET CREATED_BY = p_RQT_rec.created_by
, CREATION_DATE = p_RQT_rec.creation_date
, LAST_UPDATED_BY = p_RQT_rec.last_updated_by
, LAST_UPDATE_DATE = p_RQT_rec.last_update_date
, LAST_UPDATE_LOGIN = p_RQT_rec.last_update_login
, REQUEST_TYPE_DESC = p_RQT_rec.request_type_desc
, SOURCE_LANG = userenv('LANG')
WHERE REQUEST_TYPE_CODE = p_RQT_rec.request_type_code and
userenv('LANG') in (LANGUAGE, SOURCE_LANG);
UPDATE QP_PTE_REQUEST_TYPES_V
SET ATTRIBUTE1 = p_RQT_rec.attribute1
, ATTRIBUTE10 = p_RQT_rec.attribute10
, ATTRIBUTE11 = p_RQT_rec.attribute11
, ATTRIBUTE12 = p_RQT_rec.attribute12
, ATTRIBUTE13 = p_RQT_rec.attribute13
, ATTRIBUTE14 = p_RQT_rec.attribute14
, ATTRIBUTE15 = p_RQT_rec.attribute15
, ATTRIBUTE2 = p_RQT_rec.attribute2
, ATTRIBUTE3 = p_RQT_rec.attribute3
, ATTRIBUTE4 = p_RQT_rec.attribute4
, ATTRIBUTE5 = p_RQT_rec.attribute5
, ATTRIBUTE6 = p_RQT_rec.attribute6
, ATTRIBUTE7 = p_RQT_rec.attribute7
, ATTRIBUTE8 = p_RQT_rec.attribute8
, ATTRIBUTE9 = p_RQT_rec.attribute9
, CONTEXT = p_RQT_rec.context
, CREATED_BY = p_RQT_rec.created_by
, CREATION_DATE = p_RQT_rec.creation_date
, ENABLED_FLAG = p_RQT_rec.enabled_flag
, LAST_UPDATED_BY = p_RQT_rec.last_updated_by
, LAST_UPDATE_DATE = p_RQT_rec.last_update_date
, LAST_UPDATE_LOGIN = p_RQT_rec.last_update_login
, LINE_LEVEL_GLOBAL_STRUCT = p_RQT_rec.line_level_global_struct
, LINE_LEVEL_VIEW_NAME = p_RQT_rec.line_level_view_name
, ORDER_LEVEL_GLOBAL_STRUCT = p_RQT_rec.order_level_global_struct
, ORDER_LEVEL_VIEW_NAME = p_RQT_rec.order_level_view_name
, PROGRAM_APPLICATION_ID = p_RQT_rec.program_application_id
, PROGRAM_ID = p_RQT_rec.program_id
, PROGRAM_UPDATE_DATE = p_RQT_rec.program_update_date
, PTE_CODE = p_RQT_rec.pte_code
, REQUEST_TYPE_CODE = p_RQT_rec.request_type_code
, REQUEST_TYPE_DESC = p_RQT_rec.request_type_desc
, ROW_ID = p_RQT_rec.row_id
WHERE REQUEST_TYPE_CODE = p_RQT_rec.request_type_code
;
, 'Update_Row'
);
END Update_Row;
PROCEDURE Insert_Row
( p_RQT_rec IN QP_Attr_Map_PUB.Rqt_Rec_Type
)
IS
BEGIN
/*
INSERT INTO QP_PTE_REQUEST_TYPES_V
( ATTRIBUTE1
, ATTRIBUTE10
, ATTRIBUTE11
, ATTRIBUTE12
, ATTRIBUTE13
, ATTRIBUTE14
, ATTRIBUTE15
, ATTRIBUTE2
, ATTRIBUTE3
, ATTRIBUTE4
, ATTRIBUTE5
, ATTRIBUTE6
, ATTRIBUTE7
, ATTRIBUTE8
, ATTRIBUTE9
, CONTEXT
, CREATED_BY
, CREATION_DATE
, ENABLED_FLAG
, LAST_UPDATED_BY
, LAST_UPDATE_DATE
, LAST_UPDATE_LOGIN
, LINE_LEVEL_GLOBAL_STRUCT
, LINE_LEVEL_VIEW_NAME
, ORDER_LEVEL_GLOBAL_STRUCT
, ORDER_LEVEL_VIEW_NAME
, PROGRAM_APPLICATION_ID
, PROGRAM_ID
, PROGRAM_UPDATE_DATE
, PTE_CODE
, REQUEST_TYPE_CODE
, REQUEST_TYPE_DESC
, ROW_ID
)
VALUES
( p_RQT_rec.attribute1
, p_RQT_rec.attribute10
, p_RQT_rec.attribute11
, p_RQT_rec.attribute12
, p_RQT_rec.attribute13
, p_RQT_rec.attribute14
, p_RQT_rec.attribute15
, p_RQT_rec.attribute2
, p_RQT_rec.attribute3
, p_RQT_rec.attribute4
, p_RQT_rec.attribute5
, p_RQT_rec.attribute6
, p_RQT_rec.attribute7
, p_RQT_rec.attribute8
, p_RQT_rec.attribute9
, p_RQT_rec.context
, p_RQT_rec.created_by
, p_RQT_rec.creation_date
, p_RQT_rec.enabled_flag
, p_RQT_rec.last_updated_by
, p_RQT_rec.last_update_date
, p_RQT_rec.last_update_login
, p_RQT_rec.line_level_global_struct
, p_RQT_rec.line_level_view_name
, p_RQT_rec.order_level_global_struct
, p_RQT_rec.order_level_view_name
, p_RQT_rec.program_application_id
, p_RQT_rec.program_id
, p_RQT_rec.program_update_date
, p_RQT_rec.pte_code
, p_RQT_rec.request_type_code
, p_RQT_rec.request_type_desc
, p_RQT_rec.row_id
);
INSERT INTO QP_PTE_REQUEST_TYPES_B
( ATTRIBUTE1
, ATTRIBUTE10
, ATTRIBUTE11
, ATTRIBUTE12
, ATTRIBUTE13
, ATTRIBUTE14
, ATTRIBUTE15
, ATTRIBUTE2
, ATTRIBUTE3
, ATTRIBUTE4
, ATTRIBUTE5
, ATTRIBUTE6
, ATTRIBUTE7
, ATTRIBUTE8
, ATTRIBUTE9
, CONTEXT
, CREATED_BY
, CREATION_DATE
, ENABLED_FLAG
, LAST_UPDATED_BY
, LAST_UPDATE_DATE
, LAST_UPDATE_LOGIN
, LINE_LEVEL_GLOBAL_STRUCT
, LINE_LEVEL_VIEW_NAME
, ORDER_LEVEL_GLOBAL_STRUCT
, ORDER_LEVEL_VIEW_NAME
, PROGRAM_APPLICATION_ID
, PROGRAM_ID
, PROGRAM_UPDATE_DATE
, PTE_CODE
, REQUEST_TYPE_CODE
)
VALUES
( p_RQT_rec.attribute1
, p_RQT_rec.attribute10
, p_RQT_rec.attribute11
, p_RQT_rec.attribute12
, p_RQT_rec.attribute13
, p_RQT_rec.attribute14
, p_RQT_rec.attribute15
, p_RQT_rec.attribute2
, p_RQT_rec.attribute3
, p_RQT_rec.attribute4
, p_RQT_rec.attribute5
, p_RQT_rec.attribute6
, p_RQT_rec.attribute7
, p_RQT_rec.attribute8
, p_RQT_rec.attribute9
, p_RQT_rec.context
, p_RQT_rec.created_by
, p_RQT_rec.creation_date
, p_RQT_rec.enabled_flag
, p_RQT_rec.last_updated_by
, p_RQT_rec.last_update_date
, p_RQT_rec.last_update_login
, p_RQT_rec.line_level_global_struct
, p_RQT_rec.line_level_view_name
, p_RQT_rec.order_level_global_struct
, p_RQT_rec.order_level_view_name
, p_RQT_rec.program_application_id
, p_RQT_rec.program_id
, p_RQT_rec.program_update_date
, p_RQT_rec.pte_code
, p_RQT_rec.request_type_code);
INSERT INTO QP_PTE_REQUEST_TYPES_tl
( CREATED_BY
, CREATION_DATE
, LAST_UPDATED_BY
, LAST_UPDATE_DATE
, LAST_UPDATE_LOGIN
, REQUEST_TYPE_CODE
, REQUEST_TYPE_DESC
, language
, source_lang
)
SELECT p_RQT_rec.created_by
, p_RQT_rec.creation_date
, p_RQT_rec.last_updated_by
, p_RQT_rec.last_update_date
, p_RQT_rec.last_update_login
, p_RQT_rec.request_type_code
, p_RQT_rec.request_type_desc
, L.language_code
, userenv('LANG')
from FND_LANGUAGES L
where L.INSTALLED_FLAG in ('I', 'B')
and not exists
( select NULL
from qp_pte_request_types_tl T
where T.request_type_code = p_RQT_rec.request_type_code
and T.LANGUAGE = L.LANGUAGE_CODE );
QP_Param_Util.Insert_Parameter_Values('REQ',
p_RQT_rec.request_type_code);
, 'Insert_Row'
);
END Insert_Row;
PROCEDURE Delete_Row
( p_request_type_code IN VARCHAR2
)
IS
BEGIN
DELETE FROM QP_PTE_REQUEST_TYPES_TL
WHERE REQUEST_TYPE_CODE = p_request_type_code;
DELETE FROM QP_PTE_REQUEST_TYPES_B
WHERE REQUEST_TYPE_CODE = p_request_type_code;
QP_Param_Util.Delete_Parameter_Values('REQ',
p_request_type_code);
, '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
, ENABLED_FLAG
, LAST_UPDATED_BY
, LAST_UPDATE_DATE
, LAST_UPDATE_LOGIN
, LINE_LEVEL_GLOBAL_STRUCT
, LINE_LEVEL_VIEW_NAME
, ORDER_LEVEL_GLOBAL_STRUCT
, ORDER_LEVEL_VIEW_NAME
, PROGRAM_APPLICATION_ID
, PROGRAM_ID
, PROGRAM_UPDATE_DATE
, PTE_CODE
, REQUEST_TYPE_CODE
, REQUEST_TYPE_DESC
--**, ROW_ID
FROM QP_PTE_REQUEST_TYPES_V
WHERE ( REQUEST_TYPE_CODE = p_request_type_code
)
--**OR ( LOOKUP_CODE = p_lookup_code
OR ( pte_code = p_lookup_code
);
l_RQT_rec.last_updated_by := l_implicit_rec.LAST_UPDATED_BY;
l_RQT_rec.last_update_date := l_implicit_rec.LAST_UPDATE_DATE;
l_RQT_rec.last_update_login := l_implicit_rec.LAST_UPDATE_LOGIN;
l_RQT_rec.program_update_date := l_implicit_rec.PROGRAM_UPDATE_DATE;
SELECT ATTRIBUTE1
, ATTRIBUTE10
, ATTRIBUTE11
, ATTRIBUTE12
, ATTRIBUTE13
, ATTRIBUTE14
, ATTRIBUTE15
, ATTRIBUTE2
, ATTRIBUTE3
, ATTRIBUTE4
, ATTRIBUTE5
, ATTRIBUTE6
, ATTRIBUTE7
, ATTRIBUTE8
, ATTRIBUTE9
, CONTEXT
, CREATED_BY
, CREATION_DATE
, ENABLED_FLAG
, LAST_UPDATED_BY
, LAST_UPDATE_DATE
, LAST_UPDATE_LOGIN
, LINE_LEVEL_GLOBAL_STRUCT
, LINE_LEVEL_VIEW_NAME
, ORDER_LEVEL_GLOBAL_STRUCT
, ORDER_LEVEL_VIEW_NAME
, PROGRAM_APPLICATION_ID
, PROGRAM_ID
, PROGRAM_UPDATE_DATE
, PTE_CODE
, REQUEST_TYPE_CODE
, REQUEST_TYPE_DESC
--**, ROW_ID
INTO l_RQT_rec.attribute1
, l_RQT_rec.attribute10
, l_RQT_rec.attribute11
, l_RQT_rec.attribute12
, l_RQT_rec.attribute13
, l_RQT_rec.attribute14
, l_RQT_rec.attribute15
, l_RQT_rec.attribute2
, l_RQT_rec.attribute3
, l_RQT_rec.attribute4
, l_RQT_rec.attribute5
, l_RQT_rec.attribute6
, l_RQT_rec.attribute7
, l_RQT_rec.attribute8
, l_RQT_rec.attribute9
, l_RQT_rec.context
, l_RQT_rec.created_by
, l_RQT_rec.creation_date
, l_RQT_rec.enabled_flag
, l_RQT_rec.last_updated_by
, l_RQT_rec.last_update_date
, l_RQT_rec.last_update_login
, l_RQT_rec.line_level_global_struct
, l_RQT_rec.line_level_view_name
, l_RQT_rec.order_level_global_struct
, l_RQT_rec.order_level_view_name
, l_RQT_rec.program_application_id
, l_RQT_rec.program_id
, l_RQT_rec.program_update_date
, l_RQT_rec.pte_code
, l_RQT_rec.request_type_code
, l_RQT_rec.request_type_desc
--**, l_RQT_rec.row_id
FROM QP_PTE_REQUEST_TYPES_V
WHERE REQUEST_TYPE_CODE = p_RQT_rec.request_type_code
FOR UPDATE NOWAIT;
AND QP_GLOBALS.Equal(p_RQT_rec.last_updated_by,
l_RQT_rec.last_updated_by)
AND QP_GLOBALS.Equal(p_RQT_rec.last_update_date,
l_RQT_rec.last_update_date)
AND QP_GLOBALS.Equal(p_RQT_rec.last_update_login,
l_RQT_rec.last_update_login)
AND QP_GLOBALS.Equal(p_RQT_rec.line_level_global_struct,
l_RQT_rec.line_level_global_struct)
AND QP_GLOBALS.Equal(p_RQT_rec.line_level_view_name,
l_RQT_rec.line_level_view_name)
AND QP_GLOBALS.Equal(p_RQT_rec.order_level_global_struct,
l_RQT_rec.order_level_global_struct)
AND QP_GLOBALS.Equal(p_RQT_rec.order_level_view_name,
l_RQT_rec.order_level_view_name)
AND QP_GLOBALS.Equal(p_RQT_rec.program_application_id,
l_RQT_rec.program_application_id)
AND QP_GLOBALS.Equal(p_RQT_rec.program_id,
l_RQT_rec.program_id)
AND QP_GLOBALS.Equal(p_RQT_rec.program_update_date,
l_RQT_rec.program_update_date)
AND QP_GLOBALS.Equal(p_RQT_rec.pte_code,
l_RQT_rec.pte_code)
AND QP_GLOBALS.Equal(p_RQT_rec.request_type_code,
l_RQT_rec.request_type_code)
AND QP_GLOBALS.Equal(p_RQT_rec.request_type_desc,
l_RQT_rec.request_type_desc)
--**AND QP_GLOBALS.Equal(p_RQT_rec.row_id,
--** l_RQT_rec.row_id)
THEN
-- Row has not changed. Set out parameter.
x_RQT_rec := l_RQT_rec;
FND_MESSAGE.SET_NAME('QP','OE_LOCK_ROW_DELETED');