APPS.IBE_ORDER_UTIL_PVT SQL Statements

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

Line: 177

     SELECT    oel.line_id, oel.top_model_line_id
     FROM      oe_order_lines_all oel
     WHERE    oel.top_model_line_id = oel.line_id
     AND      oel.link_to_line_id is null
     AND      oel.header_id  = c_header_id;

Line: 269

          select phone_country_code,phone_area_code,phone_number,phone_extension,
                 contact_point_type, primary_flag,phone_line_type,
                 email_address
          from   hz_contact_points
          where contact_point_type in ('PHONE','EMAIL') and
          NVL(status, 'A') = 'A'
          and owner_table_name = 'HZ_PARTIES'
          and owner_table_id = c_party_id
          and primary_flag='Y';

Line: 320

  /*  The following procudure verifies whether the last_updated_date passed is older than the
  last_updated_date present in the DB */


  PROCEDURE  validate_last_update_date
  (p_header_id IN NUMBER,
   p_last_update_date IN DATE,
   x_is_diff_last_update  OUT NOCOPY VARCHAR2)

IS
  CURSOR c_getLastUpdatedDate(p_header_id NUMBER) IS
    SELECT last_update_date FROM oe_order_headers_all WHERE header_id = p_header_id;

Line: 334

  l_getLastUpdatedDate  c_getLastUpdatedDate%rowtype;

Line: 335

  l_is_diff_last_update  VARCHAR2(1) := 'F';

Line: 339

      IBE_Util.Debug('In validate_last_update_date : start' );

Line: 342

        IBE_Util.Debug('In validate_last_update_date : After Initializations');

Line: 346

    OPEN c_getLastUpdatedDate(p_header_id);

Line: 347

    FETCH c_getLastUpdatedDate INTO l_getLastUpdatedDate;

Line: 348

     IF (c_getLastUpdatedDate%NOTFOUND) THEN
      IF (IBE_UTIL.G_DEBUGON = l_true) THEN
        IBE_Util.Debug('No order with this header id, it is cancelled');

Line: 352

         l_is_diff_last_update := 'T';

Line: 353

     ELSIF (l_getLastUpdatedDate.last_update_date > p_last_update_date) THEN
          l_is_diff_last_update := 'T';

Line: 356

          l_is_diff_last_update := 'F';

Line: 358

  CLOSE c_getLastUpdatedDate;

Line: 360

   x_is_diff_last_update :=  l_is_diff_last_update;

Line: 361

   IBE_Util.Debug('In validate_last_update_date : End' || x_is_diff_last_update );

Line: 364

        IBE_Util.Debug('In validate_last_update_date : End');

Line: 367

END validate_last_update_date;