APPS.OE_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: 59

   SELECT sum(Percent) Per_total
   FROM   oe_sales_credits sc,
	     oe_sales_credit_types sct
   WHERE  line_id = p_line_id
   AND    sc.sales_credit_type_id = sct.sales_credit_type_id
   AND    sct.quota_flag = 'Y';

Line: 336

    IF  p_Line_Scredit_rec.dw_update_advice_flag IS NOT NULL AND
        (   p_Line_Scredit_rec.dw_update_advice_flag <>
            p_old_Line_Scredit_rec.dw_update_advice_flag OR
            p_old_Line_Scredit_rec.dw_update_advice_flag IS NULL )
    THEN
        IF NOT OE_Validate.Dw_Update_Advice(p_Line_Scredit_rec.dw_update_advice_flag) THEN
            x_return_status := FND_API.G_RET_STS_ERROR;

Line: 356

    IF  p_Line_Scredit_rec.last_updated_by IS NOT NULL AND
        (   p_Line_Scredit_rec.last_updated_by <>
            p_old_Line_Scredit_rec.last_updated_by OR
            p_old_Line_Scredit_rec.last_updated_by IS NULL )
    THEN
        IF NOT OE_Validate.Last_Updated_By(p_Line_Scredit_rec.last_updated_by) THEN
            x_return_status := FND_API.G_RET_STS_ERROR;

Line: 366

    IF  p_Line_Scredit_rec.last_update_date IS NOT NULL AND
        (   p_Line_Scredit_rec.last_update_date <>
            p_old_Line_Scredit_rec.last_update_date OR
            p_old_Line_Scredit_rec.last_update_date IS NULL )
    THEN
        IF NOT OE_Validate.Last_Update_Date(p_Line_Scredit_rec.last_update_date) THEN
            x_return_status := FND_API.G_RET_STS_ERROR;

Line: 376

    IF  p_Line_Scredit_rec.last_update_login IS NOT NULL AND
        (   p_Line_Scredit_rec.last_update_login <>
            p_old_Line_Scredit_rec.last_update_login OR
            p_old_Line_Scredit_rec.last_update_login IS NULL )
    THEN
        IF NOT OE_Validate.Last_Update_Login(p_Line_Scredit_rec.last_update_login) THEN
            x_return_status := FND_API.G_RET_STS_ERROR;

Line: 427

    IF  p_Line_Scredit_rec.wh_update_date IS NOT NULL AND
        (   p_Line_Scredit_rec.wh_update_date <>
            p_old_Line_Scredit_rec.wh_update_date OR
            p_old_Line_Scredit_rec.wh_update_date IS NULL )
    THEN
        IF NOT OE_Validate.Wh_Update_Date(p_Line_Scredit_rec.wh_update_date) THEN
            x_return_status := FND_API.G_RET_STS_ERROR;

Line: 645

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

Line: 656

   OE_DEBUG_PUB.Add('Entering OE_VALIDATE_LINE_SCREDIT.Entity_Delete',1);

Line: 676

	-- cascade the sc delete.

       IF OE_GLOBALS.G_RECURSION_MODE <> 'Y' THEN
        -- Preparing request_rec.
         l_request_rec.entity_code  := OE_GLOBALS.G_ENTITY_line_Scredit;

Line: 707

   OE_DEBUG_PUB.Add('Exiting OE_VALIDATE_LINE_SCREDIT.Entity_Delete',1);

Line: 728

            ,   'Entity_Delete'
            );

Line: 732

END Entity_Delete;