APPS.OE_CNCL_VALIDATE_LINE_SCREDIT SQL Statements

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

Line: 18

    SELECT 'DUPLICATE'
    FROM  oe_sales_credits
    WHERE line_id = p_line_id
    AND   salesrep_id = p_salesrep_id
    AND   sales_credit_type_id  = p_sales_credit_type_id
    AND   sales_credit_id <> nvl(p_sales_credit_id,-5);

Line: 243

    IF  p_Line_Scredit_rec.dw_update_advice_flag IS NOT NULL
    THEN
        IF NOT OE_CNCL_Validate.Dw_Update_Advice(p_Line_Scredit_rec.dw_update_advice_flag) THEN
            x_return_status := FND_API.G_RET_STS_ERROR;

Line: 258

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

Line: 265

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

Line: 272

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

Line: 309

    IF  p_Line_Scredit_rec.wh_update_date IS NOT NULL
    THEN
        IF NOT OE_CNCL_Validate.Wh_Update_Date(p_Line_Scredit_rec.wh_update_date) THEN
            x_return_status := FND_API.G_RET_STS_ERROR;