APPS.OE_CNCL_VAL_HEADER_SCREDIT SQL Statements

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

Line: 17

    Select 'DUPLICATE'
    From  oe_sales_credits
    Where header_id = p_header_id
    And   line_id is null
    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: 241

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

Line: 256

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

Line: 263

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

Line: 270

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

Line: 314

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