The following lines contain the word 'select', 'insert', 'update' or 'delete':
IF NOT QP_GLOBALS.Equal(p_CON_rec.last_updated_by,p_old_CON_rec.last_updated_by)
THEN
l_index := l_index + 1;
l_src_attr_tbl(l_index) := QP_CON_UTIL.G_LAST_UPDATED_BY;
IF NOT QP_GLOBALS.Equal(p_CON_rec.last_update_date,p_old_CON_rec.last_update_date)
THEN
l_index := l_index + 1;
l_src_attr_tbl(l_index) := QP_CON_UTIL.G_LAST_UPDATE_DATE;
IF NOT QP_GLOBALS.Equal(p_CON_rec.last_update_login,p_old_CON_rec.last_update_login)
THEN
l_index := l_index + 1;
l_src_attr_tbl(l_index) := QP_CON_UTIL.G_LAST_UPDATE_LOGIN;
IF NOT QP_GLOBALS.Equal(p_CON_rec.program_update_date,p_old_CON_rec.program_update_date)
THEN
l_index := l_index + 1;
l_src_attr_tbl(l_index) := QP_CON_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_CON_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_CON_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_CON_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_CON_UTIL.G_PROGRAM_UPDATE_DATE;
IF NOT QP_GLOBALS.Equal(p_CON_rec.last_updated_by,p_old_CON_rec.last_updated_by)
THEN
NULL;
IF NOT QP_GLOBALS.Equal(p_CON_rec.last_update_date,p_old_CON_rec.last_update_date)
THEN
NULL;
IF NOT QP_GLOBALS.Equal(p_CON_rec.last_update_login,p_old_CON_rec.last_update_login)
THEN
NULL;
IF NOT QP_GLOBALS.Equal(p_CON_rec.program_update_date,p_old_CON_rec.program_update_date)
THEN
NULL;
IF l_CON_rec.last_updated_by = FND_API.G_MISS_NUM THEN
l_CON_rec.last_updated_by := p_old_CON_rec.last_updated_by;
IF l_CON_rec.last_update_date = FND_API.G_MISS_DATE THEN
l_CON_rec.last_update_date := p_old_CON_rec.last_update_date;
IF l_CON_rec.last_update_login = FND_API.G_MISS_NUM THEN
l_CON_rec.last_update_login := p_old_CON_rec.last_update_login;
IF l_CON_rec.program_update_date = FND_API.G_MISS_DATE THEN
l_CON_rec.program_update_date := p_old_CON_rec.program_update_date;
IF l_CON_rec.last_updated_by = FND_API.G_MISS_NUM THEN
l_CON_rec.last_updated_by := NULL;
IF l_CON_rec.last_update_date = FND_API.G_MISS_DATE THEN
l_CON_rec.last_update_date := NULL;
IF l_CON_rec.last_update_login = FND_API.G_MISS_NUM THEN
l_CON_rec.last_update_login := NULL;
IF l_CON_rec.program_update_date = FND_API.G_MISS_DATE THEN
l_CON_rec.program_update_date := NULL;
PROCEDURE Update_Row
( p_CON_rec IN QP_Attributes_PUB.Con_Rec_Type
)
IS
BEGIN
UPDATE QP_PRC_CONTEXTS_b
SET ATTRIBUTE1 = p_CON_rec.attribute1
, ATTRIBUTE10 = p_CON_rec.attribute10
, ATTRIBUTE11 = p_CON_rec.attribute11
, ATTRIBUTE12 = p_CON_rec.attribute12
, ATTRIBUTE13 = p_CON_rec.attribute13
, ATTRIBUTE14 = p_CON_rec.attribute14
, ATTRIBUTE15 = p_CON_rec.attribute15
, ATTRIBUTE2 = p_CON_rec.attribute2
, ATTRIBUTE3 = p_CON_rec.attribute3
, ATTRIBUTE4 = p_CON_rec.attribute4
, ATTRIBUTE5 = p_CON_rec.attribute5
, ATTRIBUTE6 = p_CON_rec.attribute6
, ATTRIBUTE7 = p_CON_rec.attribute7
, ATTRIBUTE8 = p_CON_rec.attribute8
, ATTRIBUTE9 = p_CON_rec.attribute9
, CONTEXT = p_CON_rec.context
, CREATED_BY = p_CON_rec.created_by
, CREATION_DATE = p_CON_rec.creation_date
, ENABLED_FLAG = p_CON_rec.enabled_flag
, LAST_UPDATED_BY = p_CON_rec.last_updated_by
, LAST_UPDATE_DATE = p_CON_rec.last_update_date
, LAST_UPDATE_LOGIN = p_CON_rec.last_update_login
, PRC_CONTEXT_CODE = p_CON_rec.prc_context_code
, PRC_CONTEXT_ID = p_CON_rec.prc_context_id
, PRC_CONTEXT_TYPE = p_CON_rec.prc_context_type
, PROGRAM_APPLICATION_ID = p_CON_rec.program_application_id
, PROGRAM_ID = p_CON_rec.program_id
, PROGRAM_UPDATE_DATE = p_CON_rec.program_update_date
, SEEDED_FLAG = p_CON_rec.seeded_flag
WHERE PRC_CONTEXT_ID = p_CON_rec.prc_context_id ;
update qp_prc_contexts_tl
set created_by = p_con_rec.created_by
, creation_date = p_con_rec.creation_date
, last_updated_by = p_con_rec.last_updated_by
, last_update_date = p_con_rec.last_update_date
, last_update_login = p_con_rec.last_update_login
, seeded_prc_context_name = p_con_rec.seeded_prc_context_name
, user_prc_context_name = p_con_rec.user_prc_context_name
, seeded_description = p_con_rec.seeded_description
, user_description = p_con_rec.user_description
, source_lang = userenv('LANG')
where prc_context_id = p_con_rec.prc_context_id and
source_lang = userenv('LANG');
FND_DESCR_FLEX_CONTEXTS_PKG.UPDATE_ROW(
X_APPLICATION_ID => 661, --:CONTEXT.APPLICATION_ID,
X_DESCRIPTIVE_FLEXFIELD_NAME => 'QP_ATTR_DEFNS_PRICING',
X_DESCRIPTIVE_FLEX_CONTEXT_COD => p_CON_rec.prc_context_code,
X_ENABLED_FLAG => p_CON_rec.ENABLED_FLAG,
X_GLOBAL_FLAG => 'N',
X_DESCRIPTION => substr(p_CON_rec.user_description,1,240),
X_DESCRIPTIVE_FLEX_CONTEXT_NAM => substr(p_CON_rec.user_prc_context_name,1,80),
X_LAST_UPDATE_DATE => p_CON_rec.LAST_UPDATE_DATE,
X_LAST_UPDATED_BY => p_CON_rec.LAST_UPDATED_BY,
X_LAST_UPDATE_LOGIN => p_CON_rec.LAST_UPDATE_LOGIN);
, 'Update_Row'
);
END Update_Row;
PROCEDURE Insert_Row
( p_CON_rec IN QP_Attributes_PUB.Con_Rec_Type
)
IS
l_row_id varchar2(25);
oe_debug_pub.add('last_update_date=' || p_CON_rec.last_update_date);
oe_debug_pub.add('last_updated_by=' || p_CON_rec.last_updated_by);
INSERT INTO QP_PRC_CONTEXTS_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
, PRC_CONTEXT_code
, PRC_CONTEXT_ID
, PRC_CONTEXT_TYPE
, PROGRAM_APPLICATION_ID
, PROGRAM_ID
, PROGRAM_UPDATE_DATE
, SEEDED_FLAG
)
VALUES
( p_CON_rec.attribute1
, p_CON_rec.attribute10
, p_CON_rec.attribute11
, p_CON_rec.attribute12
, p_CON_rec.attribute13
, p_CON_rec.attribute14
, p_CON_rec.attribute15
, p_CON_rec.attribute2
, p_CON_rec.attribute3
, p_CON_rec.attribute4
, p_CON_rec.attribute5
, p_CON_rec.attribute6
, p_CON_rec.attribute7
, p_CON_rec.attribute8
, p_CON_rec.attribute9
, p_CON_rec.context
, p_CON_rec.created_by
, p_CON_rec.creation_date
, p_CON_rec.enabled_flag
, p_CON_rec.last_updated_by
, p_CON_rec.last_update_date
, p_CON_rec.last_update_login
, p_CON_rec.prc_context_code
, p_CON_rec.prc_context_id
, p_CON_rec.prc_context_type
, p_CON_rec.program_application_id
, p_CON_rec.program_id
, p_CON_rec.program_update_date
, p_CON_rec.seeded_flag
);
INSERT INTO qp_prc_contexts_tl
( CREATED_BY
, CREATION_DATE
, LAST_UPDATED_BY
, LAST_UPDATE_DATE
, LAST_UPDATE_LOGIN
, prc_context_id
, seeded_prc_context_name
, user_prc_context_name
, seeded_description
, user_description
, language
, source_lang
)
SELECT p_CON_rec.created_by
, p_CON_rec.creation_date
, p_CON_rec.last_updated_by
, p_CON_rec.last_update_date
, p_CON_rec.last_update_login
, p_CON_rec.prc_context_id
, p_CON_rec.seeded_prc_context_name
, p_CON_rec.user_prc_context_name
, p_CON_rec.seeded_description
, p_CON_rec.user_description
, L.language_code
, userenv('LANG')
from FND_LANGUAGES L
where L.INSTALLED_FLAG in ('I', 'B')
and not exists
( select NULL
from qp_prc_contexts_tl T
where T.prc_context_id = p_CON_rec.prc_context_id
and T.LANGUAGE = L.LANGUAGE_CODE );
FND_DESCR_FLEX_CONTEXTS_PKG.INSERT_ROW(
X_ROWID => l_row_id,
X_APPLICATION_ID => 661, --:CONTEXT.APPLICATION_ID,
X_DESCRIPTIVE_FLEXFIELD_NAME => 'QP_ATTR_DEFNS_PRICING',
X_DESCRIPTIVE_FLEX_CONTEXT_COD => p_CON_rec.prc_context_code,
X_ENABLED_FLAG => p_CON_rec.ENABLED_FLAG,
X_GLOBAL_FLAG => 'N',
X_DESCRIPTION => substr(p_CON_rec.user_description,1,240),
X_DESCRIPTIVE_FLEX_CONTEXT_NAM => substr(p_CON_rec.user_prc_context_name,1,80),
X_CREATION_DATE => p_CON_rec.CREATION_DATE,
X_CREATED_BY => p_CON_rec.CREATED_BY,
X_LAST_UPDATE_DATE => p_CON_rec.LAST_UPDATE_DATE,
X_LAST_UPDATED_BY => p_CON_rec.LAST_UPDATED_BY,
X_LAST_UPDATE_LOGIN => p_CON_rec.LAST_UPDATE_LOGIN);
, 'Insert_Row'
);
END Insert_Row;
PROCEDURE Delete_Row
( p_prc_context_id IN NUMBER
)
IS
l_qp_prc_contexts_rec qp_prc_contexts_b%rowtype;
select *
into l_qp_prc_contexts_rec
from qp_prc_contexts_b
where prc_context_id = p_prc_context_id;
DELETE FROM QP_PRC_CONTEXTS_tl
WHERE PRC_CONTEXT_ID = p_prc_context_id ;
DELETE FROM QP_PRC_CONTEXTS_b
WHERE PRC_CONTEXT_ID = p_prc_context_id ;
FND_DESCR_FLEX_CONTEXTS_PKG.DELETE_ROW(
X_APPLICATION_ID => 661, --:CONTEXT.APPLICATION_ID,
X_DESCRIPTIVE_FLEXFIELD_NAME => 'QP_ATTR_DEFNS_PRICING',
X_DESCRIPTIVE_FLEX_CONTEXT_COD => l_qp_prc_contexts_rec.prc_context_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
, PRC_CONTEXT_code
, PRC_CONTEXT_ID
, PRC_CONTEXT_TYPE
, PROGRAM_APPLICATION_ID
, PROGRAM_ID
, PROGRAM_UPDATE_DATE
, SEEDED_DESCRIPTION
, SEEDED_FLAG
, SEEDED_PRC_CONTEXT_NAME
, USER_DESCRIPTION
, USER_PRC_CONTEXT_NAME
INTO l_CON_rec.attribute1
, l_CON_rec.attribute10
, l_CON_rec.attribute11
, l_CON_rec.attribute12
, l_CON_rec.attribute13
, l_CON_rec.attribute14
, l_CON_rec.attribute15
, l_CON_rec.attribute2
, l_CON_rec.attribute3
, l_CON_rec.attribute4
, l_CON_rec.attribute5
, l_CON_rec.attribute6
, l_CON_rec.attribute7
, l_CON_rec.attribute8
, l_CON_rec.attribute9
, l_CON_rec.context
, l_CON_rec.created_by
, l_CON_rec.creation_date
, l_CON_rec.enabled_flag
, l_CON_rec.last_updated_by
, l_CON_rec.last_update_date
, l_CON_rec.last_update_login
, l_CON_rec.prc_context_code
, l_CON_rec.prc_context_id
, l_CON_rec.prc_context_type
, l_CON_rec.program_application_id
, l_CON_rec.program_id
, l_CON_rec.program_update_date
, l_CON_rec.seeded_description
, l_CON_rec.seeded_flag
, l_CON_rec.seeded_prc_context_name
, l_CON_rec.user_description
, l_CON_rec.user_prc_context_name
FROM QP_PRC_CONTEXTS_V
WHERE PRC_CONTEXT_ID = p_prc_context_id
;
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
, PRC_CONTEXT_code
, PRC_CONTEXT_ID
, PRC_CONTEXT_TYPE
, PROGRAM_APPLICATION_ID
, PROGRAM_ID
, PROGRAM_UPDATE_DATE
, SEEDED_DESCRIPTION
, SEEDED_FLAG
, SEEDED_PRC_CONTEXT_NAME
, USER_DESCRIPTION
, USER_PRC_CONTEXT_NAME
INTO l_CON_rec.attribute1
, l_CON_rec.attribute10
, l_CON_rec.attribute11
, l_CON_rec.attribute12
, l_CON_rec.attribute13
, l_CON_rec.attribute14
, l_CON_rec.attribute15
, l_CON_rec.attribute2
, l_CON_rec.attribute3
, l_CON_rec.attribute4
, l_CON_rec.attribute5
, l_CON_rec.attribute6
, l_CON_rec.attribute7
, l_CON_rec.attribute8
, l_CON_rec.attribute9
, l_CON_rec.context
, l_CON_rec.created_by
, l_CON_rec.creation_date
, l_CON_rec.enabled_flag
, l_CON_rec.last_updated_by
, l_CON_rec.last_update_date
, l_CON_rec.last_update_login
, l_CON_rec.prc_context_code
, l_CON_rec.prc_context_id
, l_CON_rec.prc_context_type
, l_CON_rec.program_application_id
, l_CON_rec.program_id
, l_CON_rec.program_update_date
, l_CON_rec.seeded_description
, l_CON_rec.seeded_flag
, l_CON_rec.seeded_prc_context_name
, l_CON_rec.user_description
, l_CON_rec.user_prc_context_name
FROM QP_PRC_CONTEXTS_V
WHERE PRC_CONTEXT_ID = p_CON_rec.prc_context_id
FOR UPDATE NOWAIT;
AND QP_GLOBALS.Equal(p_CON_rec.last_updated_by,
l_CON_rec.last_updated_by)
AND QP_GLOBALS.Equal(p_CON_rec.last_update_date,
l_CON_rec.last_update_date)
AND QP_GLOBALS.Equal(p_CON_rec.last_update_login,
l_CON_rec.last_update_login)
AND QP_GLOBALS.Equal(p_CON_rec.prc_context_code,
l_CON_rec.prc_context_code)
AND QP_GLOBALS.Equal(p_CON_rec.prc_context_id,
l_CON_rec.prc_context_id)
AND QP_GLOBALS.Equal(p_CON_rec.prc_context_type,
l_CON_rec.prc_context_type)
AND QP_GLOBALS.Equal(p_CON_rec.program_application_id,
l_CON_rec.program_application_id)
AND QP_GLOBALS.Equal(p_CON_rec.program_id,
l_CON_rec.program_id)
AND QP_GLOBALS.Equal(p_CON_rec.program_update_date,
l_CON_rec.program_update_date)
AND QP_GLOBALS.Equal(p_CON_rec.seeded_description,
l_CON_rec.seeded_description)
AND QP_GLOBALS.Equal(p_CON_rec.seeded_flag,
l_CON_rec.seeded_flag)
AND QP_GLOBALS.Equal(p_CON_rec.seeded_prc_context_name,
l_CON_rec.seeded_prc_context_name)
AND QP_GLOBALS.Equal(p_CON_rec.user_description,
l_CON_rec.user_description)
AND QP_GLOBALS.Equal(p_CON_rec.user_prc_context_name,
l_CON_rec.user_prc_context_name)
THEN
-- Row has not changed. Set out parameter.
x_CON_rec := l_CON_rec;
FND_MESSAGE.SET_NAME('QP','OE_LOCK_ROW_DELETED');