APPS.OE_CNCL_VALIDATE_HEADER_ADJ SQL Statements

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

Line: 139

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

        l_return_status := FND_API.G_RET_STS_ERROR;

Line: 249

                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 ROWNUM = 1;

Line: 398

    IF  p_Header_Adj_rec.last_update_date IS NOT NULL
    THEN
        IF NOT OE_CNCL_Validate_Adj.Last_Update_Date(p_Header_Adj_rec.last_update_date) THEN
            x_return_status := FND_API.G_RET_STS_ERROR;

Line: 405

    IF  p_Header_Adj_rec.last_updated_by IS NOT NULL
    THEN
        IF NOT OE_CNCL_Validate_Adj.Last_Updated_By(p_Header_Adj_rec.last_updated_by) THEN
            x_return_status := FND_API.G_RET_STS_ERROR;

Line: 412

    IF  p_Header_Adj_rec.last_update_login IS NOT NULL
    THEN
        IF NOT OE_CNCL_Validate_Adj.Last_Update_Login(p_Header_Adj_rec.last_update_login) THEN
            x_return_status := FND_API.G_RET_STS_ERROR;

Line: 433

    IF  p_Header_Adj_rec.program_update_date IS NOT NULL
    THEN
        IF NOT OE_CNCL_Validate_Adj.Program_Update_Date(p_Header_Adj_rec.program_update_date) THEN
            x_return_status := FND_API.G_RET_STS_ERROR;