APPS.QP_VALIDATE_MODIFIER_LIST SQL Statements

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

Line: 57

    IF p_MODIFIER_LIST_rec.operation = QP_GLOBALS.G_OPR_UPDATE
    THEN

       IF  p_old_MODIFIER_LIST_rec.list_type_code IS NOT NULL
       AND p_old_MODIFIER_LIST_rec.list_type_code <> FND_API.G_MISS_CHAR
       AND p_old_MODIFIER_LIST_rec.list_type_code <> p_MODIFIER_LIST_rec.list_type_code
	  THEN

        l_return_status := FND_API.G_RET_STS_ERROR;

Line: 67

        FND_MESSAGE.SET_NAME('QP','QP_CANNOT_UPDATE_LIST_TYPE');

Line: 78

        FND_MESSAGE.SET_NAME('QP','QP_CANNOT_UPDATE_ATTRIBUTE');

Line: 91

        FND_MESSAGE.SET_NAME('QP','QP_CANNOT_UPDATE_ATTRIBUTE');

Line: 104

        FND_MESSAGE.SET_NAME('QP','QP_CANNOT_UPDATE_ATTRIBUTE');

Line: 116

        FND_MESSAGE.SET_NAME('QP','QP_CANNOT_UPDATE_ATTRIBUTE');

Line: 128

        FND_MESSAGE.SET_NAME('QP','QP_CANNOT_UPDATE_ATTRIBUTE');

Line: 140

        FND_MESSAGE.SET_NAME('QP','QP_CANNOT_UPDATE_ATTRIBUTE');

Line: 155

        FND_MESSAGE.SET_NAME('QP','QP_CANNOT_UPDATE_NUMBER');

Line: 167

        FND_MESSAGE.SET_NAME('QP','QP_CANNOT_UPDATE_NAME');

Line: 280

	     select currency_code
		into   l_currency_code
		from   fnd_currencies_vl
		where  enabled_flag = 'Y'
		and    currency_flag = 'Y'
		and    currency_code = p_MODIFIER_LIST_rec.currency_code;

Line: 621

    IF  p_MODIFIER_LIST_rec.last_updated_by IS NOT NULL AND
        (   p_MODIFIER_LIST_rec.last_updated_by <>
            p_old_MODIFIER_LIST_rec.last_updated_by OR
            p_old_MODIFIER_LIST_rec.last_updated_by IS NULL )
    THEN
        IF NOT QP_Validate.Last_Updated_By(p_MODIFIER_LIST_rec.last_updated_by) THEN
            x_return_status := FND_API.G_RET_STS_ERROR;

Line: 632

    IF  p_MODIFIER_LIST_rec.last_update_date IS NOT NULL AND
        (   p_MODIFIER_LIST_rec.last_update_date <>
            p_old_MODIFIER_LIST_rec.last_update_date OR
            p_old_MODIFIER_LIST_rec.last_update_date IS NULL )
    THEN
        IF NOT QP_Validate.Last_Update_Date(p_MODIFIER_LIST_rec.last_update_date) THEN
            x_return_status := FND_API.G_RET_STS_ERROR;

Line: 643

    IF  p_MODIFIER_LIST_rec.last_update_login IS NOT NULL AND
        (   p_MODIFIER_LIST_rec.last_update_login <>
            p_old_MODIFIER_LIST_rec.last_update_login OR
            p_old_MODIFIER_LIST_rec.last_update_login IS NULL )
    THEN
        IF NOT QP_Validate.Last_Update_Login(p_MODIFIER_LIST_rec.last_update_login) THEN
            x_return_status := FND_API.G_RET_STS_ERROR;

Line: 698

    IF  p_MODIFIER_LIST_rec.program_update_date IS NOT NULL AND
        (   p_MODIFIER_LIST_rec.program_update_date <>
            p_old_MODIFIER_LIST_rec.program_update_date OR
            p_old_MODIFIER_LIST_rec.program_update_date IS NULL )
    THEN
        IF NOT QP_Validate.Program_Update_Date(p_MODIFIER_LIST_rec.program_update_date) THEN
            x_return_status := FND_API.G_RET_STS_ERROR;

Line: 1144

PROCEDURE Entity_Delete
(   x_return_status                 OUT NOCOPY /* file.sql.39 change */ VARCHAR2
,   p_MODIFIER_LIST_rec             IN  QP_Modifiers_PUB.Modifier_List_Rec_Type
)
IS
l_return_status               VARCHAR2(1) := FND_API.G_RET_STS_SUCCESS;

Line: 1152

    oe_debug_pub.add('BEGIN entity_delete in QPXLMLHB');

Line: 1179

            ,   'Entity_Delete'
            );

Line: 1183

    oe_debug_pub.add('END entity_delete in QPXLMLHB');

Line: 1184

END Entity_Delete;