APPS.HXC_ARCHIVE_RESTORE_PROCESS SQL Statements

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

Line: 49

  fnd_file.put_line(fnd_file.LOG,'--- >Before inserting the record into HXC_DATA_SETS table');

Line: 53

  hxc_data_set.insert_into_data_set(l_data_set_id,
	 		            p_data_set_name,
  				    p_description,
 				    l_start_date,
  				    l_stop_date,
  				    'MARKING_IN_PROGRESS');

Line: 75

  update hxc_data_sets
  set status = 'ON_LINE'
  where data_set_id = l_data_set_id;

Line: 778

     fnd_file.put_line(fnd_file.log,'was implemented. Please follow the Metalink note available to update these data ');

Line: 922

    SELECT count(1)
      INTO l_count
      FROM hxc_time_building_blocks_ar
     WHERE data_set_id IS NULL
       AND ROWNUM < 2;

Line: 933

    SELECT count(1)
      INTO l_count
      FROM hxc_time_attributes_ar
     WHERE data_set_id IS NULL
       AND ROWNUM < 2;

Line: 944

    SELECT count(1)
      INTO l_count
      FROM hxc_transaction_details_ar
     WHERE data_set_id IS NULL
       AND ROWNUM < 2;

Line: 955

    SELECT count(1)
      INTO l_count
      FROM hxc_transactions_ar
     WHERE data_set_id IS NULL
       AND ROWNUM < 2;

Line: 994

    SELECT count(1)
      INTO l_count
      FROM hxc_data_set_details
     WHERE ROWNUM < 2 ;