APPS.OE_VALIDATE_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: 58

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

Line: 93

       Select booked_flag into l_booked_flag
       From   oe_order_headers
       where  header_id = p_header_id;

Line: 342

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

Line: 362

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

Line: 372

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

Line: 382

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

Line: 443

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

Line: 661

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

Line: 669

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

Line: 693

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

Line: 713

            ,   'Entity_Delete'
            );

Line: 717

END Entity_Delete;

Line: 727

Select sum(Percent) Per_total
  From oe_sales_credits sc,
       oe_sales_credit_types sct
 Where header_id = p_header_id
   And sct.sales_credit_type_id = sc.sales_credit_type_id
   And line_id is null
   And sct.quota_flag = 'Y';