APPS.OE_VALIDATE_HEADER_ADJ SQL Statements

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

Line: 142

    /* IF upper(p_Header_adj_rec.updated_flag) ='Y'  and
       upper(p_Header_adj_rec.applied_flag) ='Y'  and
	p_Header_adj_rec.change_reason_code is null THEN

        l_return_status := FND_API.G_RET_STS_ERROR;

Line: 257

                SELECT 'VALID'
                INTO l_tmp_string
                FROM QP_LOOKUPS
                WHERE LOOKUP_TYPE = p_Header_Adj_rec.charge_type_code
                AND LOOKUP_CODE = p_Header_Adj_rec.charge_subtype_code
                AND TRUNC(sysdate) BETWEEN TRUNC(NVL(START_DATE_ACTIVE,sysdate))
                    AND TRUNC(NVL(END_DATE_ACTIVE,sysdate))
                AND ENABLED_FLAG = 'Y';

Line: 418

    IF  p_Header_Adj_rec.last_update_date IS NOT NULL AND
        (   p_Header_Adj_rec.last_update_date <>
            p_old_Header_Adj_rec.last_update_date OR
            p_old_Header_Adj_rec.last_update_date IS NULL )
    THEN
        IF NOT oe_validate_adj.Last_Update_Date(p_Header_Adj_rec.last_update_date) THEN
            x_return_status := FND_API.G_RET_STS_ERROR;

Line: 428

    IF  p_Header_Adj_rec.last_updated_by IS NOT NULL AND
        (   p_Header_Adj_rec.last_updated_by <>
            p_old_Header_Adj_rec.last_updated_by OR
            p_old_Header_Adj_rec.last_updated_by IS NULL )
    THEN
        IF NOT oe_validate_adj.Last_Updated_By(p_Header_Adj_rec.last_updated_by) THEN
            x_return_status := FND_API.G_RET_STS_ERROR;

Line: 438

    IF  p_Header_Adj_rec.last_update_login IS NOT NULL AND
        (   p_Header_Adj_rec.last_update_login <>
            p_old_Header_Adj_rec.last_update_login OR
            p_old_Header_Adj_rec.last_update_login IS NULL )
    THEN
        IF NOT oe_validate_adj.Last_Update_Login(p_Header_Adj_rec.last_update_login) THEN
            x_return_status := FND_API.G_RET_STS_ERROR;

Line: 468

    IF  p_Header_Adj_rec.program_update_date IS NOT NULL AND
        (   p_Header_Adj_rec.program_update_date <>
            p_old_Header_Adj_rec.program_update_date OR
            p_old_Header_Adj_rec.program_update_date IS NULL )
    THEN
        IF NOT oe_validate_adj.Program_Update_Date(p_Header_Adj_rec.program_update_date) THEN
            x_return_status := FND_API.G_RET_STS_ERROR;

Line: 848

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

Line: 882

            ,   'Entity_Delete'
            );

Line: 886

END Entity_Delete;