APPS.OE_FREIGHT_RATING_PVT SQL Statements

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

Line: 53

           SELECT  list_line_type_code
           INTO   l_list_line_type_code
           FROM   oe_price_adjustments
           WHERE  header_id = p_key
           AND    list_header_id = p_key * (-1);

Line: 150

    select oe_price_adjustments_s.nextval into l_price_adjustment_id
    from dual;

Line: 164

    x_line_adj_rec.last_update_date := sysdate;

Line: 166

    x_line_adj_rec.last_updated_by := 1;

Line: 167

    x_line_adj_rec.last_update_login := 1;

Line: 232

           SELECT  opa.price_adjustment_id,ool.line_id,
                   opa.adjusted_amount, opa.list_line_type_code,
                   opa.charge_type_code
           FROM    oe_order_lines ool
                  ,oe_price_adjustments opa
           WHERE   opa.charge_type_code IN ('FTEPRICE','FTECHARGE')
           AND     ool.line_id = opa.line_id
           AND     ool.item_type_code <> OE_GLOBALS.G_ITEM_CONFIG
           AND     ool.ato_line_id = p_ato_line_id;

Line: 253

  DELETE FROM OE_PRICE_ADJUSTMENTS
  WHERE HEADER_ID = P_HEADER_ID
  AND   CHARGE_TYPE_CODE IN ('FTEPRICE','FTECHARGE')
  AND   list_line_type_code = 'COST'
  AND   ESTIMATED_FLAG = 'Y'
  RETURNING line_id bulk collect into l_line_id_tbl;

Line: 266

       p_operation       => OE_GLOBALS.G_OPR_UPDATE);

Line: 327

    OE_LINE_ADJ_UTIL.INSERT_ROW(l_line_adj_rec);

Line: 335

       p_operation       => OE_GLOBALS.G_OPR_UPDATE);

Line: 382

      OE_LINE_ADJ_UTIL.INSERT_ROW(l_line_adj_rec);

Line: 388

       p_operation       => OE_GLOBALS.G_OPR_UPDATE);

Line: 394

      DELETE FROM oe_price_adjustments
      WHERE price_adjustment_id = l_bulk_adj_rec.price_adjustment_id(i);

Line: 411

       p_x_line_tbl.delete(J);

Line: 449

    select oe_price_adjustments_s.nextval
    into   l_price_adjustment_id
    from   dual;

Line: 452

    INSERT INTO oe_price_adjustments
           (PRICE_ADJUSTMENT_ID
           ,HEADER_ID
           ,LINE_ID
           ,PRICING_PHASE_ID
           ,LIST_LINE_TYPE_CODE
           ,LIST_HEADER_ID
           ,LIST_LINE_ID
           ,ADJUSTED_AMOUNT
           ,AUTOMATIC_FLAG
           ,UPDATED_FLAG
           ,APPLIED_FLAG
           ,CREATION_DATE
           ,CREATED_BY
           ,LAST_UPDATE_DATE
           ,LAST_UPDATED_BY
           )
    VALUES
          (l_price_adjustment_id
           ,p_header_id
           ,NULL
           ,-1
           ,'OM_CALLED_FREIGHT_RATES'
           ,-1*p_header_id
           ,NULL
           ,-1
           ,'N'
           ,'Y'
           ,NULL
           ,sysdate
           ,1
           ,sysdate
           ,1
          );