APPS.HZ_IMP_BATCH_SUMMARY_V2PUB SQL Statements

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

Line: 82

        p_create_update_flag                    => 'C',
        p_column                                => 'batch_name',
        p_column_value                          => p_batch_name,
        p_restricted                            => 'Y',
        x_return_status                         => x_return_status
    );

Line: 91

        p_create_update_flag                    => 'C',
        p_column                                => 'original_system',
        p_column_value                          => p_original_system,
        p_restricted                            => 'Y',
        x_return_status                         => x_return_status
    );

Line: 111

    SELECT 'Y' INTO os_exists_flag
    FROM hz_orig_systems_b
    WHERE
    orig_system= p_original_system
    AND orig_system<>'SST'
    AND status='A';

Line: 136

        INSERT INTO hz_imp_batch_summary (
          batch_id,
          batch_name,
          description,
          original_system,
          load_type,
          est_no_of_records,
          created_by,
          creation_date,
          last_updated_by,
          last_update_date,
          last_update_login
        )
        VALUES (
          hz_imp_batch_summary_s.nextval,
          p_batch_name,
          p_description,
          p_original_system,
          p_load_type,
          p_est_no_of_records,
          hz_utility_v2pub.created_by,
          hz_utility_v2pub.creation_date,
          hz_utility_v2pub.last_updated_by,
          hz_utility_v2pub.last_update_date,
          hz_utility_v2pub.last_update_login
        ) RETURNING
          batch_id
        INTO
          x_batch_id;

Line: 178

                SELECT hz_imp_batch_summary_s.NEXTVAL
                INTO   x_batch_id
                FROM   dual;

Line: 183

                  SELECT 'Y'
                  INTO   l_dummy
                  FROM   hz_imp_batch_summary hl
                  WHERE  hl.batch_id = x_batch_id;

Line: 329

        p_create_update_flag                    => 'Y',
        p_column                                => 'batch_id',
        p_column_value                          => p_batch_id,
        p_restricted                            => 'Y',
        x_return_status                         => x_return_status
    );

Line: 338

      SELECT batch_id, original_system
      INTO l_batch_id, l_original_system
      FROM hz_imp_batch_summary
      WHERE batch_id = p_batch_id;

Line: 359

      SELECT batch_id
      INTO l_batch_id
      FROM hz_imp_batch_summary
      WHERE batch_id = p_batch_id
      AND   NVL(batch_status,'ACTIVE') NOT IN ('PURGED', 'REJECTED', 'PROCESSING', 'COMPLETED', 'ACTION_REQUIRED');

Line: 381

    UPDATE hz_imp_batch_summary
    SET batch_status = 'ACTIVE',
        last_updated_by = hz_utility_v2pub.last_updated_by,
        last_update_date = hz_utility_v2pub.last_update_date,
        last_update_login = hz_utility_v2pub.last_update_login
    WHERE batch_id = p_batch_id;